Data

Versions Compared

Old Version 157

changes.mady.by.user Mohamad Bizri

Saved on

compared with

New Version 158

changes.mady.by.user Mohamad Bizri

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt Include
Data Resources
Data Resources
nopaneltrue

Panel
borderWidth0

CCSQ D&A HOME | CDR Data Catalog | Data Roadmap | Data Taxonomy | CCSQ Data Source Map | Archive




Excerpt Include
Requesting & Getting Access
Requesting & Getting Access
nopaneltrue

Panel
borderWidth0

Livesearch
spaceKeyDATA
typepage


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.


Note

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.



Excerpt Include
CCSQ Data & Analytics
CCSQ Data & Analytics
nopaneltrue

Anchor
Return to Top
Return to Top

Horizontal Navigation Bar
idCDR Data Catalog


Horizontal Navigation Bar Page
titleClaims Data


Panel
borderWidth1 px

Claims Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationMost Recent RefreshRefresh FrequencyNext RefreshDUA Required
CSATThe 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

-----------------------

Available until 9/15/2020:

csat_201908_baseline

csat_201909 [monthly]

CSAT_5_TableLayout.xlsx

CSAT_2_TableLayout.xlsx

----------------------------------

Table Layouts for Old Schemas:

CSAT_Baseline_TableLayout.xlsx

CSAT_Monthly_TableLayout.xlsx

CSAT Data Dictionary-CMS CVP-7.15.2020-v1.1.xlsx

CSAT_Partition_Info.xlsx

8/21/2020Monthly89/21/2020Yes
DDPS Part DThe 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

Part_D_TableLayout.xlsx


8/3/2020Monthly8/26/2020Yes
NCH Part AThe 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

Part_A_TableLayout.xlsx

2020_02-Data Dictionary - IP_SNF_CLM_REC.txt

2020_02-Data Dictionary-OP_CLM_REC.txt

2020_02-Data Dictionary-HHA_CLM_REC.txt

2020_02-Data Dictionary-HOSPC_CLM_REC.txt

8/27/2020Weekly9/3/2020Yes
NCH Part BThe 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

Part_B_TableLayout.xlsx

2020_02-Data Dictionary-DMERC_CLM_REC.txt

2020_02-Data Dictionary-CARR_CLM_REC.txt

8/27/2020Weekly9/3/2020Yes


Return to Top


Horizontal Navigation Bar Page
titleBeneficiary and Provider Data


Panel
borderWidth1 px

Beneficiary and Provider Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationMost Recent RefreshRefresh FrequencyNext RefreshDUA Required
Assessment

The Assessment schema contains data the following data sets: 

legacy_assessment_data

Assessment_TableLayout.xlsx

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


8/18/2020Monthly9/16/2020Yes
BeneficiaryThis 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

beneficiary_data_TableLayout.xlsx

bic-data-lake-data-dictionary.pdf

beneficiary_data_Partition_Info.xlsx

8/25/2020Weekly8/31/2020Yes
CRISThe 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

CRIS_TableLayout.xlsx

CRIS User Guide.pdf

1/13/2020NoneNeverYes
HQRPublic 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

quality_measures_hqr_pub_report_TableLayout.xlsx



8/18/2020Quarterly11/18/2020Yes
HQR - Legacy


These schema are copies of the former HQR Oracle databases and applications in SDOL, QNOL, and CLDW. legacy_hqr_asc

HQR_ASC_TableLayout.xlsx

HQR_QNOL_ASC_APP_view_logic.zip

4/6/2020NoneNeverYes
legacy_hqr_cart(QNOL)

HQR_CART_TableLayout.xlsx

HQR_QNOL_CART_view_logic.zip

8/20/20

Quarterly

9/22/2020Yes
legacy_hqr_cart_final (CLDW)

HQR_CART_Final_TableLayout.xlsx

SDOL_CLDW_CART_view_logic.zip

8/19/2020Quarterly9/22/2020Yes
legacy_hqr_ehqr

HQR_EHQR_TableLayout.xlsx

HQR_QNOL_EHQR_view_logic.zip

legacy_hqr_ehqr_Partition_Info.xlsx

6/2/2020Quarterly9/16/2020Yes
legacy_hqr_sdol_extfilapp

HQR_SDOL_ext_fil_app_TableLayout.xlsx


8/25/2020Quarterly11/11/2020Yes
legacy_hqr_qnol_extfilapp

HQR_QNOL_ext_fil_app_TableLayout.xlsx


8/25/2020Quarterly11/11/2020Yes
legacy_hqr_hai

HQR_HAI_TableLayout.xlsx

SDOL_HAI_APP_view_logic.zip

8/25/2020Quarterly11/11/2020Yes
legacy_hqr_hcahps

HQR_HCAHPS_QNOL_TableLayout.xlsx

HQR_QNOL_HCAHPS_view_logic.zip

7/2/2020Quarterly10/7/2020Yes
legacy_hqr_hcahps_final

HQR_HCAHPS_CLDW_TableLayout.xlsx

SDOL_CLDW_HCAHPS_view_logic.txt

7/2/2020Quarterly10/7/2020Yes
legacy_hqr_hvbp

HQR_HVBP_TableLayout.xlsx

HQR_QNOL_HVBP_view_logic.zip

7/28/2020Quarterly11/11/2020Yes
legacy_hqr_oat_app

HQR_oat_app_TableLayout.xlsx

HQR_QNOL_OAT_APP_view_logic.txt

7/13/2020Quarterly10/22/2020Yes
legacy_hqr_ipledge_app

QNOL_ipledge_app_TableLayout.xlsx

HQR_QNOL_IPLEDGE_APP_view_logic.txt

8/7/2020Monthly9/16/2020Yes
legacy_hqr_nop_app

HQR_nop_app_TableLayout.xlsx

HQR_QNOL_NOP_APP_view_logic.zip

8/10/2020Quarterly9/22/2020Yes
legacy_hqr_opledge_app

QNOL_opledge_app_TableLayout.xlsx

HQR_QNOL_OPLEDGE_APP_view_logic.txt

8/10/2020Monthly9/16/2020Yes
legacy_hqr_opps

HQR_OPPS_TableLayout.xlsx

SDOL_CLDW_OPPS_WHS_view_logic.zip

8/5/2020Quarterly11/11/2020Yes
legacy_hqr_opps_prs

HQR_opps_prs_TableLayout.xlsx

SDOL_OPPS_PRS_view_logic.txt

8/5/2020Quarterly9/22/2020Yes
legacy_hqr_pprs_app

HQR_pprs_app_TableLayout.xlsx

HQR_QNOL_PPRS_APP_view_logic.txt

8/5/2020Quarterly9/22/2020Yes
legacy_hqr_struct_msrs

HQR_struct_msrs_TableLayout.xlsx

HQR_QNOL_STRUCT_MSRS_APP_view_logic.zip

8/25/20Quarterly11/11/2020Yes
legacy_hqr_validation_app

HQR_validation_app_TableLayout.xlsx


8/6/20Quarterly10/28/2020Yes
legacy_cldw_rpt_etl

HQR_rpt_etl_TableLayout.xlsx


6/29/2020Quarterly10/14/2020Yes
legacy_qnol_pch_app

HQR_pch_app_TableLayout.xlsx

HQR_QNOL_PCH_APP_view_logic.txt

6/26/2020Quarterly10/14/2020Yes
legacy_hqr_cart_cdac

HQR_CART_CDAC_TableLayout.xlsx

SDOL_CLDW_CART_CDAC_view_logic.txt

8/11/2020NoneNeverYes
legacy_hqr_ci_rpt

HQR_ci_rpt_TableLayout.xlsx


8/21/2020Quarterly9/2/2020Yes
legacy_hqr_opps_import

HQR_opps_import_TableLayout.xlsx

HQR_QNOL_OPPS_IMPORT_view_logic.zip

8/3/2020Quarterly9/30/2020Yes
Miscellaneous data from the legacy CLDW and QNOL systems

legacy_cldw_prod_data_mgmtMisc_prod_data_mgmt_TableLayout.xlsx

Misc_prod_data_mgmt_view_logic.zip

8/24/2020

Quarterly11/11/2020Yes
legacy_qnol_user_admin

MISC_user_admin_TableLayout.xlsx


8/24/2020Quarterly11/11/2020Yes
legacy_sdol_ifmc_common

IFMC_COMMON_TableLayout.xlsx


3/6/2020NoneNeverYes
PRSThe 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_prsHQR_PRS_TableLayout.xlsx


8/7/2020Monthly9/16/2020Yes
NPPESThe National Plan and Provider Enumeration System contains provider NPIs, names, and location information.nppes

NPPES_TableLayout.xlsx

NPPES dissemination information on CMS Website8/14/2020Quarterly11/25/2020No

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

Provider_PMI_Data_TableLayout.xlsx

MDM PMI SPP Physical Data Dictionary_01.07.2020.pdf

MDM 3rd Qtrly Training.pptx

MDM NPI Tables Model Diagram.pdf

MDM PMI SPP Logical Data Model Diagram.pdf

Guide to Using the MDM Comprehensive PMI and SPP

Tables_V2_F_7.30.2020.docx

Guide to Using the MDM PMI_SPP_NPI Profile Tables_V2_F_7.31.2020.docx

Password: royalrabbit

8/25/2020Weekly8/31/2020Yes
ProviderThe provider schema contains data formerly found in the CASPER and QIES systems.legacy_provider_data

PROVIDER_data_TableLayout.xlsx

QIES.S&C.Table-Reports.pdf8/27/2020Monthly9/30/2020Yes
QMARSQuality Management and Review Systems (QMARS) is a system for case management and review. qmars

QMARS_TableLayout.xlsx


8/27/2020Monthly9/30/2020Yes
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

quality_measures_qpp_uds_TableLayout.xlsx

Full UDS Data Dictionary-v71.pdf

UDS_ER_Diagram.jpg

8/18/2020TBDTBDYes
SDDWContains Medicare Beneficiary and Provider enrollment data. (FAQ)legacy_sddw_np_sdps

SDDW_TableLayout.xlsx

SDDW_Data_map.xlsx

For information about beneficiary tables in SDDW: EDB_data_dictionary.doc

legacy_sddw_np_sdps_Partition_Info.xlsx

Denominator_File_Specifications.doc

8/6/2020Monthly9/16/2020Yes
SDOLContains the beneficiary coverage data previously in the Oracle SDOL database.legacy_sdol_np_sdps

SDOL_NP_SDPS_TableLayout.xlsx


8/7/2020Monthly9/16/2020Yes


Return to Top


Horizontal Navigation Bar Page
titleHealth Plan Data


Panel
borderWidth1 px

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

HPMSContains HMO/PDP contract and service area data from the CMS Health Plan Management System.

health_plan

HPMS_TableLayout.xlsx

HPMS_Data_Dictionary.xlsx

8/3/2020Monthly9/5/2020Yes


Return to Top


Horizontal Navigation Bar Page
titlePublic Data


Panel
borderWidth1 px

Public Data

Schema

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Most Recent Refresh

Refresh Frequency

Next Refresh

DUA Required

ADIThe Area Deprivation Index (ADI) contains the GIS information for US neighborhoods.public_data

ADI_TableLayout.xlsx

Neighborhood Atlas Web Page4/10/2020Annually5/13/2021No
FDAThe FDA data contains packaging and product information for FDA approved drugs.public_data

FDA_TableLayout.xlsx


8/21/2020Monthly9/30/2020No
Nursing Home CompareThis is the official data for the Nursing Home Compare website.compare_nursing_home

NHC_TableLayout.xlsx

Nursing Home Compare Overview

Data Set Page

8/27/2020Monthly10/30/2020No
ZIPThis table contains the ZIP Codes and other information for cities and towns in the US.public_data

ZipCodes_TableLayout.xlsx


8/21/2020Monthly10/30/2020No


Return to Top 


Horizontal Navigation Bar Page
titlePlanned Data Sources


Panel
borderWidth1 px

Planned Data Sources

Source NameDescriptionFuture CDR Hive SchemaCDR Legacy Data SourcesData Dictionary and Supplemental InformationTargeted 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_prslegacy_hqr_prs

PRS_Planned_Table_List.xlsx

12/15/2020



Return to Top 


Horizontal Navigation Bar Page
titleArchived Sources


Panel
borderWidth1 px

Archived Sources

Sources No Longer Being Refreshed

Source

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Final Refresh Date

DUA Required

HQRlegacy_hqr_public_reportingHQR_public_reporting_TableLayouts.xlsxSDOL_CLDW_PUBLIC_REPORTING_view_logic.zip3/2/2020Yes

Sources Continuing to be Refreshed

Source

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Most Recent Refresh

Refresh Frequency

Next RefreshDUA Required
BeneficiaryThe 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_datalegacy_beneficiary_data_TableLayout.xlsx


EDB_data_dictionary.doc

8/10/2020Monthly9/16/2020Yes


Return to Top 

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.