--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, 'N', '2.16.840.1.113883.5.83', 'Normal'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (7, 'H', '2.16.840.1.113883.5.83', 'High'); 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, 'L', '2.16.840.1.113883.5.83', 'Low'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (10, 'LL', '2.16.840.1.113883.5.83', 'Low alert'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (11, 'A', '2.16.840.1.113883.5.83', 'Abnormal'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (12, 'AA', '2.16.840.1.113883.5.83', 'Abnormal alert'); 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, 'EX', '2.16.840.1.113883.5.83', 'outside threshold'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (17, '>', '2.16.840.1.113883.5.83', 'high off scale'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (18, '<', '2.16.840.1.113883.5.83', 'low off scale'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (19, '_ObservationInterpretationDetection', '2.16.840.1.113883.5.83', 'ObservationInterpretationDetection'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (20, 'IND', '2.16.840.1.113883.5.83', 'Indeterminate'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (21, 'NEG', '2.16.840.1.113883.5.83', 'Negative'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (22, 'POS', '2.16.840.1.113883.5.83', 'Positive'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (23, '_RAST', '1.2.40.0.34.5.104', 'RAST'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (24, 'RAST 0', '1.2.40.0.34.5.104', '< 0.35 kU/l (absent or undetectable allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (25, 'RAST 1', '1.2.40.0.34.5.104', '0.35 – 0.69 kU/l (low level of allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (26, 'RAST 2', '1.2.40.0.34.5.104', '0.70 – 3.49 kU/l (moderate level of allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (27, 'RAST 3', '1.2.40.0.34.5.104', '3.50 – 17.49 kU/l (high level of allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (28, 'RAST 4', '1.2.40.0.34.5.104', '17.50 – 49.99 kU/l (very high level of allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (29, 'RAST 5', '1.2.40.0.34.5.104', '50.00 – 100.00 kU/l (ultra high level of allergen specific IgE)'); INSERT INTO ELGA_ObservationInterpretation (ELGA_ObservationInterpretation_id, code, codeSystem, displayName) VALUES (30, 'RAST 6', '1.2.40.0.34.5.104', '> 100.00 kU/l (extremely high level of allergen specific ige)');