Supplemental Healthcare Facility Assessment Variables

Last edit: 1/7/2016

Healthcare Facility Assessment (HFA) Variables: EIP

Data to be obtained from the CMS Nursing Home Compare website site https://www.medicare.gov/nursinghomecompare/search.html from the section “Download the Nursing Home Compare database” and available in Microsoft Excel format.

From the file “ProviderInfo_download” use facility name, address and provider number to identify the rows which represent facilities participating in the 2017 prevalence survey. Then include in the file the two variables FACID and DATA_DATE, and remove the variables (columns) that could be used to identify participating nursing homes so that only the variable listed below remain.

Table 1: Nursing home provider information, quality start ratings, inspection survey, staffing, and quality measure rating variables to be obtained from CMS Nursing Home Compare
Variable name	Label	Description	Format/Values
FACID	CDC Facility ID	Unique identification facility code assigned by EIP staff	7 alphanumeric characters
DATA_DATE	Date data retrieved from CMS website	Date data retrieved from CMS website	YYYY-MM-DD
Variable Name	Label	Description	Format / Values
OWNERSHIP	Ownership Type	Nature of organization that operates a provider of services	text
BEDCERT	Number of Certified Beds	Number of Federally Certified Beds	integer
RESTOT	Number of Residents in Certified Beds	Number of Residents in Federally Certified Beds	integer
CERTIFICATION	Provider Type	Category which is most indicative of provider	text
INHOSP	Provider Resides in Hospital	Facility Resides in Hospital Inidcator	Y/N
CCRC_FACIL	Continuing Care Retirement Community	Continuing Care Retirement Community Indicator	Y/N
overall_rating	Overall Rating	Overall Rating	one-digit, values 1-5
overall_rating_fn	Overall Rating Footnote	Overall Rating Footnote	text
survey_rating	Health Inspection Rating	Health Inspection Rating	one-digit, values 1-5
survey_rating_fn	Health Inspection Rating Footnote	Health Inspection Rating Footnote	text
quality_rating	QM Rating	QM Rating	one-digit, values 1-5
quality_rating_fn	QM Rating Footnote	QM Rating Footnote	text
staffing_rating	Staffing Rating	Staffing Rating	one-digit, values 1-5
staffing_rating_fn	Staffing Rating Footnote	Staffing Rating Footnote	text
RN_staffing_rating	RN Staffing Rating	RN Staffing Rating	one-digit, values 1-5
rn_staffing_rating_fn	RN Staffing Rating Footnote	RN Staffing Rating Footnote	text
STAFFING_FLAG	Reported Staffing Footnote	Reported Staffing Footnote	text
PT_STAFFING_FLAG	Physical Therapist Staffing Footnote	Physical Therapy Staffing Footnote	text
AIDHRD	Reported CNA Staffing Hours per Resident per Day	Reported CNA Staffing - Hours per Resident per Day	real number, up to 5 decimal places
VOCHRD	Reported LPN Staffing Hours per Resident per Day	Reported LPN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
RNHRD	Reported RN Staffing Hours per Resident per Day	Reported RN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
TOTLICHRD	Reported Licensed Staffing Hours per Resident per Day	Reported Licensed Staffing - Hours per Resident per Day (RN + LPN)	real number, up to 5 decimal places
TOTHRD	Reported Total Nurse Staffing Hours per Resident per Day	Reported Total Nurse Staffing - Hours per Resident per Day (CNA+LPN+RN)	real number, up to 5 decimal places
PTHRD	Reported Physical Therapist Staffing Hours per Resident Per Day	Reported Physical Therapy Staffing - Hours per Resident Per Day	real number, up to 5 decimal places
exp_aide	Expected CNA Staffing Hours per Resident per Day	Expected CNA Staffing - Hours per Resident per Day	real number, up to 5 decimal places
exp_lpn	Expected LPN Staffing Hours per Resident per Day	Expected LPN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
exp_rn	Expected RN Staffing Hours per Resident per Day	Expected RN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
exp_total	Expected Total Nurse Staffing Hours per Resident per Day	Expected Total Nurse Staffing - Hours per Resident per Day (CNA+LPN+RN)	real number, up to 5 decimal places
adj_aide	Adjusted CNA Staffing Hours per Resident per Day	Adjusted CNA Staffing - Hours per Resident per Day	real number, up to 5 decimal places
adj_lpn	Adjusted LPN Staffing Hours per Resident per Day	Adjusted LPN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
adj_rn	Adjusted RN Staffing Hours per Resident per Day	Adjusted RN Staffing - Hours per Resident per Day	real number, up to 5 decimal places
adj_total	Adjusted Total Nurse Staffing Hours per Resident per Day	Adjusted Total Nurse Staffing - Hours per Resident per Day (CNA+LPN+RN)	real number, up to 5 decimal places
cycle_1_defs	Cycle 1 Total Number of Health Deficiencies	Total Number of Health Deficiencies in Cycle 1 - See CMS 5-Star Techinical Users' Guide for description of Cycles	integer
cycle_1_defs_score	Cycle 1 Health Deficiency Score	Cycle 1 - Health Deficiency Score	integer
CYCLE_1_SURVEY_DATE	Cycle 1 Standard Survey Health Date	Date of Cycle 1 Standard Health Survey Date	YYYY-MM-DD
CYCLE_1_TOTAL_SCORE	Cycle 1 Total Health Score	Cycle 1 - Total Health Inspection Score	integer
cycle_2_defs	Cycle 2 Total Number of Health Deficiencies	Total Number of Health Deficiencies in Cycle 2 - See CMS 5-Star Techinical Users' Guide for description of Cycles	integer
cycle_2_defs_score	Cycle 2 Health Deficiency Score	Cycle 2 - Health Deficiency Score	integer
CYCLE_2_SURVEY_DATE	Cycle 2 Standard Health Survey Date	Date of Cycle 2 Standard Health Survey Date	YYYY-MM-DD
CYCLE_2_TOTAL_SCORE	Cycle 2 Total Health Score	Cycle 2 - Total Health Inspection Score	integer
cycle_3_defs	Cycle 3 Total Number of Health Deficiencies	Total Number of Health Deficiencies in Cycle 3 - See CMS 5-Star Techinical Users' Guide for description of Cycles	integer
cycle_3_defs_score	Cycle 3 Health Deficiency Score	Cycle 3 - Health Deficiency Score	integer
CYCLE_3_SURVEY_DATE	Cycle 3 Standard Health Survey Date	Date of Cycle 3 Standard Health Survey Date	YYYY-MM-DD
CYCLE_3_NUMREVIS	Cycle 3 Number of Health Revisits	Number of Health Survey Repeat-Revisits for Cycle 3	integer
WEIGHTED_ALL_CYCLES_SCORE	Total Weighted Health Survey Score	Total Weighted Health Survey Score for all 3 cycles - See CMS 5-Star Techical Users' Guide for explanation of Weighting	real number, up to 3 decimal places
FINE_CNT	Number of Fines	Number of Fines	integer
FINE_TOT	Total Amount of Fines in Dollars	Total Amount of Fines in Dollars	integer
PAYDEN_CNT	Number of Payment Denials	Number of Payment Denials	integer
TOT_PENLTY_CNT	Total Number of Penalties	Total Number of Penalties	integer
FILEDATE	Processing Date	Date the data were retrieved	YYYY-MM-DD

Table 2: List of the 18 CMS quality measures available from Nursing Home Compare
Measure #	Measure description	Resident type
(msr_cd)	(msr_descr)	(stay_type)
401	Percent of Long Stay Residents Whose Need for Help with ADLs has Increased	Long Stay
402	Percent of Long Stay Residents Who Self Report Moderate to Severe Pain	Long Stay
403	Percent of High Risk Long Stay Residents With Pressure Ulcers	Long Stay
404	Percent of Long Stay Residents Who Lose Too Much Weight	Long Stay
405	Percent of Low Risk Long Stay Residents Who Lose Control of Their Bowel or Bladder	Long Stay
406	Percent of Long Stay Residents with a Catheter Inserted and Left in Their Bladder	Long Stay
407	Percent of Long Stay Residents With a Urinary Tract Infection	Long Stay
408	Percent of Long Stay Residents Who Have Depressive Symptoms	Long Stay
409	Percent of Long Stay Residents Who Were Physically Restrained	Long Stay
410	Percent of Long Stay Residents Experiencing One or More Falls with Major Injury	Long Stay
411	Percent of Long Stay Residents Assessed and Appropriately Given the Seasonal Influenza Vaccine	Long Stay
415	Percent of Long Stay Residents Assessed and Appropriately Given the Pneumococcal Vaccine	Long Stay
419	Percent of Long Stay Residents Who Received an Antipsychotic Medication	Long Stay
424	Percent of Short Stay Residents Who Self Report Moderate to Severe Pain	Short Stay
425	Percent of Short Stay Residents With Pressure Ulcers That Are New or Worsened	Short Stay
426	Percent of Short Stay Residents Who Were Assessed and Appropriately Given the Seasonal Influenza Vaccine	Short Stay
430	Percent of Short Stay Residents Assessed and Appropriately Given the Pneumococcal Vaccine	Short Stay
434	Percent of Short Stay Residents Who Newly Received an Antipsychotic Medication	Short Stay

From the file “QualityMsr_download” use facility name, address and provider number to identify the rows which represent facilities participating in the 2017 prevalence survey. Then include in the file the two variables FACID and DATA_DATE, and remove the variables (columns) that could be used to identify participating nursing homes so that only the variable listed below remain.

Table 3: List of the CMS quality measures variables to be obtained from CMS Nursing Home Compare
Variable name	Label	Description	Format/Values
FACID	CDC Facility ID	Unique identification facility code assigned by EIP staff	7 alphanumeric characters
DATA_DATE	Date data retrieved from CMS website	Date data retrieved from CMS website	YYYY-MM-DD
Variable Name	Label	Description	Format/Values
msr_cd	Measure Code	Numeric code assigned to each quality measure	integer
msr_descr	Measure Description	Measure Description	text
stay_type	Resident type	Identifies the measure as pertaining to either short-stay or long-stay stay residents	text
q1_measure_score	Q1 Measure Score	The value for the quality measure for quarter one	real number, six decimal places
q1_measure_fn	Footnote for Q1 Measure Score	Footnote for the quality measure for quarter one	text
q2_measure_score	Q2 Measure Score	The value for the quality measure for quarter two	real number, six decimal places
q2_measure_fn	Footnote for Q2 Measure Score	Footnote for the quality measure for quarter two	text
q3_measure_score	Q3 Measure Score	The value for the quality measure for quarter three	real number, six decimal places
q3_measure_fn	Footnote for Q3 Measure Score	Footnote for the quality measure for quarter three	text
measure_score_3qtr_avg	Three Quarter Average	The value for the three quarter average	real number, six decimal places
score3qtr_fn	Footnote for Three Quarter Average	Footnote for Three Quarter Average	text
five_star_msr	Used in Quality Measure Five Star Rating	Identifies whether the quality measure is used in the calculation of the quality measure rating in the Five-Star Quality Rating System	Y/N
q1_quarter	Q1 quarter	Identifies the calendar quarter associated with quarter 1	text
q2_quarter	Q2 quarter	Identifies the calendar quarter associated with quarter 2	text
q3_quarter	Q3 quarter	Identifies the calendar quarter associated with quarter 3	text
filedate	Processing Date	Date the data were retrieved	YYYY-MM-DD

Page 14 of 14

Healthcare Facility Assessment (HFA) Form: EIP