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.
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
EHR views available for use with the Claims data
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.
