voc-1.2.276.0.76.11.42-2024-02-14T104801.sql

    --DROP TABLE referral_setting CASCADE;
    CREATE TABLE referral_setting (
            referral_setting_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (1, '305931005', '2.16.840.1.113883.6.96', 'Referral by general practitioner (procedure)');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (2, 'KVNPIK', '1.2.276.0.76.5.440', 'KV-Notfallpraxis am Krankenhaus');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (3, 'KVNDAK', '1.2.276.0.76.5.440', 'KV-Notdienst außerhalb des Krankenhauses');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (4, '397721007', '2.16.840.1.113883.6.96', 'Referral by Accident and Emergency (procedure)');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (5, '305925007', '2.16.840.1.113883.6.96', 'Referral by Accident and Emergency doctor (procedure)');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (6, '107724000', '2.16.840.1.113883.6.96', 'Patient transfer (procedure)');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (7, '183877003', '2.16.840.1.113883.6.96', 'Private referral (procedure)');
        
    INSERT INTO referral_setting (referral_setting_id, code, codeSystem, displayName)
            VALUES (8, '74964007', '2.16.840.1.113883.6.96', 'Other (qualifier value)');