--DROP TABLE ActEncounterCode CASCADE; CREATE TABLE ActEncounterCode ( ActEncounterCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (1, 'AMB', '2.16.840.1.113883.5.4', 'ambulatory'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (2, 'EMER', '2.16.840.1.113883.5.4', 'emergency'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (3, 'FLD', '2.16.840.1.113883.5.4', 'field'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (4, 'HH', '2.16.840.1.113883.5.4', 'home health'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (5, 'IMP', '2.16.840.1.113883.5.4', 'inpatient encounter'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (6, 'ACUTE', '2.16.840.1.113883.5.4', 'inpatient acute'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (7, 'NONAC', '2.16.840.1.113883.5.4', 'inpatient non-acute'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (8, 'PRENC', '2.16.840.1.113883.5.4', 'pre-admission'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (9, 'SS', '2.16.840.1.113883.5.4', 'short stay'); INSERT INTO ActEncounterCode (ActEncounterCode_id, code, codeSystem, displayName) VALUES (10, 'VR', '2.16.840.1.113883.5.4', 'virtual');