Excerpt Include

	Data Resources
	Data Resources
nopanel	true

Panel

borderWidth	0

Excerpt Include

	Requesting & Getting Access
	Requesting & Getting Access
nopanel	true

Panel

borderWidth	0

Livesearch

spaceKey	DATA
type	page

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.

Note

If you have any questions regarding the information on this page or the CCSQ 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.

The data refresh dates from legacy oracle sources are published for awareness of data timeliness. If your organization requires data to be refreshed on a different timeline or cycle, please create a ServiceNow request for the “ADO-CDR-Support” and include details of your request including business justification, data source, requested refresh frequency, and requested refresh dates.
The "Most Recent Refresh" refers to the date the data was extracted from the legacy database. This data is typically available 24-48 hours after extraction. The "Next Refresh" date marks the last possible day the data will be available in the CDR.

Please note that due to ongoing modernization efforts, this document is a work in progress. Additional information will be added regularly. Some dates may change due to changing requirements or security mandates.

Excerpt Include

	CCSQ Data & Analytics
	CCSQ Data & Analytics
nopanel	true

Anchor

	Return to Top
	Return to Top

Horizontal Navigation Bar

id	CDR Data Catalog

Horizontal Navigation Bar Page

title	Claims Data

Panel

borderWidth	1 px

Claims Data

Schema	Description	CDR Hive Schema	CDR Table Layouts	Data Dictionaries and Supplemental Information	Most Recent Refresh	Refresh Frequency	Next Refresh	DUA Required
CSAT Data Issue Identified: See Known Issues Log for current status	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). (SORN)	csat_5 csat_2 ----------------------- Legacy CSAT: csat_201908_baseline csat_201909 [monthly]	CSAT_5_TableLayout.xlsx CSAT_2_TableLayout.xlsx ---------------------------------- Table Layouts for Legacy Schemas: CSAT_Baseline_TableLayout.xlsx CSAT_Monthly_TableLayout.xlsx	CSAT Data Dictionary-CMS CVP-7.15.2020-v1.1.xlsx CSAT_Partition_Info.xlsx	12/4/2020	Monthly	12/31/2020	Yes
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. (SORN)	ddps_part_d	Part_D_TableLayout.xlsx		12/9/2020	Monthly	1/12/2021	Yes
NCH Part A Image Removed Data Issue Identified: See Known Issues Log for current status	The source data for Part A claims is the National Claims History (NCH) weekly extracts. Part A claims include the Inpatient (IP) and Skilled Nursing Facility (SNF), Home Health (HHA), Hospice, and Outpatient Extracts. (SORN)	nch_part_a	Part_A_TableLayout.xlsx	2020_02-Data Dictionary - IP_SNF_CLM_REC.txt 2020_02-Data Dictionary-OP_CLM_REC.txt 2020_02-Data Dictionary-HHA_CLM_REC.txt 2020_02-Data Dictionary-HOSPC_CLM_REC.txt	12/310/2020	Weekly	12/1117/2020	Yes
NCH Part B Image Removed Data Issue Identified: See Known Issues Log for current status	The source data for Part B claims is the NCH weekly extracts. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts. (SORN)	nch_part_b	Part_B_TableLayout.xlsx	2020_02-Data Dictionary-DMERC_CLM_REC.txt 2020_02-Data Dictionary-CARR_CLM_REC.txt	12/310/2020	Weekly	12/1117/2020	Yes

86218841

Horizontal Navigation Bar Page

title	Beneficiary and Provider Data

Panel

borderWidth	1 px

Beneficiary and Provider Data

Schema

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Most Recent Refresh

Refresh Frequency

Next Refresh

DUA Required

Assessment

(iQIES)

Anchor

	Assessment_iQIES
	Assessment_iQIES

QIES underwent a series of modernizing, system enhancements resulting in what is now called the Internet Quality Improvement and Evaluation System (iQIES). iQIES data in the CDR includes assessment data for HHA, MDS, LTCH, IRF, and Hospice schemas.

HOSPC (SORN)
IRF (SORN)
LTCH (SORN)
MDS (SORN)
OASIS (as hha_asmt_fed) (SORN)

assessment_iqies

assessment_iqies_TableLayout.xlsx

iQIES_CDR_Data_Dictionary_20200903.xlsx

12/3/2020

Monthly

1/6/2020

Yes

Beneficiary

This source contains beneficiary demographics, entitlement, enrollment, premium, health status and other coverage information from the Beneficiary Information on the Cloud (BIC) source. This data will be the source of beneficiary data going forward within the CDR.

beneficiary_data

beneficiary_data_TableLayout.xlsx

bic-data-lake-data-dictionary.pdf

beneficiary_data_Partition_Info.xlsx

12/7/2020

Weekly

12/14/2020

Yes

CRIS

The Case Review Information System (CRIS) was the predecessor to the QMARS system (see below). It was decommissioned October 31, 2018. All data in this system is archival.

legacy_cris

CRIS_TableLayout.xlsx

CRIS User Guide.pdf

1/13/2020

None

Never

Yes

HQR

Public Reporting data provides Hospital Quality Reporting (HQR) data to the Hospital Compare website. The data educates consumers by providing them with detailed information on a hospital’s quality of care. This schema is a replacement for ‘legacy_hqr_public_reporting’ and is being made available from the permanent cloud source of data.

quality_measures_hqr_pub_report

quality_measures_hqr_pub_report_TableLayout.xlsx

11/18/2020

Quarterly

2/18/2021

Yes

HQR - Legacy

These schema are copies of the former HQR Oracle databases and applications in SDOL, QNOL, and CLDW.

legacy_hqr_asc

HQR_ASC_TableLayout.xlsx

HQR_QNOL_ASC_APP_view_logic.zip

4/6/2020

None

Never

Yes

legacy_hqr_cart(QNOL)

HQR_CART_TableLayout.xlsx

HQR_QNOL_CART_view_logic.zip

12/3/2020

None

Never

Yes

legacy_hqr_cart_final (CLDW)

HQR_CART_Final_TableLayout.xlsx

SDOL_CLDW_CART_view_logic.zip

12/3/2020

None

Never

Yes

legacy_hqr_ehqr

HQR_EHQR_TableLayout.xlsx.xlsx

HQR_QNOL_EHQR_view_logic.zip

legacy_hqr_ehqr_Partition_Info.xlsx

11/16/2020

None

Never

Yes

legacy_hqr_sdol_extfilapp

HQR_SDOL_ext_fil_app_TableLayout.xlsx

12/7/2020

None

Never

Yes

legacy_hqr_qnol_extfilapp

HQR_QNOL_ext_fil_app_TableLayout.xlsx

12/7/2020

None

Never

Yes

legacy_hqr_hai

HQR_HAI_TableLayout.xlsx

SDOL_HAI_APP_view_logic.zip

12/4/2020

None

Never

Yes

legacy_hqr_hcahps

HQR_HCAHPS_QNOL_TableLayout.xlsx

HQR_QNOL_HCAHPS_view_logic.zip

10/21/2020

None

Never

Yes

legacy_hqr_hcahps_final

HQR_HCAHPS_CLDW_TableLayout.xlsx.xlsx

SDOL_CLDW_HCAHPS_view_logic.txt

10/20/2020

None

Never

Yes

legacy_hqr_hvbp

HQR_HVBP_TableLayout.xlsx

HQR_QNOL_HVBP_view_logic.zip

10/19/2020

None

Never

Yes

legacy_hqr_oat_app

HQR_oat_app_TableLayout.xlsx

HQR_QNOL_OAT_APP_view_logic.txt

12/2/2020

None

Never

Yes

legacy_hqr_ipledge_app

QNOL_ipledge_app_TableLayout.xlsx

HQR_QNOL_IPLEDGE_APP_view_logic.txt

12/9/2020

None

Never

Yes

legacy_hqr_nop_app

HQR_nop_app_TableLayout.xlsx

HQR_QNOL_NOP_APP_view_logic.zip

12/10/2020

None

Never

Yes

legacy_hqr_opledge_app

QNOL_opledge_app_TableLayout.xlsx

HQR_QNOL_OPLEDGE_APP_view_logic.txt

12/9/2020

None

Never

Yes

legacy_hqr_opps

HQR_OPPS_TableLayout.xlsx

SDOL_CLDW_OPPS_WHS_view_logic.zip

12/4/2020

None

Never

Yes

legacy_hqr_opps_prs

HQR_opps_prs_TableLayout.xlsx

SDOL_OPPS_PRS_view_logic.txt

12/3/2020

None

Never

Yes

legacy_hqr_pprs_app

HQR_pprs_app_TableLayout.xlsx

HQR_QNOL_PPRS_APP_view_logic.txt

11/10/2020

None

Never

Yes

legacy_hqr_struct_msrs

HQR_struct_msrs_TableLayout.xlsx

HQR_QNOL_STRUCT_MSRS_APP_view_logic.zip

12/4/2020

None

Never

Yes

legacy_hqr_validation_app

HQR_validation_app_TableLayout.xlsx

12/7/2020

None

Never

Yes

legacy_cldw_rpt_etl

HQR_rpt_etl_TableLayout.xlsx.xlsx

12/1/2020

None

Never

Yes

legacy_qnol_pch_app

HQR_pch_app_TableLayout.xlsx

HQR_QNOL_PCH_APP_view_logic.txt

12/8/2020

None

Never

Yes

legacy_hqr_cart_cdac

HQR_CART_CDAC_TableLayout.xlsx

SDOL_CLDW_CART_CDAC_view_logic.txt

8/11/2020

None

Never

Yes

legacy_hqr_ci_rpt

HQR_ci_rpt_TableLayout.xlsx

8/21/2020

Quarterly

12/14/2020

Yes

legacy_hqr_opps_import

HQR_opps_import_TableLayout.xlsx

HQR_QNOL_OPPS_IMPORT_view_logic.zip

11/9/2020

Quarterly

12/14/2020

Yes

Miscellaneous data from the legacy CLDW and QNOL systems

legacy_cldw_prod_data_mgmt

Misc_prod_data_mgmt_TableLayout.xlsx

Misc_prod_data_mgmt_view_logic.zip

12/9/2020

None

Never

Yes

legacy_qnol_user_admin

MISC_user_admin_TableLayout.xlsx

12/9/2020

None

Never

Yes

legacy_sdol_ifmc_common

IFMC_COMMON_TableLayout.xlsx

3/6/2020

None

Never

Yes

PRS

The Program Resource System (PRS) was formerly stored in the SDDW and SDOL schemas. It is the repository of demographic information for hospital providers in the Centers for Medicare & Medicaid Services (CMS), Survey and Certification System (CASPER), and Quality Improvement and Evaluation System (I QIES).

legacy_hqr_prs

HQR_PRS_TableLayout.xlsx

12/8/2020

None

Never

Yes

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

11/17/2020

Quarterly

2/14/2020

No

CMS Master Data Management (MDM) Provider Master Index/

Shared Provider Profile (PMI/SPP)

The PMI/SPP contains an integrated view of identity resolved provider data across multiple CMS provider data systems. It includes data from PECOS, NPPES, NPICS, QIES, and T-MSIS. It provides both "current" and "historical" provider data from multiple CMS source systems of record. This data will be the source of provider data (including PECOS) within the CDR. The CDR will still provide data concurrently from QIES (iQIES in future) and NPPES.

provider_pmi_data

Provider_PMI_Data_TableLayout.xlsx

MDM PMI SPP Physical Data Dictionary_01.07.2020.pdf

MDM 3rd Qtrly Training.pptx

MDM NPI Tables Model Diagram.pdf

MDM PMI SPP Logical Data Model Diagram.pdf

Guide to Using the MDM Comprehensive PMI and SPP

Tables_V2_F_7.30.2020.docx

Guide to Using the MDM PMI_SPP_NPI Profile Tables_V2_F_7.31.2020.docx

Password for all documents above: royalrabbit

provider_pmi_data_Partition_Info.xlsx

12/7/2020

Weekly

12/14/2020

Yes

Provider (iQIES)

QIES underwent a series of modernizing, system enhancements resulting in what is now called the Internet Quality Improvement and Evaluation System (iQIES). iQIES data in the CDR includes provider data from CASPER and iQIES_CMN schemas.

provider_iqies

provider_iqies_TableLayout.xlsx

iQIES_CDR_Data_Dictionary_20200903.xlsx

QIES_S&C_Code_Tables_Data_Dictionary 09152020.xls

12/3/2020

Monthly

1/6/2020

Yes

QMARS

Quality Management and Review Systems (QMARS) is a system for case management and review.

qmars

QMARS_TableLayout.xlsx

12/7/2020

Monthly

1/7/2021

Yes

Quality Payment Program (QPP) Universal Data Set (UDS)

The Quality Payment Program (QPP) Universal Data Set (UDS) is a curated data warehouse of all QPP data for analytics and reporting.

quality_measures_qpp_uds

quality_measures_qpp_uds_TableLayout.xlsx

Full UDS Data Dictionary-v71.pdf

UDS_ER_Diagram.jpg

11/24/2020

Monthly

12/30/2020

Yes

SDDW

Contains Medicare Beneficiary and Provider enrollment data. (FAQ)

legacy_sddw_np_sdps

SDDW_TableLayout.xlsx

SDDW_Data_map.xlsx

For information about beneficiary tables in SDDW: EDB_data_dictionary.doc

legacy_sddw_np_sdps_Partition_Info.xlsx

Denominator_File_Specifications.doc

denominator1_derived_fields_2020_09_28.docx

denominator2_derived_fields_2020_09_28.docx

12/8/2020

None

Never

Yes

SDOL

Contains the beneficiary coverage data previously in the Oracle SDOL database.

legacy_sdol_np_sdps

SDOL_NP_SDPS_TableLayout.xlsx

12/8/2020

None

Never

Yes

86218841

Horizontal Navigation Bar Page

title	Health Plan Data

Panel

borderWidth	1 px

Health Plan Data

Schema	Description	CDR Hive Schema	CDR Table Layouts	Data Dictionaries and Supplemental Information	Most Recent Refresh	Refresh Frequency	Next Refresh	DUA Required
HPMS	Contains HMO/PDP contract and service area data from the CMS Health Plan Management System.	health_plan	HPMS_TableLayout.xlsx	HPMS_Data_Dictionary.xlsx	12/2/2020	Monthly	1/6/2021	Yes

86218841

Horizontal Navigation Bar Page

title	Public Data

Panel

borderWidth	1 px

Public Data

Schema	Description	CDR Hive Schema	CDR Table Layouts	Data Dictionaries and Supplemental Information	Most Recent Refresh	Refresh Frequency	Next Refresh	DUA Required
ADI	The Area Deprivation Index (ADI) contains the GIS information for US neighborhoods.	public_data	ADI_TableLayout.xlsx	Neighborhood Atlas Web Page	4/10/2020	Annually	5/13/2021	No
FDA	The FDA data contains packaging and product information for FDA approved drugs.	public_data	FDA_TableLayout.xlsx		11/6/2020	Monthly	12/30/2020	No
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	11/5/2020	Monthly	12/30/2020	No
ZIP	This table contains the ZIP Codes and other information for cities and towns in the US.	public_data	ZipCodes_TableLayout.xlsx		11/6/2020	Monthly	12/30/2020	No

86218841

Horizontal Navigation Bar Page

title	Planned Data Sources

Panel

borderWidth	1 px

Planned Data Sources

Source Name	Description	Future CDR Hive Schema	CDR Legacy Data Sources	Data Dictionary and Supplemental Information	Targeted Date of Availability within CDR
Program Resource System (PRS)	Program Resource System (PRS) is a repository of demographic information for hospital providers in the Centers for Medicare & Medicaid Services (CMS), Survey and Certification System (CASPER), and Quality Improvement and Evaluation System (QIES). PRS assists Quality Improvement Organizations (QIOs) and Program Support Contractors in maintaining CMS Programs.	resource_hqr_prs (SDOL) resource_hqr_prs_supplemental (SDDW)	legacy_hqr_prs legacy_sddw_np_sdps legacy_sdol_np_sdps	PRS_Planned_Table_List.xlsx	12/23/2020
Data Form IQR/ASC/IPF/PCH/OQR/DACA/HCAHPS/Pop and Samp/ ECQM Denominator Declaration	Data Form formerly known as Structural Measures or Web-Based Data Collection Tool, allows IQR, OQR, ASCQR, IPFQR, MU, PCHQR, and HCAHPS providers, or any of their authorized vendors, to enter information related to the environment in which care is provided.	quality_measures_hqr_data_form	legacy_hqr_struct_msrs legacy_qnol_pch_app legacy_hqr_asc legacy_hqr_hcahps legacy_hqr_hcahps_final legacy_cldw_rpt_etl legacy_hqr_pprs_app legacy_opps_prs		1/27/2020
IQR/OQR Chart-Abstracted (Clinical Outcome)	IQR and OQR Chart Abstracted Calculations & Outcomes (CACAO) system provide CMS and its stakeholders with system functionality that calculates measure outcomes for clinical quality measures that evaluates data submitted via XML file. The following measures are included in this data set: OP-2: Fibrinolytic Therapy Received Within 30 Minutes of ED Arrival OP-3 Median Time to Transfer to Another Facility for Acute Coronary Intervention OP-3a - Overall Rate OP-3b - Reporting Measure OP-3c - Quality Improvement Measure OP-23: Head CT or MRI Scan Results for Acute Ischemic Stroke or Hemorrhagic Stroke Patients who Received Head CT or MRI Scan Interpretation Within 45 Minutes of ED Arrival OP-18a Median Time from ED Arrival to ED Departure for Discharged ED Patients – Overall Rate OP-18b Median Time from ED Arrival to ED Departure for Discharged ED Patients –Reporting Measure OP-18c Median Time from ED Arrival to ED Departure for Discharged ED Patients – Psychiatric/Mental Health Patients OP-18d Median Time from ED Arrival to ED Departure for Discharged ED Patients – Transfer Patients SEP-1 and Bundle Data	quality_measures_hqr_char_abst	legacy_hqr_opps_import legacy_hqr_opps legacy_hqr_cart legacy_hqr_cart_final		3/25/2020
Notice of Participation (NOP)	Notice of Participation is a contract between CMS and hospitals that identifies whether or not they are participating in the IQR, OQR, IPF, and PCH programs. Each of these programs have specific requirements that determine whether or not a facility is participating in a quality reporting program. This data set will describe the programs any given hospital is participating in and the date.	provider_participation_hqr_nop	legacy_hqr_ipledge_app legacy_hqr_opledge_app legacy_hqr_nop_app		3/25/2020
IQR/OQR/ECQM Validation	The Centers for Medicare & Medicaid Services (CMS) assesses the accuracy of chart-abstracted data submitted to the Hospital Outpatient Quality Reporting (OQR) Program and the Hospital Inpatient Quality Reporting (IQR) Program through the validation process. CMS verifies on a quarterly basis that hospital-abstracted data submitted to CMS’ Clinical Warehouse via the Hospital Quality Reporting (HQR) system can be reproduced by a trained abstractor using a standardized process.	quality_measures_hqr_val	legacy_hqr_validation_app legacy_hqr_oat_app legacy_hqr_cart_cdac		3/25/2020
ECQM Measure Outcomes	The HQR system consumes eCQM QRDA files and processes the data based on measure logic to determine the measure outcomes for the follow measures: STK-06 STK-05 STK-03 STK-02 ED-2 VTE-1 VTE-2 PC-05	quality_measures_hqr_ecqm	legacy_hqr_ehqr		3/25/2020
HVBP	This schema provides data and results from the Hospital Value based Purchasing (HVBP) Program.	quality_measures_hqr_hvbp	legacy_hqr_hvbp		7/1/2020
External Files - CDC NHSN Data	CDC NHSN (National Healthcare Safety Network) provides facilities, states, regions, and the nation with data needed to identify problem areas, measure progress of prevention efforts, and ultimately eliminate healthcare-associated infections. Future files will be sent from the Hospital Quality Reporting (HQR) ADO and made available in the SAS Viya workbench in source format. Once made available, these files will appear in a new folder called "external-data" under your main workbench directory: "workspace/workbench/organization-name/external-data/nhsn"	SAS Viya Workbench external-data/nhsn	legacy_hqr_sdol_extfilapp legacy_hqr_qnol_extfilapp legacy_hqr_hai		TBD

86218841

Horizontal Navigation Bar Page

title	Archived Sources

Panel

borderWidth	1 px

Archived Sources

Sources No Longer Being Refreshed

Source	CDR Hive Schema	CDR Table Layouts	Data Dictionaries and Supplemental Information	Final Refresh Date	DUA Required
HQR	legacy_hqr_public_reporting	HQR_public_reporting_TableLayouts.xlsx.xlsx	SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip	3/2/2020	Yes
QIES Legacy (Provider)	legacy_provider_data	Legacy_Provider_Data_TableLayout.xlsx	QIES.S&C.Table-Reports.pdf	8/27/2020	Yes
QIES Legacy (Assessment)	legacy_assessment_data	Legacy_Assessment_Data_TableLayout.xlsx	QIES.HHA.Table-Reports.pdf QIES.HOSPC.Table-Reports.pdf QIES.IRF.Table-Reports.pdf QIES.LTCH.Table-Reports.pdf QIES.MDS.Table-Reports.pdf	9/15/2020	Yes
Beneficiary	legacy_beneficiary_data	legacy_beneficiary_data_TableLayout.xlsx	EDB_data_dictionary.doc	12/3/2020	Yes

Sources Continuing to be Refreshed

Source	Description	CDR Hive Schema	CDR Table Layouts	Data Dictionaries and Supplemental Information	Most Recent Refresh	Refresh Frequency	Next Refresh	DUA Required

86218841

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.

Versions Compared

Old Version 307

New Version 308

Key

CDR Data Catalog

Claims Data

Beneficiary and Provider Data

Health Plan Data

Public Data

Planned Data Sources

Archived Sources

Page History

Versions Compared

Old Version 307

New Version 308

Key

CDR Data Catalog

Claims Data

Beneficiary and Provider Data

Health Plan Data

Public Data

Planned Data Sources

Archived Sources