Versions Compared

Key

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

Include Page
Data 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 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 a guide to the data catalog.

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


Note

If you have any technical questions regarding the information on this page or the CCSQ Data & Analytics Modernization effort overall, please send an email to servicecentersos@cms.hhs.gov, routing to ADO-QualityNet Analytics-Support. 

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 CDR sources are published for awareness of data timeliness.  If your organization requires data to be refreshed on a different timeline or cycle, please submit a Request Form and include details of your request including business justification, data source, requested refresh frequency, and requested refresh dates.


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.

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.



Panel
borderColor#C12026
titleColorwhite
titleBGColor#C12026
borderStylesolid
titleCDR Data Catalog


Horizontal Navigation Bar
idCDR Data Catalog


Horizontal Navigation Bar Page
titleClaims Data


Panel
borderWidth1 px


Tabs Container
directionhorizontal


Tabs Page
titleClaims Data

Claims Data

SchemaDescriptionCDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental InformationMost Recent RefreshRefresh FrequencyNext RefreshDUA Required

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]

 


Monthly

TBD

More information to be announced by CMS Program shortly.  

Yes
DDPS Part DThe 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

 

Monthly

 

Yes

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

Weekly

 

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

Weekly

 

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

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


Panel
borderWidth1 px


Tabs Container
directionhorizontal


Tabs Page
titleBeneficiary and Provider Data

Beneficiary and Provider Data

SchemaDescriptionCDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental InformationMost Recent RefreshRefresh FrequencyNext RefreshDUA Required

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_iqies

 

Monthly

 

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

 

Monthly

 

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

 

Weekly

 

Yes

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

 

Weekly

 

Yes
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_qii

 

Weekly

 

Yes

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_hqr_pub_report


 

Quarterly

 

Yes
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_formN/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_abstN/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
N/ADaily1000 UTC DailyYes

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_valN/ADaily1000 UTC DailyYes

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_ecqmData Dictionary_quality_measures_hqr_ecqm_20220908_.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    
N/ADaily1000 UTC DailyYes

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

 

Weekly

Yes
NPPESThe National Plan and Provider Enumeration System contains provider NPIs, names, and location information.nppesNPPES dissemination information on CMS Website

 

Quarterly

 

No

QMARS

 

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

 

Monthly

 

Yes
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_ngN/ADaily0400 UTC DailyYes
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_uds

 

Weekly

 

Yes



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 - ENROLLMENT DATA BASE

MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees)


CRISlegacy_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 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 - OUTPATIENT
quality_measures_hqr_data_formHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCAHPS - CONSUMER ASSESSMENT OF HEALTH PLAN STUDY SURVEY
OPT - OUTPATIENT
IPT - INPATIENT
quality_measures_hqr_char_abstHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCDAC - CLINICAL DATA ABSTRACTION CENTER
IPT - INPATIENT
OPT - OUTPATIENT
provider_hqr_nopHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENT
OPT - OUTPATIENT
quality_measures_hqr_valHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISCDAC - CLINICAL DATA ABSTRACTION CENTER
IPT - INPATIENT
OPT - OUTPATIENT
quality_measures_hqr_ecqmHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENT
resource_hqr_sec_admin    N/A
quality_measures_hqr_hvbpHQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCISIPT - INPATIENT
PRSresource_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) WORKBENCH
QMARSqmars

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 - ENROLLMENT DATA BASE

MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION

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


Panel
borderWidth1 px


Tabs Container
directionhorizontal


Tabs Page
titleHealth Plan Data

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

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

health_plan

 

Weekly

 

Yes



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


Panel
borderWidth1 px


Tabs Container
directionhorizontal


Tabs Page
titlePublic Data

Public Data

Schema

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Most Recent Refresh

Refresh Frequency

Next Refresh

DUA Required

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

Neighborhood Atlas Web Page

 

Annually

 

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

30 Aug  

Monthly

04 Oct  

No
FDBThe First Data Bank (FDB) drug list includes drug data available from the legacy data center and is no longer refreshed.  public_data8/19/2020NoneNeverNo
Nursing Home CompareThis is the official data for the Nursing Home Compare website.compare_nursing_home

Nursing Home Compare Overview

Data Set Page

Data Dictionaries

31 Aug  

Monthly

04 Oct  

No
FIPSThese tables contain FIPS county and state codes.  public_data
5/5/2021Annually5/4/2022No
ZIPThis table contains the ZIP Codes and other information for cities and towns in the US.public_data

30 Aug  

Monthly

04 Oct  

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

ASC HCPCS:  
HCPCS: 21 Apr  
Condition: 10/29/2021
DRG: 11/12/2021
ICD Diagnosis:  11/16/2021
ICD Procedure:  11/16/2021
Occurrence: 10/29/2021
Primary Payer: 10/29/2021
Revenue Center: 10/29/2021
Span: 10/29/2021
Value:  

Annual (may update quarterly if new code updates)

Varying dates based on Codes

ICD codes: 10/1/2022

HCPCS codes: Jun  

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








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 CDR
HVBP 

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

quality_measures_hqr_hvbp


  • legacy_hqr_hvbp

Q4 2022
EQRS Clinical DataThis schema will provide ESRD Facility, Personnel, Patient and Clinical Data for CDR users.  clinical_eqrsN/AQ3 2022
DDPS TAP Files

Drug Data Processing System (DDPS) contributes TAP files which come from a weekly report that is created of Part D plan-submitted prescription drug events (PDEs) that have passed the DDPS editing process as of a specific moment (TAP) in time. There are both Proprietary and Non-Proprietary TAP files. Consumers will need to specify which type they require upon completion of their onboarding request.

ddps_proprietary_tap

ddps_non_proprietary_tap

N/A
Q4 2022




Tabs Page
titleMapping DUA to Planned Data Sources

Mapping DUA to Planned Data Sources

Source NameFuture CDR Hive SchemaPreferred DUA EntryAcceptable DUA Entry
DDPS TAP Filesddps_proprietary_tap

PEDP: Part D Proprietary TAP File





Return to Top 


Horizontal Navigation Bar Page
titleLegacy Sources


Panel
borderWidth1 px

Legacy Sources

Sources No Longer Being Refreshed

Source

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Final Refresh Date

DUA Required

HQR - Legacy
legacy_hqr_public_reportingSDOL_CLDW_PUBLIC_REPORTING_view_logic.zip3/2/2020Yes
HQR - Legacy
legacy_hqr_asc4/6/2020Yes
HQR - Legacy
legacy_hqr_hcahps 10/21/2020 Yes
HQR - Legacy
legacy_hqr_hcahps_final

SDOL_CLDW_HCAHPS_view_logic.txt

10/20/2020 Yes
HQR - Legacy
legacy_qnol_pch_app12/8/2020Yes
HQR - Legacy
legacy_hqr_struct_msrs12/4/2020Yes
HQR - Legacy
legacy_cldw_rpt_etl
12/1/2020Yes
HQR - Legacy
legacy_hqr_pprs_app11/10/2020Yes
HQR - Legacy
legacy_hqr_opps_prs12/3/2020Yes
HQR - Legacy
legacy_hqr_sdol_extfilapp
12/7/2020Yes
HQR - Legacy
legacy_hqr_qnol_extfilapp
12/7/2020Yes
HQR - Legacy
legacy_hqr_hai12/4/2020Yes
HQR - Legacy
legacy_hqr_cart(QNOL)12/3/2020Yes
HQR - Legacy
legacy_hqr_cart_final (CLDW)12/3/2020Yes
HQR - Legacy
legacy_hqr_ehqr11/16/2020Yes
HQR - Legacy
legacy_hqr_oat_app12/2/2020Yes
HQR - Legacy
legacy_hqr_ipledge_app12/9/2020Yes
HQR - Legacy
legacy_hqr_nop_app12/10/2020Yes
HQR - Legacy
legacy_hqr_opledge_app12/9/2020Yes
HQR - Legacy
legacy_hqr_opps12/4/2020Yes
HQR - Legacy
legacy_hqr_validation_app
12/7/2020Yes
HQR - Legacy
legacy_hqr_cart_cdac8/11/2020Yes
HQR - Legacy
legacy_hqr_ci_rpt
12/10/2020Yes
HQR - Legacy
legacy_hqr_opps_import12/10/2020Yes
HQR - Legacy
legacy_cldw_prod_data_mgmtMisc_prod_data_mgmt_TableLayout.xlsx

12/9/2020

Yes
HQR - Legacy
legacy_qnol_user_admin
12/9/2020Yes
HQR - Legacy
legacy_sdol_ifmc_common
3/6/2020Yes
HQR - Legacy


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

legacy_hqr_hvbp10/19/2020Yes
Program Resource System (PRS)
legacy_hqr_prsHQR_PRS_TableLayout.xlsx
12/8/2020Yes

QIES Legacy

(Provider)


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

QIES Legacy

(Assessment)


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/2020Yes
Beneficiary
legacy_beneficiary_datalegacy_beneficiary_data_TableLayout.xlsxEDB_data_dictionary.doc12/3/2020Yes
SDDW
legacy_sddw_np_sdps12/8/2020Yes
SDOL
legacy_sdol_np_sdps
12/8/2020Yes
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_cris1/13/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






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>