--DROP TABLE ELGA_ObservationInterpretation CASCADE; CREATE TABLE ELGA_ObservationInterpretation ( ELGA_ObservationInterpretation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (1, 'ObservationInterpretationSusceptibility', '2.16.840.1.113883.5.83', 'ObservationInterpretationSusceptibility'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (2, 'I', '2.16.840.1.113883.5.83', 'Intermediate'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (3, 'R', '2.16.840.1.113883.5.83', 'Resistent'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (4, 'S', '2.16.840.1.113883.5.83', 'Susceptible'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (5, 'ObservationInterpretationNormality', '2.16.840.1.113883.5.83', 'ObservationInterpretationNormality'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (6, 'A', '2.16.840.1.113883.5.83', 'Abnormal'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (7, 'AA', '2.16.840.1.113883.5.83', 'Abnormal Alert'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (8, 'HH', '2.16.840.1.113883.5.83', 'High Alert'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (9, 'LL', '2.16.840.1.113883.5.83', 'Low Alert'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (10, 'H', '2.16.840.1.113883.5.83', 'High'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (11, 'L', '2.16.840.1.113883.5.83', 'Low'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (12, 'N', '2.16.840.1.113883.5.83', 'normal'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (13, 'U', '2.16.840.1.113883.5.83', 'increased'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (14, 'D', '2.16.840.1.113883.5.83', 'decreased'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (15, 'ObservationInterpretationExceptions', '2.16.840.1.113883.5.83', 'ObservationInterpretationExceptions'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (16, '>', '2.16.840.1.113883.5.83', 'high off scale'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (17, '<', '2.16.840.1.113883.5.83', 'low off scale'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (18, 'EX', '2.16.840.1.113883.5.83', 'outside threshold');