--DROP TABLE ELGA_AuthorSpeciality CASCADE; CREATE TABLE ELGA_AuthorSpeciality ( ELGA_AuthorSpeciality_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (1, '100', '1.2.40.0.34.5.2', 'Ärztin/Arzt für Allgemeinmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (2, '101', '1.2.40.0.34.5.2', 'Approbierte Ärztin/Approbierter Arzt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (3, '102', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Anästhesiologie und Intensivmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (4, '103', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Anatomie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (5, '104', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Arbeitsmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (6, '105', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Augenheilkunde und Optometrie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (7, '106', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Blutgruppenserologie und Transfusionsmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (8, '107', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Chirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (9, '108', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Frauenheilkunde und Geburtshilfe'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (10, '109', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Gerichtsmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (11, '110', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Hals-, Nasen- und Ohrenkrankheiten'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (12, '111', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Haut- und Geschlechtskrankheiten'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (13, '112', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Herzchirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (14, '113', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Histologie und Embryologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (15, '114', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Hygiene und Mikrobiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (16, '115', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Immunologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (17, '116', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Innere Medizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (18, '117', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Kinder- und Jugendchirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (19, '118', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Kinder- und Jugendheilkunde'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (20, '119', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Kinder- und Jugendpsychiatrie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (21, '120', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Lungenkrankheiten'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (22, '121', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Medizinische Biologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (23, '122', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Medizinische Biophysik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (24, '123', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Medizinische Genetik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (25, '124', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Medizinische und Chemische Labordiagnostik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (26, '125', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Medizinische Leistungsphysiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (27, '126', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Mikrobiologisch-Serologische Labordiagnostik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (28, '127', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Mund-, Kiefer- und Gesichtschirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (29, '128', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Neurobiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (30, '129', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Neurochirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (31, '130', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Neurologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (32, '131', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Neurologie und Psychiatrie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (33, '132', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Neuropathologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (34, '133', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Nuklearmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (35, '134', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Orthopädie und Orthopädische Chirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (36, '135', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Pathologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (37, '136', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Pathophysiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (38, '137', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Pharmakologie und Toxikologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (39, '138', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Physikalische Medizin und Allgemeine Rehabilitation'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (40, '139', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Physiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (41, '140', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Plastische, Ästhetische und Rekonstruktive Chirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (42, '141', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Psychiatrie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (43, '142', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Psychiatrie und Neurologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (44, '143', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Psychiatrie und Psychotherapeutische Medizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (45, '144', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Radiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (46, '145', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Sozialmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (47, '146', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Spezifische Prophylaxe und Tropenmedizin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (48, '147', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Strahlentherapie-Radioonkologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (49, '148', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Theoretische Sonderfächer'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (50, '149', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Thoraxchirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (51, '150', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Tumorbiologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (52, '151', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Unfallchirurgie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (53, '152', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Urologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (54, '153', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Virologie'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (55, '154', '1.2.40.0.34.5.2', 'Fachärztin/Facharzt für Zahn-, Mund- und Kieferheilkunde'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (56, '155', '1.2.40.0.34.5.2', 'Zahnärztin/Zahnarzt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (57, '156', '1.2.40.0.34.5.2', 'Dentistin/Dentist'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (58, '200', '1.2.40.0.34.5.2', 'Psychotherapeutin/Psychotherapeut'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (59, '201', '1.2.40.0.34.5.2', 'Klinischer Psychologe/Klinische Psychologin'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (60, '202', '1.2.40.0.34.5.2', 'Gesundheitspsychologin/Gesundheitspsychologe'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (61, '203', '1.2.40.0.34.5.2', 'Musiktherapeutin/Musiktherapeut'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (62, '204', '1.2.40.0.34.5.2', 'Hebamme'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (63, '205', '1.2.40.0.34.5.2', 'Physiotherapeutin/Physiotherapeut'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (64, '206', '1.2.40.0.34.5.2', 'Biomedizinische Analytikerin/Biomedizinischer Analytiker'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (65, '207', '1.2.40.0.34.5.2', 'Radiologietechnologin/Radiologietechnologe'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (66, '208', '1.2.40.0.34.5.2', 'Diätologin/Diätologe'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (67, '209', '1.2.40.0.34.5.2', 'Ergotherapeutin/Ergotherapeut'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (68, '210', '1.2.40.0.34.5.2', 'Logopädin/Logopäde'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (69, '211', '1.2.40.0.34.5.2', 'Orthoptistin/Orthoptist'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (70, '212', '1.2.40.0.34.5.2', 'Diplomierte Gesundheits- und Krankenschwester/Diplomierter Gesundheits- und Krankenpfleger'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (71, '213', '1.2.40.0.34.5.2', 'Diplomierte Kinderkrankenschwester/Diplomierter Kinderkrankenpfleger'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (72, '214', '1.2.40.0.34.5.2', 'Diplomierte psychiatrische Gesundheits- und Krankenschwester/Diplomierter psychiatrischer Gesundheits- und Krankenpfleger'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (73, '215', '1.2.40.0.34.5.2', 'Heilmasseurin/Heilmasseur'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (74, '216', '1.2.40.0.34.5.2', 'Kardiotechnikerin/Kardiotechniker'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (75, '300', '1.2.40.0.34.5.2', 'Allgemeine Krankenanstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (76, '301', '1.2.40.0.34.5.2', 'Sonderkrankenanstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (77, '302', '1.2.40.0.34.5.2', 'Pflegeanstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (78, '303', '1.2.40.0.34.5.2', 'Sanatorium'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (79, '304', '1.2.40.0.34.5.2', 'Selbstständiges Ambulatorium'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (80, '305', '1.2.40.0.34.5.2', 'Pflegeheim'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (81, '306', '1.2.40.0.34.5.2', 'Mobile Pflege'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (82, '307', '1.2.40.0.34.5.2', 'Kuranstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (83, '308', '1.2.40.0.34.5.2', 'Gesundheits- und Sozialberatung'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (84, '309', '1.2.40.0.34.5.2', 'Krankenabteilung Justizanstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (85, '310', '1.2.40.0.34.5.2', 'Untersuchungsanstalt'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (86, '311', '1.2.40.0.34.5.2', 'Öffentliche Apotheke'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (87, '312', '1.2.40.0.34.5.2', 'Gewebebank'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (88, '313', '1.2.40.0.34.5.2', 'Blutspende'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (89, '318', '1.2.40.0.34.5.2', 'Rettung'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (90, '314', '1.2.40.0.34.5.2', 'Augenoptik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (91, '315', '1.2.40.0.34.5.2', 'Hörgeräteakustik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (92, '316', '1.2.40.0.34.5.2', 'Orthopädische Produkte'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (93, '317', '1.2.40.0.34.5.2', 'Zahntechnik'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (94, '400', '1.2.40.0.34.5.2', 'Öffentliches Gesundheitswesen'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (95, '401', '1.2.40.0.34.5.2', 'Betreiber medizinischer Register'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (96, '402', '1.2.40.0.34.5.2', 'Krankenanstaltenverbund'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (97, '403', '1.2.40.0.34.5.2', 'Ombudsstelle'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (98, '404', '1.2.40.0.34.5.2', 'Widerspruchsstelle'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (99, '405', '1.2.40.0.34.5.2', 'Patientenvertretung'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (100, '406', '1.2.40.0.34.5.2', 'Sozialversicherung'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (101, '407', '1.2.40.0.34.5.2', 'Krankenfürsorge'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (102, '408', '1.2.40.0.34.5.2', 'Gesundheitsversicherung'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (103, '500', '1.2.40.0.34.5.2', 'IKT-Service Gesundheitswesen'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (104, '501', '1.2.40.0.34.5.2', 'Verrechnungsservice Gesundheitswesen'); INSERT INTO ELGA_AuthorSpeciality (ELGA_AuthorSpeciality_id, code, codeSystem, displayName) VALUES (105, '502', '1.2.40.0.34.5.2', 'Gesundheitsbezogenes Service, andere');