--DROP TABLE ObservationMethod CASCADE; CREATE TABLE ObservationMethod ( ObservationMethod_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (1, '0001', '2.16.840.1.113883.5.84', 'Complement fixation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (2, '0002', '2.16.840.1.113883.5.84', 'Computed axial tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (3, '0003', '2.16.840.1.113883.5.84', 'HLAR agar test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (4, '0004', '2.16.840.1.113883.5.84', 'Macroscopic observation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (5, '0005', '2.16.840.1.113883.5.84', 'Magnetic resonance'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (6, '0006', '2.16.840.1.113883.5.84', 'Morphometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (7, '0007', '2.16.840.1.113883.5.84', 'Positron emission tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (8, '0008', '2.16.840.1.113883.5.84', 'SAMHSA confirmation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (9, '0009', '2.16.840.1.113883.5.84', 'SAMHSA screening'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (10, '0010', '2.16.840.1.113883.5.84', 'Serum Neutralization'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (11, '0011', '2.16.840.1.113883.5.84', 'Titration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (12, '0012', '2.16.840.1.113883.5.84', 'Ultrasound'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (13, '0013', '2.16.840.1.113883.5.84', 'X-ray crystallography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (14, '0014', '2.16.840.1.113883.5.84', 'Agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (15, '0015', '2.16.840.1.113883.5.84', 'Buffered acidified plate agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (16, '0016', '2.16.840.1.113883.5.84', 'Card agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (17, '0017', '2.16.840.1.113883.5.84', 'Hemagglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (18, '0018', '2.16.840.1.113883.5.84', 'Hemagglutination inhibition'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (19, '0019', '2.16.840.1.113883.5.84', 'Latex agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (20, '0020', '2.16.840.1.113883.5.84', 'Plate agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (21, '0021', '2.16.840.1.113883.5.84', 'Rapid agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (22, '0022', '2.16.840.1.113883.5.84', 'RBC agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (23, '0023', '2.16.840.1.113883.5.84', 'Rivanol agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (24, '0024', '2.16.840.1.113883.5.84', 'Tube agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (25, '0025', '2.16.840.1.113883.5.84', 'Bioassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (26, '0026', '2.16.840.1.113883.5.84', 'Animal Inoculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (27, '0027', '2.16.840.1.113883.5.84', 'Cytotoxicity'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (28, '0028', '2.16.840.1.113883.5.84', 'Embryo infective dose 50'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (29, '0029', '2.16.840.1.113883.5.84', 'Embryo lethal dose 50'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (30, '0030', '2.16.840.1.113883.5.84', 'Mouse intercerebral inoculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (31, '0031', '2.16.840.1.113883.5.84', 'Bioassay, qualitative'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (32, '0032', '2.16.840.1.113883.5.84', 'Bioassay, quantitative'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (33, '0033', '2.16.840.1.113883.5.84', 'Chemical method'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (34, '0034', '2.16.840.1.113883.5.84', 'Differential light absorption chemical test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (35, '0035', '2.16.840.1.113883.5.84', 'Dipstick'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (36, '0036', '2.16.840.1.113883.5.84', 'Dipstick colorimetric laboratory test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (37, '0037', '2.16.840.1.113883.5.84', 'Test strip'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (38, '0038', '2.16.840.1.113883.5.84', 'Chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (39, '0039', '2.16.840.1.113883.5.84', 'Affinity chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (40, '0040', '2.16.840.1.113883.5.84', 'Gas liquid chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (41, '0041', '2.16.840.1.113883.5.84', 'High performance liquid chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (42, '0042', '2.16.840.1.113883.5.84', 'Liquid Chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (43, '0043', '2.16.840.1.113883.5.84', 'Protein A affinity chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (44, '0044', '2.16.840.1.113883.5.84', 'Coagulation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (45, '0045', '2.16.840.1.113883.5.84', 'Tilt tube coagulation time'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (46, '0046', '2.16.840.1.113883.5.84', 'Tilt tube reptilase induced coagulation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (47, '0047', '2.16.840.1.113883.5.84', 'Automated count'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (48, '0048', '2.16.840.1.113883.5.84', 'Manual cell count'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (49, '0049', '2.16.840.1.113883.5.84', 'Platelet count, Rees-Ecker'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (50, '0050', '2.16.840.1.113883.5.84', 'Aerobic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (51, '0051', '2.16.840.1.113883.5.84', 'Anaerobic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (52, '0052', '2.16.840.1.113883.5.84', 'Chicken embryo culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (53, '0053', '2.16.840.1.113883.5.84', 'Delayed secondary enrichment'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (54, '0054', '2.16.840.1.113883.5.84', 'Microaerophilic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (55, '0055', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, cup'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (56, '0056', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, droplet'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (57, '0057', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, filter paper'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (58, '0058', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, pad culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (59, '0059', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, pour plate'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (60, '0060', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, surface streak'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (61, '0061', '2.16.840.1.113883.5.84', 'Somatic Cell culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (62, '0062', '2.16.840.1.113883.5.84', 'Agar diffusion'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (63, '0063', '2.16.840.1.113883.5.84', 'Agar Gel Immunodiffusion'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (64, '0064', '2.16.840.1.113883.5.84', 'Electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (65, '0065', '2.16.840.1.113883.5.84', 'Agaorse gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (66, '0066', '2.16.840.1.113883.5.84', 'Electrophoresis, citrate agar'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (67, '0067', '2.16.840.1.113883.5.84', 'Immunoelectrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (68, '0068', '2.16.840.1.113883.5.84', 'Polyacrylamide gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (69, '0069', '2.16.840.1.113883.5.84', 'Starch gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (70, '0070', '2.16.840.1.113883.5.84', 'ELISA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (71, '0071', '2.16.840.1.113883.5.84', 'ELISA, antigen capture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (72, '0072', '2.16.840.1.113883.5.84', 'ELISA, avidin biotin peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (73, '0073', '2.16.840.1.113883.5.84', 'Kinetic ELISA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (74, '0074', '2.16.840.1.113883.5.84', 'ELISA, peroxidase-antiperoxidase'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (75, '0075', '2.16.840.1.113883.5.84', 'API 20 Strep'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (76, '0076', '2.16.840.1.113883.5.84', 'API 20A'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (77, '0077', '2.16.840.1.113883.5.84', 'API 20C AUX'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (78, '0078', '2.16.840.1.113883.5.84', 'API 20E'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (79, '0079', '2.16.840.1.113883.5.84', 'API 20NE'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (80, '0080', '2.16.840.1.113883.5.84', 'API 50 CH'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (81, '0081', '2.16.840.1.113883.5.84', 'API An-IDENT'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (82, '0082', '2.16.840.1.113883.5.84', 'API Coryne'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (83, '0083', '2.16.840.1.113883.5.84', 'API Rapid 20E'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (84, '0084', '2.16.840.1.113883.5.84', 'API Staph'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (85, '0085', '2.16.840.1.113883.5.84', 'API ZYM'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (86, '0086', '2.16.840.1.113883.5.84', 'Bacterial identification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (87, '0087', '2.16.840.1.113883.5.84', 'mini VIDAS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (88, '0088', '2.16.840.1.113883.5.84', 'Phage susceptibility typing'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (89, '0089', '2.16.840.1.113883.5.84', 'Quad-FERM+'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (90, '0090', '2.16.840.1.113883.5.84', 'RAPIDEC Staph'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (91, '0091', '2.16.840.1.113883.5.84', 'Staphaurex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (92, '0092', '2.16.840.1.113883.5.84', 'VIDAS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (93, '0093', '2.16.840.1.113883.5.84', 'Vitek'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (94, '0094', '2.16.840.1.113883.5.84', 'VITEK 2'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (95, '0095', '2.16.840.1.113883.5.84', 'Immune stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (96, '0096', '2.16.840.1.113883.5.84', 'Immunofluorescent antibody, direct'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (97, '0097', '2.16.840.1.113883.5.84', 'Immunofluorescent antibody, indirect'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (98, '0098', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Avidin-Biotin Complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (99, '0099', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Peroxidase anti-peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (100, '0100', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Protein A-peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (101, '0101', '2.16.840.1.113883.5.84', 'Immunoassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (102, '0102', '2.16.840.1.113883.5.84', 'Immunoassay, qualitative, multiple step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (103, '0103', '2.16.840.1.113883.5.84', 'Immunoassay, qualitative, single step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (104, '0104', '2.16.840.1.113883.5.84', 'Radioimmunoassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (105, '0105', '2.16.840.1.113883.5.84', 'Immunoassay, semi-quantitative, multiple step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (106, '0106', '2.16.840.1.113883.5.84', 'Immunoassay, semi-quantitative, single step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (107, '0107', '2.16.840.1.113883.5.84', 'Microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (108, '0108', '2.16.840.1.113883.5.84', 'Darkfield microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (109, '0109', '2.16.840.1.113883.5.84', 'Electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (110, '0110', '2.16.840.1.113883.5.84', 'Electron microscopy tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (111, '0111', '2.16.840.1.113883.5.84', 'Electron microscopy, negative stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (112, '0112', '2.16.840.1.113883.5.84', 'Electron microscopy, thick section'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (113, '0113', '2.16.840.1.113883.5.84', 'Electron microscopy, thin section'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (114, '0114', '2.16.840.1.113883.5.84', 'Microscopy, Light'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (115, '0115', '2.16.840.1.113883.5.84', 'Polarizing light microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (116, '0116', '2.16.840.1.113883.5.84', 'Scanning electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (117, '0117', '2.16.840.1.113883.5.84', 'Transmission electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (118, '0118', '2.16.840.1.113883.5.84', 'Transparent tape direct examination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (119, '0119', '2.16.840.1.113883.5.84', '3 Self-Sustaining Sequence Replication'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (120, '0120', '2.16.840.1.113883.5.84', 'Branched Chain DNA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (121, '0121', '2.16.840.1.113883.5.84', 'Hybridization Protection Assay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (122, '0122', '2.16.840.1.113883.5.84', 'Immune blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (123, '0123', '2.16.840.1.113883.5.84', 'In-situ hybridization'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (124, '0124', '2.16.840.1.113883.5.84', 'Ligase Chain Reaction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (125, '0125', '2.16.840.1.113883.5.84', 'Ligation Activated Transcription'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (126, '0126', '2.16.840.1.113883.5.84', 'Nucleic Acid Probe'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (127, '0128', '2.16.840.1.113883.5.84', 'Nucleic acid probe with amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (128, '0129', '2.16.840.1.113883.5.84', 'Nucleic acid probe with target amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (129, '0130', '2.16.840.1.113883.5.84', 'Nucleic acid reverse transcription'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (130, '0131', '2.16.840.1.113883.5.84', 'Nucleic Acid Sequence Based Analysis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (131, '0132', '2.16.840.1.113883.5.84', 'Polymerase chain reaction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (132, '0133', '2.16.840.1.113883.5.84', 'Q-Beta Replicase or probe amplification category method'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (133, '0134', '2.16.840.1.113883.5.84', 'Restriction Fragment Length Polymorphism'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (134, '0135', '2.16.840.1.113883.5.84', 'Southern Blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (135, '0136', '2.16.840.1.113883.5.84', 'Strand Displacement Amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (136, '0137', '2.16.840.1.113883.5.84', 'Transcription Mediated Amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (137, '0138', '2.16.840.1.113883.5.84', 'Western Blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (138, '0139', '2.16.840.1.113883.5.84', 'Flocculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (139, '0140', '2.16.840.1.113883.5.84', 'Immune precipitation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (140, '0141', '2.16.840.1.113883.5.84', 'Milk ring test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (141, '0142', '2.16.840.1.113883.5.84', 'Precipitin'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (142, '0143', '2.16.840.1.113883.5.84', 'Acid fast stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (143, '0144', '2.16.840.1.113883.5.84', 'Acid fast stain, fluorochrome'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (144, '0145', '2.16.840.1.113883.5.84', 'Acid fast stain, Kinyouns cold carbolfuchsin'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (145, '0146', '2.16.840.1.113883.5.84', 'Acid fast stain, Ziehl-Neelsen'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (146, '0147', '2.16.840.1.113883.5.84', 'Acid phosphatase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (147, '0148', '2.16.840.1.113883.5.84', 'Acridine orange stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (148, '0149', '2.16.840.1.113883.5.84', 'Active brilliant orange KH stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (149, '0150', '2.16.840.1.113883.5.84', 'Alazarin red S stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (150, '0151', '2.16.840.1.113883.5.84', 'Alcian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (151, '0152', '2.16.840.1.113883.5.84', 'Alcian blue with Periodic acid Schiff stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (152, '0153', '2.16.840.1.113883.5.84', 'Argentaffin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (153, '0154', '2.16.840.1.113883.5.84', 'Argentaffin silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (154, '0155', '2.16.840.1.113883.5.84', 'Azure-eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (155, '0156', '2.16.840.1.113883.5.84', 'Basic Fuschin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (156, '0157', '2.16.840.1.113883.5.84', 'Bennhold stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (157, '0158', '2.16.840.1.113883.5.84', 'Bennholds Congo red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (158, '0159', '2.16.840.1.113883.5.84', 'Bielschowsky stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (159, '0160', '2.16.840.1.113883.5.84', 'Bielschowskys silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (160, '0161', '2.16.840.1.113883.5.84', 'Bleach stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (161, '0162', '2.16.840.1.113883.5.84', 'Bodian stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (162, '0163', '2.16.840.1.113883.5.84', 'Brown-Brenn stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (163, '0164', '2.16.840.1.113883.5.84', 'Butyrate-esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (164, '0165', '2.16.840.1.113883.5.84', 'Calcofluor white fluorescent stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (165, '0166', '2.16.840.1.113883.5.84', 'Carbol-fuchsin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (166, '0167', '2.16.840.1.113883.5.84', 'Carmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (167, '0168', '2.16.840.1.113883.5.84', 'Churukian-Schenk stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (168, '0169', '2.16.840.1.113883.5.84', 'Congo red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (169, '0170', '2.16.840.1.113883.5.84', 'Cresyl echt violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (170, '0171', '2.16.840.1.113883.5.84', 'Crystal violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (171, '0172', '2.16.840.1.113883.5.84', 'De Galantha stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (172, '0173', '2.16.840.1.113883.5.84', 'Dieterle silver impregnation stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (173, '0174', '2.16.840.1.113883.5.84', 'Fite-Farco stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (174, '0175', '2.16.840.1.113883.5.84', 'Fontana-Masson silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (175, '0176', '2.16.840.1.113883.5.84', 'Fouchet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (176, '0177', '2.16.840.1.113883.5.84', 'Gomori stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (177, '0178', '2.16.840.1.113883.5.84', 'Gomori methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (178, '0179', '2.16.840.1.113883.5.84', 'Gomori-Wheatly trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (179, '0180', '2.16.840.1.113883.5.84', 'Gridley stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (180, '0181', '2.16.840.1.113883.5.84', 'Grimelius silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (181, '0182', '2.16.840.1.113883.5.84', 'Grocott stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (182, '0183', '2.16.840.1.113883.5.84', 'Grocott methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (183, '0184', '2.16.840.1.113883.5.84', 'Hales colloidal ferric oxide stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (184, '0185', '2.16.840.1.113883.5.84', 'Hales colloidal iron stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (185, '0186', '2.16.840.1.113883.5.84', 'Hansel stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (186, '0187', '2.16.840.1.113883.5.84', 'Harris regressive hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (187, '0188', '2.16.840.1.113883.5.84', 'Hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (188, '0189', '2.16.840.1.113883.5.84', 'Highman stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (189, '0190', '2.16.840.1.113883.5.84', 'Holzer stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (190, '0191', '2.16.840.1.113883.5.84', 'Iron hematoxylin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (191, '0192', '2.16.840.1.113883.5.84', 'Jones stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (192, '0193', '2.16.840.1.113883.5.84', 'Jones methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (193, '0194', '2.16.840.1.113883.5.84', 'Kossa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (194, '0195', '2.16.840.1.113883.5.84', 'Lawson-Van Gieson stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (195, '0196', '2.16.840.1.113883.5.84', 'Loeffler methylene blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (196, '0197', '2.16.840.1.113883.5.84', 'Luxol fast blue with cresyl violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (197, '0198', '2.16.840.1.113883.5.84', 'Luxol fast blue with Periodic acid-Schiff stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (198, '0199', '2.16.840.1.113883.5.84', 'MacNeals tetrachrome blood stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (199, '0200', '2.16.840.1.113883.5.84', 'Mallory-Heidenhain stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (200, '0201', '2.16.840.1.113883.5.84', 'Masson trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (201, '0202', '2.16.840.1.113883.5.84', 'Mayer mucicarmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (202, '0203', '2.16.840.1.113883.5.84', 'Mayers progressive hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (203, '0204', '2.16.840.1.113883.5.84', 'May-Grunwald Giemsa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (204, '0205', '2.16.840.1.113883.5.84', 'Methyl green stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (205, '0206', '2.16.840.1.113883.5.84', 'Methyl green pyronin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (206, '0207', '2.16.840.1.113883.5.84', 'Modified Gomori-Wheatly trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (207, '0208', '2.16.840.1.113883.5.84', 'Modified Masson trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (208, '0209', '2.16.840.1.113883.5.84', 'Modified trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (209, '0210', '2.16.840.1.113883.5.84', 'Movat pentachrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (210, '0211', '2.16.840.1.113883.5.84', 'Mucicarmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (211, '0212', '2.16.840.1.113883.5.84', 'Neutral red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (212, '0213', '2.16.840.1.113883.5.84', 'Night blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (213, '0214', '2.16.840.1.113883.5.84', 'Non-specific esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (214, '0215', '2.16.840.1.113883.5.84', 'Oil red-O stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (215, '0216', '2.16.840.1.113883.5.84', 'Orcein stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (216, '0217', '2.16.840.1.113883.5.84', 'Perls stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (217, '0218', '2.16.840.1.113883.5.84', 'Phosphotungstic acid-hematoxylin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (218, '0219', '2.16.840.1.113883.5.84', 'Potassium ferrocyanide stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (219, '0220', '2.16.840.1.113883.5.84', 'Prussian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (220, '0221', '2.16.840.1.113883.5.84', 'Putchler modified Bennhold stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (221, '0222', '2.16.840.1.113883.5.84', 'Quinacrine fluorescent stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (222, '0223', '2.16.840.1.113883.5.84', 'Reticulin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (223, '0224', '2.16.840.1.113883.5.84', 'Rhodamine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (224, '0225', '2.16.840.1.113883.5.84', 'Safranin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (225, '0226', '2.16.840.1.113883.5.84', 'Schmorl stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (226, '0227', '2.16.840.1.113883.5.84', 'Seiver-Munger stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (227, '0228', '2.16.840.1.113883.5.84', 'Silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (228, '0229', '2.16.840.1.113883.5.84', 'Specific esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (229, '0230', '2.16.840.1.113883.5.84', 'Steiner silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (230, '0231', '2.16.840.1.113883.5.84', 'Sudan III stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (231, '0232', '2.16.840.1.113883.5.84', 'Sudan IVI stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (232, '0233', '2.16.840.1.113883.5.84', 'Sulfated alcian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (233, '0234', '2.16.840.1.113883.5.84', 'Supravital stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (234, '0235', '2.16.840.1.113883.5.84', 'Thioflavine-S stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (235, '0236', '2.16.840.1.113883.5.84', 'Three micron Giemsa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (236, '0237', '2.16.840.1.113883.5.84', 'Vassar-Culling stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (237, '0238', '2.16.840.1.113883.5.84', 'Vital Stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (238, '0239', '2.16.840.1.113883.5.84', 'von Kossa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (239, '0240', '2.16.840.1.113883.5.84', 'Antibiotic sensitivity, disk'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (240, '0241', '2.16.840.1.113883.5.84', 'BACTEC susceptibility test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (241, '0242', '2.16.840.1.113883.5.84', 'Disk dilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (242, '0243', '2.16.840.1.113883.5.84', 'Minimum bactericidal concentration test, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (243, '0244', '2.16.840.1.113883.5.84', 'Minimum bactericidal concentration test, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (244, '0245', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (245, '0246', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (246, '0247', '2.16.840.1.113883.5.84', 'Turbidometric'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (247, '0248', '2.16.840.1.113883.5.84', 'Refractometric'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (248, '0249', '2.16.840.1.113883.5.84', 'Thin layer chromatography (TLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (249, '0250', '2.16.840.1.113883.5.84', 'EMIT'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (250, '0251', '2.16.840.1.113883.5.84', 'Flow cytometry (FC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (251, '0252', '2.16.840.1.113883.5.84', 'Radial immunodiffusion (RID)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (252, '0253', '2.16.840.1.113883.5.84', 'Fluorescence polarization immunoassay (FPIA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (253, '0254', '2.16.840.1.113883.5.84', 'Immunofixation electrophoresis (IFE)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (254, '0255', '2.16.840.1.113883.5.84', 'Equilibrium dialysis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (255, '0256', '2.16.840.1.113883.5.84', 'Kleihauer-Betke acid elution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (256, '0257', '2.16.840.1.113883.5.84', 'Anti-complement immunofluorescence (ACIF)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (257, '0258', '2.16.840.1.113883.5.84', 'GC/MS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (258, '0259', '2.16.840.1.113883.5.84', 'Nephelometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (259, '0260', '2.16.840.1.113883.5.84', 'IgE immunoassay antibody'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (260, '0261', '2.16.840.1.113883.5.84', 'Lymphocyte Microcytotoxicity Assay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (261, '0262', '2.16.840.1.113883.5.84', 'Spectrophotometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (262, '0263', '2.16.840.1.113883.5.84', 'Atomic absorption spectrophotometry (AAS)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (263, '0264', '2.16.840.1.113883.5.84', 'Ion selective electrode (ISE)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (264, '0265', '2.16.840.1.113883.5.84', 'Gas chromatography (GC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (265, '0266', '2.16.840.1.113883.5.84', 'Isoelectric focusing (IEF)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (266, '0267', '2.16.840.1.113883.5.84', 'Immunochemiluminescence'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (267, '0268', '2.16.840.1.113883.5.84', 'Microparticle enzyme immunoassay (MEIA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (268, '0269', '2.16.840.1.113883.5.84', 'ICP/MS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (269, '0270', '2.16.840.1.113883.5.84', 'Immunoradiometric assay (IRMA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (270, '0271', '2.16.840.1.113883.5.84', 'Photo optical clot detection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (271, 'ALGM', '2.16.840.1.113883.5.84', 'algorithm'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (272, 'BYCL', '2.16.840.1.113883.5.84', 'bayesian calculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (273, 'GINT', '2.16.840.1.113883.5.84', 'global introspection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (274, 'ALGM', '2.16.840.1.113883.5.84', 'algorithm'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (275, 'BYCL', '2.16.840.1.113883.5.84', 'bayesian calculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (276, 'GINT', '2.16.840.1.113883.5.84', 'global introspection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (277, '0272', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (278, '0245', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (279, '0246', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (280, '0275a', '2.16.840.1.113883.5.84', 'Minimum Lethal Concentration (MLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (281, '0280', '2.16.840.1.113883.5.84', 'Susceptibility Testing'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (282, '0240', '2.16.840.1.113883.5.84', 'Antibiotic sensitivity, disk'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (283, '0241', '2.16.840.1.113883.5.84', 'BACTEC susceptibility test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (284, '0242', '2.16.840.1.113883.5.84', 'Disk dilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (285, '0272', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (286, '0273', '2.16.840.1.113883.5.84', 'Viral Genotype Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (287, '0274', '2.16.840.1.113883.5.84', 'Viral Phenotype Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (288, '0275', '2.16.840.1.113883.5.84', 'Gradient Strip'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (289, '0275a', '2.16.840.1.113883.5.84', 'Minimum Lethal Concentration (MLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (290, '0276', '2.16.840.1.113883.5.84', 'Slow Mycobacteria Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (291, '0277', '2.16.840.1.113883.5.84', 'Serum bactericidal titer'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (292, '0278', '2.16.840.1.113883.5.84', 'Agar screen'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (293, '0279', '2.16.840.1.113883.5.84', 'Disk induction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (294, '_VerificationMethod', '2.16.840.1.113883.5.84', 'VerificationMethod'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (295, 'VDOC', '2.16.840.1.113883.5.84', 'document verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (296, 'VREG', '2.16.840.1.113883.5.84', 'registry verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (297, 'VTOKEN', '2.16.840.1.113883.5.84', 'electronic token verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (298, 'VVOICE', '2.16.840.1.113883.5.84', 'voice-based verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (299, '_GeneticObservationMethod', '2.16.840.1.113883.5.84', 'GeneticObservationMethod'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (300, 'PCR', '2.16.840.1.113883.5.84', 'PCR'); --DROP TABLE ObservationMethod CASCADE; CREATE TABLE ObservationMethod ( ObservationMethod_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (1, '0001', '2.16.840.1.113883.5.84', 'Complement fixation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (2, '0002', '2.16.840.1.113883.5.84', 'Computed axial tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (3, '0003', '2.16.840.1.113883.5.84', 'HLAR agar test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (4, '0004', '2.16.840.1.113883.5.84', 'Macroscopic observation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (5, '0005', '2.16.840.1.113883.5.84', 'Magnetic resonance'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (6, '0006', '2.16.840.1.113883.5.84', 'Morphometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (7, '0007', '2.16.840.1.113883.5.84', 'Positron emission tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (8, '0008', '2.16.840.1.113883.5.84', 'SAMHSA confirmation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (9, '0009', '2.16.840.1.113883.5.84', 'SAMHSA screening'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (10, '0010', '2.16.840.1.113883.5.84', 'Serum Neutralization'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (11, '0011', '2.16.840.1.113883.5.84', 'Titration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (12, '0012', '2.16.840.1.113883.5.84', 'Ultrasound'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (13, '0013', '2.16.840.1.113883.5.84', 'X-ray crystallography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (14, '0014', '2.16.840.1.113883.5.84', 'Agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (15, '0015', '2.16.840.1.113883.5.84', 'Buffered acidified plate agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (16, '0016', '2.16.840.1.113883.5.84', 'Card agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (17, '0017', '2.16.840.1.113883.5.84', 'Hemagglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (18, '0018', '2.16.840.1.113883.5.84', 'Hemagglutination inhibition'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (19, '0019', '2.16.840.1.113883.5.84', 'Latex agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (20, '0020', '2.16.840.1.113883.5.84', 'Plate agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (21, '0021', '2.16.840.1.113883.5.84', 'Rapid agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (22, '0022', '2.16.840.1.113883.5.84', 'RBC agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (23, '0023', '2.16.840.1.113883.5.84', 'Rivanol agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (24, '0024', '2.16.840.1.113883.5.84', 'Tube agglutination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (25, '0025', '2.16.840.1.113883.5.84', 'Bioassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (26, '0026', '2.16.840.1.113883.5.84', 'Animal Inoculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (27, '0027', '2.16.840.1.113883.5.84', 'Cytotoxicity'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (28, '0028', '2.16.840.1.113883.5.84', 'Embryo infective dose 50'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (29, '0029', '2.16.840.1.113883.5.84', 'Embryo lethal dose 50'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (30, '0030', '2.16.840.1.113883.5.84', 'Mouse intercerebral inoculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (31, '0031', '2.16.840.1.113883.5.84', 'Bioassay, qualitative'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (32, '0032', '2.16.840.1.113883.5.84', 'Bioassay, quantitative'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (33, '0033', '2.16.840.1.113883.5.84', 'Chemical method'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (34, '0034', '2.16.840.1.113883.5.84', 'Differential light absorption chemical test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (35, '0035', '2.16.840.1.113883.5.84', 'Dipstick'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (36, '0036', '2.16.840.1.113883.5.84', 'Dipstick colorimetric laboratory test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (37, '0037', '2.16.840.1.113883.5.84', 'Test strip'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (38, '0038', '2.16.840.1.113883.5.84', 'Chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (39, '0039', '2.16.840.1.113883.5.84', 'Affinity chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (40, '0040', '2.16.840.1.113883.5.84', 'Gas liquid chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (41, '0041', '2.16.840.1.113883.5.84', 'High performance liquid chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (42, '0042', '2.16.840.1.113883.5.84', 'Liquid Chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (43, '0043', '2.16.840.1.113883.5.84', 'Protein A affinity chromatography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (44, '0044', '2.16.840.1.113883.5.84', 'Coagulation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (45, '0045', '2.16.840.1.113883.5.84', 'Tilt tube coagulation time'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (46, '0046', '2.16.840.1.113883.5.84', 'Tilt tube reptilase induced coagulation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (47, '0047', '2.16.840.1.113883.5.84', 'Automated count'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (48, '0048', '2.16.840.1.113883.5.84', 'Manual cell count'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (49, '0049', '2.16.840.1.113883.5.84', 'Platelet count, Rees-Ecker'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (50, '0050', '2.16.840.1.113883.5.84', 'Aerobic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (51, '0051', '2.16.840.1.113883.5.84', 'Anaerobic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (52, '0052', '2.16.840.1.113883.5.84', 'Chicken embryo culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (53, '0053', '2.16.840.1.113883.5.84', 'Delayed secondary enrichment'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (54, '0054', '2.16.840.1.113883.5.84', 'Microaerophilic Culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (55, '0055', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, cup'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (56, '0056', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, droplet'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (57, '0057', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, filter paper'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (58, '0058', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, pad culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (59, '0059', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, pour plate'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (60, '0060', '2.16.840.1.113883.5.84', 'Quantitative microbial culture, surface streak'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (61, '0061', '2.16.840.1.113883.5.84', 'Somatic Cell culture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (62, '0062', '2.16.840.1.113883.5.84', 'Agar diffusion'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (63, '0063', '2.16.840.1.113883.5.84', 'Agar Gel Immunodiffusion'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (64, '0064', '2.16.840.1.113883.5.84', 'Electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (65, '0065', '2.16.840.1.113883.5.84', 'Agaorse gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (66, '0066', '2.16.840.1.113883.5.84', 'Electrophoresis, citrate agar'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (67, '0067', '2.16.840.1.113883.5.84', 'Immunoelectrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (68, '0068', '2.16.840.1.113883.5.84', 'Polyacrylamide gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (69, '0069', '2.16.840.1.113883.5.84', 'Starch gel electrophoresis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (70, '0070', '2.16.840.1.113883.5.84', 'ELISA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (71, '0071', '2.16.840.1.113883.5.84', 'ELISA, antigen capture'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (72, '0072', '2.16.840.1.113883.5.84', 'ELISA, avidin biotin peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (73, '0073', '2.16.840.1.113883.5.84', 'Kinetic ELISA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (74, '0074', '2.16.840.1.113883.5.84', 'ELISA, peroxidase-antiperoxidase'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (75, '0075', '2.16.840.1.113883.5.84', 'API 20 Strep'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (76, '0076', '2.16.840.1.113883.5.84', 'API 20A'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (77, '0077', '2.16.840.1.113883.5.84', 'API 20C AUX'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (78, '0078', '2.16.840.1.113883.5.84', 'API 20E'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (79, '0079', '2.16.840.1.113883.5.84', 'API 20NE'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (80, '0080', '2.16.840.1.113883.5.84', 'API 50 CH'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (81, '0081', '2.16.840.1.113883.5.84', 'API An-IDENT'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (82, '0082', '2.16.840.1.113883.5.84', 'API Coryne'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (83, '0083', '2.16.840.1.113883.5.84', 'API Rapid 20E'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (84, '0084', '2.16.840.1.113883.5.84', 'API Staph'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (85, '0085', '2.16.840.1.113883.5.84', 'API ZYM'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (86, '0086', '2.16.840.1.113883.5.84', 'Bacterial identification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (87, '0087', '2.16.840.1.113883.5.84', 'mini VIDAS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (88, '0088', '2.16.840.1.113883.5.84', 'Phage susceptibility typing'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (89, '0089', '2.16.840.1.113883.5.84', 'Quad-FERM+'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (90, '0090', '2.16.840.1.113883.5.84', 'RAPIDEC Staph'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (91, '0091', '2.16.840.1.113883.5.84', 'Staphaurex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (92, '0092', '2.16.840.1.113883.5.84', 'VIDAS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (93, '0093', '2.16.840.1.113883.5.84', 'Vitek'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (94, '0094', '2.16.840.1.113883.5.84', 'VITEK 2'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (95, '0095', '2.16.840.1.113883.5.84', 'Immune stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (96, '0096', '2.16.840.1.113883.5.84', 'Immunofluorescent antibody, direct'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (97, '0097', '2.16.840.1.113883.5.84', 'Immunofluorescent antibody, indirect'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (98, '0098', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Avidin-Biotin Complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (99, '0099', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Peroxidase anti-peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (100, '0100', '2.16.840.1.113883.5.84', 'Immunoperoxidase, Protein A-peroxidase complex'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (101, '0101', '2.16.840.1.113883.5.84', 'Immunoassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (102, '0102', '2.16.840.1.113883.5.84', 'Immunoassay, qualitative, multiple step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (103, '0103', '2.16.840.1.113883.5.84', 'Immunoassay, qualitative, single step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (104, '0104', '2.16.840.1.113883.5.84', 'Radioimmunoassay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (105, '0105', '2.16.840.1.113883.5.84', 'Immunoassay, semi-quantitative, multiple step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (106, '0106', '2.16.840.1.113883.5.84', 'Immunoassay, semi-quantitative, single step'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (107, '0107', '2.16.840.1.113883.5.84', 'Microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (108, '0108', '2.16.840.1.113883.5.84', 'Darkfield microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (109, '0109', '2.16.840.1.113883.5.84', 'Electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (110, '0110', '2.16.840.1.113883.5.84', 'Electron microscopy tomography'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (111, '0111', '2.16.840.1.113883.5.84', 'Electron microscopy, negative stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (112, '0112', '2.16.840.1.113883.5.84', 'Electron microscopy, thick section'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (113, '0113', '2.16.840.1.113883.5.84', 'Electron microscopy, thin section'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (114, '0114', '2.16.840.1.113883.5.84', 'Microscopy, Light'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (115, '0115', '2.16.840.1.113883.5.84', 'Polarizing light microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (116, '0116', '2.16.840.1.113883.5.84', 'Scanning electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (117, '0117', '2.16.840.1.113883.5.84', 'Transmission electron microscopy'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (118, '0118', '2.16.840.1.113883.5.84', 'Transparent tape direct examination'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (119, '0119', '2.16.840.1.113883.5.84', '3 Self-Sustaining Sequence Replication'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (120, '0120', '2.16.840.1.113883.5.84', 'Branched Chain DNA'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (121, '0121', '2.16.840.1.113883.5.84', 'Hybridization Protection Assay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (122, '0122', '2.16.840.1.113883.5.84', 'Immune blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (123, '0123', '2.16.840.1.113883.5.84', 'In-situ hybridization'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (124, '0124', '2.16.840.1.113883.5.84', 'Ligase Chain Reaction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (125, '0125', '2.16.840.1.113883.5.84', 'Ligation Activated Transcription'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (126, '0126', '2.16.840.1.113883.5.84', 'Nucleic Acid Probe'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (127, '0127', '2.16.840.1.113883.5.84', 'Nucleic acid probe'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (128, '0128', '2.16.840.1.113883.5.84', 'Nucleic acid probe with amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (129, '0129', '2.16.840.1.113883.5.84', 'Nucleic acid probe with target amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (130, '0130', '2.16.840.1.113883.5.84', 'Nucleic acid reverse transcription'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (131, '0131', '2.16.840.1.113883.5.84', 'Nucleic Acid Sequence Based Analysis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (132, '0132', '2.16.840.1.113883.5.84', 'Polymerase chain reaction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (133, '0133', '2.16.840.1.113883.5.84', 'Q-Beta Replicase or probe amplification category method'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (134, '0134', '2.16.840.1.113883.5.84', 'Restriction Fragment Length Polymorphism'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (135, '0135', '2.16.840.1.113883.5.84', 'Southern Blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (136, '0136', '2.16.840.1.113883.5.84', 'Strand Displacement Amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (137, '0137', '2.16.840.1.113883.5.84', 'Transcription Mediated Amplification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (138, '0138', '2.16.840.1.113883.5.84', 'Western Blot'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (139, '0139', '2.16.840.1.113883.5.84', 'Flocculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (140, '0140', '2.16.840.1.113883.5.84', 'Immune precipitation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (141, '0141', '2.16.840.1.113883.5.84', 'Milk ring test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (142, '0142', '2.16.840.1.113883.5.84', 'Precipitin'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (143, '0143', '2.16.840.1.113883.5.84', 'Acid fast stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (144, '0144', '2.16.840.1.113883.5.84', 'Acid fast stain, fluorochrome'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (145, '0145', '2.16.840.1.113883.5.84', 'Acid fast stain, Kinyouns cold carbolfuchsin'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (146, '0146', '2.16.840.1.113883.5.84', 'Acid fast stain, Ziehl-Neelsen'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (147, '0147', '2.16.840.1.113883.5.84', 'Acid phosphatase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (148, '0148', '2.16.840.1.113883.5.84', 'Acridine orange stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (149, '0149', '2.16.840.1.113883.5.84', 'Active brilliant orange KH stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (150, '0150', '2.16.840.1.113883.5.84', 'Alazarin red S stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (151, '0151', '2.16.840.1.113883.5.84', 'Alcian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (152, '0152', '2.16.840.1.113883.5.84', 'Alcian blue with Periodic acid Schiff stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (153, '0153', '2.16.840.1.113883.5.84', 'Argentaffin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (154, '0154', '2.16.840.1.113883.5.84', 'Argentaffin silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (155, '0155', '2.16.840.1.113883.5.84', 'Azure-eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (156, '0156', '2.16.840.1.113883.5.84', 'Basic Fuschin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (157, '0157', '2.16.840.1.113883.5.84', 'Bennhold stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (158, '0158', '2.16.840.1.113883.5.84', 'Bennholds Congo red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (159, '0159', '2.16.840.1.113883.5.84', 'Bielschowsky stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (160, '0160', '2.16.840.1.113883.5.84', 'Bielschowskys silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (161, '0161', '2.16.840.1.113883.5.84', 'Bleach stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (162, '0162', '2.16.840.1.113883.5.84', 'Bodian stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (163, '0163', '2.16.840.1.113883.5.84', 'Brown-Brenn stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (164, '0164', '2.16.840.1.113883.5.84', 'Butyrate-esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (165, '0165', '2.16.840.1.113883.5.84', 'Calcofluor white fluorescent stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (166, '0166', '2.16.840.1.113883.5.84', 'Carbol-fuchsin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (167, '0167', '2.16.840.1.113883.5.84', 'Carmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (168, '0168', '2.16.840.1.113883.5.84', 'Churukian-Schenk stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (169, '0169', '2.16.840.1.113883.5.84', 'Congo red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (170, '0170', '2.16.840.1.113883.5.84', 'Cresyl echt violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (171, '0171', '2.16.840.1.113883.5.84', 'Crystal violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (172, '0172', '2.16.840.1.113883.5.84', 'De Galantha stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (173, '0173', '2.16.840.1.113883.5.84', 'Dieterle silver impregnation stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (174, '0174', '2.16.840.1.113883.5.84', 'Fite-Farco stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (175, '0175', '2.16.840.1.113883.5.84', 'Fontana-Masson silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (176, '0176', '2.16.840.1.113883.5.84', 'Fouchet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (177, '0177', '2.16.840.1.113883.5.84', 'Gomori stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (178, '0178', '2.16.840.1.113883.5.84', 'Gomori methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (179, '0179', '2.16.840.1.113883.5.84', 'Gomori-Wheatly trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (180, '0180', '2.16.840.1.113883.5.84', 'Gridley stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (181, '0181', '2.16.840.1.113883.5.84', 'Grimelius silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (182, '0182', '2.16.840.1.113883.5.84', 'Grocott stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (183, '0183', '2.16.840.1.113883.5.84', 'Grocott methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (184, '0184', '2.16.840.1.113883.5.84', 'Hales colloidal ferric oxide stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (185, '0185', '2.16.840.1.113883.5.84', 'Hales colloidal iron stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (186, '0186', '2.16.840.1.113883.5.84', 'Hansel stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (187, '0187', '2.16.840.1.113883.5.84', 'Harris regressive hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (188, '0188', '2.16.840.1.113883.5.84', 'Hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (189, '0189', '2.16.840.1.113883.5.84', 'Highman stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (190, '0190', '2.16.840.1.113883.5.84', 'Holzer stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (191, '0191', '2.16.840.1.113883.5.84', 'Iron hematoxylin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (192, '0192', '2.16.840.1.113883.5.84', 'Jones stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (193, '0193', '2.16.840.1.113883.5.84', 'Jones methenamine silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (194, '0194', '2.16.840.1.113883.5.84', 'Kossa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (195, '0195', '2.16.840.1.113883.5.84', 'Lawson-Van Gieson stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (196, '0196', '2.16.840.1.113883.5.84', 'Loeffler methylene blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (197, '0197', '2.16.840.1.113883.5.84', 'Luxol fast blue with cresyl violet stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (198, '0198', '2.16.840.1.113883.5.84', 'Luxol fast blue with Periodic acid-Schiff stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (199, '0199', '2.16.840.1.113883.5.84', 'MacNeals tetrachrome blood stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (200, '0200', '2.16.840.1.113883.5.84', 'Mallory-Heidenhain stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (201, '0201', '2.16.840.1.113883.5.84', 'Masson trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (202, '0202', '2.16.840.1.113883.5.84', 'Mayer mucicarmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (203, '0203', '2.16.840.1.113883.5.84', 'Mayers progressive hematoxylin and eosin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (204, '0204', '2.16.840.1.113883.5.84', 'May-Grunwald Giemsa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (205, '0205', '2.16.840.1.113883.5.84', 'Methyl green stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (206, '0206', '2.16.840.1.113883.5.84', 'Methyl green pyronin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (207, '0207', '2.16.840.1.113883.5.84', 'Modified Gomori-Wheatly trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (208, '0208', '2.16.840.1.113883.5.84', 'Modified Masson trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (209, '0209', '2.16.840.1.113883.5.84', 'Modified trichrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (210, '0210', '2.16.840.1.113883.5.84', 'Movat pentachrome stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (211, '0211', '2.16.840.1.113883.5.84', 'Mucicarmine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (212, '0212', '2.16.840.1.113883.5.84', 'Neutral red stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (213, '0213', '2.16.840.1.113883.5.84', 'Night blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (214, '0214', '2.16.840.1.113883.5.84', 'Non-specific esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (215, '0215', '2.16.840.1.113883.5.84', 'Oil red-O stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (216, '0216', '2.16.840.1.113883.5.84', 'Orcein stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (217, '0217', '2.16.840.1.113883.5.84', 'Perls stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (218, '0218', '2.16.840.1.113883.5.84', 'Phosphotungstic acid-hematoxylin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (219, '0219', '2.16.840.1.113883.5.84', 'Potassium ferrocyanide stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (220, '0220', '2.16.840.1.113883.5.84', 'Prussian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (221, '0221', '2.16.840.1.113883.5.84', 'Putchler modified Bennhold stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (222, '0222', '2.16.840.1.113883.5.84', 'Quinacrine fluorescent stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (223, '0223', '2.16.840.1.113883.5.84', 'Reticulin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (224, '0224', '2.16.840.1.113883.5.84', 'Rhodamine stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (225, '0225', '2.16.840.1.113883.5.84', 'Safranin stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (226, '0226', '2.16.840.1.113883.5.84', 'Schmorl stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (227, '0227', '2.16.840.1.113883.5.84', 'Seiver-Munger stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (228, '0228', '2.16.840.1.113883.5.84', 'Silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (229, '0229', '2.16.840.1.113883.5.84', 'Specific esterase stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (230, '0230', '2.16.840.1.113883.5.84', 'Steiner silver stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (231, '0231', '2.16.840.1.113883.5.84', 'Sudan III stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (232, '0232', '2.16.840.1.113883.5.84', 'Sudan IVI stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (233, '0233', '2.16.840.1.113883.5.84', 'Sulfated alcian blue stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (234, '0234', '2.16.840.1.113883.5.84', 'Supravital stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (235, '0235', '2.16.840.1.113883.5.84', 'Thioflavine-S stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (236, '0236', '2.16.840.1.113883.5.84', 'Three micron Giemsa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (237, '0237', '2.16.840.1.113883.5.84', 'Vassar-Culling stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (238, '0238', '2.16.840.1.113883.5.84', 'Vital Stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (239, '0239', '2.16.840.1.113883.5.84', 'von Kossa stain'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (240, '0240', '2.16.840.1.113883.5.84', 'Antibiotic sensitivity, disk'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (241, '0241', '2.16.840.1.113883.5.84', 'BACTEC susceptibility test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (242, '0242', '2.16.840.1.113883.5.84', 'Disk dilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (243, '0243', '2.16.840.1.113883.5.84', 'Minimum bactericidal concentration test, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (244, '0244', '2.16.840.1.113883.5.84', 'Minimum bactericidal concentration test, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (245, '0245', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (246, '0246', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (247, '0247', '2.16.840.1.113883.5.84', 'Turbidometric'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (248, '0248', '2.16.840.1.113883.5.84', 'Refractometric'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (249, '0249', '2.16.840.1.113883.5.84', 'Thin layer chromatography (TLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (250, '0250', '2.16.840.1.113883.5.84', 'EMIT'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (251, '0251', '2.16.840.1.113883.5.84', 'Flow cytometry (FC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (252, '0252', '2.16.840.1.113883.5.84', 'Radial immunodiffusion (RID)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (253, '0253', '2.16.840.1.113883.5.84', 'Fluorescence polarization immunoassay (FPIA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (254, '0254', '2.16.840.1.113883.5.84', 'Immunofixation electrophoresis (IFE)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (255, '0255', '2.16.840.1.113883.5.84', 'Equilibrium dialysis'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (256, '0256', '2.16.840.1.113883.5.84', 'Kleihauer-Betke acid elution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (257, '0257', '2.16.840.1.113883.5.84', 'Anti-complement immunofluorescence (ACIF)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (258, '0258', '2.16.840.1.113883.5.84', 'GC/MS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (259, '0259', '2.16.840.1.113883.5.84', 'Nephelometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (260, '0260', '2.16.840.1.113883.5.84', 'IgE immunoassay antibody'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (261, '0261', '2.16.840.1.113883.5.84', 'Lymphocyte Microcytotoxicity Assay'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (262, '0262', '2.16.840.1.113883.5.84', 'Spectrophotometry'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (263, '0263', '2.16.840.1.113883.5.84', 'Atomic absorption spectrophotometry (AAS)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (264, '0264', '2.16.840.1.113883.5.84', 'Ion selective electrode (ISE)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (265, '0265', '2.16.840.1.113883.5.84', 'Gas chromatography (GC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (266, '0266', '2.16.840.1.113883.5.84', 'Isoelectric focusing (IEF)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (267, '0267', '2.16.840.1.113883.5.84', 'Immunochemiluminescence'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (268, '0268', '2.16.840.1.113883.5.84', 'Microparticle enzyme immunoassay (MEIA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (269, '0269', '2.16.840.1.113883.5.84', 'ICP/MS'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (270, '0270', '2.16.840.1.113883.5.84', 'Immunoradiometric assay (IRMA)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (271, '0271', '2.16.840.1.113883.5.84', 'Photo optical clot detection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (272, 'ALGM', '2.16.840.1.113883.5.84', 'algorithm'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (273, 'BYCL', '2.16.840.1.113883.5.84', 'bayesian calculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (274, 'GINT', '2.16.840.1.113883.5.84', 'global introspection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (275, 'ALGM', '2.16.840.1.113883.5.84', 'algorithm'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (276, 'BYCL', '2.16.840.1.113883.5.84', 'bayesian calculation'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (277, 'GINT', '2.16.840.1.113883.5.84', 'global introspection'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (278, '0272', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (279, '0245', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, macrodilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (280, '0246', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration, microdilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (281, '0275a', '2.16.840.1.113883.5.84', 'Minimum Lethal Concentration (MLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (282, '0280', '2.16.840.1.113883.5.84', 'Susceptibility Testing'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (283, '0240', '2.16.840.1.113883.5.84', 'Antibiotic sensitivity, disk'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (284, '0241', '2.16.840.1.113883.5.84', 'BACTEC susceptibility test'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (285, '0242', '2.16.840.1.113883.5.84', 'Disk dilution'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (286, '0272', '2.16.840.1.113883.5.84', 'Minimum Inhibitory Concentration'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (287, '0273', '2.16.840.1.113883.5.84', 'Viral Genotype Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (288, '0274', '2.16.840.1.113883.5.84', 'Viral Phenotype Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (289, '0275', '2.16.840.1.113883.5.84', 'Gradient Strip'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (290, '0275a', '2.16.840.1.113883.5.84', 'Minimum Lethal Concentration (MLC)'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (291, '0276', '2.16.840.1.113883.5.84', 'Slow Mycobacteria Susceptibility'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (292, '0277', '2.16.840.1.113883.5.84', 'Serum bactericidal titer'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (293, '0278', '2.16.840.1.113883.5.84', 'Agar screen'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (294, '0279', '2.16.840.1.113883.5.84', 'Disk induction'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (295, '_VerificationMethod', '2.16.840.1.113883.5.84', 'VerificationMethod'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (296, 'VDOC', '2.16.840.1.113883.5.84', 'document verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (297, 'VREG', '2.16.840.1.113883.5.84', 'registry verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (298, 'VTOKEN', '2.16.840.1.113883.5.84', 'electronic token verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (299, 'VVOICE', '2.16.840.1.113883.5.84', 'voice-based verification'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (300, '_GeneticObservationMethod', '2.16.840.1.113883.5.84', 'GeneticObservationMethod'); INSERT INTO ObservationMethod (ObservationMethod_id, code, codeSystem, displayName) VALUES (301, 'PCR', '2.16.840.1.113883.5.84', 'PCR');