--DROP TABLE ELGA_ServiceEventsLabor CASCADE; CREATE TABLE ELGA_ServiceEventsLabor ( ELGA_ServiceEventsLabor_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (1, '1', '1.2.40.0.34.5.11', 'Allgemeiner Laborbefund'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (2, '100', '1.2.40.0.34.5.11', 'Blutgruppenserologie/Immungenetik'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (3, '200', '1.2.40.0.34.5.11', 'Blutgasanalyse'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (4, '300', '1.2.40.0.34.5.11', 'Hämatologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (5, '400', '1.2.40.0.34.5.11', 'Hämostaseologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (6, '500', '1.2.40.0.34.5.11', 'Klinische Chemie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (7, '600', '1.2.40.0.34.5.11', 'Endokrinologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (8, '700', '1.2.40.0.34.5.11', 'Vitamine'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (9, '800', '1.2.40.0.34.5.11', 'Tumormarker'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (10, '900', '1.2.40.0.34.5.11', 'Toxikologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (11, '1000', '1.2.40.0.34.5.11', 'TDM'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (12, '1100', '1.2.40.0.34.5.11', 'Virologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (13, '1200', '1.2.40.0.34.5.11', 'Bakteriologie'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (14, '1300', '1.2.40.0.34.5.11', 'Autoantikörperdiagnostik'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (15, '1400', '1.2.40.0.34.5.11', 'Harndiagnostik'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (16, '1500', '1.2.40.0.34.5.11', 'Stuhldiagnostik'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (17, '1600', '1.2.40.0.34.5.11', 'Liquordiagnostik'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (18, '1700', '1.2.40.0.34.5.11', 'Sondermaterialien'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (19, '1800', '1.2.40.0.34.5.11', 'Allergiediagnostik/Globalmarker'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (20, '1900', '1.2.40.0.34.5.11', 'Allergiediagnostik Spez. IGE'); INSERT INTO ELGA_ServiceEventsLabor (ELGA_ServiceEventsLabor_id, code, codeSystem, displayName) VALUES (21, '18725-2', '2.16.840.1.113883.6.1', 'Microbiology studies');