Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkInquiryID | int | 4 | null |
|
|
Primary inquiry key - Unique identifier for each support inquiry or ticket |
||
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to Agency table for the organization submitting the inquiry |
|
| RequestedBy | int | 4 | √ | null |
|
|
Requester user ID - Links to AccessUser table for the person who submitted the inquiry |
|
| RequestedDate | datetime | 16,3 | √ | null |
|
|
Request date - Date and time when the inquiry was submitted |
|
| Comments | varchar | 7000 | √ | null |
|
|
Inquiry comments - Detailed description of the issue or request |
|
| Browser | varchar | 50 | √ | null |
|
|
Browser type - Web browser used when submitting the inquiry |
|
| BrowserVersion | varchar | 50 | √ | null |
|
|
Browser version - Version of the web browser used |
|
| OS | varchar | 50 | √ | null |
|
|
Operating system - Operating system of the user’s device |
|
| OSVersion | varchar | 50 | √ | null |
|
|
OS version - Version of the operating system |
|
| JSEnable | varchar | 50 | √ | null |
|
|
JavaScript enabled - Whether JavaScript was enabled in the browser |
|
| CookieEnable | varchar | 50 | √ | null |
|
|
Cookies enabled - Whether cookies were enabled in the browser |
|
| NewTo | varchar | 50 | √ | null |
|
|
New to system - Indicates if the user is new to the system |
|
| priority | varchar | 50 | √ | null |
|
|
Priority level - Priority level assigned to the inquiry (High, Medium, Low) |
|
| Internal | int | 4 | √ | null |
|
|
Internal flag - Indicates if this is an internal inquiry from staff |
|
| icsSummary | ntext | 1073741823 | √ | null |
|
|
ICS summary - Summary information for iCentral system context |
|
| source | varchar | 50 | √ | null |
|
|
Inquiry source - Source or channel through which the inquiry was submitted |
|
| rating | int | 4 | √ | null |
|
|
User rating - User satisfaction rating for the resolution |
|
| feedback | varchar | 200 | √ | null |
|
|
User feedback - User feedback about the support experience |
|
| clientcompletiondate | datetime | 16,3 | √ | null |
|
|
Client completion date - Date when the client marked the inquiry as resolved |
|
| priorityOrder | int | 4 | √ | null |
|
|
Priority order - Numeric priority ordering for queue management |
|
| fkITypeID | int | 4 | √ | null |
|
|
Inquiry type reference - Links to inquiry type classification table |
|
| status | varchar | 20 | √ | null |
|
|
Inquiry status - Current status of the inquiry (Open, In Progress, Resolved, Closed) |
|
| Name | varchar | 101 | √ | null |
|
|
Requester name - Full name of the person who submitted the inquiry |
|
| TASK_ID | numeric | 20 | √ | null |
|
|
Task identifier - Unique identifier for associated task if inquiry was converted to task |
|
| COMPANY_ID | numeric | 20 | √ | null |
|
|
Company identifier - Company or organization identifier for task management |
|
| PROJECT_ID | numeric | 20 | √ | null |
|
|
Project identifier - Project identifier if inquiry is part of a larger project |
|
| PROJECT_MODULE_ID | numeric | 20 | √ | null |
|
|
Project module ID - Specific module within a project |
|
| TASK_TYPE_ID | numeric | 20 | √ | null |
|
|
Task type identifier - Type classification for the task |
|
| STATUS_TYPE_ID | numeric | 20 | √ | null |
|
|
Status type identifier - Status type classification for task management |
|
| PRIORITY_TYPE_ID | numeric | 20 | √ | null |
|
|
Priority type identifier - Priority type classification for task management |
|
| USER_CREATOR_ID | numeric | 20 | √ | null |
|
|
Task creator ID - User who created the associated task |
|
| TASK_NUMBER | numeric | 20,2 | √ | null |
|
|
Task number - Sequential task number for tracking |
|
| TASK_RESUME | nvarchar | 510 | √ | null |
|
|
Task summary - Brief summary of the task |
|
| TASK_DESC_CREATOR | ntext | 1073741823 | √ | null |
|
|
Task description by creator - Detailed task description from the creator |
|
| ESTIMATED_TIME | numeric | 20,2 | √ | null |
|
|
Estimated time - Estimated time to complete the task in hours |
|
| DATE_EXPECTED_START_TASK | datetime | 16,3 | √ | null |
|
|
Expected start date - Expected date to start working on the task |
|
| DATE_EXPECTED_END_TASK | datetime | 16,3 | √ | null |
|
|
Expected end date - Expected date to complete the task |
|
| DATE_TASK_CREATED | datetime | 16,3 | √ | null |
|
|
Task creation date - Date when the task was created |
|
| DATE_TASK_MODIFIED | datetime | 16,3 | √ | null |
|
|
Task modification date - Date when the task was last modified |
|
| USER_DOING_ID | numeric | 20 | √ | null |
|
|
Assigned user ID - User currently assigned to work on the task |
|
| USER_VERIFY_ID | numeric | 20 | √ | null |
|
|
Verifier user ID - User responsible for verifying task completion |
|
| TASK_DESC_DOING | ntext | 1073741823 | √ | null |
|
|
Task progress description - Description of work being done on the task |
|
| TASK_DESC_VERIFY | ntext | 1073741823 | √ | null |
|
|
Task verification description - Description of verification process and results |
|
| POURCENTAGE_DONE | numeric | 20 | √ | null |
|
|
Percentage complete - Percentage of task completion (0-100) |
|
| ACTUAL_HOURS | numeric | 20,2 | √ | null |
|
|
Actual hours - Actual time spent on the task in hours |
|
| FROG_DATE | datetime | 16,3 | √ | null |
|
|
FROG date - Follow-up or review date for the task |
|
| LogID | int | 4 | √ | null |
|
|
Log identifier - Reference to activity log entries |
|
| TASK_RESPONSE | nvarchar | 510 | √ | null |
|
|
Task response - Response or resolution provided for the task |
|
| pkCorrID | int | 4 | √ | null |
|
|
Correspondence primary key - Unique identifier for correspondence records |
|
| fkInquiryID | int | 4 | √ | null |
|
|
Correspondence inquiry reference - Links correspondence to the parent inquiry |
|
| DateEntered | smalldatetime | 16 | √ | null |
|
|
Correspondence date - Date when correspondence was entered |
|
| cNotes | varchar | 5000 | √ | null |
|
|
Correspondence notes - Notes and comments for the correspondence |
|
| tNotes | varchar | 2000 | √ | null |
|
|
Technical notes - Technical notes for the correspondence |
|
| CorrBy | int | 4 | √ | null |
|
|
Correspondence by user - User who created the correspondence entry |
|
| cNotesInternal | text | 2147483647 | √ | null |
|
|
Internal correspondence notes - Internal notes not visible to clients |
|
| fkAgencyId | int | 4 | √ | null |
|
|
Correspondence agency reference - Agency associated with the correspondence |
|
| fkDocID | int | 4 | √ | null |
|
|
Document reference - Links to associated documents |
|
| cMinutes | decimal | 7,2 | √ | null |
|
|
Correspondence minutes - Time spent on correspondence in minutes |
|
| fkUserID | int | 4 | √ | null |
|
|
Correspondence user reference - User associated with the correspondence |
|
| fkCatID | int | 4 | √ | null |
|
|
Category reference - Category classification for the correspondence |
|
| billable | int | 4 | √ | null |
|
|
Billable flag - Indicates if the correspondence time is billable |
|
| fkCTYpeID | int | 4 | √ | null |
|
|
Correspondence type reference - Type classification for the correspondence |
|
| ScreenAttachment | nvarchar | 2000 | √ | null |
|
|
Screen attachment - Screenshot or screen capture attachment |
|
| CompanyName | varchar | 50 | √ | null |
|
|
Company name - Name of the company or agency |
|
| Page | varchar | 50 | √ | null |
|
|
Page reference - System page or module where the inquiry originated |
Relationships
Close relationships within degrees of separation
