--DROP TABLE Immunizationstatustypes CASCADE; CREATE TABLE Immunizationstatustypes ( Immunizationstatustypes_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (1, '11458-7', '2.16.840.1.113883.6.1', 'Clostridium tetani immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (2, '55263-8', '2.16.840.1.113883.6.1', 'Bordetella pertussis immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (3, '55272-9', '2.16.840.1.113883.6.1', 'Corynebacterium diphtheriae immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (4, '55266-1', '2.16.840.1.113883.6.1', 'Haemophilus influenzae B immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (5, '55264-6', '2.16.840.1.113883.6.1', 'Hepatitis A virus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (6, '55267-9', '2.16.840.1.113883.6.1', 'Human papilloma virus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (7, '55262-0', '2.16.840.1.113883.6.1', 'Influenza virus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (8, '55269-5', '2.16.840.1.113883.6.1', 'Neisseria meningitidis immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (9, '55273-7', '2.16.840.1.113883.6.1', 'Polio virus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (10, '55261-2', '2.16.840.1.113883.6.1', 'Rabies virus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (11, '55268-7', '2.16.840.1.113883.6.1', 'Rotavirus immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (12, '55271-1', '2.16.840.1.113883.6.1', 'Streptococcus pneumoniae conjugated immunization status'); INSERT INTO Immunizationstatustypes (Immunizationstatustypes_id, code, codeSystem, displayName) VALUES (13, '55270-3', '2.16.840.1.113883.6.1', 'Streptococcus pneumoniae polyvalent immunization status');