--DROP TABLE DocumentEntry.classCode CASCADE; CREATE TABLE DocumentEntry.classCode ( DocumentEntry.classCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (1, '371531000', '2.16.840.1.113883.6.96', 'Report of clinical encounter (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (2, '721927009', '2.16.840.1.113883.6.96', 'Referral note (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (3, '721963009', '2.16.840.1.113883.6.96', 'Order (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (4, '422735006', '2.16.840.1.113883.6.96', 'Summary clinical document (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (5, '371525003', '2.16.840.1.113883.6.96', 'Clinical procedure report (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (6, '734163000', '2.16.840.1.113883.6.96', 'Care plan (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (7, '440545006', '2.16.840.1.113883.6.96', 'Prescription record (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (8, '184216000', '2.16.840.1.113883.6.96', 'Patient record type (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (9, '371537001', '2.16.840.1.113883.6.96', 'Consent report (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (10, '371538006', '2.16.840.1.113883.6.96', 'Advance directive report (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (11, '722160009', '2.16.840.1.113883.6.96', 'Audit trail report (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (12, '722216001', '2.16.840.1.113883.6.96', 'Emergency medical identification record (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (13, '772790007', '2.16.840.1.113883.6.96', 'Organ donor card (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (14, '405624007', '2.16.840.1.113883.6.96', 'Administrative documentation (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (15, '417319006', '2.16.840.1.113883.6.96', 'Record of health event (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (16, '2171000195109', '2.16.756.5.30.1.127.3.4', 'Obstetrical record (record artifact)'); INSERT INTO DocumentEntry.classCode (DocumentEntry.classCode_id, code, codeSystem, displayName) VALUES (17, '419891008', '2.16.840.1.113883.6.96', 'Record artifact (record artifact)');