Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| siteid | int | 4 | √ | null |
|
|
Site reference - Links to the agency site where services were provided |
|
| patientid | int | 4 | √ | null |
|
|
Patient reference - Links to the patient who received services |
|
| Dateservice | varchar | 7 | √ | null |
|
|
Service date - Date when services were provided (stored as varchar for flexible date handling) |
|
| Amountcharged | money | 21,4 | √ | null |
|
|
Charged amount - Monetary amount charged for services during this period |
|
| DateEntered | datetime | 16,3 | √ | null |
|
|
Entry date - Date when this aging period record was created |
Relationships
Close relationships within degrees of separation
