AgConfigIDinProgType


Description

Agency configuration ID types by program defining which ID types are configured for different program types within agencies. This table manages the relationship between ID type configurations and program types, controlling which identification systems are used for different healthcare programs and enabling program-specific ID validation rules.

Columns

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

ID type reference - Links to the type of identification system (SSN, Medicaid ID, etc.)
programID int 4 √ null

Program reference - Links to the specific program type this ID configuration applies to
Main int 4 √ (0)

Main ID flag - Indicates if this is the primary ID type for the program (0=secondary, 1=primary)
AllowDups int 4 √ null

Allow duplicates flag - Controls whether duplicate IDs are allowed for this ID type in this program

Indexes

Constraint Name Type Sort Column(s)
IX_IDTypeMain Performance Asc/Asc IDTypeID + Main
IX_ProgramID Performance Asc programID

Relationships

Close relationships within degrees of separation