--DROP TABLE EprDocumentTypeCode CASCADE; CREATE TABLE EprDocumentTypeCode ( EprDocumentTypeCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (1, '371537001', '2.16.840.1.113883.6.96', 'Consent report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (2, '371538006', '2.16.840.1.113883.6.96', 'Advance directive report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (3, '371534008', '2.16.840.1.113883.6.96', 'Summary report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (4, '721912009', '2.16.840.1.113883.6.96', 'Medication summary document (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (5, '440545006', '2.16.840.1.113883.6.96', 'Prescription record (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (6, '275670009', '2.16.840.1.113883.6.96', 'Prescription exemption certificate (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (7, '1221000195109', '2.16.840.1.113883.6.96', 'Medication Comment (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (8, '721915006', '2.16.840.1.113883.6.96', 'Admission request document (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (9, '371542009', '2.16.840.1.113883.6.96', 'Admission history and physical report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (10, '721917003', '2.16.840.1.113883.6.96', 'Physician discharge concise summary (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (11, '373942005', '2.16.840.1.113883.6.96', 'Discharge summary (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (12, '371535009', '2.16.840.1.113883.6.96', 'Transfer summary report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (13, '278448002', '2.16.840.1.113883.6.96', 'Care plan (qualifier value)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (14, '5531000179105', '2.16.840.1.113883.6.96', 'Nursing report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (15, '721927009', '2.16.840.1.113883.6.96', 'Referral note (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (16, '371530004', '2.16.840.1.113883.6.96', 'Clinical consultation report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (17, '371525003', '2.16.840.1.113883.6.96', 'Clinical procedure report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (18, '4241000179101', '2.16.840.1.113883.6.96', 'Laboratory report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (19, '371528001', '2.16.840.1.113883.6.96', 'Pathology report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (20, '721631001', '2.16.840.1.113883.6.96', 'Bone marrow pathology biopsy report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (21, '721968000', '2.16.840.1.113883.6.96', 'Cardiac catheterization report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (22, '399345000', '2.16.840.1.113883.6.96', 'Adult echocardiography procedure report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (23, '4221000179107', '2.16.840.1.113883.6.96', 'Ultrasound imaging report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (24, '371527006', '2.16.840.1.113883.6.96', 'Radiology report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (25, '721969008', '2.16.840.1.113883.6.96', 'Pulmonary function report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (26, '416779005', '2.16.840.1.113883.6.96', 'Anesthesia record (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (27, '371526002', '2.16.840.1.113883.6.96', 'Operative report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (28, '444561001', '2.16.840.1.113883.6.96', 'Birth certificate (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (29, '307930005', '2.16.840.1.113883.6.96', 'Death certificate (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (30, '721599005', '2.16.840.1.113883.6.96', 'Wound care management note (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (31, '371532007', '2.16.840.1.113883.6.96', 'Progress report (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (32, '722091001', '2.16.840.1.113883.6.96', 'Conclusion interpretation document (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (33, '900000000000471000', '2.16.840.1.113883.6.96', 'Image reference (foundation metadata concept)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (34, '41000179103', '2.16.840.1.113883.6.96', 'Immunization record (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (35, '424975005', '2.16.840.1.113883.6.96', 'Record entry (record artifact)'); INSERT INTO EprDocumentTypeCode (EprDocumentTypeCode_id, code, codeSystem, displayName) VALUES (36, '722160009', '2.16.840.1.113883.6.96', 'Audit trail report (record artifact) ');