Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| facility_id | varchar | 20 | null |
|
|
|||||
| Ownership | varchar | 50 | null |
|
|
|||||
| report_month | date | 6 | null |
|
|
|||||
| report_day | date | 6 | null |
|
|
|||||
| Resident_ID | int | 4 | √ | null |
|
|
||||
| ROX_Facility_ID | int | 4 | √ | null |
|
|
||||
| Facility | varchar | 100 | √ | null |
|
|
||||
| PatientName | varchar | 50 | √ | null |
|
|
||||
| IsPriorMonthAdjustments | bit | 1 | √ | null |
|
|
||||
| PayerName | varchar | 100 | √ | null |
|
|
||||
| DateOfService | datetime | 16,3 | √ | null |
|
|
||||
| Discipline | varchar | 10 | √ | null |
|
|
||||
| Duration | decimal | 12,2 | √ | null |
|
|
||||
| TxUnits | int | 4 | √ | null |
|
|
||||
| Units | decimal | 20,13 | √ | null |
|
|
||||
| RUGScore | varchar | 3 | √ | null |
|
|
||||
| CPTCode | varchar | 10 | √ | null |
|
|
||||
| IsRUGBased | bit | 1 | √ | null |
|
|
||||
| PDPM_BillingMethod | char | 1 | √ | null |
|
|
||||
| DisplayQuantity | decimal | 30,13 | √ | null |
|
|
||||
| DisplayQuantityUnits | varchar | 25 | √ | null |
|
|
||||
| Description | varchar | 25 | √ | null |
|
|
||||
| Amount | decimal | 30,13 | √ | null |
|
|
||||
| Rate | decimal | 30,17 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
