|
Horizontal Navigation Bar Page |
---|
|
| Panel |
---|
| Claims DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information |
---|
Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required | Refresh |
---|
CSAT | 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] | CSAT_TableLayout.xlsx2_TableLayout.xlsx---------------------------------- Table Layouts for Legacy Schemas: CSAT_Baseline_TableLayout.xlsx CSAT_Monthly_TableLayout.xlsx Baseline CSAT_Monthly | f CSAT Partition Info
| Monthly - Last Friday of every month | DDPS Part D | The source data for Part D claims is the Drug Data Processing System. Each monthly refresh generally includes all drug claims processed from the previous month (as shown by 'pde_proc_dt'). This schema contains all prescription drug claims covered under Medicare Part D. (SORN) | ddps_part_d | ddps_part_d | DDPS Part D Data Dictionary
| Monthly - By the 12th of each month or the following business day | NCH Part A |
| 9/1/2020 | Monthly | 9/25/2020 | Yes | DDPS Part D D Drug Data Processing System. This schema contains all prescription drug claims covered under Medicare Part D. (SORN)ddps_part_d | | 9/11/2020 | Monthly | 10/12/2020 | Yes | | The source data for Part A claims is the National Claims History (NCH) weekly extractsNational Claims History (NCH) weekly extracts. Each weekly refresh generally includes claims with an ‘nch_daily_proc_dt’ of Friday from the previous week. Part A claims include the Inpatient (IP) and Skilled Nursing Facility (SNF), Home Health (HHA), Hospice, and Outpatient | Extractsextracts. (SORN) | nch_part_a | PartATableLayout.xlsx2020_02- IPSNFtxt2020_02-Data Dictionary-txt2020_02-HHAtxt2020_02-txt9/10/2020 | Weekly | TBD Image Removed | 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 | | | 9/10/2020 | Weekly | TBD Image Removed | Yes | |
86218841 |
Horizontal Navigation Bar Page |
---|
title | Beneficiary and Provider Data |
---|
|
Panel |
---|
|
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 | The Assessment schema contains data the following data sets: | legacy_assessment_data | | QIES.HHA.Table-Reports.pdf
QIES.HOSPC.Table-Reports.pdf
QIES.IRF.Table-Reports.pdf
QIES.LTCH.Table-Reports.pdf
QIES.MDS.Table-Reports.pdf
zip
| Weekly - Thursdays | MSDRG | A Medicare Severity-Diagnosis Related Group (MSDRG) is a system of classifying a Medicare patient’s hospital stay into various groups in order to facilitate payment of services. Additional information on MSDRG Classifications and Software can be found on the public CMS site: https://www.cms.gov/medicare/medicare-fee-for-service-payment/acuteinpatientpps/ms-drg-classifications-and-software MSDRG Codes in the CDR are generated using the Java API version of the publicly available MSDRG Grouper software produced by CMS. The grouper is a software system that classifies a patient’s hospital stay into an established DRG based on the diagnosis and procedures provided to the patient. In the nch_part_a schema, you will find 3 tables containing all MSDRG Codes produced by the software, as well as the Part A Input data: claims_msdrg_output claims_msdrg_output_diagnosiscodeinfo claims_msdrg_output_procedurecodeinfo. MSDRG codes in the CDR are available on claims effective from July 2019 onwards. | nch_part_a | nch_part_a | MSDRG_DataCatalog.xlsx MSDRG_JavaAPI_Guide.pdf | Weekly - Thursdays | NCH Part B | The source data for Part B claims is the NCH weekly extracts. Each weekly refresh generally includes claims with an ‘nch_daily_proc_dt’ of Friday from the previous week. Part B claims include the Professional and the Durable Medical Equipment (DME) extracts. (SORN) | nch_part_b | nch_part_b | Data Dictionary - DMERC_CLM_REC.zip Data Dictionary - CARR_CLM_REC.zip
| Weekly - Thursdays | NCH MEDPAR | Medicare Provider Analysis & Review (MedPAR) is a system that consolidates Inpatient Hospital or Skilled Nursing Facility (SNF) claims data from the National Claims History (NCH) files into stay level records. MEDPAR records from January 2021 onward are available in the CDR. Historical backfill to include years 2017-2020 is planned. | medpar | medpar | medpar_data_dictionary_ForCatalog.xlsx | Quarterly |
Important Notes - The CDR follows National Claims History (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 Health Account Joint Information (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
- Recommended data catalog documentation for CDR contributors is located on the CDR Data Contribution Standard Operating Procedure page.
|
Horizontal Navigation Bar Page |
---|
| Clinical DataSchema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Refresh |
---|
Clinical End Stage Renal Disease Quality Reporting System (EQRS) | This schema will provide End-Stage Renal Disease (ESRD) Facility, Personnel, Patient and Clinical Data for CDR users. | clinical_eqrs | See Data Dictionary file | EQRS Data Dictionary | Monthly – Three months in arrears (e.g. extract for the closed clinical month of September is generated and loaded in early December – a few days after the submission deadline)
| Renal Data System (RDS) Extracts | End Stage Renal Disease Quality Reporting System (EQRS) data in the format of the RDS extract reports that were first provided from the Reliability and Maintainability Information System (REMIS) system and were later provided by the Network Coordinating Council (NCC). Each quarter data is loaded for all-time from EQRS. | rds_extracts | See Data Dictionary file | RDS Extracts Data Dictionary | Quarterly (January, April, July, October)
| Clinical Extracts | End Stage Renal Disease Quality Reporting System (EQRS) clinical data submitted by End-Stage Renal Disease (ESRD) care providers from a given closed clinical month in the format of the Clinical Extracts, historically delivered monthly by the EQRS Application Development Organization (ADO). | clinical_extracts | TBD | Clinical Extracts Data Dictionary | Weekly (loaded each weekend) | Care Compare Extracts | End Stage Renal Disease Quality Reporting System (EQRS) facility and patient data from a given quarter in the format of the Care Compare Extracts, historically delivered quarterly by the EQRS Application Development Organization (ADO). | care_compare_extracts
| TBD | Care Compare Extracts Data Dictionary | Quarterly (January, April, July, October) |
Important Notes |
Horizontal Navigation Bar Page |
---|
title | Beneficiary and Provider Data |
---|
| Beneficiary and Provider DataSchema | 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 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 | iQIES CDR Data Dictionary.xlsx | Monthly - 1st Business Day of the month | 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. 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 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 | beneficiary_data | | Weekly - Mondays | 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. CDR Hive tables point directly to PMI/SPP 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 | Provider_PMI_Data | Guides: Guide to Using the MDM PMI SPP NPI Profile Tables.docx Guide to Using the MDM Comprehensive PMI and SPP Tables.docx MDM 3rd Qtrly Training.pptx DDES Quarterly Training.pptx NPI Profile Data Dictionary: MDM 3.0 NPI Profile Delta Tables Dictionary.pdf MDM 3.0 NPI Profile Logical Hive Data Model.pdf MDM 3.0 NPI Profile Physical Hive Data Model.pdf MDM 2.0 NPI Tables Model Diagram.pdf PMISPP Data Dictionary: MDM 3.0 PMISPP Delta Tables Dictionary.pdf MDM 3.0 PMISPP Logical Hive Data Model.pdf MDM 3.0 PMISPP Physical Data Dictionary.pdf MDM table Partition information: provider pmi data Partition Info.xlsx Contact the Data & Analytics team for the password to unlock the documents. | Weekly - Mondays | 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 | quality_measures_darrt_qii | DARRT QII Data Definition.xls DARRT QII Model.pdf | Weekly - Wednesdays | 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 |
| quality_measures_hqr_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. 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 | 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: - legacy_hqr_opps_import
- legacy_hqr_opps
- legacy_hqr_cart
- legacy_hqr_cart_final
| quality_measures_hqr_char_abst | quality_measures_hqr_char_abst | quality measures hqr char abst Data Dictionary.xlsx hqr 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: - legacy_hqr_ipledge_app
- legacy_hqr_opledge_app
- legacy_hqr_nop_app
| provider_hqr_nop | provider_hqr_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 ADO. This schema is the replacement for the following legacy schemas: - legacy_hqr_validation_app
- legacy_hqr_oat_app
- legacy_hqr_cart_cdac
| quality_measures_hqr_val | quality_measures_hqr_val | quality measures hqr val.xlsx hqr val ERD.pdf | Daily | 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 HQR data in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. | 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 | Exceptions-to-CDR-Discovery-HQRPP.xlsx | 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 |
|
|
9/15/2020 | Monthly | 10/14/2020 | 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 | | | 9/14/2020 | Weekly | 9/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 | 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 | | 8/18/2020 | Quarterly | 11/18/2020 | 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) | | | 8/20/20 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_cart_final (CLDW) | | | 8/19/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_ehqr | | | 9/8/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_sdol_extfilapp | | 8/25/2020 | Quarterly | 11/30/2020 | Yes | legacy_hqr_qnol_extfilapp | | 8/25/2020 | Quarterly | 11/30/2020 | Yes | legacy_hqr_hai | | | 8/25/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_hcahps | | | 7/2/2020 | Quarterly | 10/14/2020 | Yes |
legacy_hqr_hcahps_final | | SDOL_CLDW_HCAHPS_view_logic.txt | 7/2/2020 | Quarterly | 10/14/2020 | Yes |
legacy_hqr_hvbp | | | 7/28/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_oat_app | | | 7/13/2020 | Quarterly | 10/28/2020 | Yes |
legacy_hqr_ipledge_app | | | 9/8/2020 | Monthly | 10/14/2020 | Yes |
legacy_hqr_nop_app | | | 8/10/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_opledge_app | | | 9/8/2020 | Monthly | 10/14/2020 | Yes |
legacy_hqr_opps | | | 8/5/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_opps_prs | | | 8/5/2020 | Quarterly | 11/11/2020 | Yes |
legacy_hqr_pprs_app | | | 8/5/2020 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_struct_msrs | | | 8/25/20 | Quarterly | 11/30/2020 | Yes |
legacy_hqr_validation_app | | 8/6/20 | Quarterly | 11/11/2020 | Yes | legacy_cldw_rpt_etl | | 6/29/2020 | Quarterly | 10/14/2020 | Yes | legacy_qnol_pch_app | | | 6/26/2020 | Quarterly | 10/14/2020 | Yes |
legacy_hqr_cart_cdac | | | 8/11/2020 | None | Never | Yes |
legacy_hqr_ci_rpt | | 8/21/2020 | Quarterly | 11/30/2020 | Yes | legacy_hqr_opps_import | | | 8/3/2020 | Quarterly | 11/11/2020 | Yes |
Miscellaneous data from the legacy CLDW and QNOL systems
legacy_cldw_prod_data_mgmt | Misc_prod_data_mgmt_TableLayout.xlsx | | | Quarterly | 11/30/2020 | Yes | legacy_qnol_user_admin | | 8/24/2020 | Quarterly | 11/30/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 | 9/3/2020 | Monthly | 10/5/2020 | Yes | NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | | NPPES dissemination information on CMS Website | 8/14/2020 | Quarterly | 11/25/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 | | | 9/14/2020 | Weekly | 9/22/2020 | Yes |
Legacy Provider | The provider schema contains data formerly found in the CASPER and QIES systems. | legacy_provider_data | | QIES.S&C.Table-Reports.pdf | 8/27/2020 | Monthly | 9/30/2020 | Yes |
QMARS | Quality Management and Review Systems (QMARS) is a system for case management and review. | qmars | | 8/27/2020 | Monthly | 9/30/2020 | 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 | | | 8/18/2020 | Monthly | 9/30/2020 | Yes |
SDDW | Contains Medicare Beneficiary and Provider enrollment data. (FAQ) | legacy_sddw_np_sdps | | | 9/3/2020 | Monthly | 10/5/2020 | Yes |
SDOL | Contains the beneficiary coverage data previously in the Oracle SDOL database. | legacy_sdol_np_sdps | | 9/9/2020 | Monthly | 10/5/2020 | Yes | 86218841
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
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. | health_plan | | | 9/3/2020 | Monthly | 10/5/2020 | Yes |
86218841
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
Public Data
Schema | 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 | | 8/21/2020 | Monthly | 9/30/2020 | 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 | 8/27/2020 | Monthly | 10/30/2020 | No |
ZIP | This table contains the ZIP Codes and other information for cities and towns in the US. | public_data | | 8/21/2020 | Monthly | 10/30/2020 | No | 86218841
Horizontal Navigation Bar Page |
---|
title | Planned Data Sources |
---|
|
Panel |
---|
| Planned Data SourcesSource Name | Description | Future CDR Hive Schema | CDR Legacy Data Sources | Data Dictionary and Supplemental Information | Targeted Date of Availability within CDR |
---|
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. |
hqr_prs | legacy_hqr_prs | | 12/15/2020 | |
86218841 |
Horizontal Navigation Bar Page |
---|
|
Panel |
---|
|
Archived Sources
Sources No Longer Being Refreshed
Source | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Final Refresh Date | DUA Required |
---|
HQR | legacy_hqr_public_reporting | | SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip | 3/2/2020 | Yes |
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 |
---|
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 | legacy_beneficiary_data_TableLayout.xlsx | 9/10/2020 | Monthly | 10/14/2020 | Yes | 86218841