Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SourceID | varchar | 65 | √ | null |
|
|
Source identifier - Unique identifier combining source type prefix with ID (INS-, INST-, CLH-, DOH-, GUAR-) |
|
| SourceName | varchar | 145 | √ | null |
|
|
Source name - Descriptive name of the payment source or organization |
|
| fkPatientID | int | 4 | √ | null |
|
|
Patient reference - Links to specific patient for patient-specific payment sources (null for institutional sources) |
|
| fkSourceType | varchar | 4 | null |
|
|
Source type - Type classification (INS=Insurance, INST=Institution, CLH=Clearinghouse, DOH=Department of Health, GUAR=Guardian) |
||
| Address1 | varchar | 50 | √ | null |
|
|
Primary address - Street address of the payment source |
|
| Address2 | varchar | 50 | √ | null |
|
|
Secondary address - Additional address information (suite, floor, etc.) |
|
| City | varchar | 50 | √ | null |
|
|
City - City where the payment source is located |
|
| State | varchar | 50 | √ | null |
|
|
State - State or province of the payment source |
|
| Zip | varchar | 10 | √ | null |
|
|
ZIP code - Postal code for the payment source address |
|
| Alias | varchar | 100 | √ | null |
|
|
Source alias - Alternative name or abbreviation for the payment source |
|
| RateType | varchar | 20 | √ | null |
|
|
Rate type - Billing rate type (Per Service, Per Auth, etc.) |
|
| Firstname | varchar | 30 | √ | null |
|
|
Contact first name - First name of primary contact person |
|
| Lastname | varchar | 30 | √ | null |
|
|
Contact last name - Last name of primary contact person |
|
| pkId | int | 4 | null |
|
|
Primary key - Internal primary key from the source table |
Relationships
Close relationships within degrees of separation
