Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TicketID | int | 4 | null |
|
|
Primary key - Support ticket unique identifier linking to core ticket record |
||
| TicketStatus | nvarchar | 1073741823 | √ | null |
|
|
Ticket status - Current status of the support ticket (Open=new ticket, InProgress=being worked, Resolved=solution provided, Closed=customer confirmed) |
|
| TicketIssue | nvarchar | 1073741823 | null |
|
|
Ticket issue - Description of the customer’s issue, problem, or request for support |
||
| TicketCreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the support ticket was initially submitted |
|
| TicketUpdatedDate | datetime | 16,3 | √ | null |
|
|
Last update date - Date and time when the ticket was most recently modified |
|
| TicketIsPublic | bit | 1 | null |
|
|
Public visibility flag - Whether the ticket is visible to other customers (true=public, false=private) |
||
| TicketIsPublicStr | varchar | 3 | null |
|
|
Public visibility text - Text representation of public visibility (Yes=visible to others, No=private ticket) |
||
| TicketUrlReference | nvarchar | 400 | √ | null |
|
|
URL reference - Web link or URL related to the ticket issue for additional context |
|
| TicketBetaDate | datetime | 16,3 | √ | null |
|
|
Beta release date - Date when the solution was deployed to beta environment for testing |
|
| TicketCompletedDate | datetime | 16,3 | √ | null |
|
|
Completion date - Date when the ticket was marked as completed by support staff |
|
| TicketEstHours | decimal | 20,2 | √ | null |
|
|
Estimated hours - Estimated number of hours required to resolve the ticket |
|
| TicketLiveDate | datetime | 16,3 | √ | null |
|
|
Live deployment date - Date when the solution was deployed to production environment |
|
| TicketPriority | nvarchar | 100 | √ | null |
|
|
Priority level - Business priority of the ticket (Low=routine, Medium=important, High=urgent, Critical=system down) |
|
| TicketTargetDate | datetime | 16,3 | √ | null |
|
|
Target resolution date - Date by which the ticket should be resolved |
|
| TicketType | nvarchar | 100 | √ | null |
|
|
Ticket type - Classification of the ticket (Bug=software defect, Enhancement=new feature, Support=help request, Question=information needed) |
|
| TicketCreateByName | nvarchar | 400 | √ | null |
|
|
Creator name - Name of the person who submitted the support ticket |
|
| TicketCreateByAgencyName | varchar | 50 | √ | null |
|
|
Creator agency - Name of the agency or organization the ticket creator belongs to |
|
| TeamSupportAssignedName | varchar | 101 | √ | null |
|
|
Assigned support staff - Name of the support team member assigned to resolve the ticket |
|
| SolvedByName | varchar | 101 | √ | null |
|
|
Resolver name - Name of the person who provided the final solution to the ticket |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Record creation date - Date when the ticket record was created in the system |
|
| AppName | nvarchar | 1073741823 | √ | null |
|
|
Application name - Name of the software application or system component related to the ticket |
|
| UpdatedTo | nvarchar | 510 | √ | null |
|
|
Update target - Version or release the application was updated to address the ticket |
|
| Summary | nvarchar | 1073741823 | √ | null |
|
|
Ticket summary - Brief summary of the issue and resolution for quick reference |
|
| ClosedDate | datetime | 16,3 | √ | null |
|
|
Closure date - Date when the ticket was officially closed |
|
| PublicTicket | nvarchar | 510 | √ | null |
|
|
Public ticket flag - Indicates if this is a publicly visible ticket for community reference |
|
| EstimatedTime | decimal | 20 | √ | null |
|
|
Estimated time - Estimated time in hours required for resolution |
|
| TimeSpent | decimal | 20,2 | √ | null |
|
|
Actual time spent - Actual number of hours spent resolving the ticket |
|
| Functionality | nvarchar | 510 | √ | null |
|
|
Functionality area - Specific functional area or module of the system affected by the ticket |
|
| TypeOfEffort | nvarchar | 510 | √ | null |
|
|
Effort type - Classification of the work required (Development=coding, Configuration=setup, Research=investigation) |
|
| LevelOfEffort | nvarchar | 510 | √ | null |
|
|
Effort level - Complexity level of the work required (Low=simple, Medium=moderate, High=complex) |
|
| RemainingHours | decimal | 21,2 | √ | null |
|
|
Hours remaining - Calculated remaining hours needed to complete the ticket (estimated minus spent) |
|
| TargetWeek | nvarchar | 510 | √ | null |
|
|
Target week - Week number when the ticket is targeted for completion |
|
| Assigned | nvarchar | 510 | √ | null |
|
|
Assignment status - Current assignment status of the ticket |
|
| SolutionType | nvarchar | 510 | √ | null |
|
|
Solution type - Classification of the solution provided (Code Fix=programming, Configuration=settings, Documentation=instructions) |
|
| ServerLocation | nvarchar | 510 | √ | null |
|
|
Server location - Physical or cloud location where the solution was deployed |
|
| MultiApps | nvarchar | 510 | √ | null |
|
|
Multi-application flag - Whether the ticket affects multiple applications or systems |
|
| EstimatedDeliveryWeek | int | 4 | √ | null |
|
|
Delivery week - Week number when the solution is estimated to be delivered |
|
| InternalStatus | nvarchar | 1073741823 | √ | null |
|
|
Internal status - Internal tracking status used by support team for workflow management |
|
| DevelopmentFee | nvarchar | 510 | √ | null |
|
|
Development fee - Cost associated with custom development work for the ticket |
|
| PublicTitle | nvarchar | 510 | √ | null |
|
|
Public title - Customer-facing title of the ticket for public visibility |
|
| PublicSolution | nvarchar | 6000 | √ | null |
|
|
Public solution - Customer-facing description of the solution provided |
|
| SystemUpdated | datetime | 16,3 | √ | null |
|
|
System update date - Date when the system was updated with the solution |
|
| LoggedDate | datetime | 16,3 | √ | null |
|
|
Log date - Date when the ticket was logged in the tracking system |
|
| Resolution | nvarchar | 1073741823 | √ | null |
|
|
Resolution details - Detailed description of how the ticket was resolved |
|
| SolvedDate | datetime | 16,3 | √ | null |
|
|
Solution date - Date when the ticket was marked as solved |
|
| SolveOrder | int | 4 | √ | null |
|
|
Solution order - Sequential order in which tickets were solved |
|
| SolvePriority | nvarchar | 510 | √ | null |
|
|
Solution priority - Priority assigned for solving the ticket |
|
| LastComment | datetime | 16,3 | √ | null |
|
|
Last comment date - Date of the most recent comment added to the ticket |
|
| LastCommentName | varchar | 200 | √ | null |
|
|
Last commenter - Name of the person who added the most recent comment |
|
| LastCommentCompany | int | 4 | √ | null |
|
|
Last commenter company - Company ID of the person who added the most recent comment |
|
| LatestComment | varchar | 2147483647 | √ | null |
|
|
Latest comment text - Text content of the most recent comment on the ticket |
|
| LatestInternalComment | varchar | 2147483647 | √ | null |
|
|
Latest internal comment - Text content of the most recent internal comment (not visible to customers) |
|
| AssignedPerson | varchar | 101 | √ | null |
|
|
Assigned person name - Name of the specific person currently assigned to work on the ticket |
|
| Tags | nvarchar | 1073741823 | √ | null |
|
|
Ticket tags - Comma-separated list of tags categorizing the ticket for organization and filtering |
|
| TagType | varchar | 500 | √ | null |
|
|
Tag type - Classification or type of tags applied to the ticket |
|
| NumberOfComments | int | 4 | √ | null |
|
|
Comment count - Total number of public comments on the ticket |
|
| NumberOfVotes | int | 4 | √ | null |
|
|
Vote count - Total number of votes received from customers indicating importance |
|
| DescriptionWithoutHTML | nvarchar | 1073741823 | √ | null |
|
|
Plain text description - Ticket description with HTML formatting removed for analysis |
|
| NonPublicInfo | nvarchar | 510 | √ | null |
|
|
Private information - Internal notes and information not visible to customers |
|
| RootCause | nvarchar | 510 | √ | null |
|
|
Root cause analysis - Analysis of the underlying cause of the issue |
|
| HappenedBefore | nvarchar | 510 | √ | null |
|
|
Recurrence flag - Whether this type of issue has occurred before |
|
| ExplanationOfReoccurringTicket | nvarchar | 6000 | √ | null |
|
|
Recurrence explanation - Detailed explanation of why the issue is recurring |
|
| AssignedPersonId | nvarchar | 510 | √ | null |
|
|
Assigned person ID - Unique identifier of the person assigned to the ticket |
Relationships
Close relationships within degrees of separation
