--DROP TABLE ELGA_Sections CASCADE; CREATE TABLE ELGA_Sections ( ELGA_Sections_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (1, 'BRIEFT', '1.2.40.0.34.5.40', 'Brieftext'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (2, 'ABBEM', '1.2.40.0.34.5.40', 'Abschließende Bemerkungen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (3, 'TERMIN', '1.2.40.0.34.5.40', 'Termine, Kontrollen, Wiederbestellung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (4, 'BEFAUS', '1.2.40.0.34.5.40', 'Ausstehende Befunde'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (5, 'BEFERH', '1.2.40.0.34.5.40', 'Auszüge aus erhobenen Befunden'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (6, 'BEFBEI', '1.2.40.0.34.5.40', 'Beigelegte erhobene Befunde'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (7, 'BEIL', '1.2.40.0.34.5.40', 'Beilagen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (8, 'ANM', '1.2.40.0.34.5.40', 'Anmerkungen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (9, 'RES', '1.2.40.0.34.5.40', 'Hilfsmittel und Ressourcen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (10, 'PFDIAG', '1.2.40.0.34.5.40', 'Pflege- und Betreuungsdiagnosen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (11, 'PFMOB', '1.2.40.0.34.5.40', 'Mobilität'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (12, 'PFKLEI', '1.2.40.0.34.5.40', 'Körperpflege und Kleiden'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (13, 'PFERN', '1.2.40.0.34.5.40', 'Ernährung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (14, 'PFAUS', '1.2.40.0.34.5.40', 'Ausscheidung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (15, 'PFHAUT', '1.2.40.0.34.5.40', 'Hautzustand'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (16, 'PFATM', '1.2.40.0.34.5.40', 'Atmung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (17, 'PFSCHL', '1.2.40.0.34.5.40', 'Schlafen'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (18, 'PFORIE', '1.2.40.0.34.5.40', 'Orientierung und Bewusstseinslage'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (19, 'PFSOZV', '1.2.40.0.34.5.40', 'Soziales Verhalten'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (20, 'PFKOMM', '1.2.40.0.34.5.40', 'Kommunikation'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (21, 'PFROLL', '1.2.40.0.34.5.40', 'Rollenwahrnehmung und Sinnfindung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (22, 'PFMED', '1.2.40.0.34.5.40', 'Medikamentenverabreichung'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (23, '57828-6', '2.16.840.1.113883.6.1', 'Prescriptions'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (24, '60590-7', '2.16.840.1.113883.6.1', 'Medication Dispensed.Brief'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (25, '10160-0', '2.16.840.1.113883.6.1', 'History of medication use'); INSERT INTO ELGA_Sections (ELGA_Sections_id, code, codeSystem, displayName) VALUES (26, '61357-0', '2.16.840.1.113883.6.1', 'Medication Pharmaceutical Advice.Brief');