--DROP TABLE SwissVaccinationPlanExposureRisks CASCADE; CREATE TABLE SwissVaccinationPlanExposureRisks ( SwissVaccinationPlanExposureRisks_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (1, '213001', '2.16.756.5.30.1.127.3.3.2', 'BESCHAEFTIGTE_IM_GESUNDHEITSWESEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (2, '213028', '2.16.756.5.30.1.127.3.3.2', 'ENGE_KONTAKTPERSONEN_VON_MENINGOKOKKEN_ERKRANKTEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (3, '213003', '2.16.756.5.30.1.127.3.3.2', 'ERWACHSENE_UND_KINDER_AB_6_JAHREN_DIE_IN_ENDEMIEGEBIET_WOHNEN_ODER_SICH_TEILWEISE_DORT_AUFHALTEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (4, '213005', '2.16.756.5.30.1.127.3.3.2', 'FAMILIENANGEHOERIGE_VON_PERSONEN_MIT_EINEM_ERHOEHTEN_RISIKO'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (5, '213006', '2.16.756.5.30.1.127.3.3.2', 'FLEDERMAUSFORSCHER_UND_SCHUETZER'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (6, '213007', '2.16.756.5.30.1.127.3.3.2', 'GEISTIG_BEHINDERTE_PERSONEN_IN_HEIMEN_UND_DEREN_BETREUERINNEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (7, '213010', '2.16.756.5.30.1.127.3.3.2', 'KANALISATIONSARBEITER_UND_ANGESTELLTE_VON_KLAERANLAGEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (8, '213011', '2.16.756.5.30.1.127.3.3.2', 'KINDER_AUS_LAENDERN_MIT_MITTLERER_UND_HOHER_ENDEMIZITAET_DIE_IN_DER_SCHWEIZ_LEBEN_UND_FUER_EINEN_VORUEBERGEHENDEN_AUFENTHALT_IN_IHR_HERKUNFTSLAND_ZURUECKKEHREN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (9, '213031', '2.16.756.5.30.1.127.3.3.2', 'KINDERKRIPPE_HORT_VOR_5_MONATEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (10, '213012', '2.16.756.5.30.1.127.3.3.2', 'KONSUMENTEN_VON_INJIZIERBAREN_DROGEN_UND_DEREN_KONTAKTPERSONEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (11, '213032', '2.16.756.5.30.1.127.3.3.2', 'KONTAKTPERSONEN_VON_EINER_SCHWANGEREN_FRAU'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (12, '213027', '2.16.756.5.30.1.127.3.3.2', 'KONTAKTPERSONEN_VON_HEPATITIS_A_ERKRANKTEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (13, '213026', '2.16.756.5.30.1.127.3.3.2', 'KONTAKTPERSONEN_VON_HEPATITIS_B_ERKRANKTEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (14, '213030', '2.16.756.5.30.1.127.3.3.2', 'LABORPERSONAL_MIT_BAKTERIEN_EXPOSITIONSRISIKO'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (15, '213029', '2.16.756.5.30.1.127.3.3.2', 'LABORPERSONAL_MIT_VIRUS_EXPOSITIONSRISIKO'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (16, '213014', '2.16.756.5.30.1.127.3.3.2', 'MAENNER_DIE_MIT_MAENNERN_GESCHLECHTSVERKEHR_HABEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (17, '213033', '2.16.756.5.30.1.127.3.3.2', 'MITARBEITENDE_VON_KINDERKRIPPEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (18, '213024', '2.16.756.5.30.1.127.3.3.2', 'NEUGEBORENE_UND_SAEUGLINGE_UNTER_12_MONATEN_AUS_LAENDERN_MIT_HOHER_TUBERKULOSE_PRAEVALENZ_DIE_WAHRSCHEINLICH_WIEDER_DORTHIN_ZURUECKKEHREN_IN_IHREM_ERSTEN_LEBENSJAHR'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (19, '213025', '2.16.756.5.30.1.127.3.3.2', 'NEUGEBORENE_VON_HBSAG_POSITIVEN_MUETTERN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (20, '213015', '2.16.756.5.30.1.127.3.3.2', 'PATIENTINNEN_UND_PATIENTEN_IN_PFLEGEHEIMEN_UND_IN_EINRICHTUNGEN_FUER_PERSONEN_MIT_CHRONISCHEN_ERKRANKUNGEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (21, '213016', '2.16.756.5.30.1.127.3.3.2', 'PERSONEN_AUS_LAENDERN_MIT_HOHER_ODER_INTERMEDIAERER_HEPATITIS_B_ENDEMIZITAET'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (22, '213017', '2.16.756.5.30.1.127.3.3.2', 'PERSONEN_MIT_EINER_SEXUELL_UEBERTRAGBAREN_KRANKHEIT'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (23, '213018', '2.16.756.5.30.1.127.3.3.2', 'PERSONEN_MIT_ENGEM_KONTAKT_ZU_PERSONEN_AUS_LAENDERN_MIT_HOHER_ENDEMIZITAET'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (24, '213019', '2.16.756.5.30.1.127.3.3.2', 'PERSONEN_MIT_HAEUFIG_WECHSELNDEN_SEXUALPARTNERN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (25, '213020', '2.16.756.5.30.1.127.3.3.2', 'PERSONEN_MIT_REGELMAESSIGEM_KONTAKT_BERUFLICH_ODER_FAMILIAER_ZU_SAEUGLINGEN_UNTER_6_MONATEN_ODER_SCHWANGERE_FRAUEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (26, '213021', '2.16.756.5.30.1.127.3.3.2', 'REKRUTEN_MILITAER'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (27, '213022', '2.16.756.5.30.1.127.3.3.2', 'SOZIALARBEITER_GEFAENGNISPERSONAL_UND_POLIZEIANGESTELLTE_MIT_HAEUFIGEM_KONTAKT_ZU_KONSUMENTEN_VON_INJIZIERBAREN_DROGEN'); INSERT INTO SwissVaccinationPlanExposureRisks (SwissVaccinationPlanExposureRisks_id, code, codeSystem, displayName) VALUES (28, '213023', '2.16.756.5.30.1.127.3.3.2', 'TIERAERZTE_INKL_STUDENTEN_PRAXISANGESTELLTE');