CheckList


Description

Checklist definitions and instances managing workflow checklists and task lists for healthcare processes. This comprehensive table defines checklists with their items, assignments, validation rules, and workflow automation for ensuring compliance, quality assurance, and standardized processes in healthcare service delivery.

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

Relationships