--DROP TABLE ObservationInterpretation CASCADE; CREATE TABLE ObservationInterpretation ( ObservationInterpretation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (1, '_GeneticObservationInterpretation', '2.16.840.1.113883.5.83', 'GeneticObservationInterpretation'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (2, 'CAR', '2.16.840.1.113883.5.83', 'Carrier'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (3, 'Carrier', '2.16.840.1.113883.5.83', 'Carrier'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (4, '_ObservationInterpretationChange', '2.16.840.1.113883.5.83', 'ObservationInterpretationChange'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (5, 'B', '2.16.840.1.113883.5.83', 'Better'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (6, 'D', '2.16.840.1.113883.5.83', 'Significant change down'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (7, 'U', '2.16.840.1.113883.5.83', 'Significant change up'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (8, 'W', '2.16.840.1.113883.5.83', 'Worse'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (9, '_ObservationInterpretationExceptions', '2.16.840.1.113883.5.83', 'ObservationInterpretationExceptions'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (10, '<', '2.16.840.1.113883.5.83', 'Off scale low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (11, '>', '2.16.840.1.113883.5.83', 'Off scale high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (12, 'AC', '2.16.840.1.113883.5.83', 'Anti-complementary substances present'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (13, 'IE', '2.16.840.1.113883.5.83', 'Insufficient evidence'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (14, 'QCF', '2.16.840.1.113883.5.83', 'Quality control failure'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (15, 'TOX', '2.16.840.1.113883.5.83', 'Cytotoxic substance present'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (16, '_ObservationInterpretationNormality', '2.16.840.1.113883.5.83', 'ObservationInterpretationNormality'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (17, 'A', '2.16.840.1.113883.5.83', 'Abnormal'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (18, 'AA', '2.16.840.1.113883.5.83', 'Critical abnormal'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (19, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (20, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (21, 'H', '2.16.840.1.113883.5.83', 'High'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (22, 'H>', '2.16.840.1.113883.5.83', 'Significantly high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (23, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (24, 'HU', '2.16.840.1.113883.5.83', 'Significantly high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (25, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (26, 'L', '2.16.840.1.113883.5.83', 'Low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (27, 'L<', '2.16.840.1.113883.5.83', 'Significantly low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (28, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (29, 'LU', '2.16.840.1.113883.5.83', 'Significantly low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (30, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (31, 'N', '2.16.840.1.113883.5.83', 'Normal'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (32, '_ObservationInterpretationSusceptibility', '2.16.840.1.113883.5.83', 'ObservationInterpretationSusceptibility'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (33, 'IE', '2.16.840.1.113883.5.83', 'Insufficient evidence'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (34, 'I', '2.16.840.1.113883.5.83', 'Intermediate'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (35, 'MS', '2.16.840.1.113883.5.83', 'moderately susceptible'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (36, 'NS', '2.16.840.1.113883.5.83', 'Non-susceptible'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (37, 'R', '2.16.840.1.113883.5.83', 'Resistant'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (38, 'SYN-R', '2.16.840.1.113883.5.83', 'Synergy - resistant'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (39, 'S', '2.16.840.1.113883.5.83', 'Susceptible'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (40, 'SDD', '2.16.840.1.113883.5.83', 'Susceptible-dose dependent'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (41, 'SYN-S', '2.16.840.1.113883.5.83', 'Synergy - susceptible'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (42, 'VS', '2.16.840.1.113883.5.83', 'very susceptible'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (43, 'EX', '2.16.840.1.113883.5.83', 'outside threshold'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (44, 'HX', '2.16.840.1.113883.5.83', 'above high threshold'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (45, 'LX', '2.16.840.1.113883.5.83', 'below low threshold'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (46, 'HM', '2.16.840.1.113883.5.83', 'Hold for Medical Review'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (47, 'ObservationInterpretationDetection', '2.16.840.1.113883.5.83', 'ObservationInterpretationDetection'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (48, 'IND', '2.16.840.1.113883.5.83', 'Indeterminate'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (49, 'E', '2.16.840.1.113883.5.83', 'Equivocal'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (50, 'NEG', '2.16.840.1.113883.5.83', 'Negative'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (51, 'ND', '2.16.840.1.113883.5.83', 'Not detected'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (52, 'POS', '2.16.840.1.113883.5.83', 'Positive'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (53, 'DET', '2.16.840.1.113883.5.83', 'Detected'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (54, 'ObservationInterpretationExpectation', '2.16.840.1.113883.5.83', 'ObservationInterpretationExpectation'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (55, 'EXP', '2.16.840.1.113883.5.83', 'Expected'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (56, 'UNE', '2.16.840.1.113883.5.83', 'Unexpected'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (57, 'OBX', '2.16.840.1.113883.5.83', 'Interpretation qualifiers in separate OBX segments'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (58, 'ReactivityObservationInterpretation', '2.16.840.1.113883.5.83', 'ReactivityObservationInterpretation'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (59, 'NR', '2.16.840.1.113883.5.83', 'Non-reactive'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (60, 'RR', '2.16.840.1.113883.5.83', 'Reactive'); INSERT INTO ObservationInterpretation (ObservationInterpretation_id, code, codeSystem, displayName) VALUES (61, 'WR', '2.16.840.1.113883.5.83', 'Weakly reactive');