--DROP TABLE ELGA_SpecimenType CASCADE; CREATE TABLE ELGA_SpecimenType ( ELGA_SpecimenType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (1, 'ABS', '2.16.840.1.113883.5.129', 'Abcess'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (2, 'AMN', '2.16.840.1.113883.5.129', 'Amniotic fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (3, 'ASP', '2.16.840.1.113883.5.129', 'Aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (4, 'BBL', '2.16.840.1.113883.5.129', 'Blood bag'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (5, 'BDY', '2.16.840.1.113883.5.129', 'Whole body'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (6, 'BIFL', '2.16.840.1.113883.5.129', 'Bile fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (7, 'BLD', '2.16.840.1.113883.5.129', 'Whole blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (8, 'BLDA', '2.16.840.1.113883.5.129', 'Blood arterial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (9, 'BLDC', '2.16.840.1.113883.5.129', 'Blood capillary'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (10, 'BLDCO', '2.16.840.1.113883.5.129', 'Blood - cord'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (11, 'BLDV', '2.16.840.1.113883.5.129', 'Blood venous'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (12, 'BON', '2.16.840.1.113883.5.129', 'Bone'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (13, 'BPH', '2.16.840.1.113883.5.129', 'Basophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (14, 'BPU', '2.16.840.1.113883.5.129', 'Blood product unit'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (15, 'BRN', '2.16.840.1.113883.5.129', 'Burn'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (16, 'BRO', '2.16.840.1.113883.5.129', 'Bronchial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (17, 'BRTH', '2.16.840.1.113883.5.129', 'Breath (use EXG) Exhaled gas (=breath)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (18, 'CALC', '2.16.840.1.113883.5.129', 'Calculus (=Stone) Stone (use CALC)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (19, 'CDM', '2.16.840.1.113883.5.129', 'Cardiac muscle'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (20, 'CNJT', '2.16.840.1.113883.5.129', 'Conjunctiva'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (21, 'CNL', '2.16.840.1.113883.5.129', 'Cannula'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (22, 'COL', '2.16.840.1.113883.5.129', 'Colostrum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (23, 'CRN', '2.16.840.1.113883.5.129', 'Cornea'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (24, 'CSF', '2.16.840.1.113883.5.129', 'Cerebral spinal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (25, 'CTP', '2.16.840.1.113883.5.129', 'Catheter tip'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (26, 'CUR', '2.16.840.1.113883.5.129', 'Curettage'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (27, 'CVM', '2.16.840.1.113883.5.129', 'Cervical mucus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (28, 'CVX', '2.16.840.1.113883.5.129', 'Cervix'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (29, 'CYST', '2.16.840.1.113883.5.129', 'Cyst'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (30, 'DIAF', '2.16.840.1.113883.5.129', 'Dialysis fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (31, 'DOSE', '2.16.840.1.113883.5.129', 'Dose med or substance'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (32, 'DRN', '2.16.840.1.113883.5.129', 'Drain'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (33, 'DUFL', '2.16.840.1.113883.5.129', 'Duodenal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (34, 'EAR', '2.16.840.1.113883.5.129', 'Ear'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (35, 'EARW', '2.16.840.1.113883.5.129', 'Ear wax (cerumen)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (36, 'ELT', '2.16.840.1.113883.5.129', 'Electrode'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (37, 'ENDC', '2.16.840.1.113883.5.129', 'Endocardium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (38, 'ENDM', '2.16.840.1.113883.5.129', 'Endometrium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (39, 'EOS', '2.16.840.1.113883.5.129', 'Eosinophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (40, 'EXG', '2.16.840.1.113883.5.129', 'Breath (use EXG) Exhaled gas (=breath)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (41, 'EYE', '2.16.840.1.113883.5.129', 'Eye'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (42, 'FIB', '2.16.840.1.113883.5.129', 'Fibroblasts'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (43, 'FIST', '2.16.840.1.113883.5.129', 'Fistula'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (44, 'FLT', '2.16.840.1.113883.5.129', 'Filter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (45, 'FLU', '2.16.840.1.113883.5.129', 'Body fluid, unsp'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (46, 'FOOD', '2.16.840.1.113883.5.129', 'Food sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (47, 'GAS', '2.16.840.1.113883.5.129', 'Gas'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (48, 'GAST', '2.16.840.1.113883.5.129', 'Gastric fluid/contents'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (49, 'GEN', '2.16.840.1.113883.5.129', 'Genital'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (50, 'GENC', '2.16.840.1.113883.5.129', 'Genital cervix'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (51, 'GENF', '2.16.840.1.113883.5.129', 'Genital fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (52, 'GENL', '2.16.840.1.113883.5.129', 'Genital lochia'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (53, 'GENV', '2.16.840.1.113883.5.129', 'Genital vaginal'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (54, 'HAR', '2.16.840.1.113883.5.129', 'Hair'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (55, 'IHG', '2.16.840.1.113883.5.129', 'Inhaled Gas'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (56, 'ISLT', '2.16.840.1.113883.5.129', 'Isolate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (57, 'IT', '2.16.840.1.113883.5.129', 'Intubation tube'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (58, 'LAM', '2.16.840.1.113883.5.129', 'Lamella'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (59, 'LIQ', '2.16.840.1.113883.5.129', 'Liquid NOS'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (60, 'LN', '2.16.840.1.113883.5.129', 'Line'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (61, 'LNA', '2.16.840.1.113883.5.129', 'Line arterial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (62, 'LNV', '2.16.840.1.113883.5.129', 'Line venous'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (63, 'LYM', '2.16.840.1.113883.5.129', 'Lymphocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (64, 'MAC', '2.16.840.1.113883.5.129', 'Macrophages'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (65, 'MAR', '2.16.840.1.113883.5.129', 'Marrow (bone)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (66, 'MBLD', '2.16.840.1.113883.5.129', 'Menstrual blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (67, 'MEC', '2.16.840.1.113883.5.129', 'Meconium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (68, 'MILK', '2.16.840.1.113883.5.129', 'Breast milk'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (69, 'MLK', '2.16.840.1.113883.5.129', 'Milk'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (70, 'NAIL', '2.16.840.1.113883.5.129', 'Nail'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (71, 'NOS', '2.16.840.1.113883.5.129', 'Nose (nasal passage)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (72, 'PAFL', '2.16.840.1.113883.5.129', 'Pancreatic fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (73, 'PAT', '2.16.840.1.113883.5.129', 'Patient'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (74, 'PLAS', '2.16.840.1.113883.5.129', 'Plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (75, 'PLB', '2.16.840.1.113883.5.129', 'Plasma bag'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (76, 'PLC', '2.16.840.1.113883.5.129', 'Placenta'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (77, 'PLR', '2.16.840.1.113883.5.129', 'Pleural fluid (thoracentesis fld)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (78, 'PMN', '2.16.840.1.113883.5.129', 'Polymorphonuclear neutrophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (79, 'PPP', '2.16.840.1.113883.5.129', 'Platelet poor plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (80, 'PRP', '2.16.840.1.113883.5.129', 'Platelet rich plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (81, 'PRT', '2.16.840.1.113883.5.129', 'Peritoneal fluid /ascites'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (82, 'PUS', '2.16.840.1.113883.5.129', 'Pus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (83, 'RBC', '2.16.840.1.113883.5.129', 'Erythrocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (84, 'SAL', '2.16.840.1.113883.5.129', 'Saliva'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (85, 'SER', '2.16.840.1.113883.5.129', 'Serum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (86, 'SKM', '2.16.840.1.113883.5.129', 'Skeletal muscle'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (87, 'SKN', '2.16.840.1.113883.5.129', 'Skin'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (88, 'SMN', '2.16.840.1.113883.5.129', 'Seminal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (89, 'SMPLS', '2.16.840.1.113883.5.129', 'Seminal plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (90, 'SNV', '2.16.840.1.113883.5.129', 'Synovial fluid (Joint fluid)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (91, 'SPRM', '2.16.840.1.113883.5.129', 'Spermatozoa'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (92, 'SPT', '2.16.840.1.113883.5.129', 'Sputum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (93, 'SPTC', '2.16.840.1.113883.5.129', 'Sputum - coughed'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (94, 'SPTT', '2.16.840.1.113883.5.129', 'Sputum - tracheal aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (95, 'STL', '2.16.840.1.113883.5.129', 'Stool = Fecal'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (96, 'STON', '2.16.840.1.113883.5.129', 'Calculus (=Stone) Stone (use CALC)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (97, 'SWT', '2.16.840.1.113883.5.129', 'Sweat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (98, 'TEAR', '2.16.840.1.113883.5.129', 'Tears'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (99, 'THRB', '2.16.840.1.113883.5.129', 'Thrombocyte (platelet)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (100, 'THRT', '2.16.840.1.113883.5.129', 'Throat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (101, 'TISG', '2.16.840.1.113883.5.129', 'Tissue gall bladder'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (102, 'TISPL', '2.16.840.1.113883.5.129', 'Tissue placenta'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (103, 'TISS', '2.16.840.1.113883.5.129', 'Tissue, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (104, 'TISU', '2.16.840.1.113883.5.129', 'Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (105, 'TLGI', '2.16.840.1.113883.5.129', 'Tissue large intestine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (106, 'TLNG', '2.16.840.1.113883.5.129', 'Tissue lung'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (107, 'TSMI', '2.16.840.1.113883.5.129', 'Tissue small intestine Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (108, 'TUB', '2.16.840.1.113883.5.129', 'Tube, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (109, 'ULC', '2.16.840.1.113883.5.129', 'Ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (110, 'UMB', '2.16.840.1.113883.5.129', 'Umbilical blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (111, 'UMED', '2.16.840.1.113883.5.129', 'Unknown medicine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (112, 'UR', '2.16.840.1.113883.5.129', 'Urine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (113, 'URC', '2.16.840.1.113883.5.129', 'Urine clean catch'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (114, 'URNS', '2.16.840.1.113883.5.129', 'Urine sediment'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (115, 'URT', '2.16.840.1.113883.5.129', 'Urine catheter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (116, 'URTH', '2.16.840.1.113883.5.129', 'Urethra'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (117, 'USUB', '2.16.840.1.113883.5.129', 'Unknown substance'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (118, 'VOM', '2.16.840.1.113883.5.129', 'Vomitus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (119, 'WAT', '2.16.840.1.113883.5.129', 'Water'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (120, 'WBC', '2.16.840.1.113883.5.129', 'Leukocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (121, 'WICK', '2.16.840.1.113883.5.129', 'Wick'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (122, 'WND', '2.16.840.1.113883.5.129', 'Wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (123, 'WNDA', '2.16.840.1.113883.5.129', 'Wound abscess'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (124, 'WNDD', '2.16.840.1.113883.5.129', 'Wound drainage'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (125, 'WNDE', '2.16.840.1.113883.5.129', 'Wound exudate');