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 | | | 7/17/2020 | Monthly | 8/19/2020 | Yes |
Beneficiary | The beneficiary schema is a subset of the EDB (enrollment database) that contains information on beneficiary identifiers, plan information for the for the beneficiary, and other information. (SORN) | legacy_beneficiary_data | legacy_beneficiary_data_TableLayout.xlsx | | 7/13/2020 | Monthly | 8/19/2020 | Yes |
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 | | | 8/11/2020 | Weekly | 8/17/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
| 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) | | | 05/21/20 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_cart_final (CLDW) | | | 6/1/2020 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_ehqr | | | 6/2/2020 | Quarterly | 9/16/2020 | Yes |
legacy_hqr_sdol_extfilapp | |
| 5/20/2020 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_qnol_extfilapp | |
| 5/17/2020 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_hai | | | 5/21/2020 | Quarterly | 9/2/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 | | | 7/13/2020 | Monthly | 8/19/2020 | Yes |
legacy_hqr_nop_app | | | 5/7/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_opledge_app | | | 7/13/2020 | Monthly | 8/19/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_public_reporting | | | 3/2/2020 | None | Never | Yes |
legacy_hqr_struct_msrs | | | 05/22/20 | Quarterly | 9/2/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 | | | 68/311/2020 | Quarterly | None | Never9/2/2020 | Yes |
legacy_hqr_ci_rpt | |
| 6/3/2020 | Quarterly | 9/2/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 | | | 6/1/2020 | Quarterly | 9/2/2020 | Yes |
legacy_qnol_user_admin | |
| 5/29/2020 | Quarterly | 9/2/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 | |
| 7/10/2020 | Monthly | 8/19/2020 | Yes |
NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | | NPPES dissemination information on CMS Website | 5/4/2020 | Quarterly | 8/19/2020 | No |
Provider | The provider schema contains data formerly found in the CASPER and QIES systems. | legacy_provider_data | | QIES.S&C.Table-Reports.pdf | 7/28/2020 | Monthly | 9/2/2020 | Yes |
QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | |
| 7/29/2020 | Monthly | 9/2/2020 | Yes |
SDDW | Contains Medicare Beneficiary and Provider enrollment data. (FAQ) | legacy_sddw_np_sdps | | | 7/9/2020 | Monthly | 8/19/2020 | Yes |
SDOL | Contains the beneficiary coverage data previously in the Oracle SDOL database. | legacy_sdol_np_sdps | |
| 7/10/2020 | Monthly | 8/19/2020 | Yes |