System;SQLape® category;;Hospitalization;Intensive care
newborn;PAR2;Caesarean section;yes;no
circulatory;COR4;Heart transplantation;yes;yes
circulatory;COR3;Heart operation with circulatory assistance;yes;yes
circulatory;GVA3;Operation on large vessels with circulatory assistance;yes;yes
circulatory;VAL2;Operation on heart valve;yes;yes
circulatory;ARC3;Coronary artery bypass grafting;yes;yes
circulatory;VAS4;Extra corporeal circulation;yes;yes
circulatory;COR2;Heart operation without circulatory assistance;yes;yes
circulatory;GVA2;Operation on large vessels without circulatory assistance;yes;yes
circulatory;VAS6;Repair of small vessels;yes;no
circulatory;ARC2;Percutaneous transluminal coronary angioplasty;one day;yes
circulatory;VAS5;Other major operation on small vessels, except repair;yes;no
circulatory;VAS3;Other minor operation on small vessels;one day;no
circulatory;VAS2;Operation on varicose limb veins;one day;no
circulatory;COR1;Cardiac catheterization or angiocardiography;one day;yes
circulatory;ARC1;Coronary angiography or thrombolytic therapy;one day;yes
circulatory;VAS1;Other arteriography or catherization;one day;no
respiratory;PUL5;Lung transplantation;yes;yes
respiratory;PUL4;Major operation on lung;yes;yes
respiratory;PUL3;Minor operation on lung;yes;no
respiratory;THO2;Operation on chest;yes;yes
respiratory;THM2;Operation on mediastinum or thymus;yes;yes
respiratory;TRA4;Operation on trachea, except tracheostomy;yes;yes
respiratory;TRA3;Tracheostomy;yes;no
respiratory;TRA2;Ventilatory support;yes;yes
respiratory;PUL2;Pulmonary endoscopy;yes;no
respiratory;PUL1;Bronchoscopy;no;no
nervous;CER3;Major operation on brain;yes;yes
nervous;HYP2;Operation on pituitary gland;yes;yes
nervous;SPI3;Major operation on spinal cord;yes;no
nervous;CER2;Minor operation on brain;yes;yes
nervous;CRA2;Operation on skull;yes;yes
nervous;SPI2;Minor operation on spinal cord;one day;no
nervous;NER3;Operation on nerves;yes;no
nervous;NER2;Carpal tunnel release;one day;no
nervous;NER1;Injection into a nerve;one day;no
urinary;REN5;Kidney transplantation;yes;yes
urinary;REN4;Major operation on kidney;yes;yes
urinary;REN3;Minor operation on kidney;yes;no
urinary;URE3;Open operation on ureter;yes;no
urinary;VES5;Cystectomy;yes;no
urinary;VES4;Repair of bladder;yes;no
urinary;VES3;Open operation on bladder, except repair;yes;no
urinary;PRO3;Open operation on prostate;yes;no
urinary;PRO2;Endoscopic operation on prostate;yes;no
urinary;URT3;Open operation on urethra;yes;no
urinary;PEN3;Other operation on penis;yes;no
urinary;TES3;Testis resection or excision;yes;no
urinary;URE2;Endoscopic operation on ureter;one day;no
urinary;URT2;Endoscopic operation on urethra;one day;no
urinary;TES2;Minor operation on testis;one day;no
urinary;VES2;Endoscopic operation on bladder;one day;no
urinary;PEN2;Circumcision;one day;no
urinary;VES1;Bladder endoscopy;no;no
urinary;REN2;Renal dialysis;one day;yes
digestive;OES3;Major operation on esophagus;yes;yes
digestive;STO5;Resection or anastomosis of stomach;yes;no
digestive;STO4;Gastrostomy;yes;no
digestive;INT4;Resection or anastomosis of small intestine;yes;yes
digestive;INT3;Other major operation on small intestine;yes;yes
digestive;INC4;Colostomy;yes;no
digestive;INC3;Major operation on large intestine, except colostomy;yes;no
digestive;REC3;Major operation on rectum;yes;no
digestive;ANP2;Other operation of intestinal stoma;yes;no
digestive;DIA2;Operation on diaphragm;yes;yes
digestive;PER2;Operation on peritoneum;yes;no
digestive;STO3;Other open operation on stomach;yes;no
digestive;ABD5;Major operation on abdominal wall;yes;no
digestive;APP2;Operation on appendix;yes;no
digestive;ABD4;Repair of other abdominal hernia;yes;no
digestive;ABD3;Repair of inguinal or crural hernia;one day;no
digestive;OES2;Minor operation on esophagus;yes;no
digestive;ABD2;Repair of umbilical hernia without prosthesis;yes;no
digestive;STO2;Endoscopic operation on stomach;one day;no
digestive;INT2;Minor operation on small intestine;one day;no
digestive;INC2;Minor operation on large intestine;one day;no
digestive;REC2;Minor operation on rectum;yes;no
digestive;ANU4;Major operation on anus;yes;no
digestive;ANU3;Minor operation on anus;one day;no
digestive;ANU2;Procedures on hemorrhoids;one day;no
digestive;OES1;Esophagoscopy;no;no
digestive;STO1;Gastroscopy;one day;no
digestive;INT1;Endoscopy of small intestine;no;no
digestive;INC1;Endoscopy of large intestine;no;no
digestive;ABD1;Laparoscopy;one day;no
hepatic;HEP4;Liver transplantation;yes;yes
hepatic;PAN2;Operation on pancreas;yes;yes
hepatic;HEP3;Major operation on liver;yes;yes
hepatic;BIL5;Other operation on biliary tract;yes;no
hepatic;BIL4;Open cholecystectomy;yes;no
hepatic;BIL3;Endoscopic operation on biliary tract;one day;no
hepatic;HEP2;Minor operation on liver;one day;no
hepatic;BIL2;Laparoscopic cholecystectomy;yes;no
hepatic;BIL1;Biliary tract endoscopy;one day;no
endocrine;THR3;Operation on thyroïd or parathyroid;yes;no
endocrine;THR2;Thyroid biopsy;one day;no
blood;LIE2;Operation on spleen;yes;yes
blood;LYM3;Radical excision of lymph;yes;no
blood;LYM2;Operation on lymphatic nodes;one day;no
blood;SAN2;Operation on the blood marrow;one day;no
blood;SAN1;Transfusion;one day;yes
locomotion;CRU4;Lower limb amputation;yes;yes
locomotion;COL3;Major operation on spinal structure;yes;no
locomotion;COX5;Hip replacement;yes;no
locomotion;COX4;Other major operation on hip;yes;no
locomotion;SCA3;Shoulder prosthesis;yes;no
locomotion;PED4;Toe amputation;yes;no
locomotion;GEN4;Open operation on knee;yes;no
locomotion;CRU3;Other major operation on leg;yes;no
locomotion;PED3;Major operation on foot;yes;no
locomotion;ART3;Major operation on joint;yes;no
locomotion;COL2;Minor operation on spinal structure;yes;no
locomotion;COX3;Minor operation on hip;yes;no
locomotion;BRA4;Other operation on arm;yes;no
locomotion;CRU2;Minor operation on leg;yes;no
locomotion;SCA2;Operation of shoulder;yes;no
locomotion;BRA3;Other operation of forearm;yes;no
locomotion;MUS2;Excision or suture of muscle;yes;no
locomotion;MUS3;Other operation on muscle;yes;no
locomotion;ART2;Minor operation on joint;yes;no
locomotion;MAN3;Major operation on hand;yes;no
locomotion;DIG3;Major operation on fingers;yes;no
locomotion;COX2;Closed reduction of hip dislocation;yes;no
locomotion;OSS6;External fixator device;yes;no
locomotion;OSS5;Other operation on unspecified bone;yes;no
locomotion;OSS4;Excision of unspecified bone;yes;no
locomotion;OSS3;Removal of internal fixation device;yes;no
locomotion;GEN2;Excision of knee structures;one day;no
locomotion;GEN3;Other arthroscopic operation on knee;one day;no
locomotion;MAN2;Minor operation on hand;one day;no
locomotion;DIG2;Minor operation on fingers;one day;no
locomotion;OSS2;Bone biopsy;one day;no
locomotion;PED2;Minor operation on foot;one day;no
locomotion;BRA2;Closed reduction of upper limb fracture;no;no
locomotion;ART1;Arthroscopy or arthrocentesis;no;no
female;VAG2;Operation on vagina;yes;no
female;MAM4;Resection of breast with lymph nodes excision;yes;no
female;MAM3;Resection of breast without lymph nodes excision;yes;no
female;MAM5;Mammoplasty;yes;no
female;UTE3;Major operation on uterus;yes;no
female;OVA3;Major operation on ovary;yes;no
female;VUL3;Other operation on vulva;yes;no
female;VUL2;Incision or excision of the vulva;one day;no
female;MAM2;Minor operation on breast;yes;no
female;OVA2;Minor operation on ovary;yes;no
female;UTE2;Minor operation on uterus;one day;no
cutaneous;CUT4;Skin graft with flap;yes;no
cutaneous;CUT3;Skin graft without flap;yes;no
cutaneous;CUT2;Debridement;one day;no
cutaneous;CUT1;Minor operation on tegument;one day;no
ocular;ORB2;Operation on orbit;yes;no
ocular;OCU3;Major operation on eyeball;yes;no
ocular;CAP3;Major operation on posterior chamber;yes;no
ocular;CON3;Corneal graft;yes;no
ocular;OCU2;Minor operation on eyeball;one day;no
ocular;CAP2;Minor operation on posterior chamber;one day;no
ocular;CRY2;Operation on lens;one day;no
ocular;CAA2;Operation on anterior chamber;one day;no
ocular;CON2;Operation on conjunctiva;one day;no
ocular;PAL2;Operation on eyelid;one day;no
ORL;PHA3;Major operation on pharynx;yes;no
ORL;BUC3;Major operation on mouth;yes;no
ORL;LAR3;Major operation on larynx;yes;yes
ORL;FAC3;Major operation on facial bones;yes;no
ORL;AUE5;Cochlear implant;yes;no
ORL;AUE4;Major operation on ear;yes;no
ORL;NAS4;Major operation on nose;yes;no
ORL;SIN2;Operation on sinus;yes;no
ORL;FAC2;Minor operation on facial bones;yes;no
ORL;LAR2;Minor operation on larynx;one day;no
ORL;BUC2;Minor operation on mouth;one day;no
ORL;AUE2;Operation of tympan;one day;no
ORL;AUE3;Minor operation on ear;one day;no
ORL;NAS3;Other operation on nose;one day;no
ORL;PHA2;Minor operation on pharynx;one day;no
ORL;SAL2;Operation on salivary glands;yes;no
ORL;TON2;Operation on tonsil, except resection;one day;no
ORL;DEN2;Other operation on teeth;one day;no
ORL;NAS2;Control of epistaxis;yes;no
ORL;ORL1;ORL endoscopy;no;no
ORL;DEN1;Tooth extraction;no;no
© Yves Eggli, 2018. Last update: 31.12.2019;;;;