cs-1.2.276.0.76.3.1.195.5.103-2019-08-15T000000.sql

        --DROP TABLE esi_triage_factors CASCADE;
        CREATE TABLE esi_triage_factors (
            esi_triage_factors_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 esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, '1', '1.2.276.0.76.3.1.195.5.103', 'sofortige lebensrettende Maßnahme notwendig', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (2, '2', '1.2.276.0.76.3.1.195.5.103', 'Hochrisikosituation', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (3, '3', '1.2.276.0.76.3.1.195.5.103', 'verwirrt', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (4, '4', '1.2.276.0.76.3.1.195.5.103', 'lethargisch', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (5, '5', '1.2.276.0.76.3.1.195.5.103', 'desorientiert', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (6, '6', '1.2.276.0.76.3.1.195.5.103', 'starke Schmerzen', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (7, '7', '1.2.276.0.76.3.1.195.5.103', 'starkes Unwohlsein', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (8, '8', '1.2.276.0.76.3.1.195.5.103', 'großes kindliches Leid', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (9, '9', '1.2.276.0.76.3.1.195.5.103', 'mehr als eine Ressource benötigt', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (10, '10', '1.2.276.0.76.3.1.195.5.103', 'Vitalzeichen in der Gefahrenzone', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (11, '11', '1.2.276.0.76.3.1.195.5.103', 'Vitalzeichen nicht in der Gefahrenzone', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (12, '12', '1.2.276.0.76.3.1.195.5.103', 'eine Ressource benötigt', 'active', '2019-08-15T00:00:00', '', '');
        
            INSERT INTO esi_triage_factors (esi_triage_factors_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (13, '13', '1.2.276.0.76.3.1.195.5.103', 'keine Ressourcen benötigt', 'active', '2019-08-15T00:00:00', '', '');