Skip to main content
. 2022 Sep 16;9:927044. doi: 10.3389/fsurg.2022.927044

Table 1.

Data spreadsheet fields: ASA American society of anaesthesiologists, BMI body mass index, BUN blood urea nitrogen, CPAP continuous positive airway pressure, CRP C-reactive protein, GCS glasgow coma scale, ICD-9-CM 9th revision of international classification of disease clinical modification, ID identifier, INR international normalized ratio, MI myocardial infarction, mFI modified frailty Index, PCI percutaneous coronary intervention, PLT platelet, WBC white blood cell, P-POSSUM portsmouth-physiological and operative severity score for the enUmeration of mortality and morbidity, CR-POSSUM coloRectal physiological and operative severity score for the enUmeration of mortality and morbidity, SAPS II simplified acute physiology score II, CACI charlson age-comorbidity index, EmSFI emergency surgical frailty index.

Form Field Options (definitions)
Demographics ID Progressive number
ID center Number
ID code Alphanumeric (3 characters)
Age In years
Sex Male/Female
BMI BMI in kg/m2
Admission date Day/month/year
Operation date Day/month/year
Timing of surgery Emergency/urgency
Clinicopathological data Vital parameters Systolic blood pressure, heart rate, respiratory rate, oxygen saturation, temperature, urine output, mechanical ventilation or CPAP, FiO2, GCS
Laboratory analysis Arterial blood gas analysis (PaO2, PaCO2 bicarbonate, lactates), chemistry (sodium, potassium, bilirubin, glycemia, CRP), renal function (BUN, creatinine), hemoglobin, WBC, PLT, INR
Tumor Site, TNM classification, Dukes staging system, grading, radicality of surgery, vascular invasion
Comorbidities Associated diseases Cardiovascular disease (ECG-report, hypertension, MI < 6 months, heart failure <30 days, chronic heart disease, Previous cardiac surgery or PCI, peripheral vasculopathy), cerebrovascular disease, respiratory disease (chronic lung diseases, respiratory failure), smoke, renal disease (acute/chronic), diabetes, liver disease (acute/chronic), solid tumor (localized/metastatic) leukemia, lymphoma, AIDS, drugs (oral anticoagulants, immunosuppressants or steroids, oral hypoglycemic agents or insulin), peptic ulcer
Performance status Hemiplegia, dementia, weight loss, physical activity, walk time, grip strength, exhaustion
Surgical intervention Organ/body-district categories Abdominal wall, appendicitis, biliary tract and pancreas, esophagus, large bowel, small bowel, solid organs, stomach and duodenum, thorax, Others
Onset symptoms Obstruction, acute abdomen (peritonitis—abscess and/or overt perforations), Vascular disorders, Trauma
Primary operative indication Benign/malignant/delayed elective
Surgical approach Open/Laparoscopic/Laparoscopic converted/Laparoscopic assisted
Primary surgical procedure ICD-9-CM code
Associated procedures Numbers
List of associated procedures ICD-9-CM code
Intraoperative reliefs Blood loss (ml), peritoneal contamination (yes/no)
Operative time Minutes
ICU admission Yes/no
ICU length of stay Dayes
Follow-ups Date of discharge Day/month/year
Total length of stay Days
Type of discharge Home, short-term rehabilitation facility, caregiver residential facility
Complications 30-daypostoperatively Yes/no
Complication type Free text
Complication grade (Clavien-Dindo classification) None/I/II/III/IV/V
30-day mortality Yes/no
Score ASA, CACI, SAPSII, ACS-NSQIP, CORES, SMPM, USEM, EmSFI, 5-mFI