--DROP TABLE DocumentEntry.formatCode CASCADE; CREATE TABLE DocumentEntry.formatCode ( DocumentEntry.formatCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (1, 'urn:che:epr:EPR_Unstructured_Document', '2.16.756.5.30.1.127.3.10.10', 'Unstructured EPR document'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (2, '1.2.840.10008.5.1.4.1.1.88.59', '1.2.840.10008.2.6.1', 'DICOM Manifest (DICOM KOS SOP Class UID)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (3, 'urn:ihe:rad:TEXT', '1.3.6.1.4.1.19376.1.2.3', 'XDS-I CDA Wrapped Text Report (XDS-I)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (4, 'urn:ihe:rad:PDF', '1.3.6.1.4.1.19376.1.2.3', 'XDS-I PDF (XDS-I)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (5, 'urn:ihe:rad:CDA:ImagingReportStructuredHeadings:2013', '1.3.6.1.4.1.19376.1.2.3', 'XDS-I Imaging Report with Structured Headings (XDS-I)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (6, 'urn:ihe:iti:xds-sd:pdf:2008', '1.3.6.1.4.1.19376.1.2.3', 'Scanned Documents (PDF)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (7, 'urn:ihe:iti:xds-sd:text:2008', '1.3.6.1.4.1.19376.1.2.3', 'Scanned Documents (text)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (8, 'urn:ihe:pharm:pml:2013', '1.3.6.1.4.1.19376.1.2.3', 'Community Medication List'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (9, 'urn:ihe:pharm:pre:2010', '1.3.6.1.4.1.19376.1.2.3', 'Community Prescription'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (10, 'urn:ihe:pharm:dis:2010', '1.3.6.1.4.1.19376.1.2.3', 'Community Dispense'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (11, 'urn:ihe:pharm:mtp:2015', '1.3.6.1.4.1.19376.1.2.3', 'Community Medication Treatment Plan'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (12, 'urn:ihe:pharm:padv:2010', '1.3.6.1.4.1.19376.1.2.3', 'Community Pharmaceutical Advice'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (13, 'urn:ihe:lab:xd-lab:2008', '1.3.6.1.4.1.19376.1.2.3', 'CDA Laboratory Report'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (14, 'urn:ihe:pcc:ic:2009', '1.3.6.1.4.1.19376.1.2.3', 'Immunization Content (IC)'); INSERT INTO DocumentEntry.formatCode (DocumentEntry.formatCode_id, code, codeSystem, displayName) VALUES (15, 'urn:ihe:iti:xds:2017:mimeTypeSufficient', '1.3.6.1.4.1.19376.1.2.3', 'MimeType sufficient');