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/20/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 | | | 7/13/2020 | Monthly | 8/19/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/8/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/7/2020 | Quarterly | 10/7/2020 | Yes |
legacy_hqr_hcahps_final | | SDOL_CLDW_HCAHPS_view_logic.txt | 7/7/2020 | Quarterly | 10/7/2020 | Yes |
legacy_hqr_hvbp | | | 5/3/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_oat_app | | | 7/13/2020 | Quarterly | 10/22/2020 | Yes |
legacy_hqr_ipledge_app | | | 7/17/2020 | Monthly | 8/19/2020 | Yes |
legacy_hqr_nop_app | | | 5/7/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_opledge_app | | | 7/17/2020 | Monthly | 8/19/2020 | Yes |
legacy_hqr_opps | | | 5/6/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_opps_prs | | | 5/7/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_pprs_app | | | 5/7/2020 | Quarterly | 8/5/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 | |
| 7/20/20 | Quarterly | TBD | Yes |
legacy_cldw_rpt_etl | |
| 7/8/2020 | Quarterly | 10/14/2020 | Yes |
legacy_qnol_pch_app | | | 6/30/2020 | Quarterly | 10/14/2020 | Yes |
legacy_hqr_cart_cdac | | | 6/3/2020 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_ci_rpt | |
| 6/3/2020 | Quarterly | 9/2/2020 | Yes |
legacy_hqr_opps_import | | | 6/3/2020 | Quarterly | 8/5/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/20/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 | 6/30/2020 | Monthly | 8/5/2020 | Yes |
QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | |
| 7/2/2020 | Monthly | 8/5/2020 | Yes |
SDDW | Contains Medicare Beneficiary and Provider enrollment data. (FAQ) | legacy_sddw_np_sdps | | SDDW_Data_map.xlsx For information about beneficiary tables in SDDW: EDB_data_dictionary.doc | 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/20/2020 | Monthly | 8/19/2020 | Yes |