--DROP TABLE SwissVaccinationPlanComplicationRisks CASCADE; CREATE TABLE SwissVaccinationPlanComplicationRisks ( SwissVaccinationPlanComplicationRisks_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (1, '113001', '2.16.756.5.30.1.127.3.3.1', 'ANATOMISCHE_ODER_FUNKTIONELLE_ASPLENIE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (2, '114036', '2.16.756.5.30.1.127.3.3.1', 'ANDERE_LEBERERKRANKUNG'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (3, '114006', '2.16.756.5.30.1.127.3.3.1', 'ANDERE_LUNGENERKRANKUNGEN_ZB_MUKOVISZIDOSE_ASTHMA_BRONCHIALE_ETC'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (4, '114033', '2.16.756.5.30.1.127.3.3.1', 'ANDERE_NIERENERKRANKUNG'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (5, '114034', '2.16.756.5.30.1.127.3.3.1', 'ANDERER_KREBS'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (6, '114025', '2.16.756.5.30.1.127.3.3.1', 'ANGEBORENE_IMMUNDEFIZIENZ_VARIABLES_IMMUNDEFEKTSYNDROM_DEFIZITAERE_ANTWORT_AUF_POLYSACCHARIDE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (7, '114021', '2.16.756.5.30.1.127.3.3.1', 'AUTOIMMUNKRANKHEIT_WELCHE_EINE_IMMUNSUPPRESSION_ERFORDERT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (8, '114005', '2.16.756.5.30.1.127.3.3.1', 'BRONCHIEKTASEN_DURCH_ANTIKOERPERMANGEL'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (9, '114003', '2.16.756.5.30.1.127.3.3.1', 'CHRONISCH_OBSTRUKTIVE_PNEUMOPATHIE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (10, '114007', '2.16.756.5.30.1.127.3.3.1', 'CHRONISCHE_LEBERERKRANKUNG'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (11, '113002', '2.16.756.5.30.1.127.3.3.1', 'COCHLEAIMPLANTAT_IN_SITU_ODER_GEPLANT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (12, '114015', '2.16.756.5.30.1.127.3.3.1', 'DIABETES_MIT_AUSWIRKUNG_AUF_DIE_FUNKTION_VON_HERZ_LUNGEN_ODER_NIEREN'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (13, '114019', '2.16.756.5.30.1.127.3.3.1', 'EMPFAENGER_EINER_SOLIDORGANTRANSPLANTATION'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (14, '114020', '2.16.756.5.30.1.127.3.3.1', 'EMPFAENGER_EINER_STAMMZELLTRANSPLANTATION'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (15, '113004', '2.16.756.5.30.1.127.3.3.1', 'GEBURT_VOR_DER_33_SCHWANGERSCHAFTSWOCHE_ODER_GEBURTSGEWICHT_GROESSER_1500G'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (16, '114037', '2.16.756.5.30.1.127.3.3.1', 'HAEMODIALYSEPATIENT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (17, '114038', '2.16.756.5.30.1.127.3.3.1', 'HAEMOPHILIE_PATIENT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (18, '114001', '2.16.756.5.30.1.127.3.3.1', 'HERZINSUFFIZIENZ'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (19, '113007', '2.16.756.5.30.1.127.3.3.1', 'HERZKRANKHEITEN_CHRONISCHE_KONGENITALE_MISSBILDUNGEN'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (20, '113008', '2.16.756.5.30.1.127.3.3.1', 'HIV_INFEKTION_MIT_CD4_ZELLEN_GROESSER_GLEICH_15_PROZENT_ERWACHSENE_GROESSER_GLEICH_200_PRO_UL'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (21, '113009', '2.16.756.5.30.1.127.3.3.1', 'HIV_INFEKTION_MIT_CD4_ZELLEN_KLEINER_15_PROZENT_ERWACHSENE_KLEINER_200_PRO_UL'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (22, '114018', '2.16.756.5.30.1.127.3.3.1', 'KANDIDATEN_FUER_EINE_SOLIDORGANTRANSPLANTATION'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (23, '114002', '2.16.756.5.30.1.127.3.3.1', 'KARDIOPATHIE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (24, '114008', '2.16.756.5.30.1.127.3.3.1', 'LEBERZIRRHOSE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (25, '113012', '2.16.756.5.30.1.127.3.3.1', 'LYMPHOM_LEUKAEMIE_MYELOM'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (26, '118001', '2.16.756.5.30.1.127.3.3.1', 'LYMPHOM_LEUKAEMIE_MYELOM_WAEHREND_KLINISCHER_REMISSION'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (27, '113014', '2.16.756.5.30.1.127.3.3.1', 'MANGEL_AN_MANNOSE_BINDENDEM_LEKTIN'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (28, '114026', '2.16.756.5.30.1.127.3.3.1', 'MANGEL_IM_KLASSISCHEN_ODER_ALTERNATIVEN_WEG_DER_KOMPLEMENTAKTIVIERUNG'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (29, '114022', '2.16.756.5.30.1.127.3.3.1', 'MEDIKAMENTOESE_IMMUNOSUPPRESSION_INKL_SYSTEMISCHE_LANGZEITKORTIKOIDTHERAPIE_UND_RADIOTHERAPIE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (30, '114016', '2.16.756.5.30.1.127.3.3.1', 'MORBIDE_ADIPOSITAS_BMI_GROESSER_40'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (31, '113018', '2.16.756.5.30.1.127.3.3.1', 'NEPHROTISCHES_SYNDROM'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (32, '114012', '2.16.756.5.30.1.127.3.3.1', 'NEUROMUSKULAERE_KRANKHEIT_FALLS_AUSWIRKUNGEN_AUF_HERZ__LUNGEN_ODER_NIERENFUNKTION'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (33, '113023', '2.16.756.5.30.1.127.3.3.1', 'NIERENINSUFFIZIENZ'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (34, '114035', '2.16.756.5.30.1.127.3.3.1', 'PROTEIN_S_ODER_PROTEIN_C_DEFIZIT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (35, '113035', '2.16.756.5.30.1.127.3.3.1', 'RHEUMATISMUS_ODER_AUTOIMMUNKRANKHEIT_WELCHE_EINE_IMMUNSUPPRESSION_BEDINGT'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (36, '114032', '2.16.756.5.30.1.127.3.3.1', 'SCHAEDELBASISFRAKTUR_MISSBILDUNG_ZEREBROSPINALE_LIQUORFISTEL'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (37, '114028', '2.16.756.5.30.1.127.3.3.1', 'SCHWANGERSCHAFT_UND_POST_PARTUM_PERIODE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (38, '113021', '2.16.756.5.30.1.127.3.3.1', 'SCHWERE_NEURODERMITIS_BEIM_KIND'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (39, '114004', '2.16.756.5.30.1.127.3.3.1', 'SCHWERES_ASTHMA_BEI_VERLAENGERTER_ODER_HAEUFIGER_BEHANDLUNG_MIT_ORALEN_STEROIDEN'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (40, '114014', '2.16.756.5.30.1.127.3.3.1', 'SICHELZELLANAEMIE'); INSERT INTO SwissVaccinationPlanComplicationRisks (SwissVaccinationPlanComplicationRisks_id, code, codeSystem, displayName) VALUES (41, '113036', '2.16.756.5.30.1.127.3.3.1', 'ZOELIAKIE');