A data catalog is a collection of metadata, combined with data management and search tools, that helps analysts and
Requesting & Getting Access
nopanel
true
Panel
borderWidth
0
Livesearch
spaceKey
DATA
placeholder
Search CCSQ Data & Analytics site
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 the Centralized Data Repository (CDR). All data will more closely reflect the source system
. A roadmap for future schemas is available here: Data Roadmap
All data listed below is currently in the CDR environment; however, a user will only see what is defined by their data usage agreement (DUA).
The data refresh
dates
cadence from CDR sources are published for awareness of data timeliness.
If
your
the user's organization requires data to be refreshed on a different timeline or cycle,
please
they should submit a Request Formand include details of
your
theirrequest including business justification, data source, requested refresh frequency, and requested refresh dates.
Please note that due to ongoing modernization efforts, this document is a work in progress
Details of the refresh are included in the description of each source.
The "Next Refresh" date marks the last possible day the data will be available in the CDR.
Note that this document will be continuously updated. Additional information will be added regularly
. Some
and some dates may change due to changing requirements or security mandates.
Excerpt Include
CCSQ Data & Analytics
CCSQ Data & Analytics
nopanel
true
Panel
borderColor
#C12026
titleColor
White
titleBGColor
#C12026
borderStyle
solid
title
Anchor
Return to Top
Return to Top
Horizontal Navigation Bar
id
CDR Data Catalog
Horizontal Navigation Bar Pageauihorizontalnav
titleid
Claims CDR Data Catalog
Horizontal Navigation Bar Page
Panel
borderWidth
1 px
Tabs Container
direction
horizontal
Tabs Page
title
Claims Data
Claims Data
Schema
Description
CDR Hive Schema
CDR Table Layouts
Data Dictionaries and Supplemental Information
Most Recent Refresh
Refresh Frequency
Next Refresh
DUA Required
Refresh
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). (SORN)
The source data for Part D claims is the Drug Data Processing System. Each monthly refresh generally includes all drug claims processed from the previous month (as shown by 'pde_proc_dt'). This schema contains all prescription drug claims covered under Medicare Part D. (SORN)
Monthly - By the 12th of each month or the following business day
NCH Part A
The source data for Part A claims is the National Claims History (NCH) weekly extracts. Each weekly refresh generally includes claims with an ‘nch_daily_proc_dt’ of Friday from the previous week. Part A claims include the Inpatient (IP) and Skilled Nursing Facility (SNF), Home Health (HHA), Hospice, and Outpatient extracts. (SORN)
The source data for Part B claims is the NCH weekly extracts. Each weekly refresh generally includes claims with an ‘nch_daily_proc_dt’ of Friday from the previous week. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts. (SORN)
MSDRG Codes in the CDR are generated using the Java API version of the publicly available MSDRG Grouper software produced by CMS. The grouper is a software system that classifies a patient’s hospital stay into an established DRG based on the diagnosis and procedures provided to the patient.
In the nch_part_a schema, you will find 3 tables containing all MSDRG Codes produced by the software, as well as the Part A Input data:
The source data for Part B claims is the NCH weekly extracts. Each weekly refresh generally includes claims with an ‘nch_daily_proc_dt’ of Friday from the previous week. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts. (SORN)
Medicare Provider Analysis & Review (MedPAR) is a system that consolidates Inpatient Hospital or Skilled Nursing Facility (SNF) claims data from the National Claims History (NCH) files into stay level records. MEDPAR records from January 2021 onward are available in the CDR. Historical backfill to include years 2017-2020 is planned.
The CDR follows National Claims History (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 Health Account Joint Information (HAJI) did not include.
The CDR includes claim adjustments older than five years, which HAJI did not include.
In Part A Claims, dates showing as '1970-01-01' in the rev_cntr_dt field should be treated as blank or null values
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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
This source contains beneficiary demographics, entitlement, enrollment, premium, health status and other coverage information from the Beneficiary Information on the Cloud (BIC) source. CDR Hive tables point directly to BIC data in the CMS Enterprise Data Lake (EDL). This data is refreshed each weekend in the CMS EDL and it is made available by Monday in the CDR.
CDR contains only a Subset of tables listed in BIC Data Dictionary.
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. CDR Hive tables point directly to PMI/SPP
Clinical End Stage Renal Disease Quality Reporting System (EQRS)
This schema will provide End-Stage Renal Disease (ESRD) Facility, Personnel, Patient and Clinical Data for CDR users.
Monthly – Three months in arrears (e.g. extract for the closed clinical month of September is generated and loaded in early December – a few days after the submission deadline)
Renal Data System (RDS) Extracts
End Stage Renal Disease Quality Reporting System (EQRS) data in the format of the RDS extract reports that were first provided from the Reliability and Maintainability Information System (REMIS) system and were later provided by the Network Coordinating Council (NCC). Each quarter data is loaded for all-time from EQRS.
End Stage Renal Disease Quality Reporting System (EQRS) clinical data submitted by End-Stage Renal Disease (ESRD) care providers from a given closed clinical month in the format of the Clinical Extracts, historically delivered monthly by the EQRS Application Development Organization (ADO).
End Stage Renal Disease Quality Reporting System (EQRS) facility and patient data from a given quarter in the format of the Care Compare Extracts, historically delivered quarterly by the EQRS Application Development Organization (ADO).
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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
This source contains beneficiary demographics, entitlement, enrollment, premium, health status and other coverage information from the Beneficiary Information on the Cloud (BIC) source. CDR Hive tables point directly to BIC data in the CMS Enterprise Data Lake (EDL). This data is refreshed each weekend in the CMS EDL and it is made available by Monday in the CDR.
CDR contains only a Subset of tables listed in BIC Data Dictionary.
Only a subset of BIC tables are available in the CDR.
Weekly - Mondays
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. CDR Hive tables point directly to PMI/SPP data in the CMS Enterprise Data Lake (EDL). This data is refreshed each weekend in the CMS EDL and it is made available by Monday in the CDR.
Contact the Data & Analytics team for the password to unlock the documents.
Weekly - Mondays
Weekly
Yes
DARRT QII
This source includes Quality Improvement Initiative (QII) Data from the Deliverable Administration Review Repository Tool (DARRT). A QII is any formal plan designed to assist a provider(s) and/or practitioner(s) in identifying the root cause of a confirmed quality of care concern, develop a framework in which to address the concern and improve a process or system. QIIs may consist of system-wide (organization-based) and/or non-system-wide (practitioner-based) activities. QII initiation and tracking are performed in DARRT and QII data in the CDR are refreshed every Wednesday at 1:00 AM ET.
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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.
Data Form, formerly known as Structural Measures or Web-Based Data Collection Tool, allows IQR, OQR, ASCQR, IPFQR, MU, PCHQR, and HCAHPS providers (or authorized vendors) to enter information related to the environment in which care is provided. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy schemas:
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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. The following measures are included in this data set:
OP-2, OP-3, OP-3a, OP-3b, OP-3c, OP-23, OP-18a, OP-18b, OP-18c, OP-18d, and SEP-1 and Bundle Data
This schema is the replacement for the following legacy schemas:
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 will describe the programs, whether a given hospital is participating, and the date. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.
This schema is the replacement for the following legacy schemas:
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’s Clinical Warehouse via the Hospital Quality Reporting (HQR) system, can be reproduced by a trained abstractor using a standardized process. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.
This schema is the replacement for the following legacy schemas:
The HQR system evaluates Medicare claims to determine which claims are eligible for a given quarter for each required measure set for the IQR and OQR Programs. These tables provide the eligible claim counts for the IQR and OQR programs, broken out by provider, measure set, month, and year.
The HQR system consumes eCQM QRDA files and processes the data based on measure logic to determine the measure outcomes for the follow measures:
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. PRS data is extracted from the HQR source database and the "Most Recent Refresh" column indicates the date at which the data was extracted. The refreshed data is available each Monday morning however it is typically extracted 1-2 business days earlier.
The resource_hqr_prs schema is a replacement for legacy_sdol_np_sdps and resource_hqr_prs_supplemental schema is a replacement for legacy_sddw_np_sdps.
**Data Issue Identified: SeeKnown Issues Logfor current status**
Quality Management and Review Systems (QMARS) is a system for case management and review. This data is extracted from QMARS system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
The ‘healthcare_service_qmars_ng’ schema contains a set of initial tables that are included from the QMARS Next Generation (NG) application. As the QMARS NG application continues development, additional tables will be added to the CDR. The initial tables include QMARS appeals (Referrals - Fee For Service) data that is originally submitted in FHIR JSON format and then made available in Hive. CDR Hive tables point directly to QMARS NG data in the QMARS cloud. The data refresh frequency is controlled by the QMARS ADO.
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. The QPP team provides an extract of the UDS each month. The "Most Recent Refresh" column reflects the date at which the extract was made available in the CDR however the extract may be several days older.
IQIES - Internet-based Quality Improvement and Evaluation System
QIESWB - QUALITY IMPROVEMENT EVALUATION SYSTEM (QIES) WORKBENCH HOSPCE - HOSPICE HIS - HOSPICE ITEM SET (HIS) SYSTEM - HOSPICE QUALITY REPORTING PROGRAM (HQRP) IRFPAI - INPATIENT REHAB FACILITY PATIENT ASSESSMENT INSTRUMENT DATA LTCH - MEDPAR LONG TERM CARE (MDS) LTCH-QRP - LONG TERM CARE HOSPITALS QUALITY REPORTING PROGRAM LTCHOS - LONG TERM CARE HOSPITALS ASSESSMENT (CARE) ASSESSMENT DATA SET LTCMDS - LONG TERM CARE MINIMUM DATA SET MDS - MINIMUM DATA SET (NURSING HOME) MDS - PROVIDER HEALTH QUALITY ASSESSMENT DATA MDS2.0 - MINIMUM DATA SET VERSION 2.0 FOR NURSING HOME RESIDENT ASSESSMENT & CARE SCREENING OASIS - OASIS CASPER - CERTIFICATION AND SURVEY PROVIDER ENHANCED REPORT SYSTEM (CASPER)
Beneficiary
beneficiary_data
EDB - ENROLLMENT DATA BASE
MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees)
CRIS
legacy_cris
NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC PDE - PART D - PRESCRIPTION DRUG EVENT DATA
EDB - ENROLLMENT DATA BASE
MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees)
Mandatory:
EDB - ENROLLMENT DATA BASE
MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees)
Plus one of the following for FFS Claims:
NCHDB - NATIONAL CLAIMS HISTORY DATABASE FFSCLM - FFS CLAIMS DATA NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES
Plus one of the following for Prescription Drug Claims:
DDPS - DRUG DATA PROCESSING SYSTEM PDE - PART D - PRESCRIPTION DRUG EVENT DATA
DARRT QII
quality_measures_darrt_qii
QIO - QUALITY IMPROVEMENT ORGANIZATION (QIO) DELIVERABLE DATA (PATRIOT AND DDST)
The Hospital Quality Reporting (HQR) system annually calculates and reports End-of-Life (EOL) measure performance results for a given fiscal year for the PCH program. These tables provide the facility-level performance rate and supporting details as well as patient-level summary data. CDR Hive tables point directly to HQR data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.
This source contains Active Security Administrators /Officials for Hospital Quality Reporting (HQR). CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.
This schema is the replacement for the following legacy schema:
Program Resource System 2.0 (PRS 2.0) is a repository of demographic information for hospital providers in the Centers for Medicare & Medicaid Services (CMS), Survey and Certification System (CASPER), Quality Improvement and Evaluation System (QIES), and Provider Enrollment, Chain and Ownership System (PECOS). PRS 2.0 assists Quality Improvement Organizations (QIOs) and Program Support Contractors in maintaining CMS Programs.
Weekly – but possibly daily based on user validation
Program Resource System 1.0 (PRS 1.0)
Program Resource System 1.0 (PRS 1.0) 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. PRS data is extracted from the HQR source database and the "Most Recent Refresh" column indicates the date at which the data was extracted. The refreshed data is available each Monday morning however it is typically extracted 1-2 business days earlier.
The resource_hqr_prs schema is a replacement for legacy_sdol_np_sdps and resource_hqr_prs_supplemental schema is a replacement for legacy_sddw_np_sdps.
Medicare Current Beneficiary Survey (MCBS) survey data
The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The MCBS Survey File contains survey collected data augmented with administrative data to allow for analysis regarding the beneficiaries’ health status, access to health care, satisfaction with health care and usual source of care. Additional information about MCBS can be found athttps://www.cms.gov/data-research/research/medicare-current-beneficiary-survey.
mcbs_survey
Pending
Instead of including multiple years of MCBS results per table, each year has its own set of tables suffixed with the year number (eg. mcbs_survey.accesscr_2021)
Medicare Current Beneficiary Survey (MCBS) cost supplement
The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The MCBS Cost Supplement links Medicare claims to survey-reported events and provides complete expenditure and source of payment data on all health care services, including those not covered by Medicare reported by our survey beneficiaries. Additional information about MCBS can be found athttps://www.cms.gov/data-research/research/medicare-current-beneficiary-survey.
mcbs_cost
Pending
Instead of including multiple years of MCBS results per table, each year has its own set of tables suffixed with the year number (eg. mcbs_cost.csevwgts_2021)
Medicare Current Beneficiary Survey (MCBS) beneficiary crosswalk
The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The beneficiary crosswalk maps MCBS BASE ID values to HICN and BENE ID values, enabling joins on beneficiaries between MCBS and other datasets. Additional information about MCBS can be found athttps://www.cms.gov/data-research/research/medicare-current-beneficiary-survey.
mcbs_crosswalk
Pending
Instead of including multiple years of MCBS results per table, each year has its own table suffixed with the year number (eg. mcbs_crosswalk.mcbs_bas_hic_xwalk_2021)
**Data Issue Identified: SeeKnown Issues Logfor current status**
Quality Management and Review Systems (QMARS) is a system for case management and review. This data is extracted from QMARS system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction.
Monthly - 5th of the month or the next business day
QMARS Next Generation (NG)
The ‘healthcare_service_qmars_ng’ schema contains a set of initial tables that are included from the QMARS Next Generation (NG) application. As the QMARS NG application continues development, additional tables will be added to the CDR. The initial tables include QMARS appeals (Referrals - Fee For Service) data that is originally submitted in FHIR JSON format and then made available in Hive. CDR Hive tables point directly to QMARS NG data in the QMARS cloud. The data refresh frequency is controlled by the QMARS ADO.
The Quality Payment Program (QPP) Universal Data Set (UDS) is a curated data warehouse of all QPP data for analytics and reporting. The QPP team provides an extract of the UDS each month. The "Most Recent Refresh" column reflects the date at which the extract was made available in the CDR however the extract may be several days older.
Contains HMO/PDP contract and service area data from the CMS Health Plan Management System. HPMS provides an updated file on the first business day of each month. The data is generally available in the CDR by the 5th of each month.
Researchers at RAND, in coordination with the Centers for Medicare & Medicaid Services’ (CMS) Office of Minority Health (OMH), modified an existing method for indirectly estimating race-and-ethnicity from surname and residential information (Bayesian Improved Surname and Geocoding[BISG]) to augment CMS’s SSA-based administrative measure of race-and-ethnicity; this resulted in the Medicare Bayesian Improved Surname Geocoding (MBISG) algorithm.
Researchers at RAND, in coordination with the Centers for Medicare & Medicaid Services’ (CMS) Office of Minority Health (OMH), modified an existing method for indirectly estimating race-and-ethnicity from surname and residential information (Bayesian Improved Surname and Geocoding[BISG]) to augment CMS’s SSA-based administrative measure of race-and-ethnicity; this resulted in the Medicare Bayesian Improved Surname Geocoding (MBISG) algorithm. The mbisg_v211 schema in the CDR contains data from MBISG version 2.1.1, which is not the current algorithm version and requires special permission from the data owner.
Researchers at RAND, in coordination with the Centers for Medicare & Medicaid Services’ (CMS) Office of Minority Health (OMH), modified an existing method for indirectly estimating race-and-ethnicity from surname and residential information (Bayesian Improved Surname and Geocoding[BISG]) to augment CMS’s SSA-based administrative measure of race-and-ethnicity; this resulted in the Medicare Bayesian Improved Surname Geocoding (MBISG) algorithm. MBISG v2.1.2 is the current version.
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.
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.
In Part A Claims, dates showing as '1970-01-01' in the rev_cntr_dt field should be treated as blank or null values