--DROP TABLE eImpf_Impfstoffe_VS CASCADE; CREATE TABLE eImpf_Impfstoffe_VS ( eImpf_Impfstoffe_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_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (1, '0056489', '1.2.40.0.34.4.16.1', 'TETANOL PUR FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (2, '0514986', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,5ML NAD F'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (3, '0515738', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,5ML NAD F'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (4, '1076502', '1.2.40.0.34.4.16.1', 'VAXIGRIP FSPR M.KANUELE'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (5, '1079021', '1.2.40.0.34.4.16.1', 'SANDOVAC FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (6, '1258120', '1.2.40.0.34.4.16.1', 'INFLUVAC FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (7, '1260571', '1.2.40.0.34.4.16.1', 'POLIO SALK MER SPRAMP'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (8, '1265597', '1.2.40.0.34.4.16.1', 'INFLUVAC FSPR 0,5ML O.KANUEL'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (9, '1276939', '1.2.40.0.34.4.16.1', 'ACT-HIB TRSTAMP +LSM'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (10, '1290520', '1.2.40.0.34.4.16.1', 'DT-REDUCT MER FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (11, '1292200', '1.2.40.0.34.4.16.1', 'ENGERIX-B SPRAMP 10MCG'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (12, '1301057', '1.2.40.0.34.4.16.1', 'HAVRIX FSPR 1440 ERW'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (13, '1304498', '1.2.40.0.34.4.16.1', 'TWINRIX ERW 1ML FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (14, '1309515', '1.2.40.0.34.4.16.1', 'TWINRIX KIND 0,5ML FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (15, '1315496', '1.2.40.0.34.4.16.1', 'HAVRIX FSPR 720 JUNIOR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (16, '1316018', '1.2.40.0.34.4.16.1', 'VARILRIX PLV+LSM'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (17, '1325750', '1.2.40.0.34.4.16.1', 'PRIORIX IMPFDS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (18, '1329251', '1.2.40.0.34.4.16.1', 'VIVOTIF KPS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (19, '1333991', '1.2.40.0.34.4.16.1', 'TYPHERIX IJLSG 25MCG/0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (20, '1349762', '1.2.40.0.34.4.16.1', 'FLUAD FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (21, '1350268', '1.2.40.0.34.4.16.1', 'HBVAXPRO SUS INJ 40MCG FLAES'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (22, '1364721', '1.2.40.0.34.4.16.1', 'ENGERIX-B SPRAMP 20MCG'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (23, '2228368', '1.2.40.0.34.4.16.1', 'TD PUR ERW FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (24, '2228374', '1.2.40.0.34.4.16.1', 'TD PUR ERW FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (25, '2246975', '1.2.40.0.34.4.16.1', 'ENCEPUR FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (26, '2249436', '1.2.40.0.34.4.16.1', 'ENCEPUR FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (27, '2420746', '1.2.40.0.34.4.16.1', 'BOOSTRIX IJSUS 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (28, '2427180', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,25ML NAD F'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (29, '2427197', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,25ML NAD F'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (30, '2427872', '1.2.40.0.34.4.16.1', 'ENCEPUR FSPR 0,25ML KIND'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (31, '2434027', '1.2.40.0.34.4.16.1', 'VIATIM IJSUS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (32, '2442831', '1.2.40.0.34.4.16.1', 'HEPATYRIX IJSUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (33, '2454461', '1.2.40.0.34.4.16.1', 'RABIPUR PLV LSM 2,5IE/ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (34, '2454923', '1.2.40.0.34.4.16.1', 'VARIVAX DFL'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (35, '2457324', '1.2.40.0.34.4.16.1', 'BOOSTRIX POLIO IJSUS 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (36, '2465140', '1.2.40.0.34.4.16.1', 'DUKORAL SUSP+BRGRAN 2X1DOSIS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (37, '2467765', '1.2.40.0.34.4.16.1', 'HBVAXPRO SUS INJ 5MCG 2 KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (38, '2467788', '1.2.40.0.34.4.16.1', 'REPEVAX FSPR 0,5ML +KANUELEN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (39, '2467794', '1.2.40.0.34.4.16.1', 'TETRAVAC FSPR +2KANUELE'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (40, '2469988', '1.2.40.0.34.4.16.1', 'REVAXIS SPR+2 KANUE'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (41, '2469994', '1.2.40.0.34.4.16.1', 'TYPHIM VI FSPR 0,5ML +2 KAN.'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (42, '2470017', '1.2.40.0.34.4.16.1', 'STAMARIL DFL+FSPR+2 KANUEL'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (43, '2472795', '1.2.40.0.34.4.16.1', 'PROQUAD PLV FSPR +2KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (44, '2472803', '1.2.40.0.34.4.16.1', 'ROTATEQ QUETSCHTB 2ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (45, '2472826', '1.2.40.0.34.4.16.1', 'ZOSTAVAX PLV +LSM IJSUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (46, '2479314', '1.2.40.0.34.4.16.1', 'INFANRIX HEXA GLASFL.'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (47, '3511764', '1.2.40.0.34.4.16.1', 'MMRVAXPRO PLV FSPR +2KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (48, '3513450', '1.2.40.0.34.4.16.1', 'CERVARIX FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (49, '3514171', '1.2.40.0.34.4.16.1', 'GARDASIL SPR +2KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (50, '3519599', '1.2.40.0.34.4.16.1', 'HBVAXPRO SUS INJ 10MCG 2 KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (51, '3521662', '1.2.40.0.34.4.16.1', 'MENJUGATE PLV +LSM FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (52, '3528434', '1.2.40.0.34.4.16.1', 'FLUVACCINOL INJ-SUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (53, '3532424', '1.2.40.0.34.4.16.1', 'NEISVAC-C FSPR 2 NADEL 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (54, '3533837', '1.2.40.0.34.4.16.1', 'SYNFLORIX FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (55, '3537551', '1.2.40.0.34.4.16.1', 'IXIARO FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (56, '3539969', '1.2.40.0.34.4.16.1', 'INTANZA 15MCG FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (57, '3756589', '1.2.40.0.34.4.16.1', 'PREVENAR INJ.SUS 13 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (58, '3760993', '1.2.40.0.34.4.16.1', 'ROTARIX SUS FAPPLIK.1,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (59, '3761739', '1.2.40.0.34.4.16.1', 'INTANZA 9MCG FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (60, '3762986', '1.2.40.0.34.4.16.1', 'PRIORIX TETRA PLV DFL FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (61, '3782291', '1.2.40.0.34.4.16.1', 'MENVEO PLV IJLSG DFL+DFL'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (62, '3904699', '1.2.40.0.34.4.16.1', 'VAQTA FSPR INJ.SUS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (63, '3904713', '1.2.40.0.34.4.16.1', 'VAQTA K FSPR INJ.SUS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (64, '3909165', '1.2.40.0.34.4.16.1', 'NIMENRIX IJLSG FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (65, '3911995', '1.2.40.0.34.4.16.1', 'OPTAFLU INJ-SUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (66, '3919867', '1.2.40.0.34.4.16.1', 'OPTAFLU INJ-SUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (67, '3920095', '1.2.40.0.34.4.16.1', 'BEXSERO INJ.SUS FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (68, '3925649', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,25ML NAD B'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (69, '3925655', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,25ML NAD B'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (70, '3927186', '1.2.40.0.34.4.16.1', 'FLUARIX INJ.SUS FSPR O.NADEL'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (71, '3928168', '1.2.40.0.34.4.16.1', 'HEXYON IJSUSP FSPR +2 KAN.'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (72, '3932448', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,5ML NAD B'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (73, '3932454', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,5ML NAD B'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (74, '4202025', '1.2.40.0.34.4.16.1', 'FLUENZ TETRA NA-SPRAY'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (75, '4202031', '1.2.40.0.34.4.16.1', 'FLUENZ TETRA NA-SPRAY'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (76, '4202462', '1.2.40.0.34.4.16.1', 'PNEUMOVAX 23 DFL 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (77, '4205785', '1.2.40.0.34.4.16.1', 'FLUARIX TETRA IJSUSP FSPR 2N'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (78, '4209197', '1.2.40.0.34.4.16.1', 'PNEUMOVAX 23 FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (79, '4209694', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,5ML+S.NAD'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (80, '4209702', '1.2.40.0.34.4.16.1', 'FSME-IMMUN FSPR 0,25ML+S.NAD'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (81, '4215720', '1.2.40.0.34.4.16.1', 'VAXIGRIP FSPR O.KANUELE'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (82, '4224707', '1.2.40.0.34.4.16.1', 'GARDASIL 9 FSPR +2KAN'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (83, '4453106', '1.2.40.0.34.4.16.1', 'MENJUGATE IJSUS 10MCG FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (84, '4465799', '1.2.40.0.34.4.16.1', 'RABIPUR FSPR'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (85, '4467841', '1.2.40.0.34.4.16.1', 'VAXIGRIP TETRA IJSUS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (86, '4467858', '1.2.40.0.34.4.16.1', 'VAXIGRIP TETRA IJSUS O.KANUE'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (87, '4482993', '1.2.40.0.34.4.16.1', 'INFLUVAC TETRA FSPR 0,5ML'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (88, '4961340', '1.2.40.0.34.4.16.1', 'VIVOTIF MSR HKPS'); INSERT INTO eImpf_Impfstoffe_VS (eImpf_Impfstoffe_VS_id, code, codeSystem, displayName) VALUES (89, '4963681', '1.2.40.0.34.4.16.1', 'FLUCELVAX TETRA IJSUS FSPR');