--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, '_ActEncounterCode', '2.16.840.1.113883.5.4', 'ActEncounterCode'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (2, 'AMB', '2.16.840.1.113883.5.4', 'ambulatory'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (3, 'EMER', '2.16.840.1.113883.5.4', 'emergency'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (4, 'FLD', '2.16.840.1.113883.5.4', 'field'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (5, 'HH', '2.16.840.1.113883.5.4', 'home health'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (6, 'IMP', '2.16.840.1.113883.5.4', 'inpatient encounter'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (7, 'ACUTE', '2.16.840.1.113883.5.4', 'inpatient acute'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (8, 'NONAC', '2.16.840.1.113883.5.4', 'inpatient non-acute'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (9, 'PRENC', '2.16.840.1.113883.5.4', 'pre-admission'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (10, 'SS', '2.16.840.1.113883.5.4', 'short stay'); INSERT INTO ELGA_ActEncounterCode (ELGA_ActEncounterCode_id, code, codeSystem, displayName) VALUES (11, 'VR', '2.16.840.1.113883.5.4', 'virtual');