--DROP TABLE ELGA_Laborstruktur CASCADE; CREATE TABLE ELGA_Laborstruktur ( ELGA_Laborstruktur_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (1, '1', '1.2.40.0.34.5.11', 'Allgemeiner Laborbefund'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (2, '10', '1.2.40.0.34.5.11', 'Probeninformation'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (3, '100', '1.2.40.0.34.5.11', 'Blutgruppenserologie/Immungenetik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (4, '101', '1.2.40.0.34.5.11', 'Blutgruppenserologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (5, '102', '1.2.40.0.34.5.11', 'HLA-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (6, '103', '1.2.40.0.34.5.11', 'HPA-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (7, '200', '1.2.40.0.34.5.11', 'Blutgasanalyse'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (8, '201', '1.2.40.0.34.5.11', 'Blutgasanalyse Arteriell'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (9, '202', '1.2.40.0.34.5.11', 'Blutgasanalyse Venös'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (10, '203', '1.2.40.0.34.5.11', 'Blutgasanalyse Nabelschnurblut'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (11, '300', '1.2.40.0.34.5.11', 'Hämatologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (12, '301', '1.2.40.0.34.5.11', 'Blutbild'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (13, '302', '1.2.40.0.34.5.11', 'Knochenmark Morphologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (14, '303', '1.2.40.0.34.5.11', 'Immunphänotypisierung'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (15, '304', '1.2.40.0.34.5.11', 'Molekulare Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (16, '400', '1.2.40.0.34.5.11', 'Hämostaseologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (17, '401', '1.2.40.0.34.5.11', 'Hämostaseologie Globaltests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (18, '402', '1.2.40.0.34.5.11', 'Einzelfaktoranalysen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (19, '403', '1.2.40.0.34.5.11', 'Thrombophilie Tests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (20, '500', '1.2.40.0.34.5.11', 'Klinische Chemie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (21, '501', '1.2.40.0.34.5.11', 'Entzündungsmarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (22, '502', '1.2.40.0.34.5.11', 'Niere/Elektrolyte'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (23, '503', '1.2.40.0.34.5.11', 'Kardiale Marker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (24, '504', '1.2.40.0.34.5.11', 'Leber/Pankreas'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (25, '505', '1.2.40.0.34.5.11', 'Hämolysemarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (26, '506', '1.2.40.0.34.5.11', 'Eisenstoffwechsel'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (27, '507', '1.2.40.0.34.5.11', 'Glukosestoffwechsel'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (28, '508', '1.2.40.0.34.5.11', 'Fettstoffwechsel'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (29, '509', '1.2.40.0.34.5.11', 'Proteindiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (30, '600', '1.2.40.0.34.5.11', 'Endokrinologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (31, '601', '1.2.40.0.34.5.11', 'Adrenocortikales System'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (32, '602', '1.2.40.0.34.5.11', 'Katecholamine'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (33, '603', '1.2.40.0.34.5.11', 'Schilddrüsendiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (34, '604', '1.2.40.0.34.5.11', 'Geschlechtshormone'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (35, '605', '1.2.40.0.34.5.11', 'Glukosestoffwechsel'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (36, '606', '1.2.40.0.34.5.11', 'Endokrinologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (37, '700', '1.2.40.0.34.5.11', 'Vitamine'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (38, '701', '1.2.40.0.34.5.11', 'Vitamine'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (39, '800', '1.2.40.0.34.5.11', 'Tumormarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (40, '801', '1.2.40.0.34.5.11', 'Tumormarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (41, '900', '1.2.40.0.34.5.11', 'Toxikologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (42, '901', '1.2.40.0.34.5.11', 'HarnScreening'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (43, '902', '1.2.40.0.34.5.11', 'Blut'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (44, '1000', '1.2.40.0.34.5.11', 'TDM'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (45, '1001', '1.2.40.0.34.5.11', 'Antibiotika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (46, '1002', '1.2.40.0.34.5.11', 'Virostatika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (47, '1003', '1.2.40.0.34.5.11', 'Antiepileptika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (48, '1004', '1.2.40.0.34.5.11', 'Kardiaka'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (49, '1005', '1.2.40.0.34.5.11', 'Immunsuppressiva'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (50, '1006', '1.2.40.0.34.5.11', 'Sonstige'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (51, '1100', '1.2.40.0.34.5.11', 'Virologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (52, '1101', '1.2.40.0.34.5.11', 'HIV'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (53, '1102', '1.2.40.0.34.5.11', 'Hepatitis A'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (54, '1103', '1.2.40.0.34.5.11', 'Hepatitis B'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (55, '1104', '1.2.40.0.34.5.11', 'Hepatitis C'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (56, '1105', '1.2.40.0.34.5.11', 'Komplementbindungsreaktion'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (57, '1106', '1.2.40.0.34.5.11', 'Immunoassays'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (58, '1107', '1.2.40.0.34.5.11', 'PCR-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (59, '1108', '1.2.40.0.34.5.11', 'Schnelltests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (60, '1200', '1.2.40.0.34.5.11', 'Bakteriologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (61, '1201', '1.2.40.0.34.5.11', 'Syphilis-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (62, '1202', '1.2.40.0.34.5.11', 'STD'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (63, '1203', '1.2.40.0.34.5.11', 'Borrelienserologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (64, '1204', '1.2.40.0.34.5.11', 'Chl. Psitakii Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (65, '1205', '1.2.40.0.34.5.11', 'Schnelltests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (66, '1206', '1.2.40.0.34.5.11', 'Tuberkulose Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (67, '1207', '1.2.40.0.34.5.11', 'Mykoplasmen Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (68, '1208', '1.2.40.0.34.5.11', 'Malariasuche'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (69, '1300', '1.2.40.0.34.5.11', 'Autoantikörperdiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (70, '1301', '1.2.40.0.34.5.11', 'Rheumatoide Arthritis-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (71, '1302', '1.2.40.0.34.5.11', 'Kollagenose-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (72, '1303', '1.2.40.0.34.5.11', 'Lebererkrankungen-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (73, '1304', '1.2.40.0.34.5.11', 'Perniziöse Anämie assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (74, '1305', '1.2.40.0.34.5.11', 'Vasculitis-assoziierte Antikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (75, '1306', '1.2.40.0.34.5.11', 'Goodpasture Syndrom assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (76, '1307', '1.2.40.0.34.5.11', 'IBD assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (77, '1308', '1.2.40.0.34.5.11', 'Diabetes Mellitus assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (78, '1309', '1.2.40.0.34.5.11', 'Paraneoplasie assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (79, '1310', '1.2.40.0.34.5.11', 'Sonstige Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (80, '1400', '1.2.40.0.34.5.11', 'Harndiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (81, '1401', '1.2.40.0.34.5.11', 'Harnstreifen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (82, '1402', '1.2.40.0.34.5.11', 'Harnsediment'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (83, '1403', '1.2.40.0.34.5.11', 'Harnchemie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (84, '1404', '1.2.40.0.34.5.11', 'Katecholamine'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (85, '1405', '1.2.40.0.34.5.11', 'Kortikoide'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (86, '1500', '1.2.40.0.34.5.11', 'Stuhldiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (87, '1501', '1.2.40.0.34.5.11', 'Stuhldiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (88, '1600', '1.2.40.0.34.5.11', 'Liquordiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (89, '1601', '1.2.40.0.34.5.11', 'Liquordiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (90, '1700', '1.2.40.0.34.5.11', 'Sondermaterialien'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (91, '1701', '1.2.40.0.34.5.11', 'Sondermaterialien'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (92, '1702', '1.2.40.0.34.5.11', 'Peritonealdialysat'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (93, '1800', '1.2.40.0.34.5.11', 'Allergiediagnostik/Globalmarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (94, '1801', '1.2.40.0.34.5.11', 'Allergiediagnostik/Globalmarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (95, '1900', '1.2.40.0.34.5.11', 'Allergiediagnostik Spez. IGE'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (96, '1901', '1.2.40.0.34.5.11', 'Gräserpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (97, '1902', '1.2.40.0.34.5.11', 'Baumpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (98, '1903', '1.2.40.0.34.5.11', 'Kräuterpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (99, '1904', '1.2.40.0.34.5.11', 'Milben RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (100, '1905', '1.2.40.0.34.5.11', 'Epidermale Tierallergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (101, '1906', '1.2.40.0.34.5.11', 'Mikroorganismen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (102, '1907', '1.2.40.0.34.5.11', 'Nahrungsmittel RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (103, '1908', '1.2.40.0.34.5.11', 'Insektengifte RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (104, '1909', '1.2.40.0.34.5.11', 'Berufliche Allergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (105, '1910', '1.2.40.0.34.5.11', 'Diverse Allergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (106, '1911', '1.2.40.0.34.5.11', 'Medikamente RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (107, '1912', '1.2.40.0.34.5.11', 'Gräserpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (108, '1913', '1.2.40.0.34.5.11', 'Baumpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (109, '1914', '1.2.40.0.34.5.11', 'Kräuterpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (110, '1915', '1.2.40.0.34.5.11', 'Milben IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (111, '1916', '1.2.40.0.34.5.11', 'Epidermale Tierallergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (112, '1917', '1.2.40.0.34.5.11', 'Mikroorganismen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (113, '1918', '1.2.40.0.34.5.11', 'Nahrungsmittel IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (114, '1919', '1.2.40.0.34.5.11', 'Insektengifte IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (115, '1920', '1.2.40.0.34.5.11', 'Berufliche Allergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (116, '1921', '1.2.40.0.34.5.11', 'Diverse Allergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (117, '1922', '1.2.40.0.34.5.11', 'Medikamente IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (118, '2000', '1.2.40.0.34.5.11', 'Parasitologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (119, '2100', '1.2.40.0.34.5.11', 'Mykologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (120, '20', '1.2.40.0.34.5.11', 'Befundbewertung');