Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgencyBillingID | varchar | 50 | √ | null |
|
|
Agency billing identifier - Unique billing ID assigned to the agency |
|
| DateEffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when the billing configuration becomes active |
|
| DateInEffective | datetime | 16,3 | √ | null |
|
|
Inactive date - Date when the billing configuration becomes inactive |
|
| ProgramID | int | 4 | √ | null |
|
|
Program reference - Links to the specific program type for this billing configuration |
|
| fkUserID | int | 4 | √ | null |
|
|
User reference - Links to the user associated with this billing configuration |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to the healthcare provider agency |
Relationships
Close relationships within degrees of separation
