PaySourceInProgramType


Description

Payment source program associations linking payment sources to specific program types with authorization and billing requirements. This junction table manages the relationship between payment sources and program types including status tracking, authorization requirements, invoice logging, and claim site requirements, supporting program-specific billing configurations and payment source management.

Columns

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

Primary key - Unique identifier for each payment source-program association
fkProgramID int 4 √ null

Program reference - Links to program type that accepts this payment source
fkSourceID varchar 50 √ null

Source reference - Links to payment source that funds this program
PSStatus varchar 30 √ null

Payment source status - Status of the payment source for this program (e.g., ‘Active’, ‘Inactive’, ‘Pending’)
authRequired int 4 √ null

Authorization required flag - Numeric indicator whether authorization is required for this payment source
fkInvLogID int 4 √ null

Invoice log reference - Links to invoice logging configuration for this payment source
requireClaimSite int 4 √ null

Claim site required flag - Numeric indicator whether claim site is required for billing

Indexes

Constraint Name Type Sort Column(s)
PK_PaySourceInProgramType Primary key Asc PrgSrcID
IX_ProgramInvLogID Performance Asc/Asc fkProgramID + fkInvLogID
IX_SourceID Performance Asc fkSourceID

Relationships

Close relationships within degrees of separation