--DROP TABLE ObservationInterpretationNormality CASCADE; CREATE TABLE ObservationInterpretationNormality ( ObservationInterpretationNormality_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (1, 'A', '2.16.840.1.113883.5.83', 'Abnormal'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (2, 'AA', '2.16.840.1.113883.5.83', 'Critical abnormal'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (3, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (4, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (5, 'H', '2.16.840.1.113883.5.83', 'High'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (6, 'H>', '2.16.840.1.113883.5.83', 'Significantly high'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (7, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (8, 'HU', '2.16.840.1.113883.5.83', 'Significantly high'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (9, 'HH', '2.16.840.1.113883.5.83', 'Critical high'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (10, 'L', '2.16.840.1.113883.5.83', 'Low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (11, 'L<', '2.16.840.1.113883.5.83', 'Significantly low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (12, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (13, 'LU', '2.16.840.1.113883.5.83', 'Significantly low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (14, 'LL', '2.16.840.1.113883.5.83', 'Critical low'); INSERT INTO ObservationInterpretationNormality (ObservationInterpretationNormality_id, code, codeSystem, displayName) VALUES (15, 'N', '2.16.840.1.113883.5.83', 'Normal');