Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
STATE | varchar | 500 | null |
|
|
|||
C1_HLTH_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
C1_FS_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
C2_HLTH_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
C2_FS_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
C3_HLTH_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
C3_FS_DEFS_CNT | decimal | 20,1 | √ | null |
|
|
||
RESTOT | decimal | 20,1 | √ | null |
|
|
||
AIDHRD | decimal | 20,2 | √ | null |
|
|
||
VOCHRD | decimal | 20,2 | √ | null |
|
|
||
RNHRD | decimal | 20,2 | √ | null |
|
|
||
TOTLICHRD | decimal | 20,2 | √ | null |
|
|
||
TOTHRD | decimal | 20,2 | √ | null |
|
|
||
PTHRD | decimal | 20,2 | √ | null |
|
|
||
CM_RN | decimal | 20,5 | √ | null |
|
|
||
CM_TOTAL | decimal | 20,5 | √ | null |
|
|
||
FINE_CNT | decimal | 20,1 | √ | null |
|
|
||
FINE_TOT | int | 4 | √ | null |
|
|
||
QM401 | decimal | 20,6 | √ | null |
|
|
||
QM402 | decimal | 20,6 | √ | null |
|
|
||
QM404 | decimal | 20,6 | √ | null |
|
|
||
QM405 | decimal | 20,6 | √ | null |
|
|
||
QM406 | decimal | 20,6 | √ | null |
|
|
||
QM407 | decimal | 20,6 | √ | null |
|
|
||
QM408 | decimal | 20,6 | √ | null |
|
|
||
QM409 | decimal | 20,6 | √ | null |
|
|
||
QM410 | decimal | 20,6 | √ | null |
|
|
||
QM415 | decimal | 20,6 | √ | null |
|
|
||
QM419 | decimal | 20,6 | √ | null |
|
|
||
QM424 | decimal | 20,6 | √ | null |
|
|
||
QM430 | decimal | 20,6 | √ | null |
|
|
||
QM434 | decimal | 20,6 | √ | null |
|
|
||
QM451 | decimal | 20,6 | √ | null |
|
|
||
QM452 | decimal | 20,6 | √ | null |
|
|
||
QM453 | decimal | 20,6 | √ | null |
|
|
||
QM454 | decimal | 20,6 | √ | null |
|
|
||
QM471 | decimal | 20,6 | √ | null |
|
|
||
QM472 | decimal | 20,6 | √ | null |
|
|
||
QM521 | decimal | 20,6 | √ | null |
|
|
||
QM522 | decimal | 20,6 | √ | null |
|
|
||
QM551 | decimal | 20,6 | √ | null |
|
|
||
QM552 | decimal | 20,6 | √ | null |
|
|
||
FILEDATE | varchar | 500 | null |
|
|
|||
AVA_InsDate | datetime2 | 16,3 | (getdate()) |
|
|
|||
AVA_YYYYMMKey | int | 4 | null |
|
|
|||
AVA_FileKey | varchar | 100 | null |
|
|
|||
QM002 | decimal | 20,6 | √ | null |
|
|
||
Total number of nurse staff hours per resident per day on the weekend | decimal | 20,5 | √ | null |
|
|
||
Registered Nurse hours per resident per day on the weekend | decimal | 20,5 | √ | null |
|
|
||
Total nursing staff turnover | decimal | 20,5 | √ | null |
|
|
||
Registered Nurse turnover | decimal | 20,5 | √ | null |
|
|
||
Number of administrators who have left the nursing home | decimal | 20,5 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
Medicare_StateUSAverages_PK | Primary key | Asc/Asc | STATE + FILEDATE |
Medicare_StateUSAverages_IX1 | Performance | Asc/Asc | AVA_YYYYMMKey + AVA_FileKey |
Diagram producer might be missing
No diagrams were produced please see application output for any errors