Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Alias | varchar | 100 | √ | null |
|
|
Text field - Alias text information for Paysource records |
|
| AccountNum | varchar | 50 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Paysource records |
|
| Address1 | varchar | 30 | √ | null |
|
|
Address information - Geographic location data for Paysource records |
|
| Address2 | varchar | 30 | √ | null |
|
|
Address information - Geographic location data for Paysource records |
|
| City | varchar | 50 | √ | null |
|
|
Address information - Geographic location data for Paysource records |
|
| ContactInfo | Unknown | 0 | null |
|
|
Contact information - Contact details for the payment source |
||
| FirstName | varchar | 30 | √ | null |
|
|
Name field - Descriptive name or identifier for Paysource records |
|
| fkpatientid | int | 4 | √ | null |
|
|
Foreign key reference - Reference to patientid table for data relationships |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this payment source is currently active |
||
| LastName | varchar | 30 | √ | null |
|
|
Name field - Descriptive name or identifier for Paysource records |
|
| Organization | varchar | 50 | √ | null |
|
|
Text field - Organization text information for Paysource records |
|
| PaySourceCode | Unknown | 0 | null |
|
|
Payment source code - Short code for the payment source |
||
| PaySourceId | Unknown | 0 | null |
|
|
Primary key - Paysource unique identifier for each payment source |
||
| PaySourceName | Unknown | 0 | null |
|
|
Payment source name - Name of the insurance company or payer |
||
| PaySourceType | Unknown | 0 | null |
|
|
Payment source type - Type of payer (Commercial, Medicaid, etc.) |
||
| PSID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| State | varchar | 5 | √ | null |
|
|
Address information - Geographic location data for Paysource records |
|
| Zip | varchar | 10 | √ | null |
|
|
Address information - Geographic location data for Paysource records |
|
| Department | varchar | 100 | √ | null |
|
|
Text field - Department text information for Paysource records |
|
| RateType | varchar | 20 | √ | null |
|
|
Type classification - Category or classification type for Paysource records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_PSID | Must be unique | Asc | PSID |