CMS Claims/Michigan Medicine Electronic Health Record (EHR) Data Repository – Precision Health Analytics Platform

CMS Claims/Michigan Medicine Electronic Health Record (EHR) Data Repository

Please note: To access the Claims Repository, research should focus on Covid, cancer, or cardiovascular disease. Other conditions would be allowable only if the proposed analysis is accounting for Covid-related disruptions in some way. Read more about access requirements.

This dataset combines the Centers for Medicare & Medicaid Services (CMS) data with the health data of Michigan Medicine Medicare patients.

Patients in this cohort are age 65 OR have had at least one Michigan Medicine encounter between 2016 and 2021, where “Medicare” is listed as one of their insurance plan types. There are over 447,00 patients in the cohort. The following CMS claims data files are available:
Carrier
Home Health Agency
MBSF(Base)
MedPAR
Outpatient

CMS Claims Files Documentation
EHR Data Dictionaries


CMS Claims: Access Requirements
CMS Claims Data: Responsible Use Attestation
CMS Claims: Accessing CMS Claims Data on Turbo
CMS Claims: Linking the Claims and EHR files
CMS Claims: Acknowledgement and Grant Language

ClarityImmunizations

Patient’s immunization record, including historical data as well as specific information about immunizations administered at Michigan Medicine.

Note: this view does not contain antibody titers. If an antibody titer was performed at Michigan Medicine, this data can be found in the Labs section.

ClaritySocialHistory

Includes the social history (smoking, drug use, etc.) related to the patient’s health that has been reported by the patient. Because the data is self-reported by the patient, it may be incomplete.

ComorbiditiesCharlsonComprehensive

Comorbidity indexes use International Classification of Diseases (ICD) codes to predict patient mortality and hospital resource use.

Read more about comorbidities.

ComorbiditiesElixhauserComprehensive

Comorbidity indexes use International Classification of Diseases (ICD) codes to predict patient mortality and hospital resource use.

Read more about comorbidities.

DemographicInfo

Standard demographic data for all Michigan Medicine patients, including gender, race, ethnicity, religion, marital status, preferred language and more.

Read more about patient demographics.

DiagnosisComprehensiveAll

DiagnosisComprehensiveAll contains information about types of diagnoses, including pre-existing conditions and comorbidities.  Includes diagnoses documented by provider (visit) and billing (patient billing and hospital billing).

Read more about diagnosis views.

DiagnosisPSL

Entered by health care providers, the PSL is a list of active and resolved patient problems.  The PSLs are available at the patient or encounter-level. If the list is encounter-level, one of the problems will be flagged as Principal.  If the list is patient-level, it will contain data on when the problem was first diagnosed/entered as well as when it was resolved. Data available starting in 2014.

Read more about diagnosis views.

EncounterAll

Information about patient encounters including: date and times of admission and discharge/checkout; insurance plan types; admission and discharge types; indicators of labs, procedures and other encounter information. Data available starting in 2000.

Read more about Encounter views.

EncounterAnthropometricsBMI

Includes a patient’s height, weight and Body Mass Index (BMI) during an encounter.   Data for ambulatory and Emergency Department  is available starting in Fall 2012.  Data for inpatient encounters is available starting in June 2014. 

Read more about Encounter views.

EncounterCaregivers

Includes the provider types for specific encounters. Historical data from HSDW is available starting in January 2000 and real-time data began in 2002. Note: A significant portion of the “CaregiverType” fields have empty records.

Read more about Encounter views.

EncounterLocations

Includes the date, time and Michigan Medicine location for a patient encounter.  Data for ambulatory and Emergency Department  is available starting in Fall 2012.  Data for inpatient encounters is available starting in June 2014. 

Read more about Encounter views.

FlowsheetStandardVitalSigns

A flat, daily summarized view of the most common MIN / MAX vital signs. Some examples are: Arterial and Cuff BP Systolic / Diastolic, Respiratory Rate, SPO2, Heart Rate, etc. 

Read more about flowsheets.

LabResults

Information about patient pathology laboratory orders and lab results.  Data is available starting in 2001.

Read more about Lab views.

MedicationOrdersComprehensive

Includes information about medications that are ordered for a patient, including medication name, doses, strength, date/time data related to the order and more. Data is available starting in 2012.

Notes: Subsets of data prior to the MiChart implementation in 2012 may be available.

The MedicationOrdersComprehensive view does not have information indicating a patient received a medication. Use the MedicationAdminstrationsComprehensive view for information on medication administered to patients.

Read more about Medication views.

Orders

Includes all NON-MEDICATION orders within the Research Data Warehouse DW. Loaded orders include, but are not limited to: lab orders, imaging orders, nursing orders, diet orders, etc. Orders are loaded for all levels of service, including inpatient and outpatient encounters. 

Read more about Orders views.

ProceduresComprehensive

Includes information about procedure names, descriptions and billing codes.  It includes all professional CPT procedures, as well as facility procedures (ICD-9, ICD-10, HCPCS).   Data is available starting in 2006 through 2 months previous to current date.

Read more about Procedures views.

lsa logoum logoU-M Privacy StatementAccessibility at U-M