--DROP TABLE LaboratorySpecialties CASCADE; CREATE TABLE LaboratorySpecialties ( LaboratorySpecialties_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (1, '18717-9', '2.16.840.1.113883.6.1', 'BLOOD BANK STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (2, '18718-7', '2.16.840.1.113883.6.1', 'CELL MARKER STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (3, '18719-5', '2.16.840.1.113883.6.1', 'CHEMISTRY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (4, '18720-3', '2.16.840.1.113883.6.1', 'COAGULATION STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (5, '18721-1', '2.16.840.1.113883.6.1', 'THERAPEUTIC DRUG MONITORING STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (6, '18722-9', '2.16.840.1.113883.6.1', 'FERTILITY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (7, '18723-7', '2.16.840.1.113883.6.1', 'HEMATOLOGY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (8, '18724-5', '2.16.840.1.113883.6.1', 'HLA STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (9, '18725-2', '2.16.840.1.113883.6.1', 'MICROBIOLOGY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (10, '18727-8', '2.16.840.1.113883.6.1', 'SEROLOGY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (11, '18728-6', '2.16.840.1.113883.6.1', 'TOXICOLOGY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (12, '18729-4', '2.16.840.1.113883.6.1', 'URINALYSIS STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (13, '18767-4', '2.16.840.1.113883.6.1', 'BLOOD GAS STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (14, '18768-2', '2.16.840.1.113883.6.1', 'CELL COUNTS+DIFFERENTIAL STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (15, '18769-0', '2.16.840.1.113883.6.1', 'MICROBIAL SUSCEPTIBILITY TESTS'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (16, '26435-8', '2.16.840.1.113883.6.1', 'MOLECULAR PATHOLOGY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (17, '26436-6', '2.16.840.1.113883.6.1', 'LABORATORY STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (18, '26437-4', '2.16.840.1.113883.6.1', 'CHEMISTRY CHALLENGE STUDIES'); INSERT INTO LaboratorySpecialties (LaboratorySpecialties_id, code, codeSystem, displayName) VALUES (19, '26438-2', '2.16.840.1.113883.6.1', 'CYTOLOGY STUDIES');