Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
PROVNUM | varchar | 500 | null |
|
|
|||
PROVNAME | varchar | 500 | √ | null |
|
|
||
ADDRESS | varchar | 500 | √ | null |
|
|
||
CITY | varchar | 500 | √ | null |
|
|
||
STATE | varchar | 500 | √ | null |
|
|
||
ZIP | varchar | 500 | √ | null |
|
|
||
PHONE | varchar | 500 | √ | null |
|
|
||
COUNTY_SSA | varchar | 500 | √ | null |
|
|
||
COUNTY_NAME | varchar | 500 | √ | null |
|
|
||
OWNERSHIP | varchar | 500 | √ | null |
|
|
||
BEDCERT | varchar | 500 | √ | null |
|
|
||
RESTOT | varchar | 500 | √ | null |
|
|
||
CERTIFICATION | varchar | 500 | √ | null |
|
|
||
INHOSP | varchar | 500 | √ | null |
|
|
||
LBN | varchar | 500 | √ | null |
|
|
||
PARTICIPATION_DATE | date | 6 | √ | null |
|
|
||
CCRC_FACIL | varchar | 500 | √ | null |
|
|
||
SFFSTATUS | varchar | 500 | √ | null |
|
|
||
OLDSURVEY | varchar | 500 | √ | null |
|
|
||
CHOW_LAST_12MOS | varchar | 500 | √ | null |
|
|
||
RESFAMCOUNCIL | varchar | 500 | √ | null |
|
|
||
SPRINKLER_STATUS | varchar | 500 | √ | null |
|
|
||
OVERALL_RATING | decimal | 20,5 | √ | null |
|
|
||
OVERALL_RATING_FN | varchar | 500 | √ | null |
|
|
||
SURVEY_RATING | decimal | 20,5 | √ | null |
|
|
||
SURVEY_RATING_FN | varchar | 500 | √ | null |
|
|
||
QUALITY_RATING | decimal | 20,5 | √ | null |
|
|
||
QUALITY_RATING_FN | varchar | 500 | √ | null |
|
|
||
LS_QUALITY_RATING | decimal | 20,5 | √ | null |
|
|
||
LS_QUALITY_RATING_FN | varchar | 500 | √ | null |
|
|
||
SS_QUALITY_RATING | decimal | 20,5 | √ | null |
|
|
||
SS_QUALITY_RATING_FN | varchar | 500 | √ | null |
|
|
||
STAFFING_RATING | decimal | 20,5 | √ | null |
|
|
||
STAFFING_RATING_FN | varchar | 500 | √ | null |
|
|
||
RN_STAFFING_RATING | decimal | 20,5 | √ | null |
|
|
||
RN_STAFFING_RATING_FN | varchar | 500 | √ | null |
|
|
||
STAFFING_FLAG | varchar | 500 | √ | null |
|
|
||
PT_STAFFING_FLAG | varchar | 500 | √ | null |
|
|
||
AIDHRD | decimal | 20,5 | √ | null |
|
|
||
VOCHRD | decimal | 20,5 | √ | null |
|
|
||
RNHRD | decimal | 20,5 | √ | null |
|
|
||
TOTLICHRD | decimal | 20,5 | √ | null |
|
|
||
TOTHRD | decimal | 20,5 | √ | null |
|
|
||
PTHRD | decimal | 20,5 | √ | null |
|
|
||
CM_AIDE | varchar | 500 | √ | null |
|
|
||
CM_LPN | varchar | 500 | √ | null |
|
|
||
CM_RN | varchar | 500 | √ | null |
|
|
||
CM_TOTAL | varchar | 500 | √ | null |
|
|
||
ADJ_AIDE | decimal | 20,5 | √ | null |
|
|
||
ADJ_LPN | decimal | 20,5 | √ | null |
|
|
||
ADJ_RN | decimal | 20,5 | √ | null |
|
|
||
ADJ_TOTAL | decimal | 20,5 | √ | null |
|
|
||
CYCLE_1_DEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_1_NFROMDEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_1_NFROMCOMP | varchar | 500 | √ | null |
|
|
||
CYCLE_1_DEFS_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_1_SURVEY_DATE | date | 6 | √ | null |
|
|
||
CYCLE_1_NUMREVIS | varchar | 500 | √ | null |
|
|
||
CYCLE_1_REVISIT_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_1_TOTAL_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_2_DEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_2_NFROMDEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_2_NFROMCOMP | varchar | 500 | √ | null |
|
|
||
CYCLE_2_DEFS_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_2_SURVEY_DATE | date | 6 | √ | null |
|
|
||
CYCLE_2_NUMREVIS | varchar | 500 | √ | null |
|
|
||
CYCLE_2_REVISIT_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_2_TOTAL_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_3_DEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_3_NFROMDEFS | varchar | 500 | √ | null |
|
|
||
CYCLE_3_NFROMCOMP | varchar | 500 | √ | null |
|
|
||
CYCLE_3_DEFS_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_3_SURVEY_DATE | date | 6 | √ | null |
|
|
||
CYCLE_3_NUMREVIS | varchar | 500 | √ | null |
|
|
||
CYCLE_3_REVISIT_SCORE | varchar | 500 | √ | null |
|
|
||
CYCLE_3_TOTAL_SCORE | varchar | 500 | √ | null |
|
|
||
WEIGHTED_ALL_CYCLES_SCORE | varchar | 500 | √ | null |
|
|
||
INCIDENT_CNT | decimal | 20,5 | √ | null |
|
|
||
CMPLNT_CNT | decimal | 20,5 | √ | null |
|
|
||
FINE_CNT | decimal | 20,5 | √ | null |
|
|
||
FINE_TOT | decimal | 20,5 | √ | null |
|
|
||
PAYDEN_CNT | decimal | 20,5 | √ | null |
|
|
||
TOT_PENLTY_CNT | decimal | 20,5 | √ | null |
|
|
||
FILEDATE | date | 6 | null |
|
|
|||
AVA_InsDate | datetime2 | 16,3 | (getdate()) |
|
|
|||
AVA_YYYYMMKey | int | 4 | null |
|
|
|||
AVA_FileKey | varchar | 100 | null |
|
|
|||
RESAVG_FN | varchar | 500 | √ | null |
|
|
||
CITEABUSE | varchar | 100 | √ | null |
|
|
||
LOCATION | varchar | 500 | √ | null |
|
|
||
Number of Citations from Infection Control Inspections | int | 4 | √ | null |
|
|
||
Total number of nurse staff hours per resident per day on the weekend | decimal | 20,5 | √ | null |
|
|
||
Reported Physical Therapist Staffing Hours per Resident Per Day | decimal | 20,5 | √ | null |
|
|
||
Total nursing staff turnover | decimal | 20,5 | √ | null |
|
|
||
Total nursing staff turnover footnote | varchar | 1000 | √ | null |
|
|
||
Registered Nurse turnover | decimal | 20,5 | √ | null |
|
|
||
Registered Nurse turnover footnote | varchar | 1000 | √ | null |
|
|
||
Number of administrators who have left the nursing home | decimal | 20,5 | √ | null |
|
|
||
Administrator turnover footnote | varchar | 1000 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
Medicare_ProviderInfo_PK | Primary key | Asc/Asc | PROVNUM + FILEDATE |
Medicare_ProviderInfo_IX1 | Performance | Asc/Asc | AVA_YYYYMMKey + AVA_FileKey |
Diagram producer might be missing
No diagrams were produced please see application output for any errors