MSQC Procedure Type

Search:

MSQC Procedure Type

Description

This phenotype determines the procedure type of a case as defined 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 and ASPIRE data using the MSQC Case Matching Phenotype

Step 2: Check value of the e_procedure column in the MSQC.Core.AnalytictableV4 table

Step 3: Return the associated value and value code

Active Variables:

Value	Value_Code	First Date Available
Appendectomy	1	1/1/2008
Lap Cholecystectomy	2	1/1/2008
Open Cholecystectomy	3	1/1/2008
Partial Colectomy w/o Colostomy	4	1/1/2008
Total Colectomy	5	1/1/2008
Total Proctocolectomy	6	1/1/2008
Local Proctectomy	7	1/1/2008
Gastrectomy	9	1/1/2008
Ventral Hernia Repair (non-incisional)	11	1/1/2008
Groin Hernia Repair	12	1/1/2008
Pancreatectomy	13	1/1/2008
Anti-reflux surgery	14	1/1/2008
Small Bowel Resection or Strictureoplasty	15	1/1/2008
Surgery for Small Bowel Obstruction	16	1/1/2008
Partial Colectomy w/ Colostomy	28	1/1/2008
Ventral Hernia Repair (incisional)	29	1/1/2008
APR Proctectomy	31	1/1/2008
Anastomotic Proctectomy	32	1/1/2008
Partial Colectomy with Anastomosis	33	1/1/2008
Diverticulectomy	36	1/1/2008
Gastrointestinal Reconstruction	37	1/1/2008
Other Gastric Procedures	38	1/1/2008
Other Colon Procedures	39	1/1/2008
Thyroidectomy	40	1/1/2008
Umbilical Hernia Repair	42	1/1/2008
Small Bowel/Biliary	44	1/1/2008
Mastectomy	45	1/1/2023
Lymphadenectomy	46	1/1/2023