--DROP TABLE ELGA_SectionsEntlassungAerztl CASCADE; CREATE TABLE ELGA_SectionsEntlassungAerztl ( ELGA_SectionsEntlassungAerztl_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (1, 'BRIEFT', '1.2.40.0.34.5.40', 'Brieftext'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (2, 'ABBEM', '1.2.40.0.34.5.40', 'Abschließende Bemerkungen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (3, 'TERMIN', '1.2.40.0.34.5.40', 'Termine, Kontrollen, Wiederbestellung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (4, 'BEFAUS', '1.2.40.0.34.5.40', 'Ausstehende Befunde'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (5, 'BEFERH', '1.2.40.0.34.5.40', 'Auszüge aus erhobenen Befunden'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (6, 'BEFBEI', '1.2.40.0.34.5.40', 'Beigelegte erhobene Befunde'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (7, 'BEIL', '1.2.40.0.34.5.40', 'Beilagen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (8, 'ANM', '1.2.40.0.34.5.40', 'Anmerkungen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (9, 'RES', '1.2.40.0.34.5.40', 'Hilfsmittel und Ressourcen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (10, 'PFDIAG', '1.2.40.0.34.5.40', 'Pflege- und Betreuungsdiagnosen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (11, 'PFMOB', '1.2.40.0.34.5.40', 'Mobilität'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (12, 'PFKLEI', '1.2.40.0.34.5.40', 'Körperpflege und Kleiden'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (13, 'PFERN', '1.2.40.0.34.5.40', 'Ernährung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (14, 'PFAUS', '1.2.40.0.34.5.40', 'Ausscheidung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (15, 'PFHAUT', '1.2.40.0.34.5.40', 'Hautzustand'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (16, 'PFATM', '1.2.40.0.34.5.40', 'Atmung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (17, 'PFSCHL', '1.2.40.0.34.5.40', 'Schlafen'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (18, 'PFORIE', '1.2.40.0.34.5.40', 'Orientierung und Bewusstseinslage'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (19, 'PFSOZV', '1.2.40.0.34.5.40', 'Soziales Verhalten'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (20, 'PFKOMM', '1.2.40.0.34.5.40', 'Kommunikation'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (21, 'PFROLL', '1.2.40.0.34.5.40', 'Rollenwahrnehmung und Sinnfindung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (22, 'PFMED', '1.2.40.0.34.5.40', 'Medikamentenverabreichung'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (23, '42348-3', '2.16.840.1.113883.6.1', 'Advance directives'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (24, '8716-3', '2.16.840.1.113883.6.1', 'Vital signs'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (25, '51898-5', '2.16.840.1.113883.6.1', 'Risk factors'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (26, '42349-1', '2.16.840.1.113883.6.1', 'Reason for Referral'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (27, '11535-2', '2.16.840.1.113883.6.1', 'Hospital Discharge DX'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (28, '29554-3', '2.16.840.1.113883.6.1', 'Procedure narrative'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (29, '10160-0', '2.16.840.1.113883.6.1', 'History of medication use'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (30, '10183-2', '2.16.840.1.113883.6.1', 'Hospital discharge medications'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (31, '18776-5', '2.16.840.1.113883.6.1', 'Treatment plan'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (32, '47420-5', '2.16.840.1.113883.6.1', 'Functional status assessment'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (33, '8648-8', '2.16.840.1.113883.6.1', 'Hospital course'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (34, '48765-2', '2.16.840.1.113883.6.1', 'Allergies, adverse reactions, alerts'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (35, '11493-4', '2.16.840.1.113883.6.1', 'Hospital discharge studies summary'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (36, '10164-2', '2.16.840.1.113883.6.1', 'History of present illness'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (37, '11348-0', '2.16.840.1.113883.6.1', 'History of past illness'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (38, '42346-7', '2.16.840.1.113883.6.1', 'Medications on admission'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (39, '18610-6', '2.16.840.1.113883.6.1', 'Medication administered'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (40, '38212-7', '2.16.840.1.113883.6.1', 'Pain Assessment Panel'); INSERT INTO ELGA_SectionsEntlassungAerztl (ELGA_SectionsEntlassungAerztl_id, code, codeSystem, displayName) VALUES (41, '8650-4', '2.16.840.1.113883.6.1', 'Hospital discharge disposition');