--DROP TABLE eImpf_SpecialCaseVaccination_VS CASCADE; CREATE TABLE eImpf_SpecialCaseVaccination_VS ( eImpf_SpecialCaseVaccination_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_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (1, '_Rot', '1.2.40.0.34.5.183', 'Rot'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (2, '424272000', '2.16.840.1.113883.6.96', 'Inadequate immune status (finding)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (3, 'NEUER_CODE_angefordert_ersetzt_171259000', '2.16.840.1.113883.6.96', 'Immunization overdue (finding)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (4, '_Gelb', '1.2.40.0.34.5.183', 'Gelb'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (5, '171279008', '2.16.840.1.113883.6.96', 'Immunization due (finding)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (6, 'NEUER_CODE_angefordert_ersetzt_310373003', '2.16.840.1.113883.6.96', 'Date immunization due (observable entity)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (7, '_Gelb-leer', '1.2.40.0.34.5.183', 'Gelb-leer'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (8, '122541000119104', '2.16.840.1.113883.6.96', 'Vaccination needed (situation)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (9, '_Grün', '1.2.40.0.34.5.183', 'Grün'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (10, '191441008', '2.16.840.1.113883.6.96', 'Acquired immunity, function (observable entity)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (11, '713404003', '2.16.840.1.113883.6.96', 'Vaccination given (situation)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (12, '171258008', '2.16.840.1.113883.6.96', 'Up-to-date with immunizations (finding)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (13, '_Blau', '1.2.40.0.34.5.183', 'Blau'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (14, '723620004', '2.16.840.1.113883.6.96', 'Requires vaccination (finding)'); INSERT INTO eImpf_SpecialCaseVaccination_VS (eImpf_SpecialCaseVaccination_VS_id, code, codeSystem, displayName) VALUES (15, '171288004', '2.16.840.1.113883.6.96', 'No immunization history record (finding)');