--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, '_SNOMEDSpecimen', '1.2.40.0.34.5.173', 'SNOMED Specimen Type'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (2, '119297000', '2.16.840.1.113883.6.96', 'Blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (3, '446131002', '2.16.840.1.113883.6.96', 'Blood specimen obtained for blood culture'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (4, '445295009', '2.16.840.1.113883.6.96', 'Blood specimen with edetic acid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (5, '708049000', '2.16.840.1.113883.6.96', 'Plasma specimen with ethylenediamine tetraacetic acid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (6, '708048008', '2.16.840.1.113883.6.96', 'Plasma specimen with citrate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (7, '441510007', '2.16.840.1.113883.6.96', 'Blood specimen with anticoagulant'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (8, '119361006', '2.16.840.1.113883.6.96', 'Plasma specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (9, '122590004', '2.16.840.1.113883.6.96', 'Serum specimen from patient'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (10, '122552005', '2.16.840.1.113883.6.96', 'Arterial blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (11, '122554006', '2.16.840.1.113883.6.96', 'Capillary blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (12, '122555007', '2.16.840.1.113883.6.96', 'Venous blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (13, '122556008', '2.16.840.1.113883.6.96', 'Cord blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (14, '788707000', '2.16.840.1.113883.6.96', 'Plasma specimen or serum specimen or whole blood specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (15, '258580003', '2.16.840.1.113883.6.96', 'Whole blood sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (16, '258603007', '2.16.840.1.113883.6.96', 'Respiratory sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (17, '410580001', '2.16.840.1.113883.6.96', 'Respiratory fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (18, '309164002', '2.16.840.1.113883.6.96', 'Upper respiratory swab sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (19, '258606004', '2.16.840.1.113883.6.96', 'Lower respiratory sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (20, '258607008', '2.16.840.1.113883.6.96', 'Bronchoalveolar lavage fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (21, '258446004', '2.16.840.1.113883.6.96', 'Bronchial fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (22, '122610009', '2.16.840.1.113883.6.96', 'Specimen from lung obtained by biopsy'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (23, '445297001', '2.16.840.1.113883.6.96', 'Swab of internal nose'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (24, '168141000', '2.16.840.1.113883.6.96', 'Nasal fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (25, '258500001', '2.16.840.1.113883.6.96', 'Nasopharyngeal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (26, '258411007', '2.16.840.1.113883.6.96', 'Nasopharyngeal aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (27, '258529004', '2.16.840.1.113883.6.96', 'Throat swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (28, '258469001', '2.16.840.1.113883.6.96', 'Pharyngeal washings'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (29, '119334006', '2.16.840.1.113883.6.96', 'Sputum specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (30, '697989009', '2.16.840.1.113883.6.96', 'Anterior nares swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (31, '472867001', '2.16.840.1.113883.6.96', 'Swab from tonsil'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (32, '445447003', '2.16.840.1.113883.6.96', 'Specimen from trachea obtained by aspiration'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (33, '16223051000119101', '2.16.840.1.113883.6.96', 'Nasal sinus contents sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (34, '433324003', '2.16.840.1.113883.6.96', 'Specimen from eye region'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (35, '445160003', '2.16.840.1.113883.6.96', 'Swab of eye'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (36, '472894002', '2.16.840.1.113883.6.96', 'Swab from cornea'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (37, '258438000', '2.16.840.1.113883.6.96', 'Vitreous humor sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (38, '258498002', '2.16.840.1.113883.6.96', 'Conjunctival swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (39, '440473005', '2.16.840.1.113883.6.96', 'Contact lens submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (40, '472927003', '2.16.840.1.113883.6.96', 'Contact lens case submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (41, '16212771000119105', '2.16.840.1.113883.6.96', 'Specimen from eyelid obtained by biopsy'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (42, '309165001', '2.16.840.1.113883.6.96', 'Ear sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (43, '258466008', '2.16.840.1.113883.6.96', 'Middle ear fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (44, '472901003', '2.16.840.1.113883.6.96', 'Swab from nasal sinus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (45, '309166000', '2.16.840.1.113883.6.96', 'Ear swab sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (46, '122580007', '2.16.840.1.113883.6.96', 'Cerumen specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (47, '258412000', '2.16.840.1.113883.6.96', 'Oropharyngeal aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (48, '127465007', '2.16.840.1.113883.6.96', 'Specimen from gastrointestinal tract'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (49, '258662004', '2.16.840.1.113883.6.96', 'Adhesive slide'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (50, '258527002', '2.16.840.1.113883.6.96', 'Anal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (51, '309225009', '2.16.840.1.113883.6.96', 'Colonic biopsy sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (52, '122574004', '2.16.840.1.113883.6.96', 'Duodenal fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (53, '449446003', '2.16.840.1.113883.6.96', 'Specimen from gallbladder'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (54, '119341000', '2.16.840.1.113883.6.96', 'Bile specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (55, '309211008', '2.16.840.1.113883.6.96', 'Gastric biopsy sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (56, '258459007', '2.16.840.1.113883.6.96', 'Gastric fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (57, '418932006', '2.16.840.1.113883.6.96', 'Oral swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (58, '309210009', '2.16.840.1.113883.6.96', 'Esophageal brushings sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (59, '472886009', '2.16.840.1.113883.6.96', 'Swab from gastrostomy stoma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (60, '258525005', '2.16.840.1.113883.6.96', 'Perineal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (61, '168140004', '2.16.840.1.113883.6.96', 'Peritoneal dialysate sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (62, '168139001', '2.16.840.1.113883.6.96', 'Peritoneal fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (63, '258528007', '2.16.840.1.113883.6.96', 'Rectal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (64, '119339001', '2.16.840.1.113883.6.96', 'Stool specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (65, '472866005', '2.16.840.1.113883.6.96', 'Swab from tongue'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (66, '258570002', '2.16.840.1.113883.6.96', 'Genitourinary sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (67, '258524009', '2.16.840.1.113883.6.96', 'Cervical swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (68, '708112008', '2.16.840.1.113883.6.96', 'Retrouterine pouch fluid aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (69, '258508008', '2.16.840.1.113883.6.96', 'Genital swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (70, '258512002', '2.16.840.1.113883.6.96', 'Glans penis swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (71, '119347001', '2.16.840.1.113883.6.96', 'Seminal fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (72, '258511009', '2.16.840.1.113883.6.96', 'Penile urethral swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (73, '258520000', '2.16.840.1.113883.6.96', 'Vaginal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (74, '258523003', '2.16.840.1.113883.6.96', 'Vulval swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (75, '446130001', '2.16.840.1.113883.6.96', 'Urine specimen from bladder'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (76, '446846006', '2.16.840.1.113883.6.96', 'Urine specimen obtained via indwelling urinary catheter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (77, '16221251000119108', '2.16.840.1.113883.6.96', 'Urine specimen obtained via straight catheter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (78, '698276005', '2.16.840.1.113883.6.96', 'First stream urine sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (79, '122575003', '2.16.840.1.113883.6.96', 'Urine specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (80, '122565001', '2.16.840.1.113883.6.96', 'Urinary catheter specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (81, '258574006', '2.16.840.1.113883.6.96', 'Mid-stream urine sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (82, '442173007', '2.16.840.1.113883.6.96', 'Urine specimen from nephrostomy tube'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (83, '444937002', '2.16.840.1.113883.6.96', 'Urine specimen from ureter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (84, '702701006', '2.16.840.1.113883.6.96', 'Specimen from cervix or vagina'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (85, '127476006', '2.16.840.1.113883.6.96', 'Specimen from fallopian tube'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (86, '258548000', '2.16.840.1.113883.6.96', 'Dermatological sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (87, '445364004', '2.16.840.1.113883.6.96', 'Swab of axilla'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (88, '472896000', '2.16.840.1.113883.6.96', 'Swab from blister'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (89, '119326000', '2.16.840.1.113883.6.96', 'Hair specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (90, '258503004', '2.16.840.1.113883.6.96', 'Skin swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (91, '258549008', '2.16.840.1.113883.6.96', 'Skin scale sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (92, '445444005', '2.16.840.1.113883.6.96', 'Swab of groin'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (93, '445367006', '2.16.840.1.113883.6.96', 'Swab of umbilicus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (94, '119327009', '2.16.840.1.113883.6.96', 'Nail specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (95, '447098004', '2.16.840.1.113883.6.96', 'Specimen from nail obtained by scraping'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (96, '119365002', '2.16.840.1.113883.6.96', 'Specimen from wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (97, '472882006', '2.16.840.1.113883.6.96', 'Swab from superficial wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (98, '472884007', '2.16.840.1.113883.6.96', 'Swab from deep wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (99, '122568004', '2.16.840.1.113883.6.96', 'Fluid specimen from wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (100, '258539005', '2.16.840.1.113883.6.96', 'Bone and joint sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (101, '258448003', '2.16.840.1.113883.6.96', 'Bursa fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (102, '309124001', '2.16.840.1.113883.6.96', 'Joint biopsy sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (103, '431361003', '2.16.840.1.113883.6.96', 'Joint fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (104, '430268003', '2.16.840.1.113883.6.96', 'Specimen from bone'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (105, '119359002', '2.16.840.1.113883.6.96', 'Bone marrow specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (106, '258415003', '2.16.840.1.113883.6.96', 'Biopsy sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (107, '258497007', '2.16.840.1.113883.6.96', 'Abscess swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (108, '446972001', '2.16.840.1.113883.6.96', 'Specimen from abscess obtained by aspiration'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (109, '309201001', '2.16.840.1.113883.6.96', 'Ascitic fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (110, '119295008', '2.16.840.1.113883.6.96', 'Specimen obtained by aspiration'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (111, '258455001', '2.16.840.1.113883.6.96', 'Drainage fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (112, '119373006', '2.16.840.1.113883.6.96', 'Amniotic fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (113, '258588005', '2.16.840.1.113883.6.96', 'Hematoma sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (114, '16211011000119108', '2.16.840.1.113883.6.96', 'Specimen from deep surgical wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (115, '258450006', '2.16.840.1.113883.6.96', 'Cerebrospinal fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (116, '309078004', '2.16.840.1.113883.6.96', 'Lymph node tissue sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (117, '122571007', '2.16.840.1.113883.6.96', 'Pericardial fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (118, '418564007', '2.16.840.1.113883.6.96', 'Pleural fluid specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (119, '127454002', '2.16.840.1.113883.6.96', 'Device specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (120, '258647001', '2.16.840.1.113883.6.96', 'Drain tip'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (121, '258540007', '2.16.840.1.113883.6.96', 'Prosthetic joint sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (122, '473415003', '2.16.840.1.113883.6.96', 'Intrauterine contraceptive device submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (123, '472932002', '2.16.840.1.113883.6.96', 'Vascular catheter submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (124, '119312009', '2.16.840.1.113883.6.96', 'Catheter tip specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (125, '472919007', '2.16.840.1.113883.6.96', 'Device submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (126, '472938003', '2.16.840.1.113883.6.96', 'Tracheal tube submitted as specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (127, '123038009', '2.16.840.1.113883.6.96', 'Specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (128, '257261003', '2.16.840.1.113883.6.96', 'Swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (129, '258454002', '2.16.840.1.113883.6.96', 'Dialysate sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (130, '119303007', '2.16.840.1.113883.6.96', 'Microbial isolate specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (131, '119328004', '2.16.840.1.113883.6.96', 'Mothers milk specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (132, '258441009', '2.16.840.1.113883.6.96', 'Exudate sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (133, '119323008', '2.16.840.1.113883.6.96', 'Pus specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (134, '258442002', '2.16.840.1.113883.6.96', 'Fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (135, '708317005', '2.16.840.1.113883.6.96', 'Pooled specimen from vaginal introitus and rectal swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (136, '309051001', '2.16.840.1.113883.6.96', 'Body fluid sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (137, '119376003', '2.16.840.1.113883.6.96', 'Tissue specimen'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (138, '119324002', '2.16.840.1.113883.6.96', 'Specimen of unknown material '); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (139, '408836004', '2.16.840.1.113883.6.96', 'Sample not obtained'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (140, '_HL7Specimen', '1.2.40.0.34.5.173', 'HL7 Specimen Type'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (141, 'ABS', '2.16.840.1.113883.5.129', 'Abcess'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (142, 'AMN', '2.16.840.1.113883.5.129', 'Amniotic fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (143, 'ASP', '2.16.840.1.113883.5.129', 'Aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (144, 'BBL', '2.16.840.1.113883.5.129', 'Blood bag'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (145, 'BDY', '2.16.840.1.113883.5.129', 'Whole body'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (146, 'BIFL', '2.16.840.1.113883.5.129', 'Bile fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (147, 'BLD', '2.16.840.1.113883.5.129', 'Whole blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (148, 'BLDA', '2.16.840.1.113883.5.129', 'Blood arterial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (149, 'BLDC', '2.16.840.1.113883.5.129', 'Blood capillary'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (150, 'BLDCO', '2.16.840.1.113883.5.129', 'Blood - cord'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (151, 'BLDV', '2.16.840.1.113883.5.129', 'Blood venous'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (152, 'BON', '2.16.840.1.113883.5.129', 'Bone'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (153, 'BPH', '2.16.840.1.113883.5.129', 'Basophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (154, 'BPU', '2.16.840.1.113883.5.129', 'Blood product unit'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (155, 'BRN', '2.16.840.1.113883.5.129', 'Burn'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (156, 'BRO', '2.16.840.1.113883.5.129', 'Bronchial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (157, 'BRTH', '2.16.840.1.113883.5.129', 'Exhaled gas (=breath) Breath (use EXG)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (158, 'CALC', '2.16.840.1.113883.5.129', 'Calculus (=Stone) Stone (use CALC)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (159, 'CDM', '2.16.840.1.113883.5.129', 'Cardiac muscle'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (160, 'CNJT', '2.16.840.1.113883.5.129', 'Conjunctiva'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (161, 'CNL', '2.16.840.1.113883.5.129', 'Cannula'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (162, 'COL', '2.16.840.1.113883.5.129', 'Colostrum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (163, 'CRN', '2.16.840.1.113883.5.129', 'Cornea'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (164, 'CSF', '2.16.840.1.113883.5.129', 'Cerebral spinal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (165, 'CTP', '2.16.840.1.113883.5.129', 'Catheter tip'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (166, 'CUR', '2.16.840.1.113883.5.129', 'Curettage'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (167, 'CVM', '2.16.840.1.113883.5.129', 'Cervical mucus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (168, 'CVX', '2.16.840.1.113883.5.129', 'Cervix'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (169, 'CYST', '2.16.840.1.113883.5.129', 'Cyst'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (170, 'DIAF', '2.16.840.1.113883.5.129', 'Dialysis fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (171, 'DOSE', '2.16.840.1.113883.5.129', 'Dose med or substance'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (172, 'DRN', '2.16.840.1.113883.5.129', 'Drain'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (173, 'DUFL', '2.16.840.1.113883.5.129', 'Duodenal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (174, 'EAR', '2.16.840.1.113883.5.129', 'Ear'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (175, 'EARW', '2.16.840.1.113883.5.129', 'Ear wax (cerumen)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (176, 'ELT', '2.16.840.1.113883.5.129', 'Electrode'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (177, 'ENDC', '2.16.840.1.113883.5.129', 'Endocardium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (178, 'ENDM', '2.16.840.1.113883.5.129', 'Endometrium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (179, 'EOS', '2.16.840.1.113883.5.129', 'Eosinophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (180, 'EXG', '2.16.840.1.113883.5.129', 'Exhaled gas (=breath) Breath (use EXG)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (181, 'EYE', '2.16.840.1.113883.5.129', 'Eye'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (182, 'FIB', '2.16.840.1.113883.5.129', 'Fibroblasts'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (183, 'FIST', '2.16.840.1.113883.5.129', 'Fistula'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (184, 'FLT', '2.16.840.1.113883.5.129', 'Filter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (185, 'FLU', '2.16.840.1.113883.5.129', 'Body fluid, unsp'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (186, 'FOOD', '2.16.840.1.113883.5.129', 'Food sample'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (187, 'GAS', '2.16.840.1.113883.5.129', 'Gas'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (188, 'GAST', '2.16.840.1.113883.5.129', 'Gastric fluid/contents'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (189, 'GEN', '2.16.840.1.113883.5.129', 'Genital'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (190, 'GENC', '2.16.840.1.113883.5.129', 'Genital cervix'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (191, 'GENF', '2.16.840.1.113883.5.129', 'Genital fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (192, 'GENL', '2.16.840.1.113883.5.129', 'Genital lochia'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (193, 'GENV', '2.16.840.1.113883.5.129', 'Genital vaginal'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (194, 'HAR', '2.16.840.1.113883.5.129', 'Hair'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (195, 'IHG', '2.16.840.1.113883.5.129', 'Inhaled Gas'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (196, 'ISLT', '2.16.840.1.113883.5.129', 'Isolate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (197, 'IT', '2.16.840.1.113883.5.129', 'Intubation tube'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (198, 'LAM', '2.16.840.1.113883.5.129', 'Lamella'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (199, 'LIQ', '2.16.840.1.113883.5.129', 'Liquid NOS'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (200, 'LN', '2.16.840.1.113883.5.129', 'Line'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (201, 'LNA', '2.16.840.1.113883.5.129', 'Line arterial'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (202, 'LNV', '2.16.840.1.113883.5.129', 'Line venous'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (203, 'LYM', '2.16.840.1.113883.5.129', 'Lymphocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (204, 'MAC', '2.16.840.1.113883.5.129', 'Macrophages'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (205, 'MAR', '2.16.840.1.113883.5.129', 'Marrow (bone)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (206, 'MBLD', '2.16.840.1.113883.5.129', 'Menstrual blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (207, 'MEC', '2.16.840.1.113883.5.129', 'Meconium'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (208, 'MILK', '2.16.840.1.113883.5.129', 'Breast milk'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (209, 'MLK', '2.16.840.1.113883.5.129', 'Milk'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (210, 'NAIL', '2.16.840.1.113883.5.129', 'Nail'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (211, 'NOS', '2.16.840.1.113883.5.129', 'Nose (nasal passage)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (212, 'PAFL', '2.16.840.1.113883.5.129', 'Pancreatic fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (213, 'PAT', '2.16.840.1.113883.5.129', 'Patient'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (214, 'PLAS', '2.16.840.1.113883.5.129', 'Plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (215, 'PLB', '2.16.840.1.113883.5.129', 'Plasma bag'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (216, 'PLC', '2.16.840.1.113883.5.129', 'Placenta'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (217, 'PLR', '2.16.840.1.113883.5.129', 'Pleural fluid (thoracentesis fld)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (218, 'PMN', '2.16.840.1.113883.5.129', 'Polymorphonuclear neutrophils'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (219, 'PPP', '2.16.840.1.113883.5.129', 'Platelet poor plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (220, 'PRP', '2.16.840.1.113883.5.129', 'Platelet rich plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (221, 'PRT', '2.16.840.1.113883.5.129', 'Peritoneal fluid /ascites'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (222, 'PUS', '2.16.840.1.113883.5.129', 'Pus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (223, 'RBC', '2.16.840.1.113883.5.129', 'Erythrocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (224, 'SAL', '2.16.840.1.113883.5.129', 'Saliva'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (225, 'SER', '2.16.840.1.113883.5.129', 'Serum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (226, 'SKM', '2.16.840.1.113883.5.129', 'Skeletal muscle'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (227, 'SKN', '2.16.840.1.113883.5.129', 'Skin'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (228, 'SMN', '2.16.840.1.113883.5.129', 'Seminal fluid'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (229, 'SMPLS', '2.16.840.1.113883.5.129', 'Seminal plasma'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (230, 'SNV', '2.16.840.1.113883.5.129', 'Synovial fluid (Joint fluid)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (231, 'SPRM', '2.16.840.1.113883.5.129', 'Spermatozoa'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (232, 'SPT', '2.16.840.1.113883.5.129', 'Sputum'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (233, 'SPTC', '2.16.840.1.113883.5.129', 'Sputum - coughed'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (234, 'SPTT', '2.16.840.1.113883.5.129', 'Sputum - tracheal aspirate'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (235, 'STL', '2.16.840.1.113883.5.129', 'Stool = Fecal'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (236, 'STON', '2.16.840.1.113883.5.129', 'Calculus (=Stone) Stone (use CALC)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (237, 'SWAB', '1.2.40.0.34.5.173', 'Swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (238, 'SWT', '2.16.840.1.113883.5.129', 'Sweat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (239, 'TEAR', '2.16.840.1.113883.5.129', 'Tears'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (240, 'THRB', '2.16.840.1.113883.5.129', 'Thrombocyte (platelet)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (241, 'THRT', '2.16.840.1.113883.5.129', 'Throat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (242, 'TISG', '2.16.840.1.113883.5.129', 'Tissue gall bladder'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (243, 'TISPL', '2.16.840.1.113883.5.129', 'Tissue placenta'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (244, 'TISS', '2.16.840.1.113883.5.129', 'Tissue, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (245, 'TISU', '2.16.840.1.113883.5.129', 'Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (246, 'TLGI', '2.16.840.1.113883.5.129', 'Tissue large intestine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (247, 'TLNG', '2.16.840.1.113883.5.129', 'Tissue lung'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (248, 'TSMI', '2.16.840.1.113883.5.129', 'Tissue small intestine Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (249, 'TUB', '2.16.840.1.113883.5.129', 'Tube, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (250, 'ULC', '2.16.840.1.113883.5.129', 'Ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (251, 'UMB', '2.16.840.1.113883.5.129', 'Umbilical blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (252, 'UMED', '2.16.840.1.113883.5.129', 'Unknown medicine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (253, 'UR', '2.16.840.1.113883.5.129', 'Urine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (254, 'URC', '2.16.840.1.113883.5.129', 'Urine clean catch'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (255, 'URNS', '2.16.840.1.113883.5.129', 'Urine sediment'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (256, 'URT', '2.16.840.1.113883.5.129', 'Urine catheter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (257, 'URTH', '2.16.840.1.113883.5.129', 'Urethra'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (258, 'USUB', '2.16.840.1.113883.5.129', 'Unknown substance'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (259, 'VOM', '2.16.840.1.113883.5.129', 'Vomitus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (260, 'WAT', '2.16.840.1.113883.5.129', 'Water'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (261, 'WBC', '2.16.840.1.113883.5.129', 'Leukocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (262, 'WICK', '2.16.840.1.113883.5.129', 'Wick'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (263, 'WND', '2.16.840.1.113883.5.129', 'Wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (264, 'WNDA', '2.16.840.1.113883.5.129', 'Wound abscess'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (265, 'WNDD', '2.16.840.1.113883.5.129', 'Wound drainage'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (266, 'WNDE', '2.16.840.1.113883.5.129', 'Wound exudate'); --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', 'Exhaled gas (=breath) Breath (use EXG)'); 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', 'Exhaled gas (=breath) Breath (use EXG)'); 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, 'SWAB', '1.2.40.0.34.5.173', 'Swab'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (98, 'SWT', '2.16.840.1.113883.5.129', 'Sweat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (99, 'TEAR', '2.16.840.1.113883.5.129', 'Tears'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (100, 'THRB', '2.16.840.1.113883.5.129', 'Thrombocyte (platelet)'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (101, 'THRT', '2.16.840.1.113883.5.129', 'Throat'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (102, 'TISG', '2.16.840.1.113883.5.129', 'Tissue gall bladder'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (103, 'TISPL', '2.16.840.1.113883.5.129', 'Tissue placenta'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (104, 'TISS', '2.16.840.1.113883.5.129', 'Tissue, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (105, 'TISU', '2.16.840.1.113883.5.129', 'Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (106, 'TLGI', '2.16.840.1.113883.5.129', 'Tissue large intestine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (107, 'TLNG', '2.16.840.1.113883.5.129', 'Tissue lung'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (108, 'TSMI', '2.16.840.1.113883.5.129', 'Tissue small intestine Tissue ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (109, 'TUB', '2.16.840.1.113883.5.129', 'Tube, unspecified'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (110, 'ULC', '2.16.840.1.113883.5.129', 'Ulcer'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (111, 'UMB', '2.16.840.1.113883.5.129', 'Umbilical blood'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (112, 'UMED', '2.16.840.1.113883.5.129', 'Unknown medicine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (113, 'UR', '2.16.840.1.113883.5.129', 'Urine'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (114, 'URC', '2.16.840.1.113883.5.129', 'Urine clean catch'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (115, 'URNS', '2.16.840.1.113883.5.129', 'Urine sediment'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (116, 'URT', '2.16.840.1.113883.5.129', 'Urine catheter'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (117, 'URTH', '2.16.840.1.113883.5.129', 'Urethra'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (118, 'USUB', '2.16.840.1.113883.5.129', 'Unknown substance'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (119, 'VOM', '2.16.840.1.113883.5.129', 'Vomitus'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (120, 'WAT', '2.16.840.1.113883.5.129', 'Water'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (121, 'WBC', '2.16.840.1.113883.5.129', 'Leukocytes'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (122, 'WICK', '2.16.840.1.113883.5.129', 'Wick'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (123, 'WND', '2.16.840.1.113883.5.129', 'Wound'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (124, 'WNDA', '2.16.840.1.113883.5.129', 'Wound abscess'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (125, 'WNDD', '2.16.840.1.113883.5.129', 'Wound drainage'); INSERT INTO ELGA_SpecimenType (ELGA_SpecimenType_id, code, codeSystem, displayName) VALUES (126, 'WNDE', '2.16.840.1.113883.5.129', 'Wound exudate'); --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');