--DROP TABLE eImpf_SpecialSituationIndication_VS CASCADE; CREATE TABLE eImpf_SpecialSituationIndication_VS ( eImpf_SpecialSituationIndication_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (1, '_AllgemeineBevölkerung', '1.2.40.0.34.5.183', 'Allgemeine Bevölkerung'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (2, '224627004', '2.16.840.1.113883.6.96', 'Allgemeine Kategorisierung von Personen'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (3, '_SpezielleRisikogruppefür', '1.2.40.0.34.5.183', 'Spezielle Risikogruppe für'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (4, '35736007', '2.16.840.1.113883.6.96', 'Cholera Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (5, '428214002', '2.16.840.1.113883.6.96', 'Diphtherie Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (6, '333699008', '2.16.840.1.113883.6.96', 'Frühsommer-Meningoencephalitis Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (7, '56844000', '2.16.840.1.113883.6.96', 'Gelbfieber Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (8, '333680004', '2.16.840.1.113883.6.96', 'Haemophilus influenzae Typ B Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (9, '14745005', '2.16.840.1.113883.6.96', 'Hepatitis A Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (10, '34689006', '2.16.840.1.113883.6.96', 'Hepatitis B Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (11, '407737004', '2.16.840.1.113883.6.96', 'Herpes Zoster Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (12, '424519000', '2.16.840.1.113883.6.96', 'Humane Papillomaviren Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (13, '46233009', '2.16.840.1.113883.6.96', 'Influenza Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (14, '443651005', '2.16.840.1.113883.6.96', 'Influenza (H1N1) Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (15, '427036009', '2.16.840.1.113883.6.96', 'Influenza (H5N1) Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (16, '333697005', '2.16.840.1.113883.6.96', 'Japanische Encephalitis Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (17, '386012008', '2.16.840.1.113883.6.96', 'Masern Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (18, '423531006', '2.16.840.1.113883.6.96', 'Meningokokken Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (19, '785864002', '2.16.840.1.113883.6.96', 'Meningokokken Serotyp B Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (20, '422069000', '2.16.840.1.113883.6.96', 'Meningokokken Serotyp C Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (21, '421281005', '2.16.840.1.113883.6.96', 'Meningokokken Serotyp A+C Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (22, '420261000', '2.16.840.1.113883.6.96', 'Meningokokken Serotyp A+C+W135+Y Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (23, '90043005', '2.16.840.1.113883.6.96', 'Mumps Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (24, '61602008', '2.16.840.1.113883.6.96', 'Pertussis Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (25, '333598008', '2.16.840.1.113883.6.96', 'Pneumokokken Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (26, '33234009', '2.16.840.1.113883.6.96', 'Pocken Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (27, '111164008', '2.16.840.1.113883.6.96', 'Poliomyelitis Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (28, '116077000', '2.16.840.1.113883.6.96', 'Rotavirus Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (29, '386013003', '2.16.840.1.113883.6.96', 'Röteln Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (30, '333621002', '2.16.840.1.113883.6.96', 'Tetanus Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (31, '333606008', '2.16.840.1.113883.6.96', 'Tollwut Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (32, '89428009', '2.16.840.1.113883.6.96', 'Typhus Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (33, '108729007', '2.16.840.1.113883.6.96', 'Varizellen Impfstoff'); INSERT INTO eImpf_SpecialSituationIndication_VS (eImpf_SpecialSituationIndication_VS_id, code, codeSystem, displayName) VALUES (34, '420538001', '2.16.840.1.113883.6.96', 'Tuberkulose Impfstoff');