Data

Versions Compared

Old Version 987

changes.mady.by.user Gabrielle O'Neal

Saved on

compared with

New Version 988

changes.mady.by.user Gabrielle O'Neal

Saved on

Key

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

 

Include Page
Data Nav_DR
Data Nav_DR


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 the Centralized Data Repository (CDR). All data will more closely reflect the source system. Refer to User Guides & References for an overview and a guide to the data catalog.

User may need to download documents to see the content if they do not display well.


Note

Users that have any technical questions regarding the information on this page should send an email to servicecentersos@cms.hhs.gov, routing to ADO-QualityNet Analytics-Support. All data listed below is currently in the CDR environment; however, a user will only see what is defined by their data usage agreement (DUA). The data refresh cadence from CDR sources are published for awareness of data timeliness. If the user's organization requires data to be refreshed on a different timeline or cycle, they should submit a Request Form and include details of their 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. Note that this document will be continuously updated. Additional information will be added regularly and some dates may change due to changing requirements or security mandates.



Panel
borderColor#C12026
titleColorWhite
titleBGColor#C12026
borderStylesolid
titleCDR Data Catalog


Horizontal Navigation Bar
idCDR Data Catalog


Horizontal Navigation Bar Page
titleClaims Data

Claims Data

SchemaDescriptionCDR Hive SchemaCDR Table Layouts

Data Dictionaries and Supplemental Information

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_5

csat_2

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

Table Layouts for Legacy Schemas:

CSAT_Baseline 

CSAT_Monthly 

CSAT Data Dictionary

CSAT Partition Info


Monthly - Last Friday of every month
DDPS Part DThe 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_dddps_part_d

DDPS Part D Data Dictionary


Monthly - By the 12th of each month or the following business day
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_anch_part_a

Data Dictionary - FI_HHA_CLM_REC.zip

Data Dictionary - FI_OP_CLM_REC.zip

Data Dictionary - FI_IP_SNF_CLM_REC.zip

Data Dictionary - FI_HOSPC_CLM_REC.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_anch_part_a

MSDRG_DataCatalog.xlsx

MSDRG_JavaAPI_Guide.pdf

Weekly - Thursdays
NCH Part BThe 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_bnch_part_b

Data Dictionary - DMERC_CLM_REC.zip

Data Dictionary - CARR_CLM_REC.zip


Weekly - Thursdays
NCH MEDPARMedicare 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.medparmedpar

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
titleClinical Data

Clinical Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationRefresh
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_extractsSee Data Dictionary file RDS Extracts Data DictionaryQuarterly (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_extractsTBDClinical Extracts Data DictionaryWeekly (loaded each weekend)
Care Compare ExtractsEnd 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

TBDCare Compare Extracts Data Dictionary Quarterly (January, April, July, October)

Important Notes


Horizontal Navigation Bar Page
titleBeneficiary and Provider Data

Beneficiary and Provider Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationRefresh

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_iqiesassessment_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_iqiesprovider_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_databeneficiary_data

BIC data lake Data Dictionary.pdf

beneficiary data Partition Info.xlsx

BIC Data Dictionary Code Values.xlsx

BIC Data Structures.xlsx


Note
titleNote:

Only a subset of BIC tables are available in the CDR.


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_dataProvider_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 QIIThis 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_qiiquality_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.xlsxQuarterly
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_formquality_measures_hqr_data_form

quality measures hqr data form.xlsx

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_abstquality_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_nopprovider_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_valquality_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)

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:

  • legacy_hqr_ehqr
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:

  • legacy_qnol_user_admin
resource_hqr_sec_admin  
resource_hqr_sec_admin.pdfDaily

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_hvbpNAHQR 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 CodesWeekly - Thursdays
NPPESThe National Plan and Provider Enumeration System contains provider NPIs, names, and location information.nppesnppesNPPES dissemination information on CMS website Quarterly

QMARS

 

**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. qmarsqmars
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_nghealthcare_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_udsquality_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


Important Notes


Horizontal Navigation Bar Page
titleHealth Plan Data

Health Plan Data

SchemaDescriptionCDR Hive SchemaCDR Table LayoutsData Dictionaries and Supplemental InformationRefresh
HPMSContains 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_planhealth_plan

HPMS Data Dictionary

FINAL RIC0004

FINAL RIC0007

PROFILES

Weekly - Fridays

Important Notes


Horizontal Navigation Bar Page
titlePublic Data

Public Data

Schema

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Refresh 

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

ADI

Neighborhood Atlas Web Page

Annually

FDAThe FDA data contains packaging and product information for FDA approved drugs.public_data

FDA


Monthly - 1st of the month or next business day

FDBThe First Data Bank (FDB) drug list includes drug data available from the legacy data center and is no longer refreshed.  public_data

FDB

FDB Drug List Data Dictionary

4/15/2021 Communications Call Overview

 None

Nursing Home CompareThis is the official data for the Nursing Home Compare website.compare_nursing_home

NHC

Nursing Home Compare Overview

Data Set Page

Data Dictionaries


Monthly - 1st of the month or next business day


FIPSThese tables contain FIPS county and state codes.  public_data

FIPS


Annually
ZIPThis table contains the ZIP Codes and other information for cities and towns in the US.public_data

ZipCodes


Monthly - 1st of the month or next business day

Reference CodesThis schema contains various reference codes such as ICD-10, HCPCS, and others.resource_ref_codes

Resource_Ref_Codes


 Annual (may update quarterly if new code updates)

Important Notes


Horizontal Navigation Bar Page
titlePlanned Data Sources

Planned Data Sources

Source NameDescriptionFuture CDR Hive SchemaCDR Legacy Data SourcesData Dictionary and Supplemental InformationTargeted Date of Availability within CDR
Medicare Current Beneficiary Survey (MCBS)Medicare beneficiary self-reported data blended with claims and enrollment data.

TBD

NANAJuly 2024
Medicare Bayesian Improved Surname Geocoding (MBISG)Researchers at RAND, in coordination with the Centers for Medicare & Medicaid Services’ (CMS) Office of Minority Health (OMH), modified an existing method for indirectly estimating race-and-ethnicity from surname and residential information (Bayesian Improved Surname and Geocoding [BISG]) to augment CMS’s SSA-based administrative measure of race-and-ethnicity; this resulted in the Medicare Bayesian Improved Surname Geocoding (MBISG) algorithm.

TBD

NANAFall 2024

Important Notes


Horizontal Navigation Bar Page
titleLegacy Sources

Legacy Sources

Sources No Longer Being Refreshed

Source

Description

CDR Hive Schema

CDR Table Layouts

Data Dictionaries and Supplemental Information

Final Refresh Date

HQR - Legacy
legacy_hqr_public_reporting

HQR_public_reporting

SDOL_CLDW_PUBLIC_REPORTING_view_logic.zip3/2/2020
HQR - Legacy
legacy_hqr_asc

HQR_ASC

HQR_QNOL_ASC_APP_view_logic.zip

4/6/2020
HQR - Legacy
legacy_hqr_hcahps

HQR_HCAHPS_QNOL

HQR_QNOL_HCAHPS_view_logic.zip

10/21/2020 
HQR - Legacy
legacy_hqr_hcahps_final

HQR_HCAHPS_CLDW

SDOL_CLDW_HCAHPS_view_logic.txt

10/20/2020 
HQR - Legacy
legacy_qnol_pch_app

HQR_pch_app

HQR_QNOL_PCH_APP_view_logic.txt

12/8/2020
HQR - Legacy
legacy_hqr_struct_msrs

HQR_struct_msrs

HQR_QNOL_STRUCT_MSRS_APP_view_logic.zip

12/4/2020
HQR - Legacy
legacy_cldw_rpt_etl

HQR_rpt_etl


12/1/2020
HQR - Legacy
legacy_hqr_pprs_app

HQR_pprs_app

HQR_QNOL_PPRS_APP_view_logic.txt

11/10/2020
HQR - Legacy
legacy_hqr_opps_prs

HQR_opps_prs

SDOL_OPPS_PRS_view_logic.txt

12/3/2020
HQR - Legacy
legacy_hqr_sdol_extfilapp

HQR_SDOL_ext_fil_app


12/7/2020
HQR - Legacy
legacy_hqr_qnol_extfilapp

HQR_QNOL_ext_fil_app


12/7/2020
HQR - Legacy
legacy_hqr_hai

HQR_HAI

SDOL_HAI_APP_view_logic.zip

12/4/2020
HQR - Legacy
legacy_hqr_cart(QNOL)

HQR_CART

HQR_QNOL_CART_view_logic.zip

12/3/2020
HQR - Legacy
legacy_hqr_cart_final (CLDW)

HQR_CART_Final

SDOL_CLDW_CART_view_logic.zip

12/3/2020
HQR - Legacy
legacy_hqr_ehqr

HQR_EHQR

HQR_QNOL_EHQR_view_logic.zip

legacy_hqr_ehqr_Partition_Info.xlsx

11/16/2020
HQR - Legacy
legacy_hqr_oat_app

HQR_oat_app

HQR_QNOL_OAT_APP_view_logic.txt

12/2/2020
HQR - Legacy
legacy_hqr_ipledge_app

QNOL_ipledge_app

HQR_QNOL_IPLEDGE_APP_view_logic.txt

12/9/2020
HQR - Legacy
legacy_hqr_nop_app

HQR_nop_app

HQR_QNOL_NOP_APP_view_logic.zip

12/10/2020
HQR - Legacy
legacy_hqr_opledge_app

QNOL_opledge_app

HQR_QNOL_OPLEDGE_APP_view_logic.txt

12/9/2020
HQR - Legacy
legacy_hqr_opps

HQR_OPPS

SDOL_CLDW_OPPS_WHS_view_logic.zip

12/4/2020
HQR - Legacy
legacy_hqr_validation_app

HQR_validation_app


12/7/2020
HQR - Legacy
legacy_hqr_cart_cdac

HQR_CART_CDAC

SDOL_CLDW_CART_CDAC_view_logic.txt

8/11/2020
HQR - Legacy
legacy_hqr_ci_rpt

HQR_ci_rpt


12/10/2020
HQR - Legacy
legacy_hqr_opps_import

HQR_opps_import

HQR_QNOL_OPPS_IMPORT_view_logic.zip

12/10/2020
HQR - Legacy
legacy_cldw_prod_data_mgmtMisc_prod_data_mgmt

Misc_prod_data_mgmt_view_logic.zip

12/9/2020

HQR - Legacy
legacy_qnol_user_admin

MISC_user_admin


12/9/2020
HQR - Legacy
legacy_sdol_ifmc_common

IFMC_COMMON


3/6/2020
HQR - Legacy


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

legacy_hqr_hvbp

HQR_HVBP

HQR_QNOL_HVBP_view_logic.zip

10/19/2020
Program Resource System (PRS)
legacy_hqr_prsHQR_PRS
12/8/2020

QIES Legacy

(Provider)


legacy_provider_data

Legacy_Provider_Data

QIES.S&C.Table-Reports.pdf8/27/2020

QIES Legacy

(Assessment)


legacy_assessment_data

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

9/15/2020
Beneficiary
legacy_beneficiary_datalegacy_beneficiary_dataEDB_data_dictionary.doc12/3/2020
SDDW
legacy_sddw_np_sdps

SDDW_NP_SDPS

Denominator_File_Specifications.doc

denominator1_derived_fields.docx

denominator2_derived_fields.docx

SDDW_Data_map.xlsx

llegacy_sddw_np_sdps_Partition_Info.xlsx

For information about beneficiary tables in SDDW:

EDB_data_dictionary.doc


12/8/2020
SDOL
legacy_sdol_np_sdps

SDOL_NP_SDPS


12/8/2020
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_

CRIS User Guide.pdf

1/13/2020








HTML
<style>#title-text {
		display:none !important;
	}
.aui-navgroup-primary {  
                font-size: 1.25em;  
                font-weight:  bold;  
    }  
.page-metadata-modification-info {
		display:none !important;
	}
</style>