--DROP TABLE IHEXDSclassCode CASCADE; CREATE TABLE IHEXDSclassCode ( IHEXDSclassCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (1, 'ADM', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Administratives Dokument'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (2, 'ANF', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Anforderung'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (3, 'ASM', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Assessment'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (4, 'BEF', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Befundbericht'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (5, 'BIL', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Bilddaten'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (6, 'BRI', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Brief'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (7, 'DOK', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Dokumente ohne besondere Form (Notizen)'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (8, 'DUR', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Durchführungsprotokoll'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (9, 'FOR', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Forschung'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (10, 'GUT', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Gutachten und Qualitätsmanagement'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (11, 'LAB', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Laborergebnisse'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (12, 'AUS', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Medizinischer Ausweis'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (13, 'PLA', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Planungsdokument'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (14, '57016-8', '2.16.840.1.113883.6.1', 'Patienteneinverständniserklärung'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (15, 'VER', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Verordnung'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (16, 'VID', '1.3.6.1.4.1.19376.3.276.1.5.8', 'Videodaten'); INSERT INTO IHEXDSclassCode (IHEXDSclassCode_id, code, codeSystem, displayName) VALUES (17, 'MED', '1.3.6.1.4.1.19376.3.276.1.5.8', 'obsolet');