Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ApprovalLevel | Unknown | 0 | null |
|
|
Approval level - Level of approval required for checklist completion |
||
| BillingCode | Unknown | 0 | null |
|
|
Billing code - Associated billing code for checklist completion |
||
| pkChecklistID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist |
|
| LinkTo | nvarchar | 200 | √ | null |
|
|
Link target - Entity or record this checklist is linked to (Patient, Case, etc.) |
|
| ChecklistName | nvarchar | 400 | √ | null |
|
|
Checklist name - Descriptive name of the checklist |
|
| ChecklistDesc | nvarchar | 1073741823 | √ | null |
|
|
Checklist description - Detailed description of the checklist purpose and requirements |
|
| fkCategoryID | int | 4 | √ | null |
|
|
Category reference - Links to Categories table for checklist categorization |
|
| OrderBy | int | 4 | √ | null |
|
|
Display order - Order for displaying this checklist |
|
| AutoCreate | int | 4 | √ | null |
|
|
Auto-create flag - Indicates if checklist should be automatically created |
|
| CompleteValidation | int | 4 | √ | null |
|
|
Completion validation - Validation rules for checklist completion |
|
| ComplianceStandard | Unknown | 0 | null |
|
|
Compliance standard - Specific regulatory or compliance standard this checklist addresses |
||
| CostCenter | Unknown | 0 | null |
|
|
Cost center - Cost center associated with checklist completion |
||
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Soft delete flag for audit trail |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the checklist |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the checklist was created |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date of the last modification |
|
| AssignedID | int | 4 | √ | (NULL) |
|
|
Assigned user - UserID of the person assigned to complete the checklist |
|
| Department | Unknown | 0 | null |
|
|
Department - Department or unit responsible for this checklist |
||
| DocumentationRequired | Unknown | 0 | null |
|
|
Documentation required - Boolean flag indicating if documentation is required |
||
| DueDays | Unknown | 0 | null |
|
|
Due days - Number of days from assignment until checklist is due |
||
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this version of the checklist becomes effective |
||
| EstimatedDuration | Unknown | 0 | null |
|
|
Estimated duration - Expected time required to complete the checklist |
||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the checklist |
|
| ManagerID | int | 4 | √ | (NULL) |
|
|
Manager reference - UserID of the manager overseeing this checklist |
|
| fkLibChecklistID | int | 4 | √ | null |
|
|
Library checklist reference - Links to library checklist template |
|
| parentCheckListID | int | 4 | √ | null |
|
|
Parent checklist - Links to parent checklist for hierarchical checklists |
|
| status | int | 4 | √ | null |
|
|
Checklist status - Current status of the checklist (Pending, In Progress, Complete, etc.) |
|
| isAdHoc | bit | 1 | √ | null |
|
|
Ad hoc flag - Boolean indicating if this is an ad hoc checklist |
|
| isManage | bit | 1 | √ | null |
|
|
Management flag - Boolean indicating if this is a management checklist |
|
| EventDate | smalldatetime | 16 | √ | null |
|
|
Event date - Date of the event that triggered this checklist |
|
| EventName | varchar | 100 | √ | null |
|
|
Event name - Name of the triggering event |
|
| EventSystemDate | varchar | 100 | √ | null |
|
|
System event date - System date when the event occurred |
|
| EventType | int | 4 | √ | null |
|
|
Event type - Type classification of the triggering event |
|
| CaseType | nvarchar | 400 | √ | null |
|
|
Case type - Type of case this checklist applies to |
|
| VisitCode | nvarchar | 400 | √ | null |
|
|
Visit code - Visit codes this checklist applies to |
|
| GetFormId | int | 4 | √ | null |
|
|
Form reference - Links to associated form for this checklist |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer item market reference - Links to layer item market configuration |
|
| PublishBy | int | 4 | √ | null |
|
|
Published by user - UserID of the person who published the checklist |
|
| PublishToId | int | 4 | √ | null |
|
|
Publish target - Target for checklist publication |
|
| UserLeaders | nvarchar | 1073741823 | √ | null |
|
|
User leaders - List of user leaders for this checklist |
|
| TeamLeaders | nvarchar | 1073741823 | √ | null |
|
|
Team leaders - List of team leaders for this checklist |
|
| RoleLeaders | nvarchar | 1073741823 | √ | null |
|
|
Role leaders - List of role leaders for this checklist |
|
| ChecklistColor | nvarchar | 20 | √ | null |
|
|
Checklist color - Color coding for visual identification |
|
| CompletionCriteria | Unknown | 0 | null |
|
|
Completion criteria - Specific criteria that must be met for checklist completion |
||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when this version of the checklist expires |
||
| Instructions | Unknown | 0 | null |
|
|
Instructions - Detailed instructions for completing the checklist |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean flag indicating if the checklist is available for use |
||
| NotificationSettings | Unknown | 0 | null |
|
|
Notification settings - Configuration for notifications related to this checklist |
||
| Priority | Unknown | 0 | null |
|
|
Priority level - Priority classification for the checklist |
||
| RegulatoryRequirement | Unknown | 0 | null |
|
|
Regulatory requirement - Indicates if checklist is required for regulatory compliance |
||
| RequiresApproval | Unknown | 0 | null |
|
|
Approval requirement - Boolean flag indicating if checklist completion requires approval |
||
| SignatureRequired | Unknown | 0 | null |
|
|
Signature required - Boolean flag indicating if signature is required for completion |
||
| SkillLevel | Unknown | 0 | null |
|
|
Required skill level - Minimum skill level required to complete the checklist |
||
| Tags | Unknown | 0 | null |
|
|
Tags - Keywords or tags for categorizing and searching checklists |
||
| Version | Unknown | 0 | null |
|
|
Version number - Version tracking for checklist revisions |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CheckList | Primary key | Asc | pkChecklistID |
| IX_IDs | Performance | Asc/Asc/Asc | fkCategoryID + fkLibChecklistID + parentCheckListID |
| IX_LinkTo | Performance | Asc/Asc/Asc | LinkTo + ChecklistName + OrderBy |
