MSQC Postoperative Outcomes

Search:

Description

This phenotype determines the postoperative outcome as defined and reported by the Michigan Surgical Quality Collaborative (MSQC).

Limitation

A stratified sampling methodology is used to capture a representative portion of surgical cases. This involves a repeating and rotating 8-day cycle over a 12-month period and is limited to a subset of surgical CPT codes.

Data quality is limited to individual site documentation accuracy, completeness, and variable mapping, which is performed by each site, independently. MPOG, as the coordinating center, reviews data quality at each data upload and monthly via Data Diagnostics and Case Validation tools. This review, while thorough, may not contain all data elements relevant to this phenotype and thus should be carefully reviewed by the user.

Value Type

Categorical

Enumeration

Value	Value Code	Definition

Return Columns

Name	Data Type

Granularity

Logic

Step 1: Check if case matches on MSQC data using MSQC Case Matching phenotype

Step 2: Check if case has a postoperative outcome value in the category column of the MSQC.Core.PostopOccurrences table

Step 3: Result the associated values and value codes separated by commas

Active Variables:

Value_Code	Value	Available Data
1	Superficial Incisional SSI	1/1/2008 - Current
2	Deep Incisional SSI	1/1/2008 - Current
3	Organ/Space SSI	1/1/2008 - Current
4	Pneumonia	1/1/2008 - Current
9	Urinary Tract Infection (UTI) - Non-CAUTI	1/1/2012 - Current
10	Urinary Tract Infection (UTI) - CAUTI	1/1/2012 - Current
11	Stroke/CVA	1/1/2008 - Current
13	Cardiac Arrest req. CPR - Postop	1/1/2008 - Current
15	Myocardial Infarction - Postop	1/1/2008 - Current
17	Transfusions w/in first 72 hrs postop	1/1/2010 - Current
20	Sepsis-3 (Formerly "Severe Sepsis/Septic Shock")	1/1/2008 - Current
31	Anastomotic Leak	1/1/2012 - Current
39	Postop Ileus requiring NG tube or NPO	1/1/2018 - Current
40	Postop Urinary Retention	1/1/2023 - Current
41	VTE (PE/DVT)	1/1/2008 - Current

Retired Date: 2012

Data Available: 1/1/2008 - 12/31/2011

*Value_Code*	*Value*
910	Urinary Tract Infection (UTI) - Unknown

Retired Date: 2016

Data Available: 7/1/2012 - 12/31/2015

*Value_Code*	*Value*
16	Cardiac Dysrhythmias
22	CLABSI
32	Gynelogic - Cuff infection
33	Gynelogic - Pelvic abscess
34	Gastrointestinal - Anastomotic leak
35	Nerve Injury - Upper Extremity
36	Nerve Injury - Lower Extremity
37	Other

Retired Date: 2017

Data Available: 1/1/2008 - 12/31/2016

*Value_Code*	*Value*
16	Cardiac Dysrhythmias

Retired Date: 2018

Data Available: 1/1/2012 - 12/31/2017

*Value_Code*	*Value*
5	Unplanned Intubation - Intraop

Retired Date: 2019

Last Date Available: 12/31/2018

*Value_Code*	*Value*	*First Date Available*
6	Unplanned Intubation - Postop	1/1/2008
8	Acute Kidney Injury	1/1/2008
12	Cardiac Arrest req. CPR - Intraop	1/1/2012
14	Myocardial Infarction - Intraop	1/1/2012
23	Hysterectomy - Bleeding Complications	1/1/2016
25	Hysterectomy - Bowel Injury	1/1/2016
26	Hysterectomy - Ureteral Obstruction	7/1/2012
27	Hysterectomy - Bladder Injury	1/1/2016
28	Hysterectomy - Fistula	7/1/2012
29	Hysterectomy - Vaginal Cuff Dehiscence	7/1/2012
30	Hysterectomy - Vaginal Cuff Cellulitis	1/1/2016

Retired Date: 2024

Last Date Available: 12/31/2023

*Value_Code*	*Value*	*First Date Available*
7	Pulmonary Embolism *	1/1/2008
18	Deep Vein Thrombosis req. Therapy *	1/1/2008
19	Sepsis	removed
21	C-difficile	1/1/2012
38	Septic Shock **	1/1/2017

*merged to become 41 - VTE (PV/DTV)

**added to 20 - Sepsis-3