voc-1.2.276.0.76.3.1.195.11.25-2024-02-19T125534.sql

    --DROP TABLE isolation_reason CASCADE;
    CREATE TABLE isolation_reason (
            isolation_reason_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (1, '32811000119109', '2.16.840.1.113883.6.96', 'Infection caused by multi antimicrobial drug resistant bacteria (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (2, '25374005', '2.16.840.1.113883.6.96', 'Inflammation of stomach and intestine (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (3, '56717001', '2.16.840.1.113883.6.96', 'Tuberculosis (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (4, '7180009', '2.16.840.1.113883.6.96', 'Meningitis (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (5, '6142004', '2.16.840.1.113883.6.96', 'Influenza (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (6, '840539006', '2.16.840.1.113883.6.96', 'Disease caused by severe acute respiratory syndrome coronavirus 2 (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (7, '303011007', '2.16.840.1.113883.6.96', 'Neutropenic disorder (disorder)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (8, '409522005', '2.16.840.1.113883.6.96', 'Standard precautions (procedure)');
        
    INSERT INTO isolation_reason (isolation_reason_id, code, codeSystem, displayName)
            VALUES (9, '6415009', '2.16.840.1.113883.6.96', 'Human respiratory syncytial virus (organism)');