← BackSQL

voc-1.2.276.0.76.11.57-2015-03-26T000000.sql

Download
    --DROP TABLE Modulesdocumenttypes CASCADE;
    CREATE TABLE Modulesdocumenttypes (
            Modulesdocumenttypes_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (1, '68552-9', '2.16.840.1.113883.6.1', 'Emergency department Admission evaluation note');
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (2, '11488-4', '2.16.840.1.113883.6.1', 'Consultation note');
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (3, '53576-5', '2.16.840.1.113883.6.1', 'Personal health monitoring report');
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (4, '74198-3', '2.16.840.1.113883.6.1', 'Trauma Summary registry report');
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (5, '34750-0', '2.16.840.1.113883.6.1', 'Anesthesiology Note');
        
    INSERT INTO Modulesdocumenttypes (Modulesdocumenttypes_id, code, codeSystem, displayName)
            VALUES (6, '34905-0', '2.16.840.1.113883.6.1', 'Neurology Note');