StoredProc


Description

Stored procedure definitions managing database stored procedures used for data processing, validation, and business logic execution. This table defines stored procedures including names, descriptions, threshold counts, and field associations to support automated data processing, business rule execution, and database-driven workflow automation for healthcare system operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkSPID int identity 4 √ null
ActionInStoredProc.FKSPID FK__ActionInS__FKSPI__533092BC R
FieldsInStoredProc.FKSPID FK__FieldsInS__FKSPI__4E6BDD9F R
FlexFormSettings.fkSPID FK_FlexFormSettings_StoredProc R
StoredProcInFlexForm.fkSPID FK_StoredProcinFlexForm_StoredProc R

Primary key - Unique identifier for each stored procedure definition
SPName varchar 50 √ null

Stored procedure name - Name of the database stored procedure
SPDesc varchar 200 √ null

Stored procedure description - Description of the stored procedure’s purpose and functionality
thresholdCount varchar 100 √ null

Threshold count - Threshold or limit value for stored procedure execution
fkFieldID int 4 √ null

Field reference - Links to field that this stored procedure operates on

Indexes

Constraint Name Type Sort Column(s)
PK__StoredProc__45D6979E Primary key Asc pkSPID

Relationships

Close relationships within degrees of separation