EnrollmentCasePaysources


Description

Enrollment case payment sources linking enrollments to payment sources with percentage allocations and invoice scheduling. This table manages the relationship between enrollments and payment sources including percentage splits and invoice scheduling to support multi-payer enrollment management and billing allocation.

Columns

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

Primary key - Unique identifier for each enrollment paysource assignment
fkPaysourceID int 4 null
PaySource.PSID FK_EnrollmentCasePaysources_Paysource R

Paysource reference - Links to PaySource table for the payment source
fkEnrollmentID int 4 null
Enrollments.pkEnrollmentID FK_EnrollmentCasePaysources_Enrollments R

Enrollment reference - Links to Enrollments table for the enrollment
Percent int 4 √ null

Payment percentage - Percentage of costs covered by this payment source
InvoiceSchedule int 4 √ null

Invoice schedule - Schedule for invoicing this payment source
PaymentMethod nvarchar 100 √ null

Payment method - Method of payment for this payment source
CreatedBy int 4 √ null

Created by user - UserID of the person who created this association
DateCreated datetime 16,3 √ null

Creation date - Date when the association was created
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified this association
DateUpdated datetime 16,3 √ null

Last update date - Date when the association was last modified
DateDeleted datetime 16,3 √ null

Deletion date - Date when the association was deleted (soft delete)

Indexes

Constraint Name Type Sort Column(s)
PK_EnrollmentCasePaysources Primary key Asc ID

Relationships

Close relationships within degrees of separation