- Created by Susan Pagan, last modified by Kyle Webb on Oct 11, 2022
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 886 Next »
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 a guide to the data catalog.
You may need to download documents to see the content if they do not display well.
If you have any technical questions regarding the information on this page or the CCSQ Data & Analytics Modernization effort overall, please send an email to servicecentersos@cms.hhs.gov, routing to ADO-QualityNet Analytics-Support.
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 CDR sources are published for awareness of data timeliness. If your organization requires data to be refreshed on a different timeline or cycle, please submit a Request Form and include details of your request including business justification, data source, requested refresh frequency, and requested refresh dates.
Details of the refresh are included in the description of each source. 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] | CSAT_5_TableLayout_08312021.xlsx CSAT_2_TableLayout_08312021.xlsx ---------------------------------- Table Layouts for Legacy Schemas: | | Monthly |
| Yes | |
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 |
| Monthly |
| Yes | ||
NCH Part A | The source data for Part A claims is the National 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 extracts. (SORN) | nch_part_a | Weekly |
| Yes | |||
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 | Weekly |
| Yes |
Mapping DUA to Claims Data
Schema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|---|---|---|
CSAT | csat_5 csat_2 ----------------------- Legacy CSAT: csat_201908_baseline csat_201909 [monthly] | NCH-SS NATIONAL CLAIMS HISTORY - 100% STATE SPECIFIC 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 Plus one of the following for Prescription Drug Claims: DDPS - DRUG DATA PROCESSING SYSTEM |
DDPS Part D | ddps_part_d | DDPS - DRUG DATA PROCESSING SYSTEM | PDE - PART D - PRESCRIPTION DRUG EVENT DATA |
NCH Part A | nch_part_a | NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES | FFSCLM - FFS CLAIMS DATA |
NCH Part B | nch_part_b | NCH - NCH - MEDICARE INFORMATION ON PART A AND PART B SERVICES | FFSCLM - FFS CLAIMS 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 |
| Monthly | | 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. 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 |
| Monthly |
| 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 |
| Yes | ||
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 | Guides: Guide to Using the MDM PMI_SPP_NPI Profile Tables_V6_F_04.26.2022.docx Guide to Using the MDM Comprehensive PMI and SPP Tables_V2_F_7.30.2020.docx DDES Quarterly Training February 2021.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 Password for all documents above: royalrabbit |
| Weekly |
| Yes | |
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 |
| Yes | ||
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 in the HQR cloud. The data refresh frequency is controlled by the HQR ADO. This schema is the replacement for the following legacy schemas:
| quality_measures_hqr_data_form | 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 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:
| quality_measures_hqr_char_abst | 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 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:
| provider_hqr_nop | N/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 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:
| quality_measures_hqr_val | N/A | Daily | 1000 UTC Daily | Yes | |||
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 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 | Data Dictionary_quality_measures_hqr_ecqm_20220908_.xlsx | N/A | Daily | 1000 UTC Daily | Yes | ||
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 | 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 |
| Weekly | Yes | |||
NPPES | The National Plan and Provider Enumeration System contains provider NPIs, names, and location information. | nppes | NPPES dissemination information on CMS Website |
| Quarterly |
| No | |
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 |
| Yes | |||
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 |
| Yes |
Mapping DUA to Beneficiary and Provider Data
Schema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|---|---|---|
Assessment (iQIES) | assessment_iqies | IQIES - Internet-based Quality Improvement and Evaluation System | QIESWB - QUALITY IMPROVEMENT EVALUATION SYSTEM (QIES) WORKBENCH |
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 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 Plus one of the following for Prescription Drug Claims: DDPS - DRUG DATA PROCESSING SYSTEM |
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 |
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 Plus one of the following for Prescription Drug Claims: DDPS - DRUG DATA PROCESSING SYSTEM |
SDOL | legacy_sdol_np_sdps | SDPS - STANDARD DATA PROCESSING SYSTEM | EDB - ENROLLMENT DATA BASE |
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 |
| Yes |
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/A |
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 |
| Annually |
| No | ||
FDA | The FDA data contains packaging and product information for FDA approved drugs. | public_data |
| Monthly |
| No | ||
FDB | The First Data Bank (FDB) drug list includes drug data available from the legacy data center and is no longer refreshed. | public_data | 8/19/2020 | None | Never | No | ||
Nursing Home Compare | This is the official data for the Nursing Home Compare website. | compare_nursing_home |
| Monthly |
| No | ||
FIPS | These tables contain FIPS county and state codes. | public_data | 5/5/2021 | Annually | 5/4/2022 | No | ||
ZIP | This table contains the ZIP Codes and other information for cities and towns in the US. | public_data |
| Monthly |
| No | ||
Reference Codes | This schema contains various reference codes such as ICD-10, HCPCS, and others. | resource_ref_codes | ASC HCPCS: | Annual (may update quarterly if new code updates) | Varying dates based on Codes ICD codes: 10/1/2022 HCPCS codes: Condition, DRG, Occurrence, Primary Payer, Revenue Center, Span, Value Codes: Updated when ICD or HCPCS updates occur | No |
Mapping DUA to Public Data
Schema | CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|---|---|---|
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 |
---|---|---|---|---|---|
HVBP | This schema provides data and results from the Hospital Value based Purchasing (HVBP) Program. | quality_measures_hqr_hvbp |
| Q4 2022 | |
EQRS Clinical Data | This schema will provide ESRD Facility, Personnel, Patient and Clinical Data for CDR users. | clinical_eqrs | N/A | Q3 2022 | |
DDPS TAP Files | Drug Data Processing System (DDPS) contributes TAP files which come from a weekly report that is created of Part D plan-submitted prescription drug events (PDEs) that have passed the DDPS editing process as of a specific moment (TAP) in time. There are both Proprietary and Non-Proprietary TAP files. Consumers will need to specify which type they require upon completion of their onboarding request. | ddps_proprietary_tap ddps_non_proprietary_tap | N/A | Q4 2022 |
Mapping DUA to Planned Data Sources
Source Name | Future CDR Hive Schema | Preferred DUA Entry | Acceptable DUA Entry |
---|---|---|---|
DDPS TAP Files | ddps_proprietary_tap | PEDP: Part D Proprietary TAP File |
Legacy Sources
Sources No Longer Being Refreshed
Source | Description | CDR Hive Schema | CDR Table Layouts | Data Dictionaries and Supplemental Information | Final Refresh Date | DUA Required |
---|---|---|---|---|---|---|
HQR - Legacy | legacy_hqr_public_reporting | SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip | 3/2/2020 | Yes | ||
HQR - Legacy | legacy_hqr_asc | 4/6/2020 | Yes | |||
HQR - Legacy | legacy_hqr_hcahps | 10/21/2020 | Yes | |||
HQR - Legacy | legacy_hqr_hcahps_final | 10/20/2020 | Yes | |||
HQR - Legacy | legacy_qnol_pch_app | 12/8/2020 | Yes | |||
HQR - Legacy | legacy_hqr_struct_msrs | 12/4/2020 | Yes | |||
HQR - Legacy | legacy_cldw_rpt_etl | 12/1/2020 | Yes | |||
HQR - Legacy | legacy_hqr_pprs_app | 11/10/2020 | Yes | |||
HQR - Legacy | legacy_hqr_opps_prs | 12/3/2020 | Yes | |||
HQR - Legacy | legacy_hqr_sdol_extfilapp | 12/7/2020 | Yes | |||
HQR - Legacy | legacy_hqr_qnol_extfilapp | 12/7/2020 | Yes | |||
HQR - Legacy | legacy_hqr_hai | 12/4/2020 | Yes | |||
HQR - Legacy | legacy_hqr_cart(QNOL) | 12/3/2020 | Yes | |||
HQR - Legacy | legacy_hqr_cart_final (CLDW) | 12/3/2020 | Yes | |||
HQR - Legacy | legacy_hqr_ehqr | 11/16/2020 | Yes | |||
HQR - Legacy | legacy_hqr_oat_app | 12/2/2020 | Yes | |||
HQR - Legacy | legacy_hqr_ipledge_app | 12/9/2020 | Yes | |||
HQR - Legacy | legacy_hqr_nop_app | 12/10/2020 | Yes | |||
HQR - Legacy | legacy_hqr_opledge_app | 12/9/2020 | Yes | |||
HQR - Legacy | legacy_hqr_opps | 12/4/2020 | Yes | |||
HQR - Legacy | legacy_hqr_validation_app | 12/7/2020 | Yes | |||
HQR - Legacy | legacy_hqr_cart_cdac | 8/11/2020 | Yes | |||
HQR - Legacy | legacy_hqr_ci_rpt | 12/10/2020 | Yes | |||
HQR - Legacy | legacy_hqr_opps_import | 12/10/2020 | Yes | |||
HQR - Legacy | legacy_cldw_prod_data_mgmt | Misc_prod_data_mgmt_TableLayout.xlsx | 12/9/2020 | Yes | ||
HQR - Legacy | legacy_qnol_user_admin | 12/9/2020 | Yes | |||
HQR - Legacy | legacy_sdol_ifmc_common | 3/6/2020 | Yes | |||
HQR - Legacy | These schema are copies of the former HQR Oracle databases and applications in SDOL, QNOL, and CLDW. | legacy_hqr_hvbp | 10/19/2020 | Yes | ||
Program Resource System (PRS) | legacy_hqr_prs | HQR_PRS_TableLayout.xlsx | 12/8/2020 | Yes | ||
QIES Legacy (Provider) | legacy_provider_data | QIES.S&C.Table-Reports.pdf | 8/27/2020 | Yes | ||
QIES Legacy (Assessment) | legacy_assessment_data | 9/15/2020 | Yes | |||
Beneficiary | legacy_beneficiary_data | legacy_beneficiary_data_TableLayout.xlsx | EDB_data_dictionary.doc | 12/3/2020 | Yes | |
SDDW | legacy_sddw_np_sdps | 12/8/2020 | Yes | |||
SDOL | legacy_sdol_np_sdps | 12/8/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 | 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 |
---|---|---|---|---|---|---|---|---|
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
- Recommended data catalog documentation for CDR contributors is located on the CDR Contributor Documentation Requirements Page
- No labels