cs-1.2.276.0.76.5.437-2015-03-03T000000.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,
            statusCode varchar(255),
            effectiveDate varchar(255),
            expirationDate varchar(255),
            officialReleaseDate varchar(255),
        );
        
            INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, '1', '1.2.276.0.76.5.437', 'Resuscitation - Immediate, life-saving intervention required without delay', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (2, '2', '1.2.276.0.76.5.437', 'Emergent - High risk of deterioration, or signs of a time-critical problem', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            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)', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            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)', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO emergencyseverityindex (emergencyseverityindex_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (5, '5', '1.2.276.0.76.5.437', 'Nonurgent - Stable, with no resources anticipated except oral or topical medications, or prescriptions', 'active', '2015-03-03T00:00:00', '', '');