MSQC Procedure Group

Search:

Description

This phenotype determines the procedure group 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 data using MSQC Case Matching phenotype

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

Step 3: Result the associated value and value code

Active Variables:

Value Code	Value	First Date Available
1	Appendectomy	1/1/2008
2	Cholecystectomy	1/1/2008
3	Colectomy	1/1/2008
4	Proctectomy	1/1/2008
6	Gastrectomy	1/1/2008
8	Hernia Repair	1/1/2008
9	Pancreatectomy	1/1/2008
10	Anti-reflux Surgery	1/1/2008
11	Small Bowel Repair	1/1/2008
22	Other Gastric Procedures	1/1/2008
23	Other Colon Procedures	1/1/2008
24	Thyroidectomy	1/1/2008
26	Mastectomy	1/1/2023
27	Lymphadenectomy	1/1/2023

Reference Table for what procedure types are included in each procedure group

Procedure	Value_code
AAA
Endo AAA	22
Open AAA	21
Adrenalectomy
Adrenalectomy	41
Amputations
Amputations /AKA	20
Amputations /BkA	30
Aneurysm Repair
Aneurysm Repair	34
Open Lower Extremity Bypass	26
Anti-reflux surgery
Anti-reflux surgery	14
Aortoiliac
Endo Aortoiliac	24
Open Aortoiliac	23
Appendectomy
Appendectomy	1
Carotid Endarterectomy
Carotid Endarterectomy	25
Cholecystectomy
Lap Cholecystectomy	2
Open cholecystectomy	3
Colectomy
Partial Colectomy w/anastomosis	33
Partial Colectomy w/colostomy	28
Partial Colectomy wo/colostomy	4
Total Colectomy	5
Total Proctocolectomy	6
Esophagectomy
Esophagectomy	8
Gastrectomy
Gastrectomy	9
Hepatectomy
Hepatectomy	10
Hernia Repair
Groin Hernia Repair	12
Umbilical Hernia Repair	42
Ventral Hernia Repair /incisional	29
Ventral Hernia Repair /non-incisional	11
Hysterectomy
Abdominal hysterectomy for benign disease	17
Abdominal hysterectomy/Oophorectomy for cancer	19
Vaginal hysterectomy for benign disease	18
Lower Extremity Bypass
Endo Lower Extremity Bypass	27
Open Lower Extremity Bypass	26
Lymphadenectomy
Lymphadenectomy	46
Mastectomy
Mastectomy	45
Other Colon Procedures
Other Colon Procedures	39
Other Esophageal Procedure
Diverticulectomy	36
Esophagectomy	8
Gastrointestinal Reconstruction	37
Other Gastric Procedures
Other Gastric Procedures	38
Pancreatectomy
Pancreatectomy	13
Proctectomy
Anastomotic Proctectomy	32
APR Proctectomy	31
Local Proctectomy	7
Small Bowel Repair
Small Bowel Resection or Stricturoplasty	15
Small Bowel/Biliary	44
Surgery for Small Bowel Obstruction	16
Splenectomy
Splenectomy	35
Thyroidectomy
Thyroidectomy	40