ActivityAssignmentTypeControls


Description

Activity assignment type UI controls defining user interface controls and form elements for different activity assignment types. This table manages the dynamic form controls, field configurations, and user interface elements used when creating or editing activity assignments for different types of healthcare activities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ActivityAssignmentTypeControlID int identity 4 √ null
ControlInSQL.fkAATID FK_ControlInSQL_ActivityAssignmentTypeControls R

Primary key - Unique identifier for each control configuration
fkActivityAssignmentType int 4 √ null
ActivityAssignmentTypes.pkAssignmentTypeID FK_ActivityAssignmentTypeControls_ActivityAssignmentTypes R

Assignment type reference - Links to ActivityAssignmentTypes for the associated assignment type
fkControlTypeID int 4 √ null

Control type reference - Links to the type of UI control (textbox, dropdown, checkbox, etc.)
ControlID varchar 50 √ null

Control identifier - Unique identifier for the UI control element
ControlName varchar 100 √ null

Control name - Display name or label for the UI control
ControlSize int 4 √ null

Control size - Size specification for the UI control element
ControlClass varchar 50 √ null

Control CSS class - CSS class name for styling the UI control
ControlDefault varchar 50 √ null

Default value - Default value to populate in the UI control
ControlOrder int 4 √ null

Display order - Order in which the control appears on the form
show bit 1 √ null

Visibility flag - Boolean indicating if the control should be displayed

Indexes

Constraint Name Type Sort Column(s)
PK_ActivityAssignmentTypeControls Primary key Asc ActivityAssignmentTypeControlID

Relationships

Close relationships within degrees of separation