Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ABID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each agency billing type configuration |
||||
| AgencyID | int | 4 | null |
|
|
Agency reference - Links to the healthcare provider agency |
|||||
| BillingTypeID | int | 4 | √ | null |
|
|
Billing type reference - Links to the specific billing type configuration |
||||
| AgencyBillingID | varchar | 50 | √ | null |
|
|
Agency billing identifier - Unique billing ID assigned to the agency for this billing type |
||||
| DateEffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when this billing type configuration becomes active |
||||
| DateInEffective | datetime | 16,3 | √ | null |
|
|
Inactive date - Date when this billing type configuration becomes inactive |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AgencyBillingtype | Primary key | Asc | ABID |
Relationships
Close relationships within degrees of separation
