voc-1.2.276.0.76.11.45-2024-08-16T174700.sql

    --DROP TABLE emergencyseverityindex CASCADE;
    CREATE TABLE emergencyseverityindex (
            emergencyseverityindex_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName)
            VALUES (1, '1', '1.2.276.0.76.5.437', 'Resuscitation - Immediate, life-saving intervention required without delay');
        
    INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName)
            VALUES (2, '2', '1.2.276.0.76.5.437', 'Emergent - High risk of deterioration, or signs of a time-critical problem');
        
    INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName)
            VALUES (3, '3', '1.2.276.0.76.5.437', 'Urgent - Stable, with multiple types of resources needed to investigate or treat (such as lab tests plus X-ray imaging)');
        
    INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName)
            VALUES (4, '4', '1.2.276.0.76.5.437', 'Less Urgent - Stable, with only one type of resource anticipated (such as only an X-ray, or only sutures)');
        
    INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName)
            VALUES (5, '5', '1.2.276.0.76.5.437', 'Nonurgent - Stable, with no resources anticipated except oral or topical medications, or prescriptions');