Option_VW


Description

Configuration options view providing a comprehensive view of custom configuration options with program associations for system configuration management. This view joins custom configurations with program types to display configuration options, descriptions, comments, and program-specific settings, supporting system configuration, option management, and program-specific customization for healthcare applications.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
configID int 4 null

Configuration identifier - Unique identifier for each configuration option

configDesc varchar 50 null

Configuration description - Descriptive name of the configuration option

configComments varchar 200 null

Configuration comments - Additional comments or notes about the configuration option

configType int 4 null

Configuration type - Numeric type classification for the configuration option

Temp_ID int 4 null

Temporary identifier - Temporary ID used for configuration management

programName varchar 255 null

Program name - Name of the program type associated with this configuration

programid int 4 null

Program identifier - Unique identifier for the program type

orderBy int 4 null

Display order - Numeric order for displaying configuration options

Relationships

View Definition


Possibly Referenced Tables/Views