CheckList

Primary key - Unique identifier for each checklist, auto-incrementing integer

Entity association - Reference to the entity type this checklist is linked to (e.g., Case, Patient, Project)

Checklist title - Descriptive name of the checklist for identification and user interface display

Checklist description - Detailed description of the checklist purpose, scope, and completion criteria

Category reference - Foreign key linking to checklist category for organization and filtering

Display order - Numeric sequence for ordering checklists in lists and user interfaces

Auto-creation flag - Numeric flag indicating if checklist should be automatically created under certain conditions

Completion validation - Numeric code defining validation rules required for checklist completion

Soft delete flag - Boolean indicating if checklist is logically deleted but retained for audit

Creator user ID - Reference to user who created the checklist for accountability

Creation timestamp - When the checklist was first created

Last modifier - User ID who made the most recent update to the checklist

Last modification timestamp - When the checklist was most recently updated

Assigned user - User ID of person assigned to complete this checklist

Manager user - User ID of manager overseeing checklist completion and approval

Library reference - Foreign key linking to checklist library template for standardization

Parent checklist - Reference to parent checklist for hierarchical checklist structures

Checklist status - Numeric code indicating current status (e.g., Active, Completed, On Hold)

Ad-hoc flag - Boolean indicating if this is an ad-hoc checklist created for specific circumstances

Management flag - Boolean indicating if this checklist requires management oversight

Event date - Date when the event or process requiring this checklist occurred

Event name - Name of the event or process that triggered this checklist

System event date - System-generated date for event tracking and automation

Event type - Numeric classification of the event type that triggered this checklist

Case type - Classification of case or process type for checklist categorization

Visit code - Code identifying the type of visit or interaction associated with this checklist

Form reference - Reference to form associated with this checklist for data collection

Publication target - Reference to entity or user this checklist should be published to

Publisher user - User ID who published or shared this checklist

Market layer reference - Reference to market or layer context for multi-tenant checklist management

User leaders - List of user leaders responsible for checklist oversight and approval

Team leaders - List of team leaders involved in checklist management and completion

Role leaders - List of role-based leaders with authority over this checklist

Visual color - Color code for checklist visual identification and categorization