Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ExportKey | varchar | 20 | null |
|
|
|||||
| Ownership | varchar | 50 | null |
|
|
|||||
| report_month | date | 6 | null |
|
|
|||||
| report_day | date | 6 | null |
|
|
|||||
| Resident_ID | int | 4 | √ | null |
|
|
||||
| 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 |
|
|
||||
| AVA_ins_date | datetime2 | 16,3 | (getdate()) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CIX_ROX_Patient_Billings | Performance | Asc/Asc/Asc/Asc | report_month + report_day + ExportKey + Resident_ID |
Relationships
Close relationships within degrees of separation
