StoredProcInFlexForm


Description

Stored procedure form associations linking stored procedures to flexible forms for automated form processing and validation. This junction table manages the relationship between stored procedures and flex forms including execution order to support form-driven stored procedure execution, automated data processing, and form validation workflows for healthcare data management.

Columns

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

Primary key - Unique identifier for each stored procedure-form association
fkFlexFormID int 4 null
FlexForm.pkFlexFormID FK_StoredProcinFlexForm_FlexForm R

Flex form reference - Links to FlexForm table for the form that uses this stored procedure
fkSPID int 4 null
StoredProc.pkSPID FK_StoredProcinFlexForm_StoredProc R

Stored procedure reference - Links to StoredProc table for the procedure to execute
ExecOrder int 4 null

Execution order - Order in which this stored procedure should be executed relative to other procedures

Indexes

Constraint Name Type Sort Column(s)
PK__StoredPr__8473B70229D28329 Primary key Asc pkSPinFormID

Relationships

Close relationships within degrees of separation