PaySource


Description

Payment source management storing comprehensive information about payment sources, insurance providers, and funding entities for healthcare billing. This table manages payment source details including contact information, addresses, account numbers, departments, and billing configurations, supporting comprehensive billing management, insurance processing, and financial administration for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PSID int identity 4 √ null
EnrollmentCasePaysources.fkPaysourceID FK_EnrollmentCasePaysources_Paysource R

Primary key - Unique identifier for each payment source
FirstName varchar 30 √ null

Contact first name - First name of the primary contact at the payment source
LastName varchar 30 √ null

Contact last name - Last name of the primary contact at the payment source
Organization varchar 50 √ null

Organization name - Name of the payment source organization or insurance company
Alias varchar 100 √ null

Payment source alias - Alternative name or alias for the payment source
AccountNum varchar 50 √ null

Account number - Account number or identifier for billing purposes
Address1 varchar 30 √ null

Primary address - Street address of the payment source
Address2 varchar 30 √ null

Secondary address - Additional address information (suite, floor, etc.)
City varchar 50 √ null

City - City where the payment source is located
State varchar 5 √ null

State - State or province where the payment source is located
Zip varchar 10 √ null

Zip code - Postal code for the payment source address
fkpatientid int 4 √ null

Patient reference - Links to specific patient if this is a patient-specific payment source
Department varchar 100 √ null

Department - Specific department within the payment source organization
RateType varchar 20 √ null

Rate type - Type of rate structure used for this payment source (e.g., ‘Hourly’, ‘Per Diem’, ‘Capitated’)
OriginalPSID int 4 √ null

Original payment source ID - Reference to the original payment source if this is a derived or copied payment source

Indexes

Constraint Name Type Sort Column(s)
PK_PaySource Primary key Asc PSID

Relationships

Close relationships within degrees of separation