voc-1.2.276.0.76.11.42-2015-09-18T000000.sql

    --DROP TABLE Referralfromsetting CASCADE;
    CREATE TABLE Referralfromsetting (
            Referralfromsetting_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (1, 'VAP', '1.2.276.0.76.5.440', 'Vertragsarzt/Praxis');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (2, 'KVNPIK', '1.2.276.0.76.5.440', 'KV-Notfallpraxis am Krankenhaus');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (3, 'KVNDAK', '1.2.276.0.76.5.440', 'KV-Notdienst außerhalb des Krankenhauses');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (4, 'RD', '1.2.276.0.76.5.440', 'Rettungsdienst');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (5, 'NA', '1.2.276.0.76.5.440', 'Notarzt');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (6, 'KLINV', '1.2.276.0.76.5.440', 'Klinik/Verlegung');
        
    INSERT INTO Referralfromsetting (Referralfromsetting_id, code, codeSystem, displayName)
            VALUES (7, 'NPHYS', '1.2.276.0.76.5.440', 'Zuweisung nicht durch Arzt');