← BackSQL

voc-1.2.276.0.76.11.61-2016-02-21T000000.sql

Download
    --DROP TABLE CEDIS30 CASCADE;
    CREATE TABLE CEDIS30 (
            CEDIS30_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (1, 'CV', '1.2.276.0.76.5.439', 'Kardiovaskulär');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (2, '001', '1.2.276.0.76.5.439', 'Herzstillstand (nicht traumatisch)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (3, '002', '1.2.276.0.76.5.439', 'Herzstillstand (traumatisch)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (4, '003', '1.2.276.0.76.5.439', 'Brustschmerz (kardial)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (5, '004', '1.2.276.0.76.5.439', 'Brustschmerz (nicht kardial)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (6, '005', '1.2.276.0.76.5.439', 'Palpitationen/unregelmäßiger Herzschlag');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (7, '006', '1.2.276.0.76.5.439', 'Hypertonie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (8, '007', '1.2.276.0.76.5.439', 'Allgemeine Schwäche');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (9, '008', '1.2.276.0.76.5.439', 'Synkope/Präsynkope');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (10, '009', '1.2.276.0.76.5.439', 'Ödem, generalisiert');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (11, '010', '1.2.276.0.76.5.439', 'Beinschwellung/Ödem');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (12, '011', '1.2.276.0.76.5.439', 'Kühle, pulslose Extremität');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (13, '012', '1.2.276.0.76.5.439', 'Eine Extremität gerötet, überwärmt');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (14, 'HNE', '1.2.276.0.76.5.439', 'HNO (Ohren)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (15, '051', '1.2.276.0.76.5.439', 'Ohrenschmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (16, '052', '1.2.276.0.76.5.439', 'Fremdkörper im Ohr');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (17, '053', '1.2.276.0.76.5.439', 'Hörverlust');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (18, '054', '1.2.276.0.76.5.439', 'Tinnitus');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (19, '055', '1.2.276.0.76.5.439', 'Ausfluss aus dem Ohr');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (20, '056', '1.2.276.0.76.5.439', 'Ohrverletzung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (21, 'HNM', '1.2.276.0.76.5.439', 'HNO (Mund, Rachen, Hals)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (22, '101', '1.2.276.0.76.5.439', 'Zahn-/Zahnfleischprobleme');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (23, '102', '1.2.276.0.76.5.439', 'Trauma Gesicht');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (24, '103', '1.2.276.0.76.5.439', 'Halsschmerzen (wunder Rachen)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (25, '104', '1.2.276.0.76.5.439', 'Halsschwellung/-schmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (26, '105', '1.2.276.0.76.5.439', 'Trauma Hals');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (27, '106', '1.2.276.0.76.5.439', 'Schluckbeschwerden/Dysphagie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (28, '107', '1.2.276.0.76.5.439', 'Schmerzen im Gesicht (nicht traumatisch, nicht dental)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (29, 'HNN', '1.2.276.0.76.5.439', 'HNO (Nase)');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (30, '151', '1.2.276.0.76.5.439', 'Nasenbluten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (31, '152', '1.2.276.0.76.5.439', 'Verstopfte Nase/Heuschnupfen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (32, '153', '1.2.276.0.76.5.439', 'Fremdkörper in der Nase');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (33, '154', '1.2.276.0.76.5.439', 'Beschwerden eines Infektes der oberen Luftwege');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (34, '155', '1.2.276.0.76.5.439', 'Trauma Nase');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (35, 'EV', '1.2.276.0.76.5.439', 'Umweltbedingt');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (36, '201', '1.2.276.0.76.5.439', 'Erfrierung/Kälteverletzung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (37, '202', '1.2.276.0.76.5.439', 'Schädliche Inhalation');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (38, '203', '1.2.276.0.76.5.439', 'Stromunfall');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (39, '204', '1.2.276.0.76.5.439', 'Exposition gegenüber Chemikalien');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (40, '205', '1.2.276.0.76.5.439', 'Unterkühlung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (41, '206', '1.2.276.0.76.5.439', 'Beinahe-Ertrinken');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (42, 'GI', '1.2.276.0.76.5.439', 'Gastrointestinal ');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (43, '251', '1.2.276.0.76.5.439', 'Bauchschmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (44, '252', '1.2.276.0.76.5.439', 'Appetitlosigkeit');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (45, '253', '1.2.276.0.76.5.439', 'Verstopfung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (46, '254', '1.2.276.0.76.5.439', 'Durchfall');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (47, '255', '1.2.276.0.76.5.439', 'Fremdkörper im Rektum');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (48, '256', '1.2.276.0.76.5.439', 'Leistenschmerzen/-schwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (49, '257', '1.2.276.0.76.5.439', 'Übelkeit und/oder Erbrechen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (50, '258', '1.2.276.0.76.5.439', 'Rektale/perineale Schmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (51, '259', '1.2.276.0.76.5.439', 'Bluterbrechen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (52, '260', '1.2.276.0.76.5.439', 'Peranaler Blutabgang/Teerstuhl');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (53, '261', '1.2.276.0.76.5.439', 'Ikterus');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (54, '262', '1.2.276.0.76.5.439', 'Schluckauf');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (55, '263', '1.2.276.0.76.5.439', 'Abdominelle Raumforderung/gespanntes Abdomen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (56, '264', '1.2.276.0.76.5.439', 'Trauma anal/rektal');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (57, '265', '1.2.276.0.76.5.439', 'Fremdkörper oral/ösophageal');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (58, '266', '1.2.276.0.76.5.439', 'Trinkstörung des Neugeborenen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (59, '267', '1.2.276.0.76.5.439', 'Neugeborenenikterus');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (60, 'GU', '1.2.276.0.76.5.439', 'Urogenital');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (61, '301', '1.2.276.0.76.5.439', 'Flankenschmerz');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (62, '302', '1.2.276.0.76.5.439', 'Hämaturie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (63, '303', '1.2.276.0.76.5.439', 'Genitaler Ausfluss/Läsion');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (64, '304', '1.2.276.0.76.5.439', 'Penisschwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (65, '305', '1.2.276.0.76.5.439', 'Skrotale Schmerzen und/oder Schwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (66, '306', '1.2.276.0.76.5.439', 'Harnverhalt');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (67, '307', '1.2.276.0.76.5.439', 'Beschwerden eines Harnwegsinfektes');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (68, '308', '1.2.276.0.76.5.439', 'Oligurie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (69, '309', '1.2.276.0.76.5.439', 'Polyurie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (70, '310', '1.2.276.0.76.5.439', 'Trauma genital');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (71, 'MH', '1.2.276.0.76.5.439', 'Psychische Verfassung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (72, '351', '1.2.276.0.76.5.439', 'Depression/Suizidalität/absichtliche Selbstschädigung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (73, '352', '1.2.276.0.76.5.439', 'Angst/situationsbezogene Krise');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (74, '353', '1.2.276.0.76.5.439', 'Halluzinationen/Wahnvorstellungen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (75, '354', '1.2.276.0.76.5.439', 'Schlafstörung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (76, '355', '1.2.276.0.76.5.439', 'Gewalttätiges Verhalten/Fremdgefährdung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (77, '356', '1.2.276.0.76.5.439', 'Soziales Problem');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (78, '358', '1.2.276.0.76.5.439', 'Sonderbares Verhalten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (79, '359', '1.2.276.0.76.5.439', 'Sorge um das Wohlergehen des Patienten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (80, '360', '1.2.276.0.76.5.439', 'Kindliche Verhaltensauffälligkeit');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (81, 'NC', '1.2.276.0.76.5.439', 'Neurologisch');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (82, '401', '1.2.276.0.76.5.439', 'Veränderter Bewußtseinszustand');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (83, '402', '1.2.276.0.76.5.439', 'Verwirrtheit');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (84, '403', '1.2.276.0.76.5.439', 'Schwindel');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (85, '404', '1.2.276.0.76.5.439', 'Kopfschmerz');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (86, '405', '1.2.276.0.76.5.439', 'Krampfanfall');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (87, '406', '1.2.276.0.76.5.439', 'Gangstörung/Ataxie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (88, '407', '1.2.276.0.76.5.439', 'Kopfverletzung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (89, '408', '1.2.276.0.76.5.439', 'Zittern');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (90, '409', '1.2.276.0.76.5.439', 'Schwäche in den Extremitäten/Symptome eines Schlaganfalls oder TIA');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (91, '410', '1.2.276.0.76.5.439', 'Sensibilitätsstörung/Parästhesie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (92, '411', '1.2.276.0.76.5.439', 'Schlaffes Kind');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (93, 'OGY', '1.2.276.0.76.5.439', 'Geburtshilfe/Gynäkologie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (94, '451', '1.2.276.0.76.5.439', 'Menstruationsbeschwerden');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (95, '452', '1.2.276.0.76.5.439', 'Fremdkörper in der Vagina');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (96, '453', '1.2.276.0.76.5.439', 'Vaginaler Ausfluss');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (97, '454', '1.2.276.0.76.5.439', 'Sexueller Übergriff');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (98, '455', '1.2.276.0.76.5.439', 'Vaginale Blutung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (99, '456', '1.2.276.0.76.5.439', 'Schamlippenschwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (100, '457', '1.2.276.0.76.5.439', 'Schwangerschaftsprobleme ≤ 20. SSW');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (101, '458', '1.2.276.0.76.5.439', 'Schwangerschaftsprobleme > 20. SSW');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (102, '460', '1.2.276.0.76.5.439', 'Vaginale Schmerzen/Schmerzen beim Geschlechtsverkehr');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (103, 'EC', '1.2.276.0.76.5.439', 'Augenheilkunde');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (104, '502', '1.2.276.0.76.5.439', 'Exposition des Auges gegenüber Chemikalien');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (105, '503', '1.2.276.0.76.5.439', 'Fremdkörper im Auge');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (106, '504', '1.2.276.0.76.5.439', 'Sehstörung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (107, '505', '1.2.276.0.76.5.439', 'Augenschmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (108, '506', '1.2.276.0.76.5.439', 'Rote Augen, Ausfluss aus dem Auge');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (109, '507', '1.2.276.0.76.5.439', 'Lichtscheu');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (110, '508', '1.2.276.0.76.5.439', 'Doppelbilder');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (111, '509', '1.2.276.0.76.5.439', 'Periorbitale Schwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (112, '510', '1.2.276.0.76.5.439', 'Trauma Auge');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (113, '511', '1.2.276.0.76.5.439', 'Kontrolluntersuchung der Augen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (114, 'OC', '1.2.276.0.76.5.439', 'Orthopädisch/Unfall-chirurgisch');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (115, '551', '1.2.276.0.76.5.439', 'Rückenschmerzen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (116, '552', '1.2.276.0.76.5.439', 'Traumatische Rücken-/Wirbelsäulenverletzung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (117, '553', '1.2.276.0.76.5.439', 'Amputation');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (118, '554', '1.2.276.0.76.5.439', 'Schmerzen obere Extremität');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (119, '555', '1.2.276.0.76.5.439', 'Schmerzen untere Extremität');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (120, '556', '1.2.276.0.76.5.439', 'Verletzung obere Extremität');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (121, '557', '1.2.276.0.76.5.439', 'Verletzung untere Extremität');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (122, '558', '1.2.276.0.76.5.439', 'Gelenkschwellung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (123, '559', '1.2.276.0.76.5.439', 'Kindliche Gangstörung/Schmerzen beim Gehen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (124, 'RC', '1.2.276.0.76.5.439', 'Respiratorisch');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (125, '651', '1.2.276.0.76.5.439', 'Luftnot');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (126, '652', '1.2.276.0.76.5.439', 'Atemstillstand');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (127, '653', '1.2.276.0.76.5.439', 'Husten/Verschleimung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (128, '654', '1.2.276.0.76.5.439', 'Hyperventilation');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (129, '655', '1.2.276.0.76.5.439', 'Bluthusten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (130, '656', '1.2.276.0.76.5.439', 'Fremdkörper in den Atemwegen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (131, '657', '1.2.276.0.76.5.439', 'Allergische Reaktion');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (132, '658', '1.2.276.0.76.5.439', 'Stridor');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (133, '659', '1.2.276.0.76.5.439', 'Giemen ohne weitere Beschwerden');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (134, '660', '1.2.276.0.76.5.439', 'Apnoeanfälle bei Säuglingen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (135, '661', '1.2.276.0.76.5.439', 'Grippeähnliche Erkrankung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (136, 'SK', '1.2.276.0.76.5.439', 'Haut');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (137, '701', '1.2.276.0.76.5.439', 'Biss');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (138, '702', '1.2.276.0.76.5.439', 'Insektenstich');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (139, '703', '1.2.276.0.76.5.439', 'Abschürfung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (140, '704', '1.2.276.0.76.5.439', 'Riss-/Quetsch-/Schnitt-/Stichwunde');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (141, '705', '1.2.276.0.76.5.439', 'Verbrennung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (142, '706', '1.2.276.0.76.5.439', 'Kontakt mit Blut oder Körperflüssigkeiten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (143, '707', '1.2.276.0.76.5.439', 'Juckreiz');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (144, '708', '1.2.276.0.76.5.439', 'Hautausschlag');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (145, '709', '1.2.276.0.76.5.439', 'Lokalisierte Schwellung/Rötung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (146, '710', '1.2.276.0.76.5.439', 'Wundkontrolle');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (147, '711', '1.2.276.0.76.5.439', 'Sonstige Hautprobleme');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (148, '712', '1.2.276.0.76.5.439', 'Schwellung/Beule/Schwiele');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (149, '713', '1.2.276.0.76.5.439', 'Rötung/Spannungsgefühl in der Brust');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (150, '714', '1.2.276.0.76.5.439', 'Ausschluß eines Parasitenbefalls');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (151, '715', '1.2.276.0.76.5.439', 'Zyanose');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (152, '716', '1.2.276.0.76.5.439', 'Spontane Hauteinblutungen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (153, '717', '1.2.276.0.76.5.439', 'Fremdkörper in der Haut');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (154, '718', '1.2.276.0.76.5.439', 'Nagelprobleme');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (155, 'SA', '1.2.276.0.76.5.439', 'Substanzmissbrauch');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (156, '751', '1.2.276.0.76.5.439', 'Substanzmissbrauch/Intoxikation');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (157, '752', '1.2.276.0.76.5.439', 'Einnahme einer Überdosierung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (158, '753', '1.2.276.0.76.5.439', 'Substanzentzug');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (159, 'TR', '1.2.276.0.76.5.439', 'Trauma');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (160, '801', '1.2.276.0.76.5.439', 'Schweres Trauma - penetrierend');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (161, '802', '1.2.276.0.76.5.439', 'Schweres Trauma - stumpf');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (162, '803', '1.2.276.0.76.5.439', 'Isoliertes Thoraxtrauma - penetrierend');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (163, '804', '1.2.276.0.76.5.439', 'Isoliertes Thoraxtrauma - stumpf');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (164, '805', '1.2.276.0.76.5.439', 'Isoliertes Abdominaltrauma - penetrierend');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (165, '806', '1.2.276.0.76.5.439', 'Isoliertes Abdominaltrauma - stumpf');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (166, 'MC', '1.2.276.0.76.5.439', 'Allgemeine und sonstige Beschwerden');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (167, '851', '1.2.276.0.76.5.439', 'Exposition gegenüber einer übertragbaren Krankheit');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (168, '852', '1.2.276.0.76.5.439', 'Fieber');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (169, '853', '1.2.276.0.76.5.439', 'Hyperglykämie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (170, '854', '1.2.276.0.76.5.439', 'Hypoglykämie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (171, '855', '1.2.276.0.76.5.439', 'Direkte Überweisung/Weiterleitung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (172, '856', '1.2.276.0.76.5.439', 'Verbandswechsel');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (173, '857', '1.2.276.0.76.5.439', 'Entfernung von Klammern/Nähten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (174, '858', '1.2.276.0.76.5.439', 'Gipskontrolle');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (175, '859', '1.2.276.0.76.5.439', 'Bildgebung/Blutuntersuchung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (176, '860', '1.2.276.0.76.5.439', 'Problem mit Medizinprodukt');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (177, '861', '1.2.276.0.76.5.439', 'Verschreibung/Bedarf an Medikamenten');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (178, '862', '1.2.276.0.76.5.439', 'Entfernung Ring');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (179, '863', '1.2.276.0.76.5.439', 'Auffällige Ergebnisse Labor/Bildgebung');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (180, '864', '1.2.276.0.76.5.439', 'Blässe/Anämie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (181, '865', '1.2.276.0.76.5.439', 'Postoperative Komplikationen');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (182, '866', '1.2.276.0.76.5.439', 'Geringfügige unspezifische Beschwerden');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (183, '867', '1.2.276.0.76.5.439', 'Unstillbares Schreien');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (184, '868', '1.2.276.0.76.5.439', 'Angeborene Probleme bei Kindern');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (185, '869', '1.2.276.0.76.5.439', 'Neugeborenes');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (186, '870', '1.2.276.0.76.5.439', 'Intravenöse Therapie');
        
    INSERT INTO CEDIS30 (CEDIS30_id, code, codeSystem, displayName)
            VALUES (187, '998', '1.2.276.0.76.5.439', 'Patient aufgenommen und vor Ersteinschätzung wieder gegangen');