PaysourceInCase


Description

Payment source case associations linking payment sources to specific patient cases for billing and financial management. This junction table manages the relationship between payment sources and patient cases, supporting case-specific billing arrangements, payment source assignments, and financial tracking for individual patient cases across different healthcare programs and services.

Columns

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

Primary key - Unique identifier for each payment source-case association
fkCaseID int 4 √ null
PatientAdministration.AdmitID FK__Paysource__fkCas__55374011 C

Case reference - Links to PatientAdministration table for the patient case
fkSourceID varchar 30 √ null

Source reference - Links to payment source responsible for this case

Indexes

Constraint Name Type Sort Column(s)
PK__PaysourceInCase__54431BD8 Primary key Asc PayCaseID
PaysourceInCase_fkcaseid Performance Asc fkCaseID

Relationships

Close relationships within degrees of separation