--DROP TABLE xds_clasCod CASCADE; CREATE TABLE xds_clasCod ( xds_clasCod_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (1, '1211000195104', '2.16.840.1.113883.6.96', 'Note on Consultation (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (2, '1231000195106', '2.16.840.1.113883.6.96', 'Progress Note (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (3, '1241000195103', '2.16.840.1.113883.6.96', 'Note on Procedure (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (4, '1251000195100', '2.16.840.1.113883.6.96', 'Test or Procedure Request (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (5, '1261000195102', '2.16.840.1.113883.6.96', 'Clinical Care Referral (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (6, '1271000195108', '2.16.840.1.113883.6.96', 'Episode Summary Report (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (7, '371532007', '2.16.840.1.113883.6.96', 'Progress report (qualifier value)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (8, '1291000195107', '2.16.840.1.113883.6.96', 'Diagnostic Test Result (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (9, '1301000195106', '2.16.840.1.113883.6.96', 'Notification (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (10, '1281000195105', '2.16.840.1.113883.6.96', 'Historic Overview (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (11, '1311000195108', '2.16.840.1.113883.6.96', 'Present State Summary (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (12, '1321000195103', '2.16.840.1.113883.6.96', 'Care Plan (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (13, '308707006', '2.16.840.1.113883.6.96', 'Certificate (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (14, '1331000195101', '2.16.840.1.113883.6.96', 'Alert (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (15, '1351000195107', '2.16.840.1.113883.6.96', 'Data from Patient (record artifact)'); INSERT INTO xds_clasCod (xds_clasCod_id, code, codeSystem, displayName) VALUES (16, '419891008', '2.16.840.1.113883.6.96', 'Other Composition');