CDR Data Catalog

A data catalog is a collection of metadata, combined with data management and search tools, that helps analysts and other data users to find the data that they need, serves as an inventory of available data, and provides information to evaluate the fitness of data for intended uses.

This page provides the current schemas available in the CDR. All data will more closely reflect the source system. A roadmap for future schemas is available here: Data Roadmap. Refer to User Guides & References for an overview and guide to the data catalog.

If you have any questions regarding the information on this page or the HCQIS Data & Analytics Modernization effort overall, please send an email to HCQIS_Data@hcqis.org.

All data listed below is currently in the CDR; however, a user will only see what is defined by their DUA.

Error rendering macro 'excerpt-include'

No link could be created for 'CCSQ Data & Analytics_2'.

Claims Data

Schema	Description	CDR Schema and CASLIB Name	CDR Table Layouts	Data Dictionaries and Supplemental Information
CSAT	The Healthcare Quality Analytics and Reporting (HCQAR) Complete Statistical Analysis Table (CSAT) is a monthly dataset that provides state and national level claims data variables derived from Medicare Part A / Part B / Part D claims data specifically for the national and state Quality Improvement Networks and Organizations (QIN-QIOs).	csat_yyyymm_baseline csat_yyyymm [monthly] QIN-specific Versions: csat_qin_[organization]	CSAT_Baseline_TableLayout.xlsx CSAT_Monthly_TableLayout.xlsx	CSAT Data Elements v1.0 (with changes for 12th SOW from 11th SOW indicated).xlsx
DDPS Part D	The source data for Part D claims is the Drug Data Processing System. This schema contains all prescription drug claims covered under Medicare Part D.	ddps_part_d	Part_D_TableLayout.xlsx
NCH Part A	The source data for Part A claims is the National Claims History (NCH) monthly extracts. Part A claims include the Inpatient (IP) and Skilled Nursing Facility (SNF), Home Health (HHA), Hospice, and Outpatient Extracts.	nch_part_a	Part_A_TableLayout.xlsx	2019_04-Data Dictionary-OP_CLM_REC.txt 2019_04-Data Dictionary-IP_SNF_CLM_REC.txt 2019_04-Data Dictionary-HOSPC_CLM_REC.txt 2019_04-Data Dictionary-HHA_CLM_REC.txt
NCH Part B	The source data for Part B claims is the NCH monthly extracts. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts.	nch_part_b	Part_B_TableLayout.xlsx	2019_04-Data Dictionary-DMERC_CLM_REC.txt 2019_04-Data Dictionary-CARR_CLM_REC.txt

Beneficiary and Provider Data

Schema	Description	CDR Schema and CASLIB Name	CDR Table Layouts	Data Dictionaries and Supplemental Information
NPPES	The National Plan and Provider Enumeration System contains provider NPIs, names, and location information.	nppes	NPPES_TableLayout.xlsx	NPPES dissemination information on CMS Website
SDDW	Contains Medicare Beneficiary and Provider enrollment data. (FAQ)	sddw_np_sdps	SDDW_TableLayout.xlsx	SDDW_Data_map.xlsx For information about beneficiary tables in SDDW: EDB_data_dictionary.doc

Public Data

Schema	Description	CDR Schema and CASLIB Name	CDR Table Layouts	Data Dictionaries and Supplemental Information
ADI	The Area Deprivation Index (ADI) contains the GIS information for US neighborhoods.	public_data	ADI_TableLayout.xlsx	Neighborhood Atlas Web Page
FDA	The FDA data contains packaging and product information for FDA approved drugs.	public_data	FDA_TableLayout.xlsx
Nursing Home Compare	This is the official data for the Nursing Home Compare website.	compare_nursing_home	NHC_TableLayout.xlsx	Nursing Home Compare Overview Data Set Page
ZIP	This table contains the ZIP Codes and other information for cities and towns in the US.	public_data	ZipCodes_TableLayout.xlsx

Important Notes

The CDR follows NCH logic; as such, Part A claims are split into multiple records when the number of revenue center line items is greater than 45. In HAJI, these were merged into a single claim.
The CDR includes claim types 61, 62, 63, 64, 80, and 81, which HAJI did not include.
The CDR includes claim adjustments older than five years, which HAJI did not include.