voc-1.2.276.0.76.3.1.195.11.26-2024-02-19T130853.sql

    --DROP TABLE referral_actions CASCADE;
    CREATE TABLE referral_actions (
            referral_actions_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (1, '37729005', '2.16.840.1.113883.6.96', 'Patient transfer, in-hospital (procedure)');
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (2, '1', '1.2.276.0.76.3.1.195.5.53', 'intern - OP / Intervention (z.B. Herzkatheter, Endoskopie, ...)');
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (3, '3', '1.2.276.0.76.3.1.195.5.53', 'intern - Überwachung (ICU / IMC / Chest-Pain-Unit / Stroke)');
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (4, '7', '1.2.276.0.76.3.1.195.5.53', 'intern - Beobachtungsstation der Notaufnahme/INZ');
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (5, '5', '1.2.276.0.76.3.1.195.5.53', 'intern - Normalstation');
        
    INSERT INTO referral_actions (referral_actions_id, code, codeSystem, displayName)
            VALUES (6, '429202003', '2.16.840.1.113883.6.96', 'Transfer of care to hospital (procedure)');