← BackSQL

voc-1.2.276.0.76.11.56-2015-11-17T000000.sql

Download
    --DROP TABLE Dischargedispositioncodes CASCADE;
    CREATE TABLE Dischargedispositioncodes (
            Dischargedispositioncodes_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (1, '1', '1.2.276.0.76.3.1.195.5.56', 'Tod');
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (2, '2', '1.2.276.0.76.3.1.195.5.56', 'Entlassung gegen ärztlichen Rat');
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (3, '3', '1.2.276.0.76.3.1.195.5.56', 'Behandlung durch Pat. abgebrochen');
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (4, '4', '1.2.276.0.76.3.1.195.5.56', 'Entlassung nach Hause');
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (5, '5', '1.2.276.0.76.3.1.195.5.56', 'Entlassung zu weiterbehandelnden Arzt');
        
    INSERT INTO Dischargedispositioncodes (Dischargedispositioncodes_id, code, codeSystem, displayName)
            VALUES (6, '6', '1.2.276.0.76.3.1.195.5.56', 'kein Arztkontakt');