Data

Versions Compared

Old Version 581

changes.mady.by.user Curtis Smith

Saved on

compared with

New Version Current

changes.mady.by.user Gabrielle O'Neal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Added 

excerpt-

Include Page
Data

ResourcesData Resourcesnopaneltrue
Panel
borderWidth0

CCSQ D&A HOME | CDR Data Catalog | Data Roadmap | CDR Contributor Resources | Mapping DUAs to CDR | Data Taxonomy | Bring Your Own Data (BYOD) | Archive

Excerpt IncludeRequesting & Getting Access

Nav_DR
Data Nav_DR


CDR Data Catalog

A data catalog is a collection of metadata, combined with data management and search tools, that helps

Requesting & Getting Accessnopaneltrue
Panel
borderWidth0

Livesearch
spaceKeyDATA
placeholderSearch CCSQ Data & Analytics site
typepage

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.

Refer to User Guides & References

 for

for an overview and a guide to the data catalog.

You

User may need to download documents to see the content if they do not display well.


Note
If you

Users that have any technical questions regarding the information on this page

or the CCSQ Data & Analytics Modernization effort overall, please

should send an email to

HCQIS_Data@hcqis.org.

servicecentersos@cms.hhs.gov, routing to ADO-QualityNet Analytics-Support. 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 Form and include details of

your

their request 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. Additional information will be added regularly. Some

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 and some dates may change due to changing requirements or security mandates.

Excerpt IncludeCCSQ Data & AnalyticsCCSQ Data & Analyticsnopaneltrue



Panel
borderColor#C12026
titleColorWhite
titleBGColor#C12026
borderStylesolid
title
AnchorReturn to TopReturn to Top
Horizontal Navigation Bar
idCDR Data Catalog


Horizontal Navigation Bar Pageauihorizontalnav
titleidClaims CDR Data Catalog


Horizontal Navigation Bar Page
Panel
borderWidth1 px
Tabs Container
directionhorizontal
Tabs Page
titleClaims Data

Claims Data

CSAT

Image Removed 

**Data Issue Identified: See Known Issues Log for current status**

SchemaDescriptionCDR Hive SchemaCDR Table Layouts

Data Dictionaries and Supplemental Information

Most Recent RefreshRefresh FrequencyNext RefreshDUA 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)


csat_5

csat_2

-----------------------

Legacy CSAT:

csat_201908_baseline

csat_201909 [monthly]

CSAT

csat_5

_TableLayout.xlsx

CSAT

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

Frequently Asked Questions (FAQ)

6/2/2021

HTML Comment
hiddentrue

START|CSAT|3/26/2021|4/23/2021|END

Monthly6/25/2021YesDDPS Part D


Monthly - Last Friday of every month
DDPS Part DThe source
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)ddps_part_d
Part
ddps_
D
part_
TableLayout.xlsx
d

DDPS

-

Part

-

D

-

Data Dictionary

.xlsxFrequently Asked Questions (FAQ)

6/10/2021Monthly7/12/2021Yes


Monthly - By the 12th of each month or the following business day
NCH Part A 
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)nch_part_a
Part
nch_
A
part_
TableLayout.xlsx2021_05-
a

Data Dictionary - FI_HHA_CLM_REC

-CR17

.

txt 2021_05-

zip

Data Dictionary - FI_

HOSPC

OP_CLM_REC

- CR17

.

txt

zip

2021_05-

Data Dictionary - FI_IP_SNF_CLM_REC

- CR17

.

txt

zip

2021_05-

Data Dictionary - FI_

OP

HOSPC_CLM_REC

- CR17

.

txt

Frequently Asked Questions (FAQ)

6/17/2021Weekly

6/24/2021

Yes

NCH Part B

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)nch_part_b

Part_B_TableLayout.xlsx

2021_05-Data Dictionary - CARR_CLM_REC - CR17.txt

2021_05-Data Dictionary - DMERC_CLM_REC - CR17.txt

Frequently Asked Questions (FAQ)

6/17/2021Weekly

6/24/2021

Yes Tabs Page
titleMapping DUA to Claims Data

Mapping DUA to Claims Data

SchemaCDR Hive SchemaPreferred DUA EntryAcceptable DUA Entry

CSAT

csat_5

csat_2

-----------------------

Legacy CSAT:

csat_201908_baseline

csat_201909 [monthly]

NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC
PDE - PART D - PRESCRIPTION DRUG EVENT DATA
EDB
MBD (for Part D enrollees)

Mandatory:

EDB
MBD

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

DDPS Part Dddps_part_d

DDPS - DRUG DATA PROCESSING SYSTEM  

PDE - PART D - PRESCRIPTION DRUG EVENT DATA

NCH Part A

nch_part_a

NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES

FFSCLM - FFS CLAIMS DATA
NCHDB - NATIONAL CLAIMS HISTORY DATABASE
NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC

NCH Part B

nch_part_b

NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES

FFSCLM - FFS CLAIMS DATA
NCHDB - NATIONAL CLAIMS HISTORY DATABASE
NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC

Return to Top

Horizontal Navigation Bar Page
titleBeneficiary and Provider Data

zip


Weekly - Thursdays
MSDRG

A Medicare Severity-Diagnosis Related Group (MSDRG) is a system of classifying a Medicare patient’s hospital stay into various groups in order to facilitate payment of services. Additional information on MSDRG Classifications and Software can be found on the public CMS site: https://www.cms.gov/medicare/medicare-fee-for-service-payment/acuteinpatientpps/ms-drg-classifications-and-software

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:

claims_msdrg_output
claims_msdrg_output_diagnosiscodeinfo
claims_msdrg_output_procedurecodeinfo.

MSDRG codes in the CDR are available on claims effective from July 2019 onwards.

nch_part_anch_part_a

MSDRG_DataCatalog.xlsx

MSDRG_JavaAPI_Guide.pdf

Weekly - Thursdays
NCH Part BThe 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)nch_part_bnch_part_b

Data Dictionary - DMERC_CLM_REC.zip

Data Dictionary - CARR_CLM_REC.zip


Weekly - Thursdays
NCH MEDPARMedicare 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.medparmedpar

medpar_data_dictionary_ForCatalog.xlsx

 Quarterly

Important Notes

  • 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
  • Recommended data catalog documentation for CDR contributors is located on the CDR Data Contribution Standard Operating Procedure page.


Beneficiary and Provider

Data

Horizontal Navigation Bar Page
titleClinical Data

Clinical

Panel
borderWidth1 px
Tabs Container
directionhorizontal
Tabs Page
titleBeneficiary and Provider Data
SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental Information
Most Recent
Refresh
Refresh FrequencyNext RefreshDUA Required

Assessment

(iQIES) AnchorAssessment_iQIESAssessment_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. 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.  

assessment_iqies

assessment_iqies_TableLayout.xlsx

iQIES_CDR_Data_Dictionary_20200903.xlsx

6/1/2021Monthly7/6/2021Yes

Beneficiary

Image Removed 

**Data Issue Identified: See Known Issues Log for current status**

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.  beneficiary_data

beneficiary_data_TableLayout.xlsx

bic-data-lake-data-dictionary.pdf

beneficiary_data_Partition_Info.xlsx

BIC-Data-Dictionary-Code-Values-20210309.xlsx

Frequently Asked Questions (FAQ)

6/21/2021Weekly6/28/2021YesCRISThe 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/2020NoneNeverYesDARRT QIIThis 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.quality_measures_darrt_qii

quality_measures_darrt_qii_TableLayout.xlsx

DARRT QII Data Definition.04192021.xls

DARRT QII Model.04192021.pdf

6/23/2021Weekly6/30/2021Yes

Hospital Quality Reporting (HQR)

Image Removed 

**Data Issue Identified: See Known Issues Log for current status**

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.  quality_measures_hqr_pub_report

quality_measures_hqr_pub_report_TableLayout.xlsx

6/17/2020Quarterly8/30/2021Yes
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:
  • 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
quality_measures_hqr_data_form

quality_measures_hqr_data_form_TableLayout.xlsx

N/ADaily1100 UTC DailyYes

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:

  • legacy_hqr_opps_import
  • legacy_hqr_opps
  • legacy_hqr_cart
  • legacy_hqr_cart_final
quality_measures_hqr_char_abst

quality_measures_hqr_char_abst_TableLayout.xlsx

hqr_char_abst_DataDictionary_03262021.xlsx

hqr_char_abst_iqr_ERD_04092021.pdf

hqr_char_abst_oqr_ERD_04092021.pdf

N/ADaily1000 UTC DailyYes

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:

  • legacy_hqr_ipledge_app
  • legacy_hqr_opledge_app
  • legacy_hqr_nop_app
provider_hqr_nop

provider_hqr_nop_TableLayout.xlsx

N/ADaily1000 UTC DailyYesThe 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
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.  clinical_eqrs 

See Data Dictionary file

EQRS Data Dictionary

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.

rds_extractsSee Data Dictionary file RDS Extracts Data DictionaryQuarterly (January, April, July, October)

Clinical Extracts 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).clinical_extractsTBDClinical Extracts Data DictionaryWeekly (loaded each weekend)
Care Compare ExtractsEnd 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).care_compare_extracts

TBDCare Compare Extracts Data Dictionary Quarterly (January, April, July, October)

Important Notes


quality_measures_hqr_val_TableLayout
Horizontal Navigation Bar Page
titleBeneficiary and Provider Data

Beneficiary and Provider Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationRefresh

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. 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.  

assessment_iqiesassessment_iqies

iQIES CDR Data Dictionary.xlsx

Monthly - 1st Business Day of the month
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. 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. provider_iqiesprovider_iqies

iQIES CDR Data Dictionary.xlsx

iQIES S&C Code Tables Data Dictionary.xls

Monthly - 1st Business Day of the month


Beneficiary

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. 

beneficiary_databeneficiary_data

BIC data lake Data Dictionary.pdf

beneficiary data Partition Info.xlsx

BIC Data Dictionary Code Values.xlsx

BIC Data Structures.xlsx


Note
titleNote:

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.  provider_pmi_dataProvider_PMI_Data

Guides:

Guide to Using the MDM PMI SPP NPI Profile Tables.docx

Guide to Using the MDM Comprehensive PMI and SPP Tables.docx

MDM 3rd Qtrly Training.pptx

DDES Quarterly Training.pptx

NPI Profile Data Dictionary:

MDM 3.0 NPI Profile Delta Tables Dictionary.pdf

MDM 3.0 NPI Profile Logical Hive Data Model.pdf

MDM 3.0 NPI Profile Physical Hive Data Model.pdf

MDM 2.0 NPI Tables Model Diagram.pdf

PMISPP Data Dictionary:

MDM 3.0 PMISPP Delta Tables Dictionary.pdf

MDM 3.0 PMISPP Logical Hive Data Model.pdf

MDM 3.0 PMISPP Physical Data Dictionary.pdf

MDM table Partition information:

provider pmi data Partition Info.xlsx

Contact the Data & Analytics team for the password to unlock the documents.

Weekly - Mondays
DARRT QIIThis 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.quality_measures_darrt_qiiquality_measures_darrt_qii

DARRT QII Data Definition.xls

DARRT QII Model.pdf

Weekly - Wednesdays
Hospital Quality Reporting (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. 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.
 quality_measures

This schema is the replacement for the following legacy schemas:

legacy
_hqr_
validation
pub_
app
report
legacy

quality_measures_hqr_
oat_app
  • legacy_hqr_cart_cdac
    		• quality_measures_hqr_val
    pub_report.xlsx
    N/ADaily1000 UTC DailyYes
    Quarterly
    Hospital Quality Reporting (HQR)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

    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

    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
    schemas:
    • legacy_hqr_struct_
    ehqr
    • msrs
    quality
    • legacy_
    measures
    • qnol_
    hqr
    • pch_
    ecqm
    • app
    quality_measures
    • legacy_hqr_
    ecqm_TableLayout.xlsxN/ADaily1000 UTC DailyYes

    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:

    • legacy_qnol_user_admin
    resource_hqr_sec_admin    

    resource_hqr_sec_admin_TableLayout.xlsx

    N/ADaily1000 UTC DailyYesHQR - Legacy
    These schema are copies of the former HQR Oracle databases and applications in SDOL, QNOL, and CLDW. legacy_hqr_hvbp

    HQR_HVBP_TableLayout.xlsx

    HQR_QNOL_HVBP_view_logic.zip

    10/19/2020

    None

    NeverYes

    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. 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.  

    resource_hqr_prs
    resource_hqr_prs_supplemental

    Resource_HQR_PRS_TableLayouts.xlsx

    Resource_HQR_PRS_Supplemental_TableLayouts.xlsx

    Frequently Asked Questions (FAQ)

    6/17/2021Weekly6/28/2021YesNPPESThe National Plan and Provider Enumeration System contains provider NPIs, names, and location information.nppes

    NPPES_TableLayout.xlsx

    NPPES dissemination information on CMS Website5/12/2021Quarterly8/12/2021No

    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.  provider_pmi_data

    Provider_PMI_Data_TableLayout.xlsx

    MDM PMI SPP Physical Data Dictionary_01.07.2020.pdf

    MDM 3rd Qtrly Training.pptx

    DDES Quarterly Training February 2021.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_V3_F_11.10.2020.docx

    Password for all documents above: royalrabbit

    provider_pmi_data_Partition_Info.xlsx

    6/21/2021Weekly6/28/2021YesProvider (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. 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.  provider_iqies

    provider_iqies_TableLayout.xlsx

    iQIES_CDR_Data_Dictionary_20200903.xlsx

    QIES_S&C_Code_Tables_Data_Dictionary 09152020.xls

    6/1/2021Monthly7/6/2021Yes

    QMARS

    Image Removed 

    **Data Issue Identified: See Known Issues Log for 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. qmars

    QMARS_TableLayout.xlsx

    6/7/2021Monthly7/8/2021YesQuality 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.  quality_measures_qpp_uds

    quality_measures_qpp_uds_TableLayout.xlsx

    Full_UDS_Data_Dictionary-6.11.2021.pdf

    UDS_ER_Diagram.jpg

    QPP_Universal_Dataset (UDS)_User_Guide-6.11.2021.pdf

    Querying_UDS_For_Fun-6.11.2021.pdf

    UDS_UDSDM_Deep_Schema_Walk-6.11.2021.pdf

    6/2/2021Monthly7/6/2021Yes Tabs Page
    titleMapping DUA to Beneficiary and Provider Data

    Mapping DUA to Beneficiary and Provider Data

    SchemaCDR Hive SchemaPreferred DUA EntryAcceptable DUA Entry

    Assessment

    (iQIES)

    assessment_iqies

    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)

    Beneficiarybeneficiary_data

    EDB
    MBD (for Part D enrollees)

    CRISlegacy_cris

    NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC
    PDE - PART D - PRESCRIPTION DRUG EVENT DATA
    EDB
    MBD (for Part D enrollees)

    Mandatory:

    EDB
    MBD

    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 QIIquality_measures_darrt_qiiQIO - QUALITY IMPROVEMENT ORGANIZATION (QIO) DELIVERABLE DATA (PATRIOT AND DDST)HQR
    quality_measures_hqr_pub_reportHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENT
    OPT - OUTPATIENTquality_measures_hqr_data_formHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCAHPS - CONSUMER ASSESSMENT OF HEALTH PLAN STUDY SURVEY
    OPT - OUTPATIENT
    IPT - INPATIENTquality_measures_hqr_char_abstHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCDAC - CLINICAL DATA ABSTRACTION CENTER
    IPT - INPATIENT
    OPT - OUTPATIENTprovider_hqr_nopHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENT
    OPT - OUTPATIENTquality_measures_hqr_valHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCDAC - CLINICAL DATA ABSTRACTION CENTER
    IPT - INPATIENT
    OPT - OUTPATIENTquality_measures_hqr_ecqmHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENTresource_hqr_sec_admin    N/Aquality_measures_hqr_hvbpHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENTPRSresource_hqr_prs

    PRS - PROGRAM RESOURCE SYSTEM DATA

    resource_hqr_prs_supplemental

    PRS - PROGRAM RESOURCE SYSTEM DATA

    NPPESnppes

    N/A - Public

    CMS Master Data Management (MDM) Provider Master Index/

    Shared Provider Profile (PMI/SPP)

    provider_pmi_data

    PECOS - PROVIDER/PHYSICIAN DATA

    PECOS - SYSTEM FOR TRACKING HHA OWNERSHIP
    PECUGE - PECOS UGE FILE
    CASPER - CERTIFICATION AND SURVEY PROVIDER ENHANCED REPORT SYSTEM (CASPER)
    QIESWB - QUALITY IMPROVEMENT EVALUATION SYSTEM (QIES) WORKBENCH

    Provider (iQIES)provider_iqies

    IQIES - Quality Improvement and Evaluation System

    CASPER
    CASPER - CERTIFICATION AND SURVEY PROVIDER ENHANCED REPORT SYSTEM (CASPER)
    QIESWB - QUALITY IMPROVEMENT EVALUATION SYSTEM (QIES) WORKBENCHQMARSqmars

    NCH, DDPS, EDB and PECOS

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

    QPP - QUALITY AND PERFORMANCE DATA

    SDDWlegacy_sddw_np_sdps

    SDPS - STANDARD DATA PROCESSING SYSTEM

    Mandatory:

    EDB
    MBD

    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

    SDOLlegacy_sdol_np_sdps

    SDPS - STANDARD DATA PROCESSING SYSTEM

    EDB - ENROLLMENT DATA BASE

    Return to Top

    Horizontal Navigation Bar Page
    titleHealth Plan Data
    • asc
    • legacy_hqr_hcahps
    • legacy_hqr_hcahps_final
    • legacy_cldw_rpt_etl
    • legacy_hqr_pprs_app
    • legacy_opps_prs
    		quality_measures_hqr_data_formquality_measures_hqr_data_form

    quality measures hqr data form.xlsx

    quality_measure_hqr_data_forms.pdf


    		Daily

    Hospital Quality Reporting (HQR)

    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:

    • legacy_hqr_opps_import
    • legacy_hqr_opps
    • legacy_hqr_cart
    • legacy_hqr_cart_final
    		quality_measures_hqr_char_abstquality_measures_hqr_char_abst

    quality measures hqr char abst Data Dictionary.xlsx

    hqr char abst iqr ERD.pdf

    hqr char abst oqr ERD.pdf

    		Daily

    Hospital Quality Reporting (HQR) 

    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:

    • legacy_hqr_ipledge_app
    • legacy_hqr_opledge_app
    • legacy_hqr_nop_app
    		provider_hqr_nopprovider_hqr_nop
    		Daily

    Hospital Quality Reporting (HQR)

    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:

    • legacy_hqr_validation_app
    • legacy_hqr_oat_app
    • legacy_hqr_cart_cdac
    		quality_measures_hqr_valquality_measures_hqr_val

    quality measures hqr val.xlsx

    hqr val ERD.pdf

    		Daily
    Hospital Quality Reporting (HQR)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. CDR Hive tables point directly to HQR data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO.quality_measures_hqr_claims quality_measures_hqr_claims 

    OQR Eligible Claims Counts Data Dictionary.xlsx

    quality_measures_hqr_claims.xlsx


    Hospital Quality Reporting (HQR)This schema houses data for hqr exceptions, exceptions reasons, and exception types.hqr_exceptionsreporting_exception, exception_type, reason

    NA

    		The refresh will occur on demand (initiated by the schema owner when a change is made)

    Hospital Quality Reporting (HQR)

    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

    SAFE_USE_OF_OPIOIDS


    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:

    • legacy_hqr_ehqr
    		quality_measures_hqr_ecqm

    quality_measures_hqr_ecqm

    quality_measures_hqr_ecqm.xlsx


    		Daily
    Hospital Quality Reporting (HQR)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.quality_measures_hqr_pch  PCH EOL Data Dictionary.xlsx 

    Hospital Quality Reporting (HQR)

    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:

    • legacy_qnol_user_admin
    		resource_hqr_sec_admin  
    		resource_hqr_sec_admin.pdfDaily

    Hospital Quality Reporting (HQR)  Hospital Value Based Purchasing (HVBP)

    Hospital Value Based Purchasing (HVBP) Summary Data, corresponds with the data in the 542 report.

    		quality_measures_hqr_hvbpNAHQR HVBP Data Dictionary Annually, beginning of August
    Program Resource System 2.0 (PRS 2.0) 

    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.

     

    		ess_prs

    NA

    		PRS2-CDR-Data-Dictionary.xlsx

    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.  

    		resource_hqr_prs
    resource_hqr_prs_supplemental

    resource_hqr_prs

    resource_hqr_prs_supplemental

    		PRS Waiver Type CodesWeekly - Thursdays
    NPPESThe National Plan and Provider Enumeration System contains provider NPIs, names, and location information.nppesnppesNPPES dissemination information on CMS website Quarterly

    QMARS

    Image Added 

    **Data Issue Identified: See Known Issues Log for 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. qmarsqmars
    		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.healthcare_service_qmars_nghealthcare_service_qmars_ng

    QMARS NG Livanta Data Dictionary.docx

    QMARS NG Kepro Data Dictionary.docx

    		Daily
    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.quality_measures_qpp_udsquality_measures_qpp_uds

    Full UDS Data Dictionary.pdf

    UDS ER Diagram.jpg

    QPP Universal Dataset (UDS) User Guide.pdf

    Querying UDS For Fun.pdf

    UDS UDSDM Deep Schema Walk.pdf

    		Weekly - Thursdays
    CRIS
    		legacy_cris


    SDDW
    		legacy_sddw_np_sdps


    SDOL
    		legacy_sdol_np_sdps


    Important Notes


    Health Plan Data

    Contains HMO
    Horizontal Navigation Bar Page
    titleHealth Plan Data

    Health Plan Data

    SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationRefresh
    HPMSContains HMO
    Panel
    borderWidth1 px
    Tabs Container
    directionhorizontal
    Tabs Page
    titleHealth 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
    /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. health_plan
    HPMS
    health_
    TableLayout.xlsx
    plan

    HPMS

    _

    Data

    _Dictionary.xlsx6/4/2021Monthly7/5/2021Yes Tabs Page
    titleMapping DUA to Health Plan Data

    Mapping DUA to Health Plan Data

    Schema

    CDR Hive Schema

    Preferred DUA Entry

    Acceptable DUA Entry

    HPMShealth_plan

    HPMS - HEALTH PLAN MGMT SYS

    N/A

    Return to Top

    Horizontal Navigation Bar Page
    titlePublic Data

    Dictionary

    FINAL RIC0004

    FINAL RIC0007

    PROFILES

    		Weekly - Fridays

    Important Notes


    Public Data

    Horizontal Navigation Bar Page
    titlePublic Data

    Public Data

    Panel
    borderWidth1 px
    Tabs Container
    directionhorizontal
    Tabs Page
    titlePublic Data

    Schema

    Description

    CDR Hive Schema

    CDR Table Layouts

    Data Dictionaries and Supplemental Information

    Most Recent Refresh

    Refresh Frequency

    Next Refresh

    DUA Required

    Schema

    Description

    CDR Hive Schema

    CDR Table Layouts

    Data Dictionaries and Supplemental Information

    Refresh 

    ADIThe Area Deprivation Index (ADI) contains the GIS information for US neighborhoods.public_data

    ADI

    _TableLayout.xlsx

    Neighborhood Atlas Web Page

    4/2/2021Annually4/1/2022No

    Annually

    FDAThe FDA data contains packaging and product information for FDA approved drugs.public_data

    FDA

    _TableLayout.xlsx


    Monthly - 1st of the month or next business day

    FDBThe First Data Bank (FDB) drug list includes drug data available from the legacy data center and is no longer refreshed.  public_data

    FDB

    FDB Drug List Data Dictionary

    4/15/2021 Communications Call Overview

     None

    5/28/2021Monthly6/30/2021No

    Nursing Home CompareThis is the official data for the Nursing Home Compare website.compare_nursing_home

    NHC

    _TableLayout.xlsxNo

    Nursing Home Compare Overview

    Data Set Page

    5/27/2021Monthly6/30/2021

    Data Dictionaries


    Monthly - 1st of the month or next business day


    FIPSThese tables contain FIPS county and state codes.  public_data

    FIPS

    _TableLayout.xlsx5/5/2021


    		Annually
    5/4/2022
    No
    ZIPThis table contains the ZIP Codes and other information for cities and towns in the US.public_data

    ZipCodes

    _TableLayout.xlsx

    5/28/2021Monthly6/30/2021No

    Monthly - 1st of the month or next business day

    Reference CodesThis schema contains various reference codes such as ICD-10, HCPCS, and others.resource_ref_codes

    Resource_Ref_Codes

    _TableLayout.xlsxASC HCPCS: 10/1/2020
    HCPCS: 1/26/2020
    Condition: 11/16/2020
    DRG: 10/1/2020
    ICD Diagnosis:  10/1/2020
    ICD Procedure:  10/1/2020
    Occurrence: 11/13/2020
    Primary Payer: 11/10/2020
    Revenue Center: 11/10/2020
    Span: 11/10/2020
    Value: 11/10/2020Annual (may update quarterly if new code updates)

    Varying dates based on Codes

    ICD codes: 9/30/2021

    HCPCS codes: 12/31/2021

    Condition, DRG, Occurrence, Primary Payer, Revenue Center, Span, Value Codes: Updated when ICD or HCPCS updates occur

    No Tabs Page
    titleMapping DUA to Public Data

    Mapping DUA to Public Data

    Schema

    CDR Hive Schema

    Preferred DUA Entry

    Acceptable DUA Entry

    ADIpublic_dataN/AFDApublic_dataN/ANursing Home Comparecompare_nursing_homeN/AZIPpublic_dataN/A

    Return to Top 

    Horizontal Navigation Bar Page
    titlePlanned Data Sources
    Panel
    borderWidth1 px
    Tabs Container
    directionhorizontal
    Tabs Page
    titlePlanned Data Sources

    Planned Data Sources

    Source NameDescriptionFuture CDR Hive SchemaCDR Legacy Data SourcesData Dictionary and Supplemental InformationTargeted Date of Availability within CDRHVBP 

    This schema provides data and results from the Hospital Value based Purchasing (HVBP) Program.  

    quality_measures_hqr_hvbp

    • legacy_hqr_hvbp
    11/15/2021EQRS Clinical ExtractThe clinical extract from EQRS provides ESRD clinical data for the most recently closed month to CMS contractors to fulfill their contract requirements.  This clinical extract data will be made available in the CDR for users.  clinical_eqrsN/A

    CROWNWeb_R5.1.3_Clncl_Extrct.docx

    Q3 2021QMARS Next Generation (NG)This schema provides QMARS NG data that will replace the current 'qmars' schema as the source for QMARS data in the CDR.  This NG schema will be fully managed by the QMARS ADO and is planned to have daily refreshes of data.  healthcare_service_qmars_ngqmars

    QMARS_NG_Data_Dictionary_6_16_2021.pdf

    8/1/2021 Tabs Page
    titleMapping DUA to Planned Data Sources

    Mapping DUA to Planned Data Sources

    Source NameFuture CDR Hive SchemaPreferred DUA EntryAcceptable DUA Entry

    Return to Top 


     Annual (may update quarterly if new code updates)

    Important Notes


    Horizontal Navigation Bar Page
    titlePlanned Data Sources

    Planned Data Sources

    Source NameDescriptionFuture CDR Hive SchemaCDR Legacy Data SourcesData Dictionary and Supplemental InformationTargeted Date of Availability within CDR
    Medicare Current Beneficiary Survey (MCBS)Medicare beneficiary self-reported data blended with claims and enrollment data.

    TBD

    		NANAJuly 2024
    Medicare Bayesian Improved Surname Geocoding (MBISG)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.

    TBD

    		NANAFall 2024

    Important Notes


    Horizontal Navigation Bar Page
    titleLegacy Sources

    Legacy Sources

    Sources No Longer Being Refreshed

    Source

    		Description

    CDR Hive Schema

    CDR Table Layouts

    Data Dictionaries and Supplemental Information

    Final Refresh Date

    HQR - Legacy
    		legacy_hqr_public_reporting

    HQR_public_reporting

    		SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip3/2/2020
    HQR - Legacy
    		legacy_hqr_asc

    HQR_ASC

    HQR_QNOL_ASC_APP_view_logic.zip

    		4/6/2020
    HQR - Legacy
    		legacy_hqr_hcahps

    HQR_HCAHPS_QNOL

    HQR_QNOL_HCAHPS_view_logic.zip

    		10/21/2020 
    HQR - Legacy
    		legacy_hqr_hcahps_final

    HQR_HCAHPS_CLDW

    SDOL_CLDW_HCAHPS_view_logic.txt

    		10/20/2020 
    HQR - Legacy
    		legacy_qnol_pch_app

    HQR_pch_app

    HQR_QNOL_PCH_APP_view_logic.txt

    		12/8/2020
    HQR - Legacy
    		legacy_hqr_struct_msrs

    HQR_struct_msrs

    HQR_QNOL_STRUCT_MSRS_APP_view_logic.zip

    		12/4/2020
    HQR - Legacy
    		legacy_cldw_rpt_etl

    HQR_rpt_etl


    		12/1/2020
    HQR - Legacy
    		legacy_hqr_pprs_app

    HQR_pprs_app

    HQR_QNOL_PPRS_APP_view_logic.txt

    		11/10/2020
    Horizontal Navigation Bar Page
    titleArchived Sources
    Yes
    Panel
    borderWidth1 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 - Legacylegacy_hqr_public_reporting

    HQR_public_reporting_TableLayouts.xlsx.xlsx

    		SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip3/2/2020Yes
    HQR - Legacylegacy_hqr_asc

    HQR_ASC_TableLayout.xlsx

    HQR_QNOL_ASC_APP_view_logic.zip

    		4/6/2020Yes
    HQR - Legacylegacy_hqr_hcahps

    HQR_HCAHPS_QNOL_TableLayout.xlsx

    HQR_QNOL_HCAHPS_view_logic.zip

    		10/21/2020 
    HQR - Legacy
    		legacy_hqr_
    hcahps
    opps_
    final
    prs

    HQR_

    HCAHPS_CLDW_TableLayout.xlsx.xlsx

    opps_prs

    SDOL_

    CLDW

    OPPS_

    HCAHPS

    PRS_view_logic.txt

    10
    12/
    20
    3/
    2020 Yes
    2020
    HQR - Legacy
    		legacy_
    qnol
    hqr_
    pch_appHQR_pch_app_TableLayout.xlsx
    sdol_extfilapp

    HQR_SDOL_ext_fil_app


    		12/7/2020
    HQR - Legacy
    		legacy_hqr_qnol_extfilapp

    HQR_QNOL_

    PCH

    ext_

    APP_view_logic.txt

    fil_app


    		12/
    8
    7/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    struct_msrs
    hai

    HQR_

    struct_msrs_TableLayout.xlsxHQR_QNOL_STRUCT_MSRS_

    HAI

    SDOL_HAI_APP_view_logic.zip

    		12/4/2020
    Yes
    HQR - Legacy
    		legacy_
    cldw_rpt_etl
    hqr_cart(QNOL)

    HQR_CART

    HQR_

    rpt

    QNOL_CART_

    etl

    view_

    TableLayout

    logic.

    xlsx.xlsx

    zip

    		12/
    1
    3/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    pprs_app
    cart_final (CLDW)

    HQR_

    pprs_app_TableLayout.xlsx

    CART_Final

    SDOL_CLDW_CART

    HQR_QNOL_PPRS_APP

    _view_logic.

    txt

    zip

    11
    12/
    10
    3/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    opps
    ehqr

    HQR_

    prs

    EHQR

    HQR_

    opps

    QNOL_EHQR_

    prs

    view_

    TableLayout

    logic.

    xlsx

    zip

    SDOL

    legacy_

    OPPS

    hqr_

    PRS

    ehqr_

    view

    Partition_

    logic

    Info.

    txt

    xlsx

    12
    11/
    3
    16/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    sdol
    oat_
    extfilapp
    app

    HQR_

    SDOL_ext_fil_app_TableLayout.xlsx

    oat_app

    HQR_QNOL_OAT_APP_view_logic.txt

    		12/
    7
    2/2020
    Yes
    HQR - Legacy
    		legacy_hqr
    _qnol_extfilapp
    _ipledge_app

    QNOL_ipledge_app

    HQR_QNOL_

    ext

    IPLEDGE_

    fil

    APP_

    app

    view_

    TableLayout

    logic.

    xlsx

    txt

    		12/
    7
    9/2020
    Yes
    HQR - Legacy
    		legacy_hqr_nop_
    hai
    app

    HQR_

    HAI

    nop_

    TableLayout.xlsx

    app

    HQR_QNOL_NOP

    SDOL_HAI

    _APP_view_logic.zip

    		12/
    4
    10/2020
    Yes
    HQR - Legacy
    		legacy_hqr_opledge_
    cart(QNOL)HQR_CART_TableLayout.xlsx
    app

    QNOL_opledge_app

    HQR_QNOL_OPLEDGE_

    CART

    APP_view_logic.

    zip

    txt

    		12/
    3
    9/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    cart_final (CLDW)
    opps

    HQR_

    CART_Final_TableLayout.xlsx

    OPPS

    SDOL_CLDW_

    CART

    OPPS_WHS_view_logic.zip

    		12/
    3
    4/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    ehqrHQR_EHQR_TableLayout.xlsx.xlsx
    validation_app

    HQR_

    QNOL_EHQR_view_logic.zip

    legacy_hqr_ehqr_Partition_Info.xlsx

    validation_app


    		12/7
    11/16
    /2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    oat
    cart_
    app
    cdac

    HQR_

    oat_app_TableLayout.xlsx

    CART_CDAC

    SDOL_CLDW_CART_CDAC

    HQR_QNOL_OAT_APP

    _view_logic.txt

    12
    8/
    2
    11/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    ipledge
    ci_
    app
    rpt
    QNOL

    HQR_

    ipledge_app_TableLayout.xlsxHQR_QNOL_IPLEDGE_APP_view_logic.txt

    ci_rpt


    		12/
    9
    10/2020
    Yes
    HQR - Legacy
    		legacy_hqr_
    nop
    opps_
    app
    import

    HQR_

    nop_app_TableLayout.xlsx

    opps_import

    HQR_QNOL_

    NOP

    OPPS_

    APP

    IMPORT_view_logic.zip

    		12/10/2020
    Yes
    HQR - Legacy
    		legacy_
    hqr
    cldw_prod_
    opledge
    data_
    app
    mgmt
    QNOL
    Misc_
    opledge
    prod_
    app
    data_
    TableLayout.xlsx
    mgmt
    HQR

    Misc_

    QNOL

    prod_

    OPLEDGE

    data_

    APP

    mgmt_view_logic.

    txt

    zip

    12/9/2020

    Yes
    HQR - Legacy
    		legacy_
    hqr
    qnol_user_
    opps
    admin
    HQR

    MISC_

    OPPS

    user_

    TableLayout.xlsx

    SDOL_CLDW_OPPS_WHS_view_logic.zip

    admin


    		12/9
    12/4
    /2020
    Yes
    HQR - Legacy
    		legacy_
    hqr
    sdol_
    validation
    ifmc_
    app
    common

    HQR_validation_app_TableLayout.xlsx

    IFMC_COMMON


    		3/6
    12/7
    /2020
    Yes
    HQR - Legacy


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

    		legacy_hqr_
    cart_cdac
    hvbp

    HQR_

    CART_CDAC_TableLayout.xlsx

    HVBP

    HQR_QNOL_HVBP_

    SDOL_CLDW_CART_CDAC_

    view_logic.

    txt

    zip

    8
    10/
    11HQR - Legacy
    19/2020
    Yes
    Program Resource System (PRS)
    		legacy_hqr_
    ci_rpt
    prsHQR_
    ci_rpt_TableLayout.xlsx
    PRS
    		12/
    10
    8/2020
    Yes

    QIES Legacy

    (Provider)

    HQR - Legacy


    		legacy_
    hqr
    provider_
    opps_import
    data
    HQR

    Legacy_

    opps_import_TableLayout.xlsx

    HQR_QNOL_OPPS_IMPORT_view_logic.zip

    12/10/2020YesHQR - Legacylegacy_cldw_prod_data_mgmtMisc_prod_data_mgmt_TableLayout.xlsx

    Misc_prod_data_mgmt_view_logic.zip

    12/9/2020

    YesHQR - Legacylegacy_qnol_user_admin

    MISC_user_admin_TableLayout.xlsx

    12/9/2020YesHQR - Legacylegacy_sdol_ifmc_common

    IFMC_COMMON_TableLayout.xlsx

    3/6/2020Yes

    QIES Legacy

    (Provider)

    legacy_provider_data

    Legacy_Provider_Data_TableLayout.xlsx

    QIES.S&C.Table-Reports.pdf8/27/2020Yes

    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/2020YesBeneficiarylegacy_beneficiary_datalegacy_beneficiary_data_TableLayout.xlsxEDB_data_dictionary.doc12/3/2020YesProgram Resource System (PRS)legacy_hqr_prsHQR_PRS_TableLayout.xlsx12/8/2020YesSDDWlegacy_sddw_np_sdps

    SDDW_NP_SDPS_TableLayout.xlsx

    Denominator_File_Specifications.doc

    denominator1_derived_fields_2020_09_28.docx

    denominator2_derived_fields_2020_09_28.docx

    SDDW_Data_map.xlsx

    legacy_sddw_np_sdps_Partition_Info.xlsx

    For information about beneficiary tables in SDDW:

    EDB_data_dictionary.doc

    12/8/2020YesSDOLlegacy_sdol_np_sdps

    SDOL_NP_SDPS_TableLayout.xlsx

    12/8/2020Yes

    Sources Continuing to be Refreshed

    Source

    Description

    CDR Hive Schema

    CDR Table Layouts

    Data Dictionaries and Supplemental Information

    Most Recent Refresh

    Refresh Frequency

    Next RefreshDUA Required

    Return to Top 

    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.
  • In Part A Claims, dates showing as '1970-01-01' in the rev_cntr_dt field should be treated as blank or null values
    • Recommended data catalog documentation for CDR contributors is located on the CDR Contributor Documentation Requirements Page

    Provider_Data

    		QIES.S&C.Table-Reports.pdf8/27/2020

    QIES Legacy

    (Assessment)


    		legacy_assessment_data

    Legacy_Assessment_Data

    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
    Beneficiary
    		legacy_beneficiary_datalegacy_beneficiary_dataEDB_data_dictionary.doc12/3/2020
    SDDW
    		legacy_sddw_np_sdps

    SDDW_NP_SDPS

    Denominator_File_Specifications.doc

    denominator1_derived_fields.docx

    denominator2_derived_fields.docx

    SDDW_Data_map.xlsx

    llegacy_sddw_np_sdps_Partition_Info.xlsx

    For information about beneficiary tables in SDDW:

    EDB_data_dictionary.doc


    		12/8/2020
    SDOL
    		legacy_sdol_np_sdps

    SDOL_NP_SDPS


    		12/8/2020
    CRISThe 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_

    CRIS User Guide.pdf

    		1/13/2020








    HTML
    <style>#title-text {
		display:none !important;
	}
.aui-navgroup-primary {  
                font-size: 1.25em;  
                font-weight:  bold;  
    }  
.page-metadata-modification-info {
		display:none !important;
	}
</style>