Schema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
Assessment | The Assessment schema contains data the following data sets: | legacy_assessment_data | | | 8/18/2020 | Monthly | 9/16/2020 | Yes |
Beneficiary | This source contains beneficiary demographics, entitlement, enrollment, premium, health status and other coverage information from the Beneficiary Information on the Cloud (BIC) source. This data will be the source of beneficiary data going forward within the CDR. | beneficiary_data | | | 9/8/2020 | Weekly | 9/14/2020 | Yes |
CRIS | The Case Review Information System (CRIS) was the predecessor to the QMARS system (see below). It was decommissioned October 31, 2018. All data in this system is archival. | legacy_cris | | | 1/13/2020 | None | Never | Yes |
HQR | Public Reporting data provides Hospital Quality Reporting (HQR) data to the Hospital Compare website. The data educates consumers by providing them with detailed information on a hospital’s quality of care. This schema is a replacement for ‘legacy_hqr_public_reporting’ and is being made available from the permanent cloud source of data. | quality_measures_hqr_pub_report | |
| 8/18/2020 | Quarterly | 11/18/2020 | Yes |
HQR - Legacy
| These schema are copies of the former HQR Oracle databases and applications in SDOL, QNOL, and CLDW. | legacy_hqr_asc | | | 4/6/2020 | None | Never | Yes |
legacy_hqr_cart(QNOL) | | | 8/20/20 | Quarterly | 9/22/2020 | Yes |
legacy_hqr_cart_final (CLDW) | | | 8/19/2020 | Quarterly | 9/22/2020 | Yes |
legacy_hqr_ehqr | | | 9/8/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_sdol_extfilapp | |
| 8/25/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_qnol_extfilapp | |
| 8/25/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_hai | | | 8/25/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_hcahps | | | 7/2/2020 | Quarterly | 10/7/2020 | Yes |
legacy_hqr_hcahps_final | | SDOL_CLDW_HCAHPS_view_logic.txt | 7/2/2020 | Quarterly | 10/7/2020 | Yes |
legacy_hqr_hvbp | | | 7/28/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_oat_app | | | 7/13/2020 | Quarterly | 10/22/2020 | Yes |
legacy_hqr_ipledge_app | | | 9/8/2020 | Monthly | 10/14/2020 | Yes |
legacy_hqr_nop_app | | | 8/10/2020 | Quarterly | 9/22/2020 | Yes |
legacy_hqr_opledge_app | | | 9/8/2020 | Monthly | 10/14/2020 | Yes |
legacy_hqr_opps | | | 8/5/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_opps_prs | | | 8/5/2020 | Quarterly | 9/22/2020 | Yes |
legacy_hqr_pprs_app | | | 8/5/2020 | Quarterly | 9/22/2020 | Yes |
legacy_hqr_struct_msrs | | | 8/25/20 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_validation_app | |
| 8/6/20 | Quarterly | 10/28/2020 | Yes |
legacy_cldw_rpt_etl | |
| 6/29/2020 | Quarterly | 10/14/2020 | Yes |
legacy_qnol_pch_app | | | 6/26/2020 | Quarterly | 10/14/2020 | Yes |
legacy_hqr_cart_cdac | | | 8/11/2020 | None | Never | Yes |
legacy_hqr_ci_rpt | |
| 8/21/2020 | Quarterly | 911/211/2020 | Yes |
legacy_hqr_opps_import | | | 8/3/2020 | Quarterly | 9/30/2020 | Yes |
Miscellaneous data from the legacy CLDW and QNOL systems
| legacy_cldw_prod_data_mgmt | Misc_prod_data_mgmt_TableLayout.xlsx | | | Quarterly | 11/11/2020 | Yes |
legacy_qnol_user_admin | |
| 8/24/2020 | Quarterly | 11/11/2020 | Yes |
legacy_sdol_ifmc_common | |
| 3/6/2020 | None | Never | Yes |
PRS | The Program Resource System (PRS) was formerly stored in the SDDW and SDOL schemas. It is the repository of demographic information for hospital providers in the Centers for Medicare & Medicaid Services (CMS), Survey and Certification System (CASPER), and Quality Improvement and Evaluation System (I QIES). | legacy_hqr_prs | HQR_PRS_TableLayout.xlsx | | 9/3/2020 | Monthly | 10/14/2020 | Yes |
NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | | NPPES dissemination information on CMS Website | 8/14/2020 | Quarterly | 11/25/2020 | No |
CMS Master Data Management (MDM) Provider Master Index/ Shared Provider Profile (PMI/SPP) | The PMI/SPP contains an integrated view of identity resolved provider data across multiple CMS provider data systems. It includes data from PECOS, NPPES, NPICS, QIES, and T-MSIS. It provides both "current" and "historical" provider data from multiple CMS source systems of record. This data will be the source of provider data (including PECOS) within the CDR. The CDR will still provide data concurrently from QIES (iQIES in future) and NPPES. | provider_pmi_data | | | 9/8/2020 | Weekly | 9/14/2020 | Yes |
Legacy Provider | The provider schema contains data formerly found in the CASPER and QIES systems. | legacy_provider_data | | QIES.S&C.Table-Reports.pdf | 8/27/2020 | Monthly | 9/30/2020 | Yes |
QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | |
| 8/27/2020 | Monthly | 9/30/2020 | Yes |
Quality Payment Program (QPP) Universal Data Set (UDS) | The Quality Payment Program (QPP) Universal Data Set (UDS) is a curated data warehouse of all QPP data for analytics and reporting. | quality_measures_qpp_uds | | | 8/18/2020 | Monthly | 9/30/2020 | Yes |
SDDW | Contains Medicare Beneficiary and Provider enrollment data. (FAQ) | legacy_sddw_np_sdps | | | 9/3/2020 | Monthly | 10/5/2020 | Yes |
SDOL | Contains the beneficiary coverage data previously in the Oracle SDOL database. | legacy_sdol_np_sdps | |
| 9/3/2020 | Monthly | 10/5/2020 | Yes |