Long Term Care Facilities Cost Report Database

This database is available as a flat file in text format, and includes only those facilities that provide services to MassHealth clients for HCF-1 and Division of Transitional Assistance clients for HCF-4. It is composed of the following files:

HCF-1: Nursing Home Facilities Cost Report File

The HCF-1: Nursing Home Facilities Cost Report File contains a detailed balance sheet, as well as profit and loss statements, total and claimed expense data, disallowed expenses, information on general staffing, licensed beds by level, detailed employee wages and benefits, and patient days and charges by payer. Available years: CY'90 to the present (Exception: hospital-based SNFs available FY94 to the present.)

HCF-2: Realty Company Cost Report File

The HCF- 2 Realty Company Cost Report File contains information on the financial position of any realty company that leases buildings and/or equipment to a nursing and/or rest home. Data include the realty company's balance sheet, profit and loss statement, and claimed fixed and variable costs. The source of this data is an annual supplementary document required with HCF-1 or HCF-4 to substantiate claims for rent expenses. Available years: CY90 to the present.

HCF-4: Rest Home Cost Report File

The HCF- 4: Rest Home Cost Report File contains the balance sheet, profit and loss statement, patient days and charges by payer (equivalent to HCF-1 data). Available years: CY90 to the present.

Long Term Care Provider Listing File

The Provider Listing File contains a list of all nursing and rest home facilities for one year, including vendor payment number, provider type, name, address, facility I.D., date opened, dates of changes of ownership, # licensed beds by level, mean beds by level, preparer's name, and profit/non-profit status indicator. Available years: CY90 to the present.

Long Term Care Provider History File

The Long Term Care Provider History File contains historical list of all nursing and rest home facilities since 1975, including vendor payment number, name, address, and dates of changes in ownership. It is maintained from the initial date of operation of the facility to the current time period based on documentation provided by the Department of Public Health.

Long Term Care Patient Day Listing File

The Patient Day Listing File contains a listing of all nursing and rest home facilities for one year, including vendor payment number, name, resident days by payer, total days, total year-end operating beds and total mean operating beds. Available years: CY91 to the present.

Long Term Care Final Rate Listing File

The Final Rate Listing contains a list of nursing or rest home annual facility-specific public payer rates including vendor payment number, name, begin and end dates, certification date, rates, and rate components. Available years: CY88 (some facilities); CY89 to the present (all facilities).

Long Term Care Management Minutes Questionnaire Database

The Management Minutes Questionnaire (MMQ) Data contains management minute questionnaire data aggregated to the nursing facility level including: vendor payment number, number of minutes and number of patients in each case-mix category. Available years: CY98 and to the present.

Please contact the Division for more information about these particular databases.