--DROP TABLE IHEXDSpracticeSettingCodedoctoral CASCADE; CREATE TABLE IHEXDSpracticeSettingCodedoctoral ( IHEXDSpracticeSettingCodedoctoral_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (1, 'ALLG', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Allgemeinmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (2, 'ANAE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Anästhesiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (3, 'ARBE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Arbeitsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (4, 'AUGE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Augenheilkunde'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (5, 'CHIR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Chirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (6, 'ALCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Allgemeinchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (7, 'GFCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gefäßchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (8, 'HZCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Herzchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (9, 'KDCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinderchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (10, 'ORTH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Orthopädie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (11, 'PLCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Plastische und Ästhetische Chirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (12, 'THCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Thoraxchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (13, 'UNFC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Unfallchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (14, 'VICH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Viszeralchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (15, 'FRAU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Frauenheilkunde und Geburtshilfe'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (16, 'GEND', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gynäkologische Endokrinologie und Reproduktionsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (17, 'GONK', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gynäkologische Onkologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (18, 'PERI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Perinatalmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (19, 'GERI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Geriatrie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (20, 'HNOH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Hals-Nasen-Ohrenheilkunde'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (21, 'HRST', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Sprach-, Stimm- und kindliche Hörstörungen'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (22, 'HAUT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Haut- und Geschlechtskrankheiten'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (23, 'HIST', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Histologie / Zytologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (24, 'HUMA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Humangenetik'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (25, 'HYGI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Hygiene und Umweltmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (26, 'INNE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Innere Medizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (27, 'ANGI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Angiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (28, 'ENDO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Endokrinologie und Diabetologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (29, 'GAST', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gastroenterologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (30, 'HAEM', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Hämatologie und internistische Onkologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (31, 'KARD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kardiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (32, 'NEPH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Nephrologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (33, 'PNEU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pneumologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (34, 'RHEU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Rheumatologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (35, 'INTM', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Intensivmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (36, 'INTO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Onkologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (37, 'INTS', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Schmerzmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (38, 'KIJU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder- und Jugendmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (39, 'KONK', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder-Hämatologie und -Onkologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (40, 'KKAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder-Kardiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (41, 'NNAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neonatologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (42, 'NPAE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropädiatrie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (43, 'KPSY', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder- und Jugendpsychiatrie und -psychotherapie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (44, 'LABO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Laboratoriumsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (45, 'MIKR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Mikrobiologie, Virologie und Infektionsepidemiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (46, 'MKGC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Mund-Kiefer-Gesichtschirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (47, 'NATU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Naturheilverfahren und alternative Heilmethoden'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (48, 'NOTF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Notfallmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (49, 'NRCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurochirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (50, 'NEUR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (51, 'NUKL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Nuklearmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (52, 'GESU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Öffentliches Gesundheitswesen'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (53, 'PALL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Palliativmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (54, 'PATH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pathologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (55, 'NPAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropathologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (56, 'PHAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pharmakologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (57, 'TOXI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Toxikologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (58, 'REHA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Physikalische und Rehabilitative Medizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (59, 'PSYC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Psychiatrie und Psychotherapie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (60, 'FPSY', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Forensische Psychiatrie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (61, 'PSYM', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Psychosomatische Medizin und Psychotherapie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (62, 'RADI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Radiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (63, 'KRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinderradiologie '); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (64, 'NRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuroradiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (65, 'RECH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Rechtsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (66, 'SCHL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Schlafmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (67, 'SPOR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Sport- und Bewegungsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (68, 'STRA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Strahlentherapie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (69, 'TRAN', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Transfusionsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (70, 'TROP', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Tropen-/Reisemedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (71, 'UROL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Urologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (72, 'MZKH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Zahnmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (73, 'ORAL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Oralchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (74, 'KIEF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kieferorthopädie');