- Created by Susan Pagan, last modified by Mohamad Bizri on Sep 11, 2020
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 181 Next »
CCSQ D&A HOME | CDR Data Catalog | Data Roadmap | Data Taxonomy | CCSQ Data Source Map | Archive
Error rendering macro 'excerpt-include'
No link could be created for 'Requesting & Getting Access'.
CDR Data Catalog
A data catalog is a collection of metadata, combined with data management and search tools, that helps analysts and other data users to find the data that they need, serves as an inventory of available data, and provides information to evaluate the fitness of data for intended uses.
This page provides the current schemas available in the CDR. All data will more closely reflect the source system. A roadmap for future schemas is available here: Data Roadmap. Refer to User Guides & References for an overview and guide to the data catalog.
If you have any questions regarding the information on this page or the CCSQ Data & Analytics Modernization effort overall, please send an email to HCQIS_Data@hcqis.org.
All data listed below is currently in the CDR; however, a user will only see what is defined by their DUA.
The data refresh dates from legacy oracle sources are published for awareness of data timeliness. If your organization requires data to be refreshed on a different timeline or cycle, please create a ServiceNow request for the “ADO-CDR-Support” and include details of your request including business justification, data source, requested refresh frequency, and requested refresh dates.
The "Most Recent Refresh" refers to the date the data was extracted from the legacy database. This data is typically available 24-48 hours after extraction. The "Next Refresh" date marks the last possible day the data will be available in the CDR.
Please note that due to ongoing modernization efforts, this document is a work in progress. Additional information will be added regularly. Some dates may change due to changing requirements or security mandates.
Claims Data
Schema | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Most Recent Refresh | Refresh Frequency | Next Refresh | DUA Required |
---|---|---|---|---|---|---|---|---|
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] | 9/1/2020 | Monthly | 9/21/2020 | 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 | 8/6/2020 | Monthly | 9/12/2020 | Yes | ||
NCH Part A | 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 | 9/10/2020 | Weekly | 9/17/2020 | Yes | ||
NCH Part B | 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 | 9/17/2020 | Yes |
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 | 8/18/2020 | Monthly | 9/16/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/8/2020 | Weekly | 9/14/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 | 9/22/2020 | Yes | ||||
legacy_hqr_cart_final (CLDW) | 8/19/2020 | Quarterly | 9/22/2020 | Yes | ||||
legacy_hqr_ehqr | 9/8/2020 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_sdol_extfilapp | 8/25/2020 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_qnol_extfilapp | 8/25/2020 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_hai | 8/25/2020 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_hcahps | 7/2/2020 | Quarterly | 10/7/2020 | Yes | ||||
legacy_hqr_hcahps_final | 7/2/2020 | Quarterly | 10/7/2020 | Yes | ||||
legacy_hqr_hvbp | 7/28/2020 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_oat_app | 7/13/2020 | Quarterly | 10/22/2020 | Yes | ||||
legacy_hqr_ipledge_app | 9/8/2020 | Monthly | 10/14/2020 | Yes | ||||
legacy_hqr_nop_app | 8/10/2020 | Quarterly | 9/22/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 | 9/22/2020 | Yes | ||||
legacy_hqr_pprs_app | 8/5/2020 | Quarterly | 9/22/2020 | Yes | ||||
legacy_hqr_struct_msrs | 8/25/20 | Quarterly | 11/11/2020 | Yes | ||||
legacy_hqr_validation_app | 8/6/20 | Quarterly | 10/28/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/11/2020 | Yes | ||||
legacy_hqr_opps_import | 8/3/2020 | Quarterly | 9/30/2020 | Yes | ||||
Miscellaneous data from the legacy CLDW and QNOL systems | legacy_cldw_prod_data_mgmt | Misc_prod_data_mgmt_TableLayout.xlsx | 8/24/2020 | Quarterly | 11/11/2020 | Yes | ||
legacy_qnol_user_admin | 8/24/2020 | Quarterly | 11/11/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/14/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/8/2020 | Weekly | 9/14/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 | For information about beneficiary tables in SDDW: EDB_data_dictionary.doc | 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 |
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 |
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 | 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 |
Planned Data Sources
Source 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 |
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 | 8/10/2020 | Monthly | 9/16/2020 | Yes |
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.
- No labels