PaysourceInSite


Description

Payment source site associations linking payment sources to specific service delivery sites for location-based billing and financial management. This junction table manages the relationship between payment sources and service sites, supporting site-specific billing arrangements, payment source assignments, and financial tracking for healthcare services delivered at different locations.

Columns

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

Primary key - Unique identifier for each payment source-site association
fkSourceID varchar 20 √ null

Source reference - Links to payment source that funds services at this site
fkSiteID int 4 √ null
AgencySite.SiteID FK_PaysourceInSite_AgencySite R

Site reference - Links to AgencySite table for the service delivery location

Indexes

Constraint Name Type Sort Column(s)
PK_PaysourceInSite Primary key Asc pkPSID

Relationships

Close relationships within degrees of separation