--DROP TABLE ActPriority CASCADE; CREATE TABLE ActPriority ( ActPriority_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (1, 'A', '2.16.840.1.113883.5.7', 'ASAP'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (2, 'CR', '2.16.840.1.113883.5.7', 'callback results'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (3, 'EL', '2.16.840.1.113883.5.7', 'elective'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (4, 'EM', '2.16.840.1.113883.5.7', 'emergency'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (5, 'P', '2.16.840.1.113883.5.7', 'preop'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (6, 'PRN', '2.16.840.1.113883.5.7', 'as needed'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (7, 'R', '2.16.840.1.113883.5.7', 'routine'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (8, 'RR', '2.16.840.1.113883.5.7', 'rush reporting'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (9, 'S', '2.16.840.1.113883.5.7', 'stat'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (10, 'T', '2.16.840.1.113883.5.7', 'timing critical'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (11, 'UD', '2.16.840.1.113883.5.7', 'use as directed'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (12, 'UR', '2.16.840.1.113883.5.7', 'urgent'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (13, 'CS', '2.16.840.1.113883.5.7', 'callback for scheduling'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (14, 'CSP', '2.16.840.1.113883.5.7', 'callback placer for scheduling'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (15, 'CSR', '2.16.840.1.113883.5.7', 'contact recipient for scheduling'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (16, 'EL', '2.16.840.1.113883.5.7', 'elective'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (17, 'EM', '2.16.840.1.113883.5.7', 'emergency'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (18, 'R', '2.16.840.1.113883.5.7', 'routine'); INSERT INTO ActPriority (ActPriority_id, code, codeSystem, displayName) VALUES (19, 'UR', '2.16.840.1.113883.5.7', 'urgent');