--DROP TABLE IHEXDSauthorSpeciality CASCADE; CREATE TABLE IHEXDSauthorSpeciality ( IHEXDSauthorSpeciality_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (1, '011001', '1.2.276.0.76.5.514', 'FA Allgemeinmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (2, '012901', '1.2.276.0.76.5.514', 'SP Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (3, '021001', '1.2.276.0.76.5.514', 'FA Anästhesiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (4, '021002', '1.2.276.0.76.5.514', 'FA Anästhesiologie und Intensivtherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (5, '031001', '1.2.276.0.76.5.514', 'FA Anatomie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (6, '041001', '1.2.276.0.76.5.514', 'FA Arbeitshygiene'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (7, '041002', '1.2.276.0.76.5.514', 'FA Arbeitsmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (8, '051001', '1.2.276.0.76.5.514', 'FA Augenheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (9, '061001', '1.2.276.0.76.5.514', 'FA Biochemie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (10, '071107', '1.2.276.0.76.5.514', 'FA Allgemeinchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (11, '071101', '1.2.276.0.76.5.514', 'FA Allgemeine Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (12, '071001', '1.2.276.0.76.5.514', 'FA Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (13, '071102', '1.2.276.0.76.5.514', 'FA Gefäßchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (14, '071002', '1.2.276.0.76.5.514', 'FA Herzchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (15, '071202', '1.2.276.0.76.5.514', 'FA Kinder- und Jugendchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (16, '071003', '1.2.276.0.76.5.514', 'FA Kinderchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (17, '071004', '1.2.276.0.76.5.514', 'FA Orthopädie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (18, '071103', '1.2.276.0.76.5.514', 'FA Orthopädie und Unfallchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (19, '071005', '1.2.276.0.76.5.514', 'FA Plastische Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (20, '071106', '1.2.276.0.76.5.514', 'FA Plastische und Ästhetische Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (21, '071201', '1.2.276.0.76.5.514', 'FA Plastische; Rekonstruktive und Ästhetische Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (22, '071104', '1.2.276.0.76.5.514', 'FA Thoraxchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (23, '071105', '1.2.276.0.76.5.514', 'FA Visceralchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (24, '071108', '1.2.276.0.76.5.514', 'FA Viszeralchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (25, '072001', '1.2.276.0.76.5.514', 'SP Gefäßchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (26, '072002', '1.2.276.0.76.5.514', 'SP Rheumatologie (Orthopädie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (27, '072003', '1.2.276.0.76.5.514', 'SP Thoraxchirurgie in der Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (28, '072004', '1.2.276.0.76.5.514', 'SP Thoraxchirurgie in der Herzchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (29, '072005', '1.2.276.0.76.5.514', 'SP Unfallchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (30, '072006', '1.2.276.0.76.5.514', 'SP Visceralchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (31, '073001', '1.2.276.0.76.5.514', 'TG Echokardiologie herznaher Gefäße'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (32, '073002', '1.2.276.0.76.5.514', 'TG Gefäßchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (33, '073003', '1.2.276.0.76.5.514', 'TG Herz- und Gefäßchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (34, '073004', '1.2.276.0.76.5.514', 'TG Kinderchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (35, '073005', '1.2.276.0.76.5.514', 'TG Plastische Chirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (36, '073006', '1.2.276.0.76.5.514', 'TG Rheumatologie (Orthopädie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (37, '073007', '1.2.276.0.76.5.514', 'TG Thorax- und Kardiovaskularchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (38, '073008', '1.2.276.0.76.5.514', 'TG Thoraxchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (39, '073009', '1.2.276.0.76.5.514', 'TG Unfallchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (40, '081001', '1.2.276.0.76.5.514', 'FA Frauenheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (41, '081002', '1.2.276.0.76.5.514', 'FA Frauenheilkunde und Geburtshilfe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (42, '081003', '1.2.276.0.76.5.514', 'FA Gynäkologie und Geburtshilfe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (43, '082101', '1.2.276.0.76.5.514', 'SP Gynäkologische Endokrinologie und Reproduktionsmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (44, '082102', '1.2.276.0.76.5.514', 'SP Gynäkologische Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (45, '082103', '1.2.276.0.76.5.514', 'SP Spezielle Geburtshilfe und Perinatalmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (46, '091001', '1.2.276.0.76.5.514', 'FA Hals-Nasen-Ohrenheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (47, '091002', '1.2.276.0.76.5.514', 'FA Phoniatrie und Pädaudiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (48, '091101', '1.2.276.0.76.5.514', 'FA Sprach-; Stimm- und kindliche Hörstörungen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (49, '093001', '1.2.276.0.76.5.514', 'TG Audiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (50, '093002', '1.2.276.0.76.5.514', 'TG Phoniatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (51, '093003', '1.2.276.0.76.5.514', 'TG Phoniatrie und Pädaudiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (52, '101001', '1.2.276.0.76.5.514', 'FA Dermatologie und Venerologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (53, '101002', '1.2.276.0.76.5.514', 'FA Haut- und Geschlechtskrankheiten'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (54, '111001', '1.2.276.0.76.5.514', 'FA Humangenetik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (55, '121001', '1.2.276.0.76.5.514', 'FA Hygiene'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (56, '121002', '1.2.276.0.76.5.514', 'FA Hygiene und Umweltmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (57, '131001', '1.2.276.0.76.5.514', 'FA Immunologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (58, '141002', '1.2.276.0.76.5.514', 'FA Innere Medizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (59, '141110', '1.2.276.0.76.5.514', 'FA Innere Medizin und Angiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (60, '141111', '1.2.276.0.76.5.514', 'FA Innere Medizin und Endokrinologie und Diabetologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (61, '141112', '1.2.276.0.76.5.514', 'FA Innere Medizin und Gastroenterologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (62, '141903', '1.2.276.0.76.5.514', 'FA Innere Medizin und Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (63, '141113', '1.2.276.0.76.5.514', 'FA Innere Medizin und Hämatologie und Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (64, '141904', '1.2.276.0.76.5.514', 'FA Innere Medizin und Infektiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (65, '141114', '1.2.276.0.76.5.514', 'FA Innere Medizin und Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (66, '141115', '1.2.276.0.76.5.514', 'FA Innere Medizin und Nephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (67, '141116', '1.2.276.0.76.5.514', 'FA Innere Medizin und Pneumologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (68, '141117', '1.2.276.0.76.5.514', 'FA Innere Medizin und Rheumatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (69, '141102', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Angiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (70, '141103', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Endokrinologie und Diabetologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (71, '141104', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Gastroenterologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (72, '141901', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (73, '141902', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt gesamte Innere Medizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (74, '141105', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Hämatologie und Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (75, '141106', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (76, '141107', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Nephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (77, '141108', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Pneumologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (78, '141109', '1.2.276.0.76.5.514', 'FA Innere Medizin und Schwerpunkt Rheumatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (79, '141003', '1.2.276.0.76.5.514', 'FA Internist/Lungen- und Bronchialheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (80, '141005', '1.2.276.0.76.5.514', 'FA Lungen- und Bronchialheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (81, '141004', '1.2.276.0.76.5.514', 'FA Lungenheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (82, '142001', '1.2.276.0.76.5.514', 'SP Angiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (83, '142002', '1.2.276.0.76.5.514', 'SP Endokrinologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (84, '142901', '1.2.276.0.76.5.514', 'SP Endokrinologie und Diabetologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (85, '142003', '1.2.276.0.76.5.514', 'SP Gastroenterologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (86, '142004', '1.2.276.0.76.5.514', 'SP Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (87, '142005', '1.2.276.0.76.5.514', 'SP Hämatologie und Internistische Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (88, '142006', '1.2.276.0.76.5.514', 'SP Infektiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (89, '142007', '1.2.276.0.76.5.514', 'SP Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (90, '142008', '1.2.276.0.76.5.514', 'SP Nephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (91, '142009', '1.2.276.0.76.5.514', 'SP Pneumologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (92, '142010', '1.2.276.0.76.5.514', 'SP Rheumatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (93, '143001', '1.2.276.0.76.5.514', 'TG Diabetologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (94, '143002', '1.2.276.0.76.5.514', 'TG Endokrinologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (95, '143003', '1.2.276.0.76.5.514', 'TG Gastroenterologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (96, '143004', '1.2.276.0.76.5.514', 'TG Hämatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (97, '143005', '1.2.276.0.76.5.514', 'TG Infektions- und Tropenmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (98, '143006', '1.2.276.0.76.5.514', 'TG Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (99, '143901', '1.2.276.0.76.5.514', 'TG Kardiologie und Angiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (100, '143007', '1.2.276.0.76.5.514', 'TG Lungen- und Bronchialheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (101, '143008', '1.2.276.0.76.5.514', 'TG Nephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (102, '143009', '1.2.276.0.76.5.514', 'TG Rheumatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (103, '151002', '1.2.276.0.76.5.514', 'FA Kinder- und Jugendmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (104, '151001', '1.2.276.0.76.5.514', 'FA Kinderheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (105, '152901', '1.2.276.0.76.5.514', 'SP Endokrinologie und Diabetologie in der Kinder- und Jugendmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (106, '152902', '1.2.276.0.76.5.514', 'SP Gastroenterologie in der Kinder- und Jugendmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (107, '152001', '1.2.276.0.76.5.514', 'SP Infektiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (108, '152201', '1.2.276.0.76.5.514', 'SP Kinder- und Jugend-Hämatologie und -Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (109, '152202', '1.2.276.0.76.5.514', 'SP Kinder- und Jugend-Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (110, '152101', '1.2.276.0.76.5.514', 'SP Kinder-Hämatologie und -Onkologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (111, '152002', '1.2.276.0.76.5.514', 'SP Kinder-Kardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (112, '152906', '1.2.276.0.76.5.514', 'SP Kinderpneumologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (113, '152003', '1.2.276.0.76.5.514', 'SP Neonatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (114, '152903', '1.2.276.0.76.5.514', 'SP Nephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (115, '152102', '1.2.276.0.76.5.514', 'SP Neuropädiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (116, '152904', '1.2.276.0.76.5.514', 'SP Pädiatrische Rheumatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (117, '152905', '1.2.276.0.76.5.514', 'SP Pulmologie in der Kinder- und Jugendmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (118, '153001', '1.2.276.0.76.5.514', 'TG Kinderdiabetologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (119, '153002', '1.2.276.0.76.5.514', 'TG Kindergastroenterologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (120, '153003', '1.2.276.0.76.5.514', 'TG Kinderhämatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (121, '153004', '1.2.276.0.76.5.514', 'TG Kinderkardiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (122, '153005', '1.2.276.0.76.5.514', 'TG Kinderlungen- und -bronchialheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (123, '153006', '1.2.276.0.76.5.514', 'TG Kinderneonatologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (124, '153007', '1.2.276.0.76.5.514', 'TG Kindernephrologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (125, '153008', '1.2.276.0.76.5.514', 'TG Kinderneuropsychiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (126, '161001', '1.2.276.0.76.5.514', 'FA Kinder- und Jugendpsychiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (127, '161002', '1.2.276.0.76.5.514', 'FA Kinder- und Jugendpsychiatrie und -psychotherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (128, '171001', '1.2.276.0.76.5.514', 'FA Laboratoriumsmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (129, '173001', '1.2.276.0.76.5.514', 'TG Medizinische Mikrobiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (130, '181001', '1.2.276.0.76.5.514', 'FA Mikrobiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (131, '181002', '1.2.276.0.76.5.514', 'FA Mikrobiologie und Infektionsepidemiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (132, '181101', '1.2.276.0.76.5.514', 'FA Mikrobiologie; Virologie und Infektionsepidemiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (133, '191001', '1.2.276.0.76.5.514', 'FA Kieferchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (134, '191002', '1.2.276.0.76.5.514', 'FA Mund-Kiefer-Gesichtschirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (135, '191901', '1.2.276.0.76.5.514', 'FA Oralchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (136, '201001', '1.2.276.0.76.5.514', 'FA Nervenheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (137, '201002', '1.2.276.0.76.5.514', 'FA Nervenheilkunde (Neurologie und Psychiatrie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (138, '201003', '1.2.276.0.76.5.514', 'FA Neurologie und Psychiatrie (Nervenarzt)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (139, '203001', '1.2.276.0.76.5.514', 'TG Kinderneuropsychiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (140, '211001', '1.2.276.0.76.5.514', 'FA Neurochirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (141, '221001', '1.2.276.0.76.5.514', 'FA Neurologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (142, '222901', '1.2.276.0.76.5.514', 'SP Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (143, '231001', '1.2.276.0.76.5.514', 'FA Nuklearmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (144, '241001', '1.2.276.0.76.5.514', 'FA Öffentliches Gesundheitswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (145, '251001', '1.2.276.0.76.5.514', 'FA Neuropathologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (146, '251002', '1.2.276.0.76.5.514', 'FA Pathobiochemie und Labordiagnostik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (147, '251003', '1.2.276.0.76.5.514', 'FA Pathologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (148, '251004', '1.2.276.0.76.5.514', 'FA Pathologische Anatomie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (149, '251005', '1.2.276.0.76.5.514', 'FA Pathologische Physiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (150, '253001', '1.2.276.0.76.5.514', 'TG Neuropathologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (151, '261001', '1.2.276.0.76.5.514', 'FA Klinische Pharmakologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (152, '261002', '1.2.276.0.76.5.514', 'FA Pharmakologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (153, '261003', '1.2.276.0.76.5.514', 'FA Pharmakologie und Toxikologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (154, '263001', '1.2.276.0.76.5.514', 'TG Klinische Pharmakologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (155, '381201', '1.2.276.0.76.5.514', 'Phoniatrie und Pädaudiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (156, '271001', '1.2.276.0.76.5.514', 'FA Physikalische und Rehabilitative Medizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (157, '271002', '1.2.276.0.76.5.514', 'FA Physiotherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (158, '281001', '1.2.276.0.76.5.514', 'FA Physiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (159, '291001', '1.2.276.0.76.5.514', 'FA Psychiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (160, '291002', '1.2.276.0.76.5.514', 'FA Psychiatrie und Psychotherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (161, '292101', '1.2.276.0.76.5.514', 'SP Forensische Psychiatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (162, '292901', '1.2.276.0.76.5.514', 'SP Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (163, '301101', '1.2.276.0.76.5.514', 'FA Psychosomatische Medizin und Psychotherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (164, '301001', '1.2.276.0.76.5.514', 'FA Psychotherapeutische Medizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (165, '301002', '1.2.276.0.76.5.514', 'FA Psychotherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (166, '311001', '1.2.276.0.76.5.514', 'FA Diagnostische Radiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (167, '311002', '1.2.276.0.76.5.514', 'FA Radiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (168, '311003', '1.2.276.0.76.5.514', 'FA Radiologische Diagnostik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (169, '312201', '1.2.276.0.76.5.514', 'SP Kinder- und Jugendradiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (170, '312001', '1.2.276.0.76.5.514', 'SP Kinderradiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (171, '312002', '1.2.276.0.76.5.514', 'SP Neuroradiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (172, '313001', '1.2.276.0.76.5.514', 'TG Kinderradiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (173, '313002', '1.2.276.0.76.5.514', 'TG Neuroradiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (174, '313003', '1.2.276.0.76.5.514', 'TG Strahlentherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (175, '321001', '1.2.276.0.76.5.514', 'FA Rechtsmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (176, '351001', '1.2.276.0.76.5.514', 'FA Strahlentherapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (177, '361001', '1.2.276.0.76.5.514', 'FA Blutspende- und Transfusionswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (178, '361002', '1.2.276.0.76.5.514', 'FA Transfusionsmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (179, '371001', '1.2.276.0.76.5.514', 'FA Urologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (180, '011002', '1.2.276.0.76.5.514', 'FA Praktischer Arzt'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (181, '011101', '1.2.276.0.76.5.514', 'FA Innere und Allgemeinmedizin (Hausarzt)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (182, '131001', '1.2.276.0.76.5.514', 'FA Immunologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (183, '142902', '1.2.276.0.76.5.514', 'SP Geriatrie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (184, '331001', '1.2.276.0.76.5.514', 'FA Sozialhygiene'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (185, '341001', '1.2.276.0.76.5.514', 'FA Sportmedizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (186, '590001', '1.2.276.0.76.5.514', 'Biomathematik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (187, '590002', '1.2.276.0.76.5.514', 'Biophysik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (188, '590003', '1.2.276.0.76.5.514', 'Geschichte der Medizin'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (189, '590004', '1.2.276.0.76.5.514', 'Industrietoxikologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (190, '590005', '1.2.276.0.76.5.514', 'Kieferchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (191, '590006', '1.2.276.0.76.5.514', 'Klinische Strahlenphysik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (192, '590007', '1.2.276.0.76.5.514', 'Medizinische Genetik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (193, '590008', '1.2.276.0.76.5.514', 'Medizinische Informatik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (194, '590009', '1.2.276.0.76.5.514', 'Medizinische Physik und Biophysik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (195, '590010', '1.2.276.0.76.5.514', 'Medizinische Wissenschaftsinformation'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (196, '590011', '1.2.276.0.76.5.514', 'Pathologische Biochemie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (197, '000001', '1.2.276.0.76.5.514', 'Ärztin/Arzt'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (198, '000011', '1.2.276.0.76.5.514', 'Praktische Ärztin/Praktischer Arzt (EWG-Recht ab 86/457/EWG)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (199, '1', '1.2.276.0.76.5.492', 'Zahnarzt'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (200, '2', '1.2.276.0.76.5.492', 'FZA Allgemeine Zahnheilkunde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (201, '3', '1.2.276.0.76.5.492', 'FZA Parodontologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (202, '4', '1.2.276.0.76.5.492', 'FZA Oralchirurgie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (203, '5', '1.2.276.0.76.5.492', 'FZA Kieferorthopädie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (204, '6', '1.2.276.0.76.5.492', 'FZA öffentliches Gesundheitswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (205, '1', '1.2.276.0.76.5.493', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (206, '3', '1.2.276.0.76.5.493', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (207, '1', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheits- Sozial-, Sportmanagement'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (208, '2', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Arzthilfe, Praxisorganisation, -verwaltung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (209, '179', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Physician Assistant'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (210, '3', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kaufmann/-frau - Gesundheitswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (211, '4', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinischer Fachangestellter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (212, '5', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (213, '6', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Zahnmedizinischer Fachangestellter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (214, '7', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Arztsekretär'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (215, '8', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozial-, Gesundheitsmanagement'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (216, '9', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheitsaufseher / Hygienekontrolleur'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (217, '10', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Assistent Gesundheits- und Sozialwesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (218, '11', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Beamte Sozialversicherung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (219, '12', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Beamte Sozialverwaltung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (220, '13', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Betriebswirt Sozialversicherung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (221, '14', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheitsmanager'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (222, '15', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialökonom, -wirt'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (223, '16', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialversicherungsfachangestellte'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (224, '17', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportmanagement'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (225, '18', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (226, '19', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachwirt Fitness'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (227, '20', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sport- und Fitnesskaufmann'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (228, '21', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportmanager, Sportökonom'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (229, '22', '1.3.6.1.4.1.19376.3.276.1.5.11', 'nichtärztliche medizinische Analyse, Beratung, Pflege, Therapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (230, '23', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheitsberatung, -förderung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (231, '24', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Assistenten für Gesundheitstourismus, -prophylaxe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (232, '25', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Diätassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (233, '26', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheitsförderer, -pädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (234, '27', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheitswissenschaftler'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (235, '28', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Oekotrophologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (236, '29', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Tai-Chi-Chuan- und Qigong-Lehrer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (237, '30', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Yogalehrer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (238, '31', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportfachmann'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (239, '32', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportwissenschaftler'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (240, '33', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kranken-, Altenpflege, Geburtshilfe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (241, '34', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Altenpflegehelfer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (242, '35', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Altenpfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (243, '36', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkraft Pflegeassistenz'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (244, '37', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheits- und Kinderkrankenpfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (245, '38', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheits- und Krankenpflegehelfer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (246, '39', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheits- und Krankenpfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (247, '40', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Haus- und Familienpfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (248, '41', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Hebamme / Entbindungspfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (249, '42', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Heilerziehungspfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (250, '43', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Helfer Altenpflege'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (251, '44', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Helfer stationäre Krankenpflege'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (252, '45', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Heilerziehungspflegehelfer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (253, '46', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pflegewissenschaftler'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (254, '175', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkrankenpfleger für Intensivpflege und Anästhesie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (255, '176', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkrankenpfleger im Operations-/Endoskopiedienst'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (256, '177', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkrankenpfleger für Hygiene'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (257, '178', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkrankenpfleger für Palliativ- und Hospizpflege'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (258, '47', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Nichtärztliche Behandlung, Therapie (außer Psychotherapie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (259, '48', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Akademischer Sprachtherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (260, '49', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Atem-, Sprech- und Stimmlehrer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (261, '50', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ergotherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (262, '51', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachangestellter für Bäderbetriebe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (263, '52', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Heilpraktiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (264, '53', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Klinischer Linguist'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (265, '54', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kunsttherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (266, '55', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Logopäde'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (267, '56', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Masseur und medizinische Bademeister'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (268, '57', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Motologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (269, '58', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Musiktherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (270, '59', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Orthoptist'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (271, '60', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Physiotherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (272, '61', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Podologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (273, '62', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sporttherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (274, '63', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sprechwissenschaftler'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (275, '64', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Staatlich anerkannter Sprachtherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (276, '65', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Stomatherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (277, '66', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Tanz- und Bewegungstherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (278, '67', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (279, '68', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialtherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (280, '69', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pharmazeutische Beratung, Pharmavertrieb'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (281, '70', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Apotheker /Fachapotheker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (282, '71', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pharmazeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (283, '72', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pharmazeutisch-technischer Assistent – PTA'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (284, '73', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pharmazeutisch-kaufmännischer Angestellter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (285, '180', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pharmazieingenieur'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (286, '181', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Apothekenassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (287, '182', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Apothekerassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (288, '74', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychologische Analyse, Beratung, Therapie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (289, '75', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gesundheits- und Rehabilitationspsychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (290, '76', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kinder- und Jugendlichenpsychotherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (291, '77', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Klinischer Psychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (292, '78', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kommunikationspsychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (293, '79', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pädagogischer Psychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (294, '80', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychoanalytiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (295, '81', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (296, '82', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychologischer Psychotherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (297, '183', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychotherapeut'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (298, '184', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachpsychotherapeut für Kinder und Jugendliche'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (299, '185', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachpsychotherapeut für Erwachsene'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (300, '83', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sportpsychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (301, '84', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Verkehrspsychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (302, '85', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Wirtschaftspsychologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (303, '86', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Rettungsdienst'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (304, '87', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ingenieur Rettungswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (305, '88', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Notfallsanitäter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (306, '89', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Rettungsassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (307, '90', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Rettungshelfer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (308, '91', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Rettungssanitäter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (309, '92', '1.3.6.1.4.1.19376.3.276.1.5.11', 'med. Datenverarbeitung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (310, '93', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (311, '94', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinischer Dokumentar'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (312, '95', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinischer Dokumentationsassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (313, '173', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachangestellter f. Medien- und Informationsdienste - Medizinische Dokumentation'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (314, '174', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinischer Informationsmanager'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (315, '96', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Soziales, Pädagogik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (316, '97', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kinderbetreuung, -erziehung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (317, '98', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Pädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (318, '99', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kinderdorfmutter, -vater'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (319, '100', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kinderpfleger'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (320, '101', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Erzieher'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (321, '102', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Erzieher Jugend- und Heimerziehung'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (322, '103', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Lehrer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (323, '104', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Orientierungs- und Mobilitätslehrer'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (324, '105', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medien-, Kulturpädagogik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (325, '106', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Musikpädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (326, '107', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialberatung, -arbeit'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (327, '108', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialarbeiter / Sozialpädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (328, '109', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Betreuungskraft / Alltagsbegleiter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (329, '110', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gerontologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (330, '111', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Psychosozialer Prozessbegleiter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (331, '112', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Rehabilitationspädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (332, '113', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Sozialassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (333, '114', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Seelsorge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (334, '115', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Religionspädagoge'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (335, '116', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Gemeindehelfer, Gemeindediakon'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (336, '117', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Theologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (337, '118', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizintechnik, Laboranalyse'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (338, '119', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizin-, Orthopädie- und Rehatechnik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (339, '120', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Assistent Medizinische Gerätetechnik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (340, '121', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Augenoptiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (341, '122', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Hörakustiker / Hörgeräteakustiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (342, '123', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Hörgeräteakustikermeister'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (343, '124', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ingenieur Augenoptik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (344, '125', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ingenieur - Hörtechnik und Audiologie'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (345, '126', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ingenieur - Medizintechnik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (346, '127', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Ingenieur - Orthopädie- und Rehatechnik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (347, '128', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinphysiker (z.B. in Strahlenmedizin)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (348, '129', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Orthopädieschuhmacher'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (349, '130', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Orthopädietechnik-Mechaniker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (350, '131', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Zahntechniker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (351, '132', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Glasbläser (Fachrichtung Kunstaugen)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (352, '133', '1.3.6.1.4.1.19376.3.276.1.5.11', 'staatlich geprüfter Techniker der Fachrichtung Medizintechnik'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (353, '134', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinisch-technische Assistenz'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (354, '135', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Anästhesietechnischer Assistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (355, '136', '1.3.6.1.4.1.19376.3.276.1.5.11', 'HNO Audiologieassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (356, '137', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinisch-Technischer Assistent Funktionsdiagnostik – MTA-F'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (357, '138', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinisch-Technischer Laboratoriumsassistent – MTA-L'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (358, '139', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Medizinisch-Technischer Radiologieassistent – MTA-R'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (359, '140', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Operationstechnischer Angestellter'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (360, '141', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Operationstechnischer Assistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (361, '142', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (362, '143', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Zytologieassistent'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (363, '144', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Chemie, naturwissenschaftliche Laboranalyse (außer MTA)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (364, '145', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Biochemiker (z.B. klinische Chemie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (365, '146', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Chemiker (z.B. klinische Chemie)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (366, '147', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Humangenetiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (367, '148', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Mikrobiologe'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (368, '149', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Dienstleistungen am Menschen (außer medizinische)'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (369, '150', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Körperpflege'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (370, '151', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Fachkraft Beauty und Wellness'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (371, '152', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Friseur'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (372, '153', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Kosmetiker'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (373, '154', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Bestattungswesen'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (374, '155', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Bestattungsfachkraft'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (375, '156', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Berufe aus sonstigen Berufsfeldern'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (376, '157', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Umwelt'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (377, '158', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (378, '159', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (379, '162', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (380, '163', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (381, '164', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (382, '165', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Jurist'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (383, '166', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (384, '167', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (385, '168', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (386, '169', '1.3.6.1.4.1.19376.3.276.1.5.11', 'Taxifahrer bei Krankentransport'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (387, '170', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (388, '171', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet'); INSERT INTO IHEXDSauthorSpeciality (IHEXDSauthorSpeciality_id, code, codeSystem, displayName) VALUES (389, '172', '1.3.6.1.4.1.19376.3.276.1.5.11', 'obsolet');