Horizontal Navigation Bar Page |
---|
|
Clinical |
Panel |
---|
|
Tabs Container |
---|
|
|
Tabs Page |
---|
title | Beneficiary and Provider Data |
---|
|
Beneficiary and Provider Data
Schema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information |
---|
Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required | Assessment
(iQIES) Anchor |
---|
Assessment_iQIES | 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. | assessment_iqies | | | 1/5/2021 | Monthly | 1/21/2021 | 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 | | | 1/11/2021 | Weekly | 1/18/2021 | 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 | | 11/18/2020 | Quarterly | 2/18/2021 | 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. 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_form | | N/A | Daily | 1200 UTC Daily | 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) | | | 12/3/2020 | None | Never | Yes |
legacy_hqr_cart_final (CLDW) | | | 12/3/2020 | None | Never | Yes |
legacy_hqr_ehqr | | | 11/16/2020 | None | Never | Yes |
legacy_hqr_sdol_extfilapp | | 12/7/2020 | None | Never | Yes | legacy_hqr_qnol_extfilapp | | 12/7/2020 | None | Never | Yes | legacy_hqr_hai | | | 12/4/2020 | None | Never | Yes |
legacy_hqr_hcahps | | | 10/21/2020 | None | Never | Yes |
legacy_hqr_hcahps_final | | SDOL_CLDW_HCAHPS_view_logic.txt | 10/20/2020 | None | Never | Yes |
legacy_hqr_hvbp | | | 10/19/2020 | None | Never | Yes |
legacy_hqr_oat_app | | | 12/2/2020 | None | Never | Yes |
legacy_hqr_ipledge_app | | | 12/9/2020 | None | Never | Yes |
legacy_hqr_nop_app | | | 12/10/2020 | None | Never | Yes |
legacy_hqr_opledge_app | | | 12/9/2020 | None | Never | Yes |
legacy_hqr_opps | | | 12/4/2020 | None | Never | Yes |
legacy_hqr_opps_prs | | | 12/3/2020 | None | Never | Yes |
legacy_hqr_pprs_app | | | 11/10/2020 | None | Never | Yes |
legacy_hqr_struct_msrs | | | 12/4/2020 | None | Never | Yes |
legacy_hqr_validation_app | | 12/7/2020 | None | Never | Yes | legacy_cldw_rpt_etl | | 12/1/2020 | None | Never | Yes | legacy_qnol_pch_app | | | 12/8/2020 | None | Never | Yes |
legacy_hqr_cart_cdac | | | 8/11/2020 | None | Never | Yes |
legacy_hqr_ci_rpt | | 12/10/2020 | None | Never | Yes | legacy_hqr_opps_import | | | 12/10/2020 | None | Never | Yes |
Miscellaneous data from the legacy CLDW and QNOL systems
legacy_cldw_prod_data_mgmt | Misc_prod_data_mgmt_TableLayout.xlsx | | | None | Never | Yes | legacy_qnol_user_admin | | 12/9/2020 | None | Never | Yes | legacy_sdol_ifmc_common | | 3/6/2020 | None | Never | Yes | Program Resource System (PRS) Image Removed **Data Issue Identified: See Known Issues Log for current status** | 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. 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 | | 1/11/2021 | Weekly | 1/18/2021 | Yes | NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | | NPPES dissemination information on CMS Website | 11/17/2020 | Quarterly | 2/14/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 | | | 1/11/2021 | Weekly | 1/18/2021 | 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. | provider_iqies | | | 1/5/2021 | Monthly | 1/19/2021 | Yes |
QMARS Image Removed **Data Issue Identified: See Known Issues Log for current status** | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | | 1/11/2021 | Monthly | 2/9/2021 | 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 | | | 12/28/2020 | Monthly | 1/30/2021 | Yes |
SDDW | Contains Medicare Beneficiary and Provider enrollment data. (FAQ) | legacy_sddw_np_sdps | | denominator1_derived_fields_2020_09_28.docx denominator2_derived_fields_2020_09_28.docx | 12/8/2020 | None | Never | Yes |
SDOL | Contains the beneficiary coverage data previously in the Oracle SDOL database. | legacy_sdol_np_sdps | | 12/8/2020 | None | Never | Yes | Tabs Page |
---|
title | Mapping DUA to Beneficiary and Provider Data |
---|
|
Mapping DUA to Beneficiary and Provider Data
Schema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
| 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) |
Beneficiary | beneficiary_data | EDB MBD (for Part D enrollees) | CRIS | legacy_cris | NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC PDE - PART D - PRESCRIPTION DRUG EVENT DATA EDB MBD (for Part D enrollees) | Mandatory: EDB MBD 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 |
HQR | quality_measures_hqr_pub_report | OTHER-OTHER (SPECIFY)
| HQR - Legacy
legacy_hqr_asc | OTHER-OTHER (SPECIFY)
| legacy_hqr_cart(QNOL) | OTHER-OTHER (SPECIFY)
| legacy_hqr_cart_final (CLDW) | OTHER-OTHER (SPECIFY)
| legacy_hqr_ehqr | OTHER-OTHER (SPECIFY)
| legacy_hqr_sdol_extfilapp | OTHER-OTHER (SPECIFY)
| legacy_hqr_qnol_extfilapp | OTHER-OTHER (SPECIFY)
| legacy_hqr_hai | OTHER-OTHER (SPECIFY)
| legacy_hqr_hcahps | OTHER-OTHER (SPECIFY)
| legacy_hqr_hcahps_final | OTHER-OTHER (SPECIFY)
| legacy_hqr_hvbp | OTHER-OTHER (SPECIFY)
| legacy_hqr_oat_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_ipledge_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_nop_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_opledge_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_opps | OTHER-OTHER (SPECIFY)
| legacy_hqr_opps_prs | OTHER-OTHER (SPECIFY)
| legacy_hqr_pprs_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_struct_msrs | OTHER-OTHER (SPECIFY)
| legacy_hqr_validation_app | OTHER-OTHER (SPECIFY)
| legacy_cldw_rpt_etl | OTHER-OTHER (SPECIFY)
| legacy_qnol_pch_app | OTHER-OTHER (SPECIFY)
| legacy_hqr_cart_cdac | OTHER-OTHER (SPECIFY)
| legacy_hqr_ci_rpt | OTHER-OTHER (SPECIFY)
| legacy_hqr_opps_import | OTHER-OTHER (SPECIFY)
| legacy_cldw_prod_data_mgmt | OTHER-OTHER (SPECIFY)
| legacy_qnol_user_admin | OTHER-OTHER (SPECIFY)
| legacy_sdol_ifmc_common | OTHER-OTHER (SPECIFY)
| PRS | legacy_hqr_prs | PECOS - PROVIDER/PHYSICIAN DATA IQIES - Internet-based Quality Improvement and Evaluation System HPMS - HEALTH PLAN MGMT SYS | Mandatory: HPMS - HEALTH PLAN MGMT SYS Plus one of the following for Providers: 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 |
NPPES | nppes | 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 |
QMARS | qmars | NCH, DDPS, EDB and PECOS | Quality Payment Program (QPP) Universal Data Set (UDS) | quality_measures_qpp_uds | QPP - QUALITY AND PERFORMANCE DATA | SDDW | legacy_sddw_np_sdps | SDPS - STANDARD DATA PROCESSING SYSTEM | Mandatory: EDB MBD 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 |
SDOL | legacy_sdol_np_sdps | SDPS - STANDARD DATA PROCESSING SYSTEM | EDB - ENROLLMENT DATA BASE |