ControlInSQL


Description

SQL control definitions managing SQL queries and control logic for activity assignment type controls. This table stores SQL statements and control logic used in activity assignment workflows, enabling dynamic control behavior, data validation, and business rule enforcement for healthcare activity management and assignment processes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkControlSQLID int identity 4 √ null

Primary key - Unique identifier for each SQL control
fkAATID int 4 null
ActivityAssignmentTypeControls.ActivityAssignmentTypeControlID FK_ControlInSQL_ActivityAssignmentTypeControls R

Activity assignment type reference - Links to ActivityAssignmentTypeControls for the associated control
ControlSQL varchar 5000 null

SQL statement - SQL query or control logic for this control

Indexes

Constraint Name Type Sort Column(s)
PK_ControlInSQL Primary key Asc pkControlSQLID

Relationships

Close relationships within degrees of separation