voc-1.2.276.0.76.3.1.195.11.7-2024-02-14T134346.sql

    --DROP TABLE discharge_disposition CASCADE;
    CREATE TABLE discharge_disposition (
            discharge_disposition_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (1, '371828006', '2.16.840.1.113883.6.96', 'Patient deceased during stay (discharge status = dead) (finding)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (2, '225928004', '2.16.840.1.113883.6.96', 'Patient self-discharge against medical advice (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (3, '34596002', '2.16.840.1.113883.6.96', 'Patient discharge, elopement (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (4, '306689006', '2.16.840.1.113883.6.96', 'Discharge to home (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (5, '306205009', '2.16.840.1.113883.6.96', 'Referral to hospice (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (6, '307374004', '2.16.840.1.113883.6.96', 'Referral to rehabilitation service (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (7, '25675004', '2.16.840.1.113883.6.96', 'Patient transfer to skilled nursing facility (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (8, '183515008', '2.16.840.1.113883.6.96', 'Referral to physician (procedure)');
        
    INSERT INTO discharge_disposition (discharge_disposition_id, code, codeSystem, displayName)
            VALUES (9, '6', '1.2.276.0.76.3.1.195.5.56', 'Kein Arztkontakt');