--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, '300', '1.2.40.0.34.5.11', 'Hämatologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (4, '1010', '1.2.40.0.34.5.11', 'Blutbild'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (5, '1020', '1.2.40.0.34.5.11', 'Knochenmark Morphologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (6, '1030', '1.2.40.0.34.5.11', 'Immunphänotypisierung'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (7, '1040', '1.2.40.0.34.5.11', 'Molekulare Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (8, '1050', '1.2.40.0.34.5.11', 'Hämatologie Sonstiges'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (9, '200', '1.2.40.0.34.5.11', 'Blutgasanalytik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (10, '2060', '1.2.40.0.34.5.11', 'Blutgasanalyse arteriell'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (11, '2070', '1.2.40.0.34.5.11', 'Hb-Derivate arteriell'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (12, '2080', '1.2.40.0.34.5.11', 'Blutgasanalyse venös'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (13, '2090', '1.2.40.0.34.5.11', 'Hb-Derivate venös'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (14, '2100', '1.2.40.0.34.5.11', 'Blutgasanalyse kapillär'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (15, '2110', '1.2.40.0.34.5.11', 'Hb-Derivate kapillär'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (16, '2120', '1.2.40.0.34.5.11', 'Hb-Derivate, gemischtvenös (Rechtsherzkatheter)'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (17, '2130', '1.2.40.0.34.5.11', 'BGA Sonstiges'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (18, '400', '1.2.40.0.34.5.11', 'Gerinnung/Hämostaseologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (19, '3140', '1.2.40.0.34.5.11', 'Hämostaseologie Globaltests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (20, '3150', '1.2.40.0.34.5.11', 'Einzelfaktoranalysen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (21, '3160', '1.2.40.0.34.5.11', 'Thrombophilie Tests'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (22, '3170', '1.2.40.0.34.5.11', 'Gerinnung Sonstiges'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (23, '500', '1.2.40.0.34.5.11', 'Klinische Chemie/Proteindiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (24, '4180', '1.2.40.0.34.5.11', 'Klinische Chemie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (25, '4190', '1.2.40.0.34.5.11', 'Proteindiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (26, '4200', '1.2.40.0.34.5.11', 'Spurenelemente'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (27, '4210', '1.2.40.0.34.5.11', 'Sondermaterialien'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (28, '4220', '1.2.40.0.34.5.11', 'Unters. bei Stoffwechselerkrankungen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (29, '900', '1.2.40.0.34.5.11', 'Toxikologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (30, '5230', '1.2.40.0.34.5.11', 'Harn-Screening'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (31, '5240', '1.2.40.0.34.5.11', 'Blut'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (32, '5250', '1.2.40.0.34.5.11', 'Toxikologie Sonstiges'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (33, '1000', '1.2.40.0.34.5.11', 'Medikamente'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (34, '6260', '1.2.40.0.34.5.11', 'Antibiotika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (35, '6270', '1.2.40.0.34.5.11', 'Virostatika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (36, '6280', '1.2.40.0.34.5.11', 'Antiepileptika'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (37, '6290', '1.2.40.0.34.5.11', 'Psychopharmaka'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (38, '6300', '1.2.40.0.34.5.11', 'Kardiaka'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (39, '6310', '1.2.40.0.34.5.11', 'Immunsuppressiva'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (40, '6320', '1.2.40.0.34.5.11', 'Medikamente Sonstiges'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (41, '600', '1.2.40.0.34.5.11', 'Hormone/Vitamine/Tumormarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (42, '7330', '1.2.40.0.34.5.11', 'Hormone'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (43, '7340', '1.2.40.0.34.5.11', 'Vitamine'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (44, '7350', '1.2.40.0.34.5.11', 'Tumormarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (45, '1300', '1.2.40.0.34.5.11', 'Autoimmundiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (46, '9360', '1.2.40.0.34.5.11', 'Rheumatoide Arthritis-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (47, '9370', '1.2.40.0.34.5.11', 'Kollagenose-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (48, '9380', '1.2.40.0.34.5.11', 'Myositis-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (49, '9390', '1.2.40.0.34.5.11', 'Lebererkrankungen-assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (50, '9400', '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 (51, '9410', '1.2.40.0.34.5.11', 'Vasculitis-assoziierte Antikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (52, '9420', '1.2.40.0.34.5.11', 'Goodpasture Syndrom assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (53, '9430', '1.2.40.0.34.5.11', 'IBD assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (54, '9440', '1.2.40.0.34.5.11', 'Zöliakie assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (55, '9450', '1.2.40.0.34.5.11', 'Diabetes Mellitus assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (56, '9460', '1.2.40.0.34.5.11', 'Paraneoplasie assoziierte Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (57, '9470', '1.2.40.0.34.5.11', 'Sonstige Autoantikörper'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (58, '1800', '1.2.40.0.34.5.11', 'Allergiediagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (59, '10480', '1.2.40.0.34.5.11', 'Globalmarker'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (60, '10490', '1.2.40.0.34.5.11', 'Gräserpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (61, '10500', '1.2.40.0.34.5.11', 'Baumpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (62, '10510', '1.2.40.0.34.5.11', 'Kräuterpollen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (63, '10520', '1.2.40.0.34.5.11', 'Milben RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (64, '10530', '1.2.40.0.34.5.11', 'Epidermale Tierallergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (65, '10540', '1.2.40.0.34.5.11', 'Mikroorganismen RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (66, '10550', '1.2.40.0.34.5.11', 'Nahrungsmittel RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (67, '10560', '1.2.40.0.34.5.11', 'Insektengifte RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (68, '10570', '1.2.40.0.34.5.11', 'Berufliche Allergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (69, '10580', '1.2.40.0.34.5.11', 'Diverse Allergene RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (70, '10590', '1.2.40.0.34.5.11', 'Medikamente RAST Klassen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (71, '10600', '1.2.40.0.34.5.11', 'Gräserpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (72, '10610', '1.2.40.0.34.5.11', 'Baumpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (73, '10620', '1.2.40.0.34.5.11', 'Kräuterpollen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (74, '10630', '1.2.40.0.34.5.11', 'Milben IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (75, '10640', '1.2.40.0.34.5.11', 'Epidermale Tierallergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (76, '10650', '1.2.40.0.34.5.11', 'Mikroorganismen IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (77, '10660', '1.2.40.0.34.5.11', 'Nahrungsmittel IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (78, '10670', '1.2.40.0.34.5.11', 'Insektengifte IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (79, '10680', '1.2.40.0.34.5.11', 'Berufliche Allergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (80, '10690', '1.2.40.0.34.5.11', 'Diverse Allergene IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (81, '10700', '1.2.40.0.34.5.11', 'Medikamente IGE quant.'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (82, '10710', '1.2.40.0.34.5.11', 'Komponentendiagnostik Allergenchip'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (83, '10720', '1.2.40.0.34.5.11', 'Allergiediagnostik Spez. IGG'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (84, '1400', '1.2.40.0.34.5.11', 'Harndiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (85, '11730', '1.2.40.0.34.5.11', 'Harnstreifen'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (86, '11740', '1.2.40.0.34.5.11', 'Harnsediment'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (87, '11750', '1.2.40.0.34.5.11', 'Harnchemie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (88, '1500', '1.2.40.0.34.5.11', 'Stuhldiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (89, '12760', '1.2.40.0.34.5.11', 'Stuhldiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (90, '1600', '1.2.40.0.34.5.11', 'Liquordiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (91, '13770', '1.2.40.0.34.5.11', 'Liquordiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (92, '1100', '1.2.40.0.34.5.11', 'Infektionsdiagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (93, '14780', '1.2.40.0.34.5.11', 'Virologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (94, '14790', '1.2.40.0.34.5.11', 'Bakteriologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (95, '14800', '1.2.40.0.34.5.11', 'Mykologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (96, '14810', '1.2.40.0.34.5.11', 'Parasitologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (97, '14820', '1.2.40.0.34.5.11', 'Zytologie/Bakterioskopie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (98, '2300', '1.2.40.0.34.5.11', 'Molekulare Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (99, '15830', '1.2.40.0.34.5.11', 'Pharmakogenetik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (100, '15840', '1.2.40.0.34.5.11', 'Humangenetik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (101, '100', '1.2.40.0.34.5.11', 'Blutgruppenserologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (102, '16850', '1.2.40.0.34.5.11', 'Blutgruppenserologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (103, '16860', '1.2.40.0.34.5.11', 'HLA-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (104, '16870', '1.2.40.0.34.5.11', 'HPA-Diagnostik'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (105, '2500', '1.2.40.0.34.5.11', 'Sonstige'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (106, '17880', '1.2.40.0.34.5.11', 'Zytologie'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (107, '17890', '1.2.40.0.34.5.11', 'Sonstige'); INSERT INTO ELGA_Laborstruktur (ELGA_Laborstruktur_id, code, codeSystem, displayName) VALUES (108, '20', '1.2.40.0.34.5.11', 'Befundbewertung');