--DROP TABLE ParticipationMode CASCADE; CREATE TABLE ParticipationMode ( ParticipationMode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (1, 'PHYSICAL', '2.16.840.1.113883.5.1064', 'physical presence'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (2, 'REMOTE', '2.16.840.1.113883.5.1064', 'remote presence'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (3, 'VERBAL', '2.16.840.1.113883.5.1064', 'verbal'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (4, 'DICTATE', '2.16.840.1.113883.5.1064', 'dictated'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (5, 'FACE', '2.16.840.1.113883.5.1064', 'face-to-face'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (6, 'PHONE', '2.16.840.1.113883.5.1064', 'telephone'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (7, 'VIDEOCONF', '2.16.840.1.113883.5.1064', 'videoconferencing'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (8, 'WRITTEN', '2.16.840.1.113883.5.1064', 'written'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (9, 'FAXWRIT', '2.16.840.1.113883.5.1064', 'telefax'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (10, 'HANDWRIT', '2.16.840.1.113883.5.1064', 'handwritten'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (11, 'MAILWRIT', '2.16.840.1.113883.5.1064', 'mail'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (12, 'ONLINEWRIT', '2.16.840.1.113883.5.1064', 'online written'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (13, 'EMAILWRIT', '2.16.840.1.113883.5.1064', 'email'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (14, 'TYPEWRIT', '2.16.840.1.113883.5.1064', 'typewritten'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (15, 'ELECTRONIC', '2.16.840.1.113883.5.1064', 'electronic data'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (16, 'PHYSICAL', '2.16.840.1.113883.5.1064', 'physical presence'); INSERT INTO ParticipationMode (ParticipationMode_id, code, codeSystem, displayName) VALUES (17, 'VERBAL', '2.16.840.1.113883.5.1064', 'verbal');