AgencyProgramType


Description

Agency program configurations linking agencies to the specific healthcare programs they offer. This table defines which program types (Early Intervention, Special Education, Therapy Services, etc.) each agency is authorized to provide and their associated billing configurations.

Columns

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

Agency reference - Links to iCS2.dbo.Agency for centralized healthcare provider organization management
ProgramID int 4 √ null

Program type reference - Links to iCS2.dbo.ProgramType for centralized program type definitions and healthcare service category management
AgencyProgramID int identity 4 √ null

Primary key - Unique identifier for each agency-program relationship
fkABID int 4 √ null
AgencyBillingtype.ABID FK__AgencyPro__fkABI__06CE9BA5 R

Billing type reference - Links to AgencyBillingtype table for billing configuration
fkUserID int 4 √ null

Program coordinator - UserID of the staff member responsible for this program
BillDateLimit int 4 √ null

Billing date limit - Number of days limit for billing submission for this program

Indexes

Constraint Name Type Sort Column(s)
IX_ProgramID Performance Asc ProgramID

Relationships

Close relationships within degrees of separation