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