Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillingID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each billing ID configuration |
|
| FieldID | int | 4 | √ | null |
|
|
Field reference - Links to the specific field or data element this billing ID applies to |
|
| DateEffective | datetime | 16,3 | √ | null |
|
|
Effective date - Date when this billing ID configuration becomes active |
|
| DateInactive | datetime | 16,3 | √ | null |
|
|
Inactive date - Date when this billing ID configuration becomes inactive |
|
| Status | varchar | 10 | √ | ('Active') |
|
|
Configuration status - Current status of the billing ID (Active, Inactive, Pending) |
|
| BillingTypeID | int | 4 | √ | null |
|
|
Billing type reference - Links to the type of billing this ID is used for |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AgencyBillingID__60BD35FF | Primary key | Asc | BillingID |
Relationships
Close relationships within degrees of separation
