Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AttachmentRequired | Unknown | 0 | null |
|
|
Attachment required - Boolean indicating if document attachment is required |
||
| ChoiceOptions | Unknown | 0 | null |
|
|
Choice options - Available choices for choice-type fields |
||
| Comments | Unknown | 0 | null |
|
|
Field comments - Additional comments or notes about the field value |
||
| CompletedBy | Unknown | 0 | null |
|
|
Completed by user - UserID of the person who completed the field |
||
| DateValue | smalldatetime | 16 | √ | null |
|
|
Date value - Date value for date-type checklist fields |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this value |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the value was created |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date of the last modification |
|
| BitValue | bit | 1 | √ | null |
|
|
Boolean value - Boolean value for yes/no or checkbox-type fields |
|
| AssignedUserID | int | 4 | √ | null |
|
|
Assigned user - UserID of the person assigned to complete this item |
|
| CompletedDate | datetime | 16,3 | √ | null |
|
|
Completion date - Date and time when the item was completed |
|
| DefaultValue | Unknown | 0 | null |
|
|
Default value - Default value for the field |
||
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Soft delete flag for audit trail |
|
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Order for displaying fields within the checklist item |
||
| FieldName | Unknown | 0 | null |
|
|
Field name - Name of the field being valued |
||
| FieldType | Unknown | 0 | null |
|
|
Field type - Type of field (text, number, date, choice, etc.) |
||
| FieldValue | Unknown | 0 | null |
|
|
Field value - Actual value or response entered for the field |
||
| fkCheckListItemID | int | 4 | null |
|
|
Checklist item reference - Links to CheckListItems for the associated item |
||
| fkLinkToID | int | 4 | √ | null |
|
|
Link reference - Links to the entity this field value is associated with (Patient, Case, etc.) |
|
| DueDate | smalldatetime | 16 | √ | null |
|
|
Due date - Due date for completing this checklist item |
|
| HelpText | Unknown | 0 | null |
|
|
Help text - Instructional text to assist with field completion |
||
| IntValue | int | 4 | √ | null |
|
|
Integer value - Numeric value for number-type checklist fields |
|
| isComplete | bit | 1 | √ | null |
|
|
Completion flag - Boolean indicating if this checklist item is complete |
|
| IsEditable | Unknown | 0 | null |
|
|
Editable flag - Boolean indicating if the field value can be edited |
||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Boolean indicating if this field is required for completion |
||
| IsVisible | Unknown | 0 | null |
|
|
Visibility flag - Boolean indicating if the field is visible to users |
||
| pkChecklistFieldValueID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each field value |
|
| TextValue | nvarchar | 1000 | √ | null |
|
|
Text value - Text value for text-type checklist fields |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this value |
|
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table if item is patient-specific |
|
| UserID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the user associated with this value |
|
| ValidationRule | Unknown | 0 | null |
|
|
Validation rule - Validation logic applied to the field value |
||
| VerifiedBy | Unknown | 0 | null |
|
|
Verified by user - UserID of the person who verified the field value |
||
| VerifiedDate | Unknown | 0 | null |
|
|
Verification date - Date when the field value was verified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistFieldValues | Primary key | Asc | pkChecklistFieldValueID |
| IX_fkChecklistItemID_fkLinkToID | Performance | Asc/Asc | fkCheckListItemID + fkLinkToID |
| IX_IsComplete | Performance | Asc | isComplete |
Relationships
Close relationships within degrees of separation
