--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');