Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AssignedDate | Unknown | 0 | null |
|
|
Assignment date - Date when the payment source was assigned |
|||||
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when the payment source becomes effective |
|||||
| ExpirationDate | Unknown | 0 | null |
|
|
Expiration date - Date when the payment source expires |
|||||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each enrollment payment source |
||||
| fkUserID | int | 4 | null |
|
|
User reference - Links to the user who assigned this payment source |
|||||
| fkEnrollmentID | int | 4 | null |
|
|
Enrollment reference - Links to the patient enrollment |
|||||
| Percent | int | 4 | √ | null |
|
|
Payment percentage - Percentage of costs covered by this payment source |
||||
| InvoiceSchedule | int | 4 | √ | null |
|
|
Invoice schedule - Billing schedule identifier for this payment source |
||||
| PaymentMethod | nvarchar | 100 | √ | null |
|
|
Payment method - Method of payment for this source (check, electronic, etc.) |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this assignment |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - Date and time when the assignment was created |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this assignment |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update timestamp - Date and time when the assignment was last modified |
||||
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Date and time when the assignment was deleted (soft delete) |
||||
| fkPaymentSourceID | Unknown | 0 | null |
|
|
Payment source reference - Links to the payment source |
|||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if the payment source is currently active |
|||||
| Notes | Unknown | 0 | null |
|
|
Assignment notes - Notes about the payment source assignment |
|||||
| Priority | Unknown | 0 | null |
|
|
Payment priority - Priority order for multiple payment sources |
|||||
| Status | Unknown | 0 | null |
|
|
Assignment status - Status of the payment source assignment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_EnrollmentPaysources | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
