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 | | 6/18/2020 | Monthly | 7/22/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 | | | 6/18/2020 | Monthly | 7/22/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 |
legacy_hqr_asc | | 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 | | 4/6/2020 | Quarterly | 7/8/2020 | Yes | legacy_hqr_hcahps_final | | 4/6/2020 | Quarterly | 7/8/2020 | Yes | legacy_hqr_hvbp | | 5/3/2020 | Quarterly | 8/5/2020 | Yes | legacy_hqr_oat_app | | 4/20/2020 | Quarterly | 7/22/2020 | Yes | legacy_hqr_ipledge_app | | 6/19/2020 | Monthly | 7/22/2020 | Yes | legacy_hqr_nop_app | | 5/7/2020 | Quarterly | 8/5/2020 | Yes | legacy_hqr_opledge_app | | 6/19/2020 | Monthly | 7/22/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 | | 05/29/20 | Quarterly | 7/22/2020 | Yes | legacy_cldw_rpt_etl | | 4/3/2020 | Quarterly | 7/8/2020 | Yes | legacy_qnol_pch_app | | 4/3/2020 | Quarterly | 7/8/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 | HQR_PRS_TableLayout.xlsx | 6/18/2020 | Monthly | 7/22/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 | | 6/1/2020 | Monthly | 7/8/2020 | Yes | QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | | 6/3/2020 | Monthly | 7/10/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: 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 | |
| 6/18/2020 | Monthly | 7/22/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 | | | 6/18/2020 | Monthly | 7/22/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 | |
| 4/6/2020 | Quarterly | 7/8/2020 | Yes |
legacy_hqr_hcahps_final | |
| 4/6/2020 | Quarterly | 7/8/2020 | Yes |
legacy_hqr_hvbp | |
| 5/3/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_oat_app | |
| 4/20/2020 | Quarterly | 7/22/2020 | Yes |
legacy_hqr_ipledge_app | |
| 6/19/2020 | Monthly | 7/22/2020 | Yes |
legacy_hqr_nop_app | |
| 5/7/2020 | Quarterly | 8/5/2020 | Yes |
legacy_hqr_opledge_app | |
| 6/19/2020 | Monthly | 7/22/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 | |
| 05/29/20 | Quarterly | 7/22/2020 | Yes |
legacy_cldw_rpt_etl | |
| 4/3/2020 | Quarterly | 7/8/2020 | Yes |
legacy_qnol_pch_app | |
| 4/3/2020 | Quarterly | 7/8/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 | HQR_PRS_TableLayout.xlsx |
| 6/18/2020 | Monthly | 7/22/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 | |
| 6/1/2020 | Monthly | 7/8/2020 | Yes |
QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | |
| 6/3/2020 | Monthly | 7/10/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 | 6/18/2020 | Monthly | 7/22/2020 | Yes | SDOL | Contains the beneficiary coverage data previously in the Oracle SDOL database. | legacy_sdol_np_sdps | | 6/18/2020 | Monthly | 7/22/2020 | Yes |