HHA Cost Alphanumeric Data 2017-2018

$179 / year

This dataset contains all alpha data reported on a cost report such as hospital name, address, dates, and questions that require a yes/no response. It has information on the Home Health Agency (HHA) cost reports received by Healthcare Cost Report Information System (HCRIS).

Complexity

Home Health Agency Medicare Cost Report data files contain cost reports for the year 2017. Among the 4 files of The Home Health Agency (HHA) cost reports, the HHA Cost Alphanumeric Table 2017, HHA Cost Numeric Table 2017, HHA Cost Report Table 2017 and HHA Cost Rollup Table 2017, the ‘HHA Cost Report Table 2017’ is the parent of the other tables and contains the unique primary key field Report_Record_Number. The field Report_Record_Number is the foreign key in the other 3 tables. That is, all data in all tables are related by the value of the field Report_Record_Number. The data files contain the highest level of Medicare cost report status. If HCRIS has both an as submitted report and a final settled report from an HHA for a particular year, the data files will only contain the final settled report. If HCRIS has an as submitted, final settled, and reopened report from an HHA for a particular year, the data files will contain the reopened cost report. It is possible for 1 HHA Provider to submit 2 or more cost reports for a given year for the same cost report status. This may happen if a Provider changes its FY, or if there is a CHOW (Change of Ownership) during the year. To use the HHA cost report database, it necessary to determine the data interested in by reviewing the cost report forms and the data specifications. The Worksheet ID, line, and column specifications need to be known to pull the data from the cost report form. For example, to extract the data for “Home Health Agency-Number of Skilled Nursing Visits Title XVIII”, determine where this information is collected in the report and use these elements as parameters to pull the data from the HHA_RPT_NMRC table.

Date Created

2018-04-04

Last Modified

2020-01-15

Version

2020-01-15

Update Frequency

Annual

Temporal Coverage

2017-2018

Spatial Coverage

United States

Source

John Snow Labs; Centers for Medicare and Medicaid Services;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Home Health Agency Cost, Medicare Cost Report, Provider Cost, Healthcare Cost Report, CMS Report, Home Health Costs, Report Medicare

Other Titles

Medicare HHA Provider Cost Record 2017, Medicare Home Health Cost Report Data 2017, CMS Report Home Health Agency Medicare Cost Data 2017, Home Health Agency Medicare Report Alphanumeric Data 2017

NameDescriptionTypeConstraints
YearYear of the data.number-
Report_Record_NumberHCRIS assigned cost report specific numberintegerlevel : Nominal
Worksheet_IdentifierValid worksheets are defined for each subsystem in other documentation.string-
Line_NumberLabel or Code for specified Line numbersstring-
Column_NumberLabel or Code for specified Column Numberstring-
Item_DescriptionItem specification for the particular worksheet, line and column. It is retrieved from "HCRIS Specifications for the CMS 1728-94 - Transmittal 13 Table 3 - Cost Report Data Specifications"string-
Alphanumeric_Item_TextProvider reported alpha datastring-
YearReport Record NumberWorksheet IdentifierLine NumberColumn NumberItem DescriptionAlphanumeric Item Text
2017332553S000000100200Date Cost Report Received from the Provider20170424
2017332553S200000100100Street5656 US HIGHWAY 29 SUITE B1
2017332553S200000101100CityBLAIRS
2017332553S200000101200StateVA
2017332553S200000101300Zip Code24527-2412
2017332553S200000200100Component Provider NamePRINCE CHARLES HOME HC AGENCY
2017332553S200000200300Component Date Certified (CCYYMMDD)20161104
2017333097S000000100200Date Cost Report Received from the Provider20170502
2017333097S200000100100Street220 WINTERGREEN DRIVE STE G
2017333097S200000101100CityLUMBERTON