--DROP TABLE x_EncounterParticipant CASCADE; CREATE TABLE x_EncounterParticipant ( x_EncounterParticipant_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO x_EncounterParticipant (x_EncounterParticipant_id, code, codeSystem, displayName) VALUES (1, 'ADM', '2.16.840.1.113883.5.90', 'admitter'); INSERT INTO x_EncounterParticipant (x_EncounterParticipant_id, code, codeSystem, displayName) VALUES (2, 'ATND', '2.16.840.1.113883.5.90', 'attender'); INSERT INTO x_EncounterParticipant (x_EncounterParticipant_id, code, codeSystem, displayName) VALUES (3, 'CON', '2.16.840.1.113883.5.90', 'consultant'); INSERT INTO x_EncounterParticipant (x_EncounterParticipant_id, code, codeSystem, displayName) VALUES (4, 'DIS', '2.16.840.1.113883.5.90', 'discharger'); INSERT INTO x_EncounterParticipant (x_EncounterParticipant_id, code, codeSystem, displayName) VALUES (5, 'REF', '2.16.840.1.113883.5.90', 'referrer');