Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProgramName | varchar | 255 | √ | null |
|
|
Program name - Descriptive name of the healthcare program type |
|
| ProgramId | int identity | 4 | null |
|
|
Program primary key - Unique identifier for the program type |
||
| CustomForm | nvarchar | 1073741823 | √ | null |
|
|
Custom forms list - Comma-separated list of custom forms assigned to this program with data source types |
|
| PaySources | nvarchar | 1073741823 | √ | null |
|
|
Payment sources list - Comma-separated list of payment sources available for this program |
|
| UserId | int | 4 | √ | null |
|
|
User reference - UserID associated with this program type |
|
| BillingForms | nvarchar | 1073741823 | √ | null |
|
|
Billing forms list - Comma-separated list of billing forms configured for this program |
|
| BillingFormsDescriptions | nvarchar | 1073741823 | √ | null |
|
|
Billing form descriptions - Comma-separated list of billing form descriptions |
|
| BillingFormsActions | nvarchar | 1073741823 | √ | null |
|
|
Billing form actions - Comma-separated list of billing form actions and statuses |
|
| BillingMethod | nvarchar | 1073741823 | √ | null |
|
|
Billing methods - Comma-separated list of billing method logic names for this program |
Relationships
Close relationships within degrees of separation
