Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkCheckListItemID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each checklist item, auto-incrementing integer |
|
| fkChecklistID | int | 4 | null |
|
|
Checklist reference - Foreign key linking to CheckList.pkChecklistID for the parent checklist (required field) |
||
| CheckListItemName | nvarchar | 200 | √ | null |
|
|
Item name - Display name of the checklist item for user interface and task identification |
|
| CheckListItemDesc | nvarchar | 1000 | √ | null |
|
|
Item description - Detailed description of the task, requirement, or validation to be performed |
|
| CheckListItemType | nvarchar | 100 | √ | null |
|
|
Item type - Type classification defining the input method (e.g., Text, Date, Boolean, Choice, File) |
|
| IsRequired | bit | 1 | √ | null |
|
|
Required flag - Boolean indicating if this item must be completed for checklist completion |
|
| OrderBy | int | 4 | √ | null |
|
|
Display order - Numeric sequence for ordering items within the checklist |
|
| Deleted | bit | 1 | √ | null |
|
|
Soft delete flag - Boolean indicating if item is logically deleted but retained for audit |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this checklist item |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - When this checklist item was first created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this item |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last modification timestamp - When this item was most recently updated |
|
| AssignedID | int | 4 | √ | null |
|
|
Assigned user - User ID of person assigned to complete this specific item |
|
| AssignedUserID | int | 4 | √ | null |
|
|
Alternative assigned user - Alternative user assignment for flexible task delegation |
|
| AutoComplete | bit | 1 | √ | null |
|
|
Auto-completion flag - Boolean indicating if item can be automatically completed under certain conditions |
|
| isRequiredValue | bit | 1 | √ | null |
|
|
Value required flag - Boolean indicating if a value must be entered for this item |
|
| isDueDateCalculation | bit | 1 | √ | null |
|
|
Due date calculation flag - Boolean indicating if due date should be automatically calculated |
|
| DueDateValue | varchar | 100 | √ | null |
|
|
Due date calculation value - Value used in due date calculation formula |
|
| DueDateDays | varchar | 50 | √ | null |
|
|
Due date offset days - Number of days to add/subtract for due date calculation |
|
| DueDateBAO | varchar | 50 | √ | null |
|
|
Due date business rule - Business rule code for due date calculation (Before/After/On) |
|
| DueDateSelectedField | int | 4 | √ | null |
|
|
Due date reference field - Field ID used as reference point for due date calculation |
|
| isUserDueDate | bit | 1 | √ | null |
|
|
User-defined due date flag - Boolean indicating if user can manually set due date |
|
| ChoiceValue | varchar | 100 | √ | null |
|
|
Choice options - Predefined choice values for selection-type items |
|
| Query | varchar | 255 | √ | null |
|
|
Data query - SQL query or data source query for populating dynamic choice lists |
|
| QueryColumns | varchar | 255 | √ | null |
|
|
Query columns - Column specifications for query-based choice lists |
|
| ChoiceOption | varchar | 10 | √ | null |
|
|
Choice configuration - Configuration options for choice-type items |
|
| fkLibChecklistItemID | int | 4 | √ | null |
|
|
Library reference - Foreign key linking to library checklist item template |
|
| Custom | varchar | 100 | √ | null |
|
|
Custom configuration - Custom settings or configuration specific to this item |
|
| DueDate | smalldatetime | 16 | √ | null |
|
|
Static due date - Fixed due date for this checklist item |
|
| isRepeat | bit | 1 | √ | null |
|
|
Repeating item flag - Boolean indicating if this item repeats on a schedule |
|
| SystemDateType | varchar | 100 | √ | null |
|
|
System date type - Type of system date to use for calculations (e.g., Created, Updated, Event) |
|
| ShowAsTask | bit | 1 | ((1)) |
|
|
Task display flag - Boolean controlling whether item appears as a task in task lists (required field, defaults to true) |
||
| AssignedUsers | nvarchar | 1073741823 | √ | null |
|
|
Assigned user list - List of users assigned to complete this item |
|
| AssignedTeams | nvarchar | 1073741823 | √ | null |
|
|
Assigned team list - List of teams assigned to complete this item |
|
| AssignedRoles | nvarchar | 1073741823 | √ | null |
|
|
Assigned role list - List of roles assigned to complete this item |
|
| IsPausePoint | bit | 1 | ((0)) |
|
|
Workflow pause flag - Boolean indicating if workflow should pause at this item (required field, defaults to false) |
||
| Reoccurs | bit | 1 | √ | ((0)) |
|
|
Recurrence flag - Boolean indicating if this item recurs on a schedule |
|
| DueDateDataSourceField | nvarchar | 1073741823 | √ | null |
|
|
Due date data source - Data source field used for dynamic due date calculation |
|
| DueDateDataSourceFieldConfig | nvarchar | 1073741823 | √ | null |
|
|
Due date field configuration - Configuration for due date data source field usage |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CheckListFields | Primary key | Asc | pkCheckListItemID |