Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
Tabs Container |
---|
|
Tabs Page |
---|
| Claims DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
CSAT
**Data Issue Identified: See Known Issues Log for current status** | The Healthcare Quality Analytics and Reporting (HCQAR) Complete Statistical Analysis Table (CSAT) is a monthly dataset that provides state and national level claims data variables derived from Medicare Part A / Part B / Part D claims data specifically for the national and state Quality Improvement Networks and Organizations (QIN-QIOs). (SORN) | csat_5 csat_2 ----------------------- Legacy CSAT: csat_201908_baseline csat_201909 [monthly] | | | 12/31/2020 | Monthly | 1/26/2021 | Yes | DDPS Part D | The source data for Part D claims is the Drug Data Processing System. This schema contains all prescription drug claims covered under Medicare Part D. (SORN) | ddps_part_d | |
| 1/8/2021 | Monthly | 2/12/2021 | Yes | | The source data for Part A claims is the National Claims History (NCH) weekly extracts. Part A claims include the Inpatient (IP) and Skilled Nursing Facility (SNF), Home Health (HHA), Hospice, and Outpatient Extracts. (SORN) | nch_part_a | | | 1/21/2021 | Weekly | | Yes | | The source data for Part B claims is the NCH weekly extracts. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts. (SORN) | nch_part_b | | | 1/21/2021 | Weekly | | Yes |
|
Tabs Page |
---|
title | Mapping DUA to Claims Data |
---|
| Mapping DUA to Claims DataSchema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
| csat_5 csat_2 ----------------------- Legacy CSAT: csat_201908_baseline csat_201909 [monthly] | 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 | DDPS Part D | ddps_part_d | DDPS - DRUG DATA PROCESSING SYSTEM | PDE - PART D - PRESCRIPTION DRUG EVENT DATA | | nch_part_a | NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES | FFSCLM - FFS CLAIMS DATA NCHDB - NATIONAL CLAIMS HISTORY DATABASE NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC | | nch_part_b | NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES | FFSCLM - FFS CLAIMS DATA NCHDB - NATIONAL CLAIMS HISTORY DATABASE NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC |
|
|
|
86218841 |
Horizontal Navigation Bar Page |
---|
title | Beneficiary and Provider Data |
---|
|
Panel |
---|
|
Tabs Container |
---|
|
Tabs Page |
---|
title | Beneficiary and Provider Data |
---|
| Beneficiary and Provider DataSchema | 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/20/2021 | Monthly | 2/3/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/25/2021 | Weekly | 2/1/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_ | haiHAISDOLHAIAPP12419/2020 | None | Never | Yes | legacy_hqr_ | hcahps HCAHPSQNOLHCAHPSzip10212020 2020 | None | Never | Yes | legacy_hqr_ | hcahpsfinalHQRHCAHPSCLDW.xlsxSDOL_CLDW_HCAHPS10202020 2020 | None | Never | Yes | legacy_hqr_ | hvbpHVBPHVBP19/2020 | None | Never | Yes | legacy_hqr_ | oatHQRoatOAT29/2020 | None | Never | Yes | legacy_hqr_ | ipledge_appQNOLipledgeapp_HQRQNOLIPLEDGEAPPtxt94/2020 | None | Never | Yes | legacy_hqr_ | nopappnopappNOP104/2020 | None | Never | Yes | legacy_hqr_ | opledgeQNOLopledge | 97/2020 | None | Never | Yes | legacy_hqr_ | oppsOPPSOPPSWHSzip12411/2020 | None | Never | Yes | legacy_hqr_ | oppsprsoppsprs | 310/2020 | None | Never | Yes | legacy_hqr_ | pprsapppprsappPPRSAPPtxt1112/10/2020 | None | Never | Yes | Miscellaneous data from the legacy CLDW and QNOL systems
| legacy_ | hqrstructmsrsHQRstructmsrsHQRQNOLSTRUCTMSRSAPP_4hqrvalidationappHQRvalidationapp79/2020 | None | Never | Yes | legacy_ | cldwrptetlHQRrptetl_.xlsx121legacy_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 systemslegacy_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) 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/22/2021 | Weekly | 2/1/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/25/2021 | Weekly | 2/1/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/20/2021 | Monthly | 2/3/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/20/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 | Program Resource System (PRS)
| 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/22/2021 | Weekly | 2/1/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/25/2021 | Weekly | 2/1/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/20/2021 | Monthly | 2/3/2021 | Yes | QMARS Image Added
**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/20/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 |
|
Tabs Page |
---|
title | Mapping DUA to Beneficiary and Provider Data |
---|
| Mapping DUA to Beneficiary and Provider DataSchema | 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 |
| Tabs Page |
---|
title | Mapping DUA to Beneficiary and Provider Data |
---|
| Mapping DUA to Beneficiary and Provider DataSchema | 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_hqrqnol_user_ascadmin | OTHER-OTHER (SPECIFY)
|
| legacy_sdol_hqr_cart(QNOL)ifmc_common | OTHER-OTHER (SPECIFY)
|
| PRS | 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 |
|
|
|
86218841 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 |
|
|
|
86218841 |
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
Tabs Container |
---|
|
Tabs Page |
---|
| Health Plan DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
HPMS | Contains HMO/PDP contract and service area data from the CMS Health Plan Management System. | health_plan | | | 1/6/2021 | Monthly | 2/3/2021 | Yes |
|
Tabs Page |
---|
title | Mapping DUA to Health Plan Data |
---|
| Mapping DUA to Health Plan DataSchema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
HPMS | health_plan | HPMS - HEALTH PLAN MGMT SYS | N/A |
|
|
|
86218841 |
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
Tabs Container |
---|
|
Tabs Page |
---|
| Public DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
ADI | The Area Deprivation Index (ADI) contains the GIS information for US neighborhoods. | public_data | | Neighborhood Atlas Web Page | 4/10/2020 | Annually | 5/13/2021 | No | FDA | The FDA data contains packaging and product information for FDA approved drugs. | public_data | |
| 1/12/2021 | Monthly | 2/11/2021 | No | Nursing Home Compare | This is the official data for the Nursing Home Compare website. | compare_nursing_home | | Nursing Home Compare Overview Data Set Page | 1/7/2021 | Monthly | 2/11/2021 | No | ZIP | This table contains the ZIP Codes and other information for cities and towns in the US. | public_data | |
| 1/12/2021 | Monthly | 2/11/2021 | No | Reference Codes | This schema contains various reference codes such as ICD-10, HCPCS, and others. | resource_ref_codes | |
| ASC HCPCS: 10/1/2020 HCPCS: 1/26/2020 Condition: 11/16/2020 DRG: 10/1/2020 ICD Diagnosis: 10/1/2020 ICD Procedure: 10/1/2020 Occurrence: 11/13/2020 Primary Payer: 11/10/2020 Revenue Center: 11/10/2020 Span: 11/10/2020 Value: 11/10/2020 | Annual (may update quarterly if new code updates) | Varying dates based on Codes ICD codes: 9/30/2021 HCPCS codes: 12/31/2021 Condition, DRG, Occurrence, Primary Payer, Revenue Center, Span, Value Codes: Updated when ICD or HCPCS updates occur | No |
|
Tabs Page |
---|
title | Mapping DUA to Public Data |
---|
| Mapping DUA to Public |
|
|
| Horizontal Navigation Bar Page |
---|
| Panel |
---|
| Tabs Container |
---|
| Tabs Page |
---|
| Health Plan DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
HPMS | Contains HMO/PDP contract and service area data from the CMS Health Plan Management System. | health_plan | | | 1/6/2021 | Monthly | 2/3/2021 | Yes | Tabs Page |
---|
title | Mapping DUA to Health Plan Data |
---|
| Mapping DUA to Health Plan DataSchema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
HPMS | health_plan | HPMS - HEALTH PLAN MGMT SYSADI | public_data | N/A |
| FDA | public_data | N/A |
| Nursing Home Compare | compare_nursing_home | N/A |
| ZIP | public_data | N/A |
|
|
|
|
86218841 |
Horizontal Navigation Bar Page |
---|
title | Public Planned Data Sources |
---|
|
Panel |
---|
|
Tabs Container |
---|
|
Tabs Page |
---|
title | Public Planned Data Sources |
---|
| Public Planned Data SourcesSchemaSource Name | Description | Future CDR Hive Schema | CDR | Table LayoutsLegacy Data Sources | Data | Dictionaries Dictionary and Supplemental Information |
---|
Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required | ADI | The Area Deprivation Index (ADI) contains the GIS information for US neighborhoods. | public_data | | Neighborhood Atlas Web Page | 4/10/2020 | Annually | 5/13/2021 | No | FDA | The FDA data contains packaging and product information for FDA approved drugs. | public_data | | 1/12/2021 | Monthly | 2/11/2021 | No | Nursing Home Compare | This is the official data for the Nursing Home Compare website. | compare_nursing_home | | Nursing Home Compare Overview Data Set Page | 1/7/2021 | Monthly | 2/11/2021 | No | ZIP | This table contains the ZIP Codes and other information for cities and towns in the US. | public_data | | 1/12/2021 | Monthly | 2/11/2021 | No | Reference Codes | This schema contains various reference codes such as ICD-10, HCPCS, and others. | resource_ref_codes | | ASC HCPCS: 10/1/2020 HCPCS: 10/1/2020 Condition: 11/16/2020 DRG: 10/1/2020 ICD Diagnosis: 10/1/2020 ICD Procedure: 10/1/2020 Occurrence: 11/13/2020 Primary Payer: 11/10/2020 Revenue Center: 11/10/2020 Span: 11/10/2020 Value: 11/10/2020 | Annual (may update quarterly if new code updates) | Varying dates based on Codes ICD codes: 9/30/2021 HCPCS codes: 12/31/2021 Condition, DRG, Occurrence, Primary Payer, Revenue Center, Span, Value Codes: Updated when ICD or HCPCS updates occur | No | | Tabs Page |
---|
title | Mapping DUA to Public Data |
---|
| Mapping DUA to Public DataSchema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
ADI | public_data | N/A | FDA | public_data | N/A | Nursing Home Compare | compare_nursing_home | N/A | ZIP | public_data | N/A |
|
|
86218841 | Horizontal Navigation Bar Page |
---|
title | Planned Data Sources |
---|
| Panel |
---|
| Tabs Container |
---|
| Tabs Page |
---|
title | Planned Data Sources |
---|
| Planned Data SourcesSource Name | Description | Future CDR Hive Schema | CDR Legacy Data Sources | Data Dictionary and Supplemental Information | Targeted Date of Availability within CDR |
---|
IQR/OQR Chart-Abstracted (Clinical Outcome) | IQR and OQR Chart Abstracted Calculations & Outcomes (CACAO) system provide CMS and its stakeholders with system functionality that calculates measure outcomes for clinical quality measures that evaluates data submitted via XML file. The following measures are included in this data set: - OP-2: Fibrinolytic Therapy Received Within 30 Minutes of ED Arrival
- OP-3 Median Time to Transfer to Another Facility for Acute Coronary Intervention
- OP-3a - Overall Rate
- OP-3b - Reporting Measure
- OP-3c - Quality Improvement Measure
- OP-23: Head CT or MRI Scan Results for Acute Ischemic Stroke or Hemorrhagic Stroke Patients who Received Head CT or MRI Scan Interpretation Within 45 Minutes of ED Arrival
- OP-18a Median Time from ED Arrival to ED Departure for Discharged ED Patients – Overall Rate
- OP-18b Median Time from ED Arrival to ED Departure for Discharged ED Patients –Reporting Measure
- OP-18c Median Time from ED Arrival to ED Departure for Discharged ED Patients – Psychiatric/Mental Health Patients
- OP-18d Median Time from ED Arrival to ED Departure for Discharged ED Patients – Transfer Patients
- SEP-1 and Bundle Data
| quality_measures_hqr_char_abst | - legacy_hqr_opps_import
- legacy_hqr_opps
- legacy_hqr_cart
- legacy_hqr_cart_final
| | 3/25/2020 | Notice of Participation (NOP) | Notice of Participation is a contract between CMS and hospitals that identifies whether or not they are participating in the IQR, OQR, IPF, and PCH programs. Each of these programs have specific requirements that determine whether or not a facility is participating in a quality reporting program. This data set will describe the programs any given hospital is participating in and the date. | provider_participation_hqr_nop | - legacy_hqr_ipledge_app
- legacy_hqr_opledge_app
- legacy_hqr_nop_app
| | 3/25/2020 | IQR/OQR/ECQM Validation | The Centers for Medicare & Medicaid Services (CMS) assesses the accuracy of chart-abstracted data submitted to the Hospital Outpatient Quality Reporting (OQR) Program and the Hospital Inpatient Quality Reporting (IQR) Program through the validation process. CMS verifies on a quarterly basis that hospital-abstracted data submitted to CMS’ Clinical Warehouse via the Hospital Quality Reporting (HQR) system can be reproduced by a trained abstractor using a standardized process. | quality_measures_hqr_val | - legacy_hqr_validation_app
- legacy_hqr_oat_app
- legacy_hqr_cart_cdac
| 3/25/2020 | ECQM Measure Outcomes | The HQR system consumes eCQM QRDA files and processes the data based on measure logic to determine the measure outcomes for the follow measures: - STK-06
- STK-05
- STK-03
- STK-02
- ED-2
- VTE-1
- VTE-2
- PC-05
| quality_measures_hqr_ecqm | | | 3/25/2020 | HVBP | This schema provides data and results from the Hospital Value based Purchasing (HVBP) Program. | quality_measures_hqr_hvbp | 7/1/2020 | External Files - CDC NHSN Data | CDC NHSN (National Healthcare Safety Network) provides facilities, states, regions, and the nation with data needed to identify problem areas, measure progress of prevention efforts, and ultimately eliminate healthcare-associated infections. Future files will be sent from the Hospital Quality Reporting (HQR) ADO and made available in the SAS Viya workbench in source format. Once made available, these files will appear in a new folder called "external-data" under your main workbench directory: "workspace/workbench/organization-name/external-data/nhsn" SAS Viya Workbench external-data/nhsn | - legacy_hqr_sdol_extfilapp
- legacy_hqr_qnol_extfilapp
- legacy_hqr_hai
| Available 1/18/2021 | Targeted Date of Availability within CDR |
---|
IQR/OQR Chart-Abstracted (Clinical Outcome) | IQR and OQR Chart Abstracted Calculations & Outcomes (CACAO) system provide CMS and its stakeholders with system functionality that calculates measure outcomes for clinical quality measures that evaluates data submitted via XML file. The following measures are included in this data set: - OP-2: Fibrinolytic Therapy Received Within 30 Minutes of ED Arrival
- OP-3 Median Time to Transfer to Another Facility for Acute Coronary Intervention
- OP-3a - Overall Rate
- OP-3b - Reporting Measure
- OP-3c - Quality Improvement Measure
- OP-23: Head CT or MRI Scan Results for Acute Ischemic Stroke or Hemorrhagic Stroke Patients who Received Head CT or MRI Scan Interpretation Within 45 Minutes of ED Arrival
- OP-18a Median Time from ED Arrival to ED Departure for Discharged ED Patients – Overall Rate
- OP-18b Median Time from ED Arrival to ED Departure for Discharged ED Patients –Reporting Measure
- OP-18c Median Time from ED Arrival to ED Departure for Discharged ED Patients – Psychiatric/Mental Health Patients
- OP-18d Median Time from ED Arrival to ED Departure for Discharged ED Patients – Transfer Patients
- SEP-1 and Bundle Data
| quality_measures_hqr_char_abst | - legacy_hqr_opps_import
- legacy_hqr_opps
- legacy_hqr_cart
- legacy_hqr_cart_final
| | 3/25/2020 | Notice of Participation (NOP) | Notice of Participation is a contract between CMS and hospitals that identifies whether or not they are participating in the IQR, OQR, IPF, and PCH programs. Each of these programs have specific requirements that determine whether or not a facility is participating in a quality reporting program. This data set will describe the programs any given hospital is participating in and the date. | provider_participation_hqr_nop | - legacy_hqr_ipledge_app
- legacy_hqr_opledge_app
- legacy_hqr_nop_app
| | 3/25/2020 | IQR/OQR/ECQM Validation | The Centers for Medicare & Medicaid Services (CMS) assesses the accuracy of chart-abstracted data submitted to the Hospital Outpatient Quality Reporting (OQR) Program and the Hospital Inpatient Quality Reporting (IQR) Program through the validation process. CMS verifies on a quarterly basis that hospital-abstracted data submitted to CMS’ Clinical Warehouse via the Hospital Quality Reporting (HQR) system can be reproduced by a trained abstractor using a standardized process. | quality_measures_hqr_val | - legacy_hqr_validation_app
- legacy_hqr_oat_app
- legacy_hqr_cart_cdac
|
| 3/25/2020 | ECQM Measure Outcomes | The HQR system consumes eCQM QRDA files and processes the data based on measure logic to determine the measure outcomes for the follow measures: - STK-06
- STK-05
- STK-03
- STK-02
- ED-2
- VTE-1
- VTE-2
- PC-05
| quality_measures_hqr_ecqm | | | 3/25/2020 | HVBP | This schema provides data and results from the Hospital Value based Purchasing (HVBP) Program. | quality_measures_hqr_hvbp
| |
| 7/1/2020 | External Files - CDC NHSN Data | CDC NHSN (National Healthcare Safety Network) provides facilities, states, regions, and the nation with data needed to identify problem areas, measure progress of prevention efforts, and ultimately eliminate healthcare-associated infections.
Future files will be sent from the Hospital Quality Reporting (HQR) ADO and made available in the SAS Viya workbench in source format. Once made available, these files will appear in a new folder called "external-data" under your main workbench directory: "workspace/workbench/organization-name/external-data/nhsn" | SAS Viya Workbench external-data/nhsn | - legacy_hqr_sdol_extfilapp
- legacy_hqr_qnol_extfilapp
- legacy_hqr_hai
|
| Available 1/18/2021 |
|
Tabs Page |
---|
title | Mapping DUA to Planned Data Sources |
---|
| Mapping DUA to Planned Data SourcesSource Name | Future CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
Program Resource System (PRS) | resource_hqr_prs | PRS - PROGRAM RESOURCE SYSTEM DATA |
|
|
|
|
86218841 |
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
| Archived SourcesSources No Longer Being Refreshed |
| Tabs Page |
---|
title | Mapping DUA to Planned Data Sources |
---|
| Mapping DUA to Planned Data SourcesSource Name | Future CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
Program Resource System (PRS) | resource_hqr_prs | PRS - PROGRAM RESOURCE SYSTEM DATA | 86218841 Horizontal Navigation Bar Page |
---|
| Panel |
---|
| Archived SourcesSources No Longer Being Refreshed Sources Continuing to be Refreshed Source | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|
|
|
|
| |
|
|
|
|
|
86218841 |
Important Notes
- The CDR follows NCH logic, as such Part A claims are split into multiple records when the number of revenue center line items is greater than 45. In HAJI, these were merged into a single claim.
- The CDR includes claim types 61, 62, 63, 64, 80, and 81, which HAJI did not include.
- The CDR includes claim adjustments older than five years, which HAJI did not include.
- In Part A Claims, dates showing as '1970-01-01' in the rev_cntr_dt field should be treated as blank or null values
|