Standardized Views

General Case Information Administrative information pertaining to a case: admission type, procedural services, room, date, charge capture codes
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data E8AF35EA-1197-E111-8EA6-0022191D9ED3
MPOG_Patient_ID A unique HIPAA safe identifier to link patient data 1242A3E2-1197-E111-8EA6-0022191D9ED3
MPOG_Admission_Type_Concept_ID Integer representing patient admission type 501
MPOG_Admission_Type_Desc Description associated with concept identifier Surgical Admission Type - Outpatient
AIMS_Admission_Type Admission type From AIMS text S
MPOG_Primary_Procedural_Service_Concept_ID Integer representing primary procedural service 80006
MPOG_Primary_Procedural_Service_Concept_Desc Description associated with concept identifier General
AIMS_Primary_Procedural_Service Primary procedural service from AIMS text SON
MPOG_Procedure_Room_Type_Concept_ID Integer representing procedure room type 20002
MPOG_Procedure_Room_Type_Desc Description associated with concept identifier Acute care hospital - mixed use operating room
AIMS_Procedure_Room_Name Procedure room name from AIMS text U-OR 1999
AIMS_Scheduled_DT Scheduled procedure start datetime 01/01/1999 7:30
AIMS_Scheduled_Procedure_Text Scheduled procedure description from AIMS text INGUINAL LYMPH NODE BIOPSY
AIMS_Actual_Procedure_Text Actual procedure description from AIMS text INGUINAL LYMPH NODE BIOPSY
Charge_Capture_Primary_Anesthesia_Code Anesthesia CPT code 400
Charge_Capture_Primary_Surgery_Code Surgery CPT code 38500
Charge_Capture_Primary_Diagnosis_Code ICD code 202.8
AIMS_Case_ID Case uniqueidentifier for AIMS 123456
AIMS_Encounter_ID Visit uniqueidentifier for AIMS 12345678
ASA Class ASA classification data, AIMS source text and value processed from most recent entry
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data E8AF35EA-1197-E111-8EA6-0022191D9ED3
AIMS_Source_Value Text from AIMS field, concatenated in order of entry ASA 3
ASA_Class Processed ASA classification from most recent entry 3
Emergent Processed emergent status from most recent entry 0
Patient Anthropometrics Text, counts and MPOG processed numeric data for a patient by case, such as height weight and BMI, by case
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data E8AF35EA-1197-E111-8EA6-0022191D9ED3
AIMS_Height_cm AIMS text for patient height in centimeters, concatenated in order of entry 177.8
AIMS_Height_cm_Count Number of valid AIMS text entries for height in centimeters 1
AIMS_Height_in AIMS text for patient height in inches, concatenated in order of entry 70
AIMS_Height_in_Count Number of valid AIMS text entries for height in inches 1
AIMS_Weight_kg AIMS text for patient weight in kilograms, concatenated in order of entry 89.3
AIMS_Weight_kg_Count Number of valid AIMS text entries for weight in kilograms 1
AIMS_Weight_lb AIMS text for patient weight in pounds, concatenated in order of entry 196.9
AIMS_Weight_lb_Count Number of valid AIMS text entries for weight in pounds 1
AIMS_Body_Mass_Index AIMS text for patient body mass index, concatenated in order of entry 28.300 ; 28.300
AIMS_Body_Mass_Index_Count Number of valid AIMS text entries for body mass index 2
MPOG_Height_cm MPOG processed height in centimeters via most recent height in centimeters, or converted from inches if not available 177.8
MPOG_Weight_kg MPOG processed weight in kilograms via most recent weight in kilograms, or converted from pounds if not available 89.3
MPOG_Body_Mass_Index MPOG Body Mass Index calculated from MPOG Height in centimeters and MPOG Weight in Kilograms 28.248
MPOG_WHO_Obesity_Classification_CD WHO Obesity Classification code from MPOG Body Mass Index 3
MPOG_Body_Surface_Area MPOG Body Surface Area from MPOG Height in Centimeters and MPOG Weight in Pounds 2.1
MPOG_Ideal_Body_Weight MPOG Ideal Body weight from MPOG Height in Centimeters and MPOG Weight in pounds and age 72.02
MPOG_Adjusted_Body_Weight MPOG Adjusted Ideal Body weight from MPOG Height in Centimeters and MPOG Weight in pounds and age 78.932
Patient Demographics Includes demographic information such as age, sex and race, by case
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data 8AF0A3D7-A590-E111-BC80-0022191D9ED3
MPOG_Patient_ID A unique HIPAA safe identifier to link patient data FCD13AC7-A590-E111-BC80-0022191D9ED3
AIMS_Case_ID Case uniqueidentifier for AIMS 123456
AIMS_Patient_ID Patient uniqueidentifier for AIMS 123456
AIMS_Patient_Age_Years patient age in years, null if patient age is less than 1 year 90
AIMS_Patient_Age_Months patient age in month, null if patient age is more than one year or less than 4 weeks NULL
AIMS_Patient_Age_Weeks patient age in weeks, null if patient age is more than 4 weeks NULL
AIMS_Sex patient sex M/F
AIMS_Race_Text Text from AIMS pertaining to race concatenated in order of entry Caucasian/AfricanAmerican/Etc.
MPOG_Race_Concept_ID Integer representing MPOG race concept identifier 4005
MPOG_Race_Text Description associated with concept identifier White, not of Hispanic Origin
AIMS_DOB Patient date of birth from AIMS 01/01/1900 0:00
AIMS_Medical_Record_Number patient registration number or record number from hospital 123456789
Preoperative Physical Exam History and Physical exam information as concatenated strings from the respective text fields in concatenated in order of entry, by case
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data 3907353A-0297-E111-8EA6-0022191D9ED3
Beard text from AIMS beard examination field concatenated in the order of entry No
Cervical_Spine text from AIMS cervical spine examination field concatenated in the order of entry Normal
Dentition text from AIMS Dentition examination field concatenated in the order of entry Normal
Existing_Airway text from AIMS Existing Airway examination field concatenated in the order of entry None
Hyoid_to_Mentum_Subjective text from AIMS Hyoid to Mentum examination field concatenated in the order of entry T to M >= 6 cm
Jaw_Protrusion text from AIMS Jaw Protrusion examination field concatenated in the order of entry B: Limited, lower incisiors can only be advanced to meet the upper incisors
Mallampati_Extended text from AIMS Mallampati Extended examination field concatenated in the order of entry II
Mallampati_Neutral text from AIMS Mallampati Neutral examination field concatenated in the order of entry  
Mallampati_Score_Unspecified_Position text from AIMS Unspecified Mallampati examination field concatenated in the order of entry II
Mouth_Opening text from AIMS Mouth Opening examination field concatenated in the order of entry >= 3 cm mouth opening
Neck_Anatomy text from AIMS Neck Anatomy examination field concatenated in the order of entry (Normal)
Neck_Circumference_cm text from AIMS Neck Circumference Centimeters examination field concatenated in the order of entry  
Neck_Circumference_in text from AIMS Neck Circumference Inches examination field concatenated in the order of entry 18
Overall_Airway_Exam text from AIMS Overall Airway examination field concatenated in the order of entry  
Airway_Freetext_Comments text from AIMS Airway Freetext Comment field concatenated in the order of entry cervical fusion plated 5th and 6th vertebrae.
Airway_Other text from AIMS Airway Other textfield concatenated in the order of entry  
Cardiac text from AIMS Cardiac examination field concatenated in the order of entry S1, S2
Lung_Fields text from AIMS Lung examination field concatenated in the order of entry Clear Bilat
Neurologic text from AIMS Neurologic examination field concatenated in the order of entry Grossly normal
Level_of_Consciousness text from AIMS Level of Consciousness examination field concatenated in the order of entry  
Integument text from AIMS Integument examination field concatenated in the order of entry  
Extremities text from AIMS Extremities examination field concatenated in the order of entry  
Oxygen_Supplementation text from AIMS Oxygen Supplementation examination field concatenated in the order of entry RA
Multiple_Body_Systems text from AIMS Multiple Body Systems examination field concatenated in the order of entry  
Existing_Vascular_Access text from AIMS Existing Vascular Access examination field concatenated in the order of entry  
Physical_Exam_Other text from AIMS Physical Exam Other text field concatenated in the order of entry  
Case Providers Staff ID for the Anesthesiologists and Surgeon for the case based on the sign in and sign out record
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data 3E8AF35EA-1197-E111-8EA6-0022191D9ED3
Anesthetist_First Staff ID for Anesthetist present at 'Anestheisa Start' 12345
Anesthetist_last Staff ID for Anesthetist present at 'Anestheisa End' 12345
Anesthetist_Primary Staff ID for Anesthetist with the most time signed into case 12345
Attending_First Staff ID for Attending present at 'Anestheisa Start' 1234
Attending_last Staff ID for Attending present at 'Anestheisa End' 1234
Attending_Primary Staff ID for Attending with the most time signed into case 1234
Surgeon_Primary Staff ID for Surgeon assigned to case 12345
Anesthesia Technique Which anesthesia techniques were used for a case via MPOG processing (documentation)
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data 3E8AF35EA-1197-E111-8EA6-0022191D9ED3
Block_yn Whether case received a block based on block note or route concept id 0
Epidural_yn Whether case received a epidural based on epidural note or route concept id 1
General_yn Whether case received a general anesthesia based on mask or tube note, paralytic medication or volatile gas usage 1
Spinal_yn Whether case received a spinal based on spinal note or route concept id 0
Case Times MPOG note timestamps and minute durations between associated timestamps for a case
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data 3E8AF35EA-1197-E111-8EA6-0022191D9ED3
Patient_In_Room_DT First date and time when patient entered room documented for case 01/01/1900 7:49
Patient_Out_Of_Room_DT Last date and time when patient transported from room documented for case 01/01/1900 8:38
Anesthesia_Start_DT First date and time when Anesthesia start documented for case 01/01/1900 7:26
Anesthesia_End_DT Last date and time when anesthesia end documented for case 01/01/1900 8:46
Procedure_Start_DT First date and time when procedure start (surgical incision) documented for case 01/01/1900 8:13
Procedure_End_DT Last date and time when procedure end (surgical dressing) documented for case 01/01/1900 8:35
Recovery_Room_Start_DT First date and time when recovery room start documented for case 01/01/1900 8:45
Recovery_Room_End_DT Last date and time when recovery room end documented for case 01/01/1900 8:47
Case_Duration_In_Room_min Minutes from patient in room to patient out of room 49
Case_Duration_Anesthesia_min Minutes from anesthesia start to end 80
Case_Duration_Surgery_min Minutes from procedure start to procedure end 22
Case Counts Number of valid entries for a given MPOG note by case
Column Name Description Example
MPOG_Case_ID A unique HIPAA safe identifier to link case data E8AF35EA-1197-E111-8EA6-0022191D9ED3
Valid_ASA_Count Number of Valid ASA entries 1
Patient_In_Room_Count Number of valid patient in room entries for case 1
Anesthesia_Start_Count Number of valid patient out of room entries for case 1
Procedure_Start_Count Number of valid procedure start room entries for case 2
Recovery_Room_Start_Count Number of valid recovery room start entries for case 1
Patient_Out_Of_Room_Count Number of valid patient out of room entries for case 1
Anesthesia_End_Count Number of valid anesthesia end entries for case 2
Procedure_End_Count Number of valid procedure end entries for case 1
Recovery_Room_End_Count Number of valid recovery room start entries for case 1