Horizontal Navigation Bar Page |
---|
title | Beneficiary and Provider Data |
---|
|
Beneficiary and Provider Data |
Horizontal Navigation Bar Page |
---|
title | Beneficiary and Provider Data |
---|
|
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)
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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction. | assessment_iqies | assessment_iqies_TableLayout.xlsx
| Monthly - 1st Business Day of the monthYes | Provider Schema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Refresh |
---|
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 IQIES data in the CDR includes |
provider data from CASPER and iQIES_CMN schemas. This assessment data for HHA, MDS, LTCH, IRF, and Hospice schemas. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction. |
providerprovider_TableLayout.xlsx____20220405QIES_S&C_Code_Tables_Data_Dictionary 09152020.xls | Monthly - 1st Business Day of the month |
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. CDR Hive tables point directly to BIC data in the CMS Enterprise Data Lake (EDL). This data is refreshed each weekend in the CMS EDL and it is made available by Monday in the CDR. CDR contains only a Subset of tables listed in BIC Data Dictionary. | beneficiary_data | | | Weekly - MondaysYes | 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 CDRProvider (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. This data is extracted from iQIES system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction. | provider_iqies | provider_iqies | iQIES CDR Data Dictionary.xlsx iQIES S&C Code Tables Data Dictionary.xls | Monthly - 1st Business Day of the month
|
Beneficiary | This source contains beneficiary demographics, entitlement, enrollment, premium, health status and other coverage information from the Beneficiary Information on the Cloud (BIC) source. CDR Hive tables point directly to |
PMI/SPP BIC data in the CMS Enterprise Data Lake (EDL). This data is refreshed each weekend in the CMS EDL and it is made available by Monday in the CDR. |
provider_pmi_data | | | Weekly - MondaysYes | DARRT QII | This source includes Quality Improvement Initiative (QII) Data from the Deliverable Administration Review Repository Tool (DARRT). A QII is any formal plan designed to assist a provider(s) and/or practitioner(s) in identifying the root cause of a confirmed quality of care concern, develop a framework in which to address the concern and improve a process or system. QIIs may consist of system-wide (organization-based) and/or non-system-wide (practitioner-based) activities. QII initiation and tracking are performed in DARRT and QII data in the CDR are refreshed every Wednesday at 1:00 AM ET. | quality_measures_darrt_qii | | | Weekly - WednesdaysYes | Hospital Quality Reporting (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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. | quality_measures_hqr_pub_report | | | Quarterly | | 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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data This schema is the replacement for the following legacy schemas:legacystruct_msrslegacy_qnol_pch_applegacy_hqr_asclegacy_hqr_hcahpslegacy_hqr_hcahps_finallegacy_cldw_rpt_etllegacy_hqr_pprs_applegacy_opps_prsdata_form | quality_measures_hqr_data_form_08312021.xlsx
N/A | Daily | 1100 UTC Daily | Yes | 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. CDR pub_report.xlsx | Quarterly |
Hospital Quality Reporting (HQR) | 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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. |
The following measures are included in this data set:OP-2, OP-3, OP-3a, OP-3b, OP-3c, OP-23, OP-18a, OP-18b, OP-18c, OP-18d, and SEP-1 and Bundle Data
This This schema is the replacement for the following legacy schemas: |
_opps_import- _struct_msrs
- legacy_qnol_pch_app
- legacy_hqr_
|
oppscartcartqualitymeasureshqrchar_abstqualitymeasureshqrcharabstTableLayout.xlsxchar_abst_DataDictionary_08312021.xlsxhqr_char_abst_iqr_ERD_04092021.pdf
hqr_char_abst_oqr_ERD_04092021.pdf
N/A | Daily | 1000 UTC Daily | Yes | 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 will describe the programs, whether a given hospital is participating, and the dateThis schema is the replacement for the following legacy schemas:
data_form | NA | quality_measure_hqr_data_forms.pdf
| Daily |
Hospital Quality Reporting (HQR) | 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. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. |
The following measures are included in this data set: OP-2, OP-3, OP-3a, OP-3b, OP-3c, OP-23, OP-18a, OP-18b, OP-18c, OP-18d, and SEP-1 and Bundle Data This schema is the replacement for the following legacy schemas: |
ipledgeapp- import
- legacy_hqr_opps
- legacy_
|
opledgeappnopappproviderquality_measures_hqr_char_ |
nopprovidernop_TableLayoutN/A | Daily | 1000 UTC Daily | Yes | 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’s Clinical Warehouse via the Hospital Quality Reporting (HQR) system, can be reproduced by a trained abstractor using a standardized processhqr char abst iqr ERD.pdf hqr char abst oqr ERD.pdf | Daily |
Hospital Quality Reporting (HQR) | 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 will describe the programs, whether a given hospital is participating, and the date. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy schemas: |
validationoatcartcdacqualitymeasures_valquality_measuresval_TableLayout.xlsx | N/A | Daily | 1000 UTC Daily | Yes | nop |
| Daily |
Hospital Quality Reporting (HQR) | 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’s Clinical Warehouse via the Hospital Quality Reporting (HQR) system, can be reproduced by a trained abstractor using a standardized process. CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR |
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
SAFE_USE_OF_OPIOIDS
CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy |
schemaehqrquality_measures_hqr_ecqmData Dictionary_- validation_app
- legacy_hqr_oat_app
- legacy_hqr_cart_cdac
| quality_measures_hqr_ |
ecqm_TableLayout.xlsxecqm_20220908_N/A1000 UTC Daily | Yes | This source contains Active Security Administrators /Officials for Hospital Hospital Quality Reporting (HQR) | The HQR system evaluates Medicare claims to determine which claims are eligible for a given quarter for each required measure set for the IQR and OQR Programs. These tables provide the eligible claim counts for the IQR and OQR programs, broken out by provider, measure set, month, and year. CDR Hive tables point directly to |
Hospital Quality Reporting () data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. |
This schema is the replacement for the following legacy schema:
resource_hqr_sec_admin | | N/A | Daily | 1000 UTC Daily | 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. PRS data is extracted from the HQR source database and the "Most Recent Refresh" column indicates the date at which the data was extracted. The refreshed data is available each Monday morning however it is typically extracted 1-2 business days earlier. 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 | | PRS Waiver Type Codes
Weekly - ThursdaysYes | NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | | NPPES dissemination information on CMS Website | | Quarterly | | No |
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. This data is extracted from QMARS system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction. | qmars | | Monthly - 5th of the month or the next business dayYes | QMARS Next Generation (NG) | The ‘healthcare_service_qmars_ng’ schema contains a set of initial tables that are included from the QMARS Next Generation (NG) application. As the QMARS NG application continues development, additional tables will be added to the CDR. The initial tables include QMARS appeals (Referrals - Fee For Service) data that is originally submitted in FHIR JSON format and then made available in Hive. CDR Hive tables point directly to QMARS NG data in the QMARS cloud. The data refresh frequency is controlled by the QMARS ADO. | healthcare_service_qmars_ng | | | N/A | Daily | 0400 UTC Daily | 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. The QPP team provides an extract of the UDS each month. The "Most Recent Refresh" column reflects the date at which the extract was made available in the CDR however the extract may be several days older. | quality_measures_qpp_uds | | | Weekly - ThursdaysYes | 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 - ENROLLMENT DATA BASE MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees) | CRIS | legacy_cris | NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC PDE - PART D - PRESCRIPTION DRUG EVENT DATA
EDB - ENROLLMENT DATA BASE MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees) | Mandatory: EDB - ENROLLMENT DATA BASE MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION (for part D enrollees) 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 |
DARRT QII | quality_measures_darrt_qii | QIO - QUALITY IMPROVEMENT ORGANIZATION (QIO) DELIVERABLE DATA (PATRIOT AND DDST) | HQR
quality_measures_hqr_pub_report | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | IPT - INPATIENT OPT - OUTPATIENT | quality_measures_hqr_data_form | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | CAHPS - CONSUMER ASSESSMENT OF HEALTH PLAN STUDY SURVEY OPT - OUTPATIENT IPT - INPATIENT |
quality_measures_hqr_char_abst | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | CDAC - CLINICAL DATA ABSTRACTION CENTER IPT - INPATIENT OPT - OUTPATIENT |
provider_hqr_nop | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | IPT - INPATIENT OPT - OUTPATIENT |
quality_measures_hqr_val | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | CDAC - CLINICAL DATA ABSTRACTION CENTER IPT - INPATIENT OPT - OUTPATIENT |
quality_measures_hqr_ecqm | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | IPT - INPATIENT |
resource_hqr_sec_admin | N/A | quality_measures_hqr_hvbp | HQR - HOSPITAL QUALITY REPORTING, OTHER-OTHER (SPECIFY): HQR, HQCIS | IPT - INPATIENT |
PRS | resource_hqr_prs | PRS - PROGRAM RESOURCE SYSTEM DATA | resource_hqr_prs_supplemental | PRS - PROGRAM RESOURCE SYSTEM DATA | 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 - ENROLLMENT DATA BASE MBD - ENROLLMENT, ENTITLEMENT AND DEMOGRAPHIC INFORMATION 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 |
Important Notes
Return to Top
Horizontal Navigation Bar Page |
---|
|
| quality_measures_hqr_claims | quality_measures_hqr_claims | OQR Eligible Claims Counts Data Dictionary.xlsx quality_measures_hqr_claims.xlsx |
| Hospital Quality Reporting (HQR) | This schema houses data for hqr exceptions, exceptions reasons, and exception types. | hqr_exceptions | reporting_exception, exception_type, reason | NA | The refresh will occur on demand (initiated by the schema owner when a change is made) | Hospital Quality Reporting (HQR) | 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 SAFE_USE_OF_OPIOIDS
CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy schema: | quality_measures_hqr_ecqm | quality_measures_hqr_ecqm | quality_measures_hqr_ecqm.xlsx
| Daily | Hospital Quality Reporting (HQR) | The Hospital Quality Reporting (HQR) system annually calculates and reports End-of-Life (EOL) measure performance results for a given fiscal year for the PCH program. These tables provide the facility-level performance rate and supporting details as well as patient-level summary data. CDR Hive tables point directly to HQR data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. | quality_measures_hqr_pch | | PCH EOL Data Dictionary.xlsx |
| Hospital Quality Reporting (HQR) | This source contains Active Security Administrators /Officials for Hospital Quality Reporting (HQR). CDR Hive tables point directly to Hospital Quality Reporting (HQR) data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy schema: | resource_hqr_sec_admin |
| resource_hqr_sec_admin.pdf | Daily | Hospital Quality Reporting (HQR) Hospital Value Based Purchasing (HVBP) | Hospital Value Based Purchasing (HVBP) Summary Data, corresponds with the data in the 542 report. | quality_measures_hqr_hvbp | NA | HQR HVBP Data Dictionary | Annually, beginning of August | Program Resource System 2.0 (PRS 2.0) | Program Resource System 2.0 (PRS 2.0) is a repository of demographic information for hospital providers in the Centers for Medicare & Medicaid Services (CMS), Survey and Certification System (CASPER), Quality Improvement and Evaluation System (QIES), and Provider Enrollment, Chain and Ownership System (PECOS). PRS 2.0 assists Quality Improvement Organizations (QIOs) and Program Support Contractors in maintaining CMS Programs. | ess_prs | NA | PRS2-CDR-Data-Dictionary.xlsx | Weekly – but possibly daily based on user validation | Program Resource System 1.0 (PRS 1.0) | Program Resource System 1.0 (PRS 1.0) 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. PRS data is extracted from the HQR source database and the "Most Recent Refresh" column indicates the date at which the data was extracted. The refreshed data is available each Monday morning however it is typically extracted 1-2 business days earlier. 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 | resource_hqr_prs resource_hqr_prs_supplemental | PRS Waiver Type Codes | Weekly - Thursdays | Medicare Current Beneficiary Survey (MCBS) survey data | The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The MCBS Survey File contains survey collected data augmented with administrative data to allow for analysis regarding the beneficiaries’ health status, access to health care, satisfaction with health care and usual source of care. Additional information about MCBS can be found at https://www.cms.gov/data-research/research/medicare-current-beneficiary-survey. | mcbs_survey | Pending Instead of including multiple years of MCBS results per table, each year has its own set of tables suffixed with the year number (eg. mcbs_survey.accesscr_2021) | mcbs_survey_data_dictionary.xlsx This data dictionary was compiled using the 2021 MCBS Survey File and Cost Supplement File codebooks. Codebooks for additional years are available at https://www.cms.gov/data-research/research/medicare-current-beneficiary-survey/data-documentation-codebooks | Annual | Medicare Current Beneficiary Survey (MCBS) cost supplement | The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The MCBS Cost Supplement links Medicare claims to survey-reported events and provides complete expenditure and source of payment data on all health care services, including those not covered by Medicare reported by our survey beneficiaries. Additional information about MCBS can be found at https://www.cms.gov/data-research/research/medicare-current-beneficiary-survey. | mcbs_cost | Pending Instead of including multiple years of MCBS results per table, each year has its own set of tables suffixed with the year number (eg. mcbs_cost.csevwgts_2021) | mcbs_cost_data_dictionary.xlsx This data dictionary was compiled using the 2021 MCBS Survey File and Cost Supplement File codebooks. Codebooks for additional years are available at https://www.cms.gov/data-research/research/medicare-current-beneficiary-survey/data-documentation-codebooks. | Annual | Medicare Current Beneficiary Survey (MCBS) beneficiary crosswalk | The Medicare Current Beneficiary Survey (MCBS) is a continuous, in-person, longitudinal survey of a representative national sample of the Medicare population. The beneficiary crosswalk maps MCBS BASE ID values to HICN and BENE ID values, enabling joins on beneficiaries between MCBS and other datasets. Additional information about MCBS can be found at https://www.cms.gov/data-research/research/medicare-current-beneficiary-survey. | mcbs_crosswalk | Pending Instead of including multiple years of MCBS results per table, each year has its own table suffixed with the year number (eg. mcbs_crosswalk.mcbs_bas_hic_xwalk_2021) | mcbs_crosswalk_data_dictionary.xlsx | Annual | NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | nppes | NPPES dissemination information on CMS website | Quarterly | 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. This data is extracted from QMARS system and the "Most Recent Refresh" column reflects the date at which the data was extracted. The data is generally made available in the CDR within 2 business days of extraction. | qmars | qmars |
| Monthly - 5th of the month or the next business day | QMARS Next Generation (NG) | The ‘healthcare_service_qmars_ng’ schema contains a set of initial tables that are included from the QMARS Next Generation (NG) application. As the QMARS NG application continues development, additional tables will be added to the CDR. The initial tables include QMARS appeals (Referrals - Fee For Service) data that is originally submitted in FHIR JSON format and then made available in Hive. CDR Hive tables point directly to QMARS NG data in the QMARS cloud. The data refresh frequency is controlled by the QMARS ADO. | healthcare_service_qmars_ng | healthcare_service_qmars_ng | QMARS NG Livanta Data Dictionary.docx QMARS NG Kepro Data Dictionary.docx | Daily | 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. The QPP team provides an extract of the UDS each month. The "Most Recent Refresh" column reflects the date at which the extract was made available in the CDR however the extract may be several days older. | quality_measures_qpp_uds | quality_measures_qpp_uds | Full UDS Data Dictionary.pdf UDS ER Diagram.jpg QPP Universal Dataset (UDS) User Guide.pdf Querying UDS For Fun.pdf UDS UDSDM Deep Schema Walk.pdf | Weekly - Thursdays | CRIS |
| legacy_cris |
|
|
| SDDW |
| legacy_sddw_np_sdps |
|
|
| SDOL |
| legacy_sdol_np_sdps |
Panel |
---|
|
|
Tabs Container |
---|
|
Tabs Page |
---|
|
Health Plan Data
Schema | 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. HPMS provides an updated file on the first business day of each month. The data is generally available in the CDR by the 5th of each month. | health_plan | | | Weekly - FridaysYes | Tabs Page |
---|
title | Mapping DUA to Health Plan Data |
---|
|
Mapping DUA to Health Plan Data
Schema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|
HPMS | health_plan | HPMS - HEALTH PLAN MGMT SYS | N/AImportant Notes
- Recommended data catalog documentation for CDR contributors is located on
the CDR Contributor Documentation Requirements PageReturn to Top