--DROP TABLE IHEXDSpracticeSettingCode CASCADE; CREATE TABLE IHEXDSpracticeSettingCode ( IHEXDSpracticeSettingCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (1, 'ALLG', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Allgemeinmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (2, 'ANAE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Anästhesiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (3, 'ARBE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Arbeitsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (4, 'AUGE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Augenheilkunde'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (5, 'CHIR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Chirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (6, 'ALCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Allgemeinchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (7, 'GFCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gefäßchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (8, 'HZCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Herzchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (9, 'KDCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinderchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (10, 'ORTH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Orthopädie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_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 IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (12, 'THCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Thoraxchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (13, 'UNFC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Unfallchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (14, 'VICH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Viszeralchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (15, 'FRAU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Frauenheilkunde und Geburtshilfe'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_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 IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (17, 'GONK', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gynäkologische Onkologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (18, 'PERI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Perinatalmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (19, 'GERI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Geriatrie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (20, 'HNOH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Hals-Nasen-Ohrenheilkunde'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_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 IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (22, 'HAUT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Haut- und Geschlechtskrankheiten'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (23, 'HIST', '1.3.6.1.4.1.19376.3.276.1.5.4', 'obsolet'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (24, 'HUMA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Humangenetik'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (25, 'HYGI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Hygiene und Umweltmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (26, 'INNE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Innere Medizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (27, 'ANGI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Angiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (28, 'ENDO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Endokrinologie und Diabetologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (29, 'GAST', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Gastroenterologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_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 IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (31, 'KARD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kardiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (32, 'NEPH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Nephrologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (33, 'PNEU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pneumologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (34, 'RHEU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Rheumatologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (35, 'INTM', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Intensivmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (36, 'INTZ', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Zusammenarbeit'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (37, 'INTO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Onkologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (38, 'INTS', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Schmerzmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (39, 'TRPL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Transplantationsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (40, 'SELT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'seltene Erkrankungen'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (41, 'KIJU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder- und Jugendmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (42, 'KONK', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder-Hämatologie und -Onkologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (43, 'KKAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder-Kardiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (44, 'NNAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neonatologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (45, 'NPAE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropädiatrie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (46, 'KPSY', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder- und Jugendpsychiatrie und -psychotherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (47, 'LABO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Laboratoriumsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (48, 'MIKR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Mikrobiologie, Virologie und Infektionsepidemiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (49, 'MKGC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Mund-Kiefer-Gesichtschirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (50, 'NATU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Naturheilverfahren und alternative Heilmethoden'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (51, 'NOTF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Notfallmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (52, 'NRCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurochirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (53, 'NEUR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (54, 'NUKL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Nuklearmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (55, 'GESU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Öffentliches Gesundheitswesen'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (56, 'PALL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Palliativmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (57, 'PATH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pathologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (58, 'NPAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropathologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (59, 'PHAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pharmakologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (60, 'TOXI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Toxikologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (61, 'REHA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Physikalische und Rehabilitative Medizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (62, 'PSYC', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Psychiatrie und Psychotherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (63, 'FPSY', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Forensische Psychiatrie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (64, 'PSYM', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Psychosomatische Medizin und Psychotherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (65, 'RADI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Radiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (66, 'KRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinderradiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (67, 'NRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuroradiologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (68, 'RECH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Rechtsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (69, 'SCHL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Schlafmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (70, 'SPOR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Sport- und Bewegungsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (71, 'STRA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Strahlentherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (72, 'TRAN', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Transfusionsmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (73, 'TROP', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Tropen-/Reisemedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (74, 'UROL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Urologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (75, 'MZKH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Zahnmedizin'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (76, 'ORAL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Oralchirurgie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (77, 'KIEF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kieferorthopädie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (78, 'PARO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Parodontologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (79, 'ERG', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Ergotherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (80, 'ERN', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Ernährung und Diätetik'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (81, 'FOR', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Forschung'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (82, 'PFL', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Pflege und Betreuung'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (83, 'ALT', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Altenpflege'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (84, 'KIN', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Kinderpflege'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (85, 'PAT', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Patient außerhalb der Betreuung'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (86, 'PHZ', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Pharmazeutik'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (87, 'POD', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Podologie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (88, 'PRV', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Prävention'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (89, 'SOZ', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Sozialwesen'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (90, 'SPR', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Sprachtherapie'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (91, 'VKO', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Versorgungskoordination'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (92, 'VER', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Verwaltung'); INSERT INTO IHEXDSpracticeSettingCode (IHEXDSpracticeSettingCode_id, code, codeSystem, displayName) VALUES (93, 'PST', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Psychotherapie'); --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', 'obsolet'); 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, 'INTZ', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Interdisziplinäre Zusammenarbeit'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (37, '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 (38, '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 (39, 'TRPL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Transplantationsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (40, 'SELT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'seltene Erkrankungen'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (41, '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 (42, '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 (43, 'KKAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinder-Kardiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (44, 'NNAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neonatologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (45, 'NPAE', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropädiatrie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (46, '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 (47, 'LABO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Laboratoriumsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (48, '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 (49, '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 (50, '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 (51, 'NOTF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Notfallmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (52, 'NRCH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurochirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (53, 'NEUR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neurologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (54, 'NUKL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Nuklearmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (55, 'GESU', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Öffentliches Gesundheitswesen'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (56, 'PALL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Palliativmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (57, 'PATH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pathologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (58, 'NPAT', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuropathologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (59, 'PHAR', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Pharmakologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (60, 'TOXI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Toxikologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (61, '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 (62, '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 (63, 'FPSY', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Forensische Psychiatrie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (64, '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 (65, 'RADI', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Radiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (66, 'KRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kinderradiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (67, 'NRAD', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Neuroradiologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (68, 'RECH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Rechtsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (69, 'SCHL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Schlafmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (70, '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 (71, 'STRA', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Strahlentherapie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (72, 'TRAN', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Transfusionsmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (73, 'TROP', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Tropen-/Reisemedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (74, 'UROL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Urologie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (75, 'MZKH', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Zahnmedizin'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (76, 'ORAL', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Oralchirurgie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (77, 'KIEF', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Kieferorthopädie'); INSERT INTO IHEXDSpracticeSettingCodedoctoral (IHEXDSpracticeSettingCodedoctoral_id, code, codeSystem, displayName) VALUES (78, 'PARO', '1.3.6.1.4.1.19376.3.276.1.5.4', 'Parodontologie'); --DROP TABLE IHEXDSpracticeSettingCodenondoctoral CASCADE; CREATE TABLE IHEXDSpracticeSettingCodenondoctoral ( IHEXDSpracticeSettingCodenondoctoral_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (1, 'ERG', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Ergotherapie'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (2, 'ERN', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Ernährung und Diätetik'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (3, 'FOR', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Forschung'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (4, 'PFL', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Pflege und Betreuung'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (5, 'ALT', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Altenpflege'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (6, 'KIN', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Kinderpflege'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (7, 'PAT', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Patient außerhalb der Betreuung'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (8, 'PHZ', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Pharmazeutik'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (9, 'POD', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Podologie'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (10, 'PRV', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Prävention'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (11, 'SOZ', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Sozialwesen'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (12, 'SPR', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Sprachtherapie'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (13, 'VKO', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Versorgungskoordination'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (14, 'VER', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Verwaltung'); INSERT INTO IHEXDSpracticeSettingCodenondoctoral (IHEXDSpracticeSettingCodenondoctoral_id, code, codeSystem, displayName) VALUES (15, 'PST', '1.3.6.1.4.1.19376.3.276.1.5.5', 'Psychotherapie');