Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| siteid | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for the service delivery location |
|
| Dateservice | varchar | 7 | √ | null |
|
|
Service date - Date when the healthcare service was delivered (formatted for grouping) |
|
| programtypeid | int | 4 | √ | null |
|
|
Program type reference - Links to program type for categorization |
|
| Amountcharged | money | 21,4 | √ | null |
|
|
Charged amount - Total amount charged for services in this grouping |
Relationships
Close relationships within degrees of separation
