--DROP TABLE ELGA_ActEncounterCode CASCADE; CREATE TABLE ELGA_ActEncounterCode ( ELGA_ActEncounterCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (1, 'AMB', '2.16.840.1.113883.5.4', 'Ambulatory'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (2, 'EMER', '2.16.840.1.113883.5.4', 'Emergency'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (3, 'HH', '2.16.840.1.113883.5.4', 'Home health'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (4, 'IMP', '2.16.840.1.113883.5.4', 'Inpatient encounter'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (5, 'ACUTE', '2.16.840.1.113883.5.4', 'Inpatient acute'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (6, 'NONAC', '2.16.840.1.113883.5.4', 'Inpatient non-acute'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (7, 'VR', '2.16.840.1.113883.5.4', 'Virtual');