text: USE [Anlab]
  GO
  DELETE FROM [dbo].[TestItems]
  GO
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#ADFAF', NULL, N'Acid Detergent Fiber (ash free)', N'Plant', N'FEED TESTS', 5044, NULL, 0, 5540)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#AD-HM', NULL, N'Acid Digestible Heavy Metals [Cd, Cr, Pb, Ni]', N'Water', N'ACID DIGESTIBLE MINERALS - DISCOUNTED TEST GROUPS', 7400, NULL, 0, 7604)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#ADIN', NULL, N'Acid Detergent Insoluble Nitrogen (includes ADF)', N'Plant', N'FEED TESTS', 5054, NULL, 0, 5520)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#AD-MICR', NULL, N'Acid Digestible Micronutrients [Zn, Mn, Fe, Cu]', N'Water', N'ACID DIGESTIBLE TESTS - DISCOUNTED TEST GROUP', 7300, NULL, 0, 7603)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#AD-MICRT', NULL, N'Acid Digestible MIcronutrients Group (Zn, Mn, Fe, Cu)', N'Soil', N'ACID DIGESTIBLES - DISCOUNTED TEST GROUPS', 3500, NULL, 0, 2900)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#AD-SALTS', NULL, N'Acid Digestible Salts [K, Ca, Mg, Na]', N'Water', N'ACID DIGESTIBLE MINERALS - DISCOUNTED TEST GROUPS', 7200, NULL, 0, 7600)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#ANIONS', NULL, N'Anion Panel [Cl, SO4-S (soluble S), NO3-N, HCO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7052, NULL, 0, 7040)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CARBS', NULL, N'Soluble Carbohydrates Group 1 [Fructose, Glucose, Sucrose]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5702, NULL, 0, 5702)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CARBS2', NULL, N'Soluble Carbohydrates Group 2 [Fructose, Glucose, Sucrose, Sorbitol]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5704, NULL, 0, 5704)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CEC-EST', NULL, N'Cation Exchange Capacity - Estimate from Exchangeable Cations *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4110, N'Requires Exchangeable Cations', 0, 2710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CELLULOS', NULL, N'Cellulose', N'Plant', N'FEED TESTS', 5050, NULL, 0, 5560)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CORG', NULL, N'Organic Carbon  (Calculated from Walkley-Black OM) *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4610, N'Requires OM (Walkley-Black)
  Alternate method', 0, 2732)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CORG-LOI', NULL, N'Organic Carbon - Calculated from OM (LOI) *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4125, N'Requires OM (LOI)', 0, 2730)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#CRBBI', NULL, N'Bicarbonate & Carbonate [HCO3, CO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7080, NULL, 0, 7030)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#ESP-W', NULL, N'Exchangeable Sodium Percent (ESP) *', N'Water', N'INDIVIDUAL TESTS', 7072, N'Requires selection of Ca, Mg and Na', 0, 7300)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#FEED1', NULL, N'Feed Group 1 [DM, Protein, ADF, TDN]', N'Plant', N'FEED TESTS - DISCOUNTED GROUPS', 5002, NULL, 0, 5500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#FEED2', NULL, N'Feed Group 2 [DM, Protein, ADF, TDN, Ash, Fat]', N'Plant', N'FEED TESTS - DISCOUNTED GROUPS', 5004, NULL, 0, 5505)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#FERT', NULL, N'Soil Fertility Group 1 [NO3-N, Olsen-P, X-K]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3225, NULL, 0, 2205)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#FERT2', NULL, N'Soil Fertility Group 2 [NO3-N, Olsen-P, X-K, X-Na, X-Ca, X-Mg, OM (LOI), pH, CEC (Estimated)]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3225, NULL, 0, 2205)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#HARD', NULL, N'Hardness *', N'Water', N'INDIVIDUAL TESTS', 7074, N'Requires selection of Ca and Mg', 0, 7310)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#IC-PANEL', NULL, N'Ion Chromatography Panel [Cl, SO4]', N'Water', N'DISCOUNTED TEST GROUPS', 7700, NULL, 0, 7050)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#LIG-AF', NULL, N'Lignin', N'Plant', N'FEED TESTS', 5048, NULL, 0, 5620)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#MICRE', NULL, N'Extractable (DTPA) Micronutrient Group [DTPA: Zn, Mn, Fe, Cu]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3280, NULL, 0, 2225)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#MICRS', NULL, N'Soluble Micronutrients [Zn, Mn, Fe, Cu]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS', 7140, NULL, 0, 7402)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NA-E', NULL, N'Nitrate-N & Ammonium-N Group', N'Water', N'DISCOUNTED TEST GROUPS', 7050, NULL, 0, 7060)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NA-EXT', NULL, N'Nitrate-N & Ammonium-N Group - Client Provided Extract', N'Soil', N'CLIENT-PROVIDED EXTRACTS', 4810, NULL, 0, 3500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NAF-S', NULL, N'Nitrate & Ammonium Group [NO3-N, NH4-N]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3220, NULL, 0, 2215)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NA-P', NULL, N'Nitrate & Ammonium Group [NO3-N, NH4-N]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5400, NULL, 0, 5080)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NA-PMF', NULL, N'Add Na to a Nutrient Panel', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5136, NULL, 0, 5041)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NC-P', NULL, N'Total Nitrogen & Carbon [N, C]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5100, NULL, 0, 5070)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NC-S', NULL, N'Total Nitrogen & Carbon [N, C]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3202, NULL, 0, 2212)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NDFAF', NULL, N'Neutral Detergent Fiber (NDF) - Ash Free', N'Plant', N'FEED TESTS', 5068, NULL, 0, 5640)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NN-WET', NULL, N'Nitrate & Ammonium (undried soil) [NO3-N, NH4-N]', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4900, NULL, 0, 2470)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NUTRA2', NULL, N'Nutrient Panel A [N, P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5120, NULL, 0, 5010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NUTRB', NULL, N'Nutrient Panel B [S, B, Ca, Mg]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5125, NULL, 0, 5020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#NUTRC', NULL, N'Nutrient Panel C [Zn, Mn, Fe, Cu] ', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5130, NULL, 0, 5030)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#PLANT-D3', NULL, N'Nutrient Panel D [Panels A, B & C tests', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5135, NULL, 0, 5040)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#PLANT-E', NULL, N'Nutrient Panel E [NO3-N, PO4-P, K, Panels B & C tests] ', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5140, NULL, 0, 5050)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#PROT', NULL, N'Crude Protein', N'Plant', N'FEED TESTS', 5040, NULL, 0, 5579)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#PSA', NULL, N'Particle Size [Sand/Silt/Clay]', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4500, NULL, 0, 2800)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#SALIN', NULL, N'Soil Salinity Group 1 [SP, pH, EC, Ca, Mg, Na, Cl, B, HCO3, CO3]', N'Soil', N'SALINITY/SATURATED PASTE TESTS - DISCOUNTED GROUPS', 2005, NULL, 0, 2500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#SALIN-2', NULL, N'Soil Salinity Group 2 [SP, pH, EC, Ca, Mg, Na, Cl, B]', N'Soil', N'SALINITY/SATURATED PASTE TESTS - DISCOUNTED GROUPS', 2020, NULL, 0, 2505)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#SAR-W', NULL, N'Sodium Adsorption Ratio (SAR) *', N'Water', N'INDIVIDUAL TESTS', 7070, N'Requires selection of Ca, Mg and Na', 0, 7350)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#SLSLT', NULL, N'Soluble Salts [K, Ca, Mg, Na]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS', 7030, NULL, 0, 7400)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#SOL-HM', NULL, N'Soluble Heavy Metals [Cd, Cr, Pb, Ni]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS', 7160, NULL, 0, 7404)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#STARCH', NULL, N'Starch *', N'Plant', N'CARBOHYDRATES', 5710, N'Includes Soluble and Total Glucose', 0, 5710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#TCARB', NULL, N'Carbohydrate Panel [TNC, Starch, Fructose, Glucose, Sucrose, Total Glucose]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5706, NULL, 0, 5706)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#TDNRF', NULL, N'Total Digestible Nutrients (TDN) *', N'Plant', N'FEED TESTS', 5640, N'Requires Selection of ADF', 0, 5655)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#TNC', NULL, N'Total Non-Structural Carbohydrates (TNC) *', N'Plant', N'CARBOHYDRATES', 5720, N'Includes Fructose, Sucrose and Total Glucose', 0, 5760)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#WSUIT', NULL, N'Water Suitability Group 1 [pH, EC, SAR, Ca, Mg, Na, Cl, B, HCO3, CO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7010, NULL, 0, 7010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#WSUIT-2', NULL, N'Water Suitability Group 2 [pH, EC, SAR, Ca, Mg, Na, Cl, B]', N'Water', N'DISCOUNTED TEST GROUPS', 7020, NULL, 0, 7020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#XCAT', NULL, N'Exchangeable Cation Group [X-K, X-Na, X-Ca, X-Mg]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3270, NULL, 0, 2220)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#XK-X', NULL, N'Exchangeable Potassium (X-K)', N'Soil', N'FERTILITY TESTS', 3276, NULL, 0, 2305)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#XNPK', NULL, N'Extractable N-P-K Group 1 [NO3-N, NH4-N, PO4-P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5410, NULL, 0, 5090)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'#XNPKF-2', NULL, N'Extractable N-P-K Group 2 [NO3-N, PO4-P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5420, NULL, 0, 5100)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ADFAF', NULL, N'ADFAF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ADFRF', NULL, N'Acid Detergent Fiber (ADF)', N'Plant', N'FEED TESTS', 5042, NULL, 1, 5530)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ADIN', NULL, N'ADIN', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AG-W', NULL, N'AG-W', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AG-WT', NULL, N'AG-WT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL', NULL, N'Aluminum (Al)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5355, NULL, 1, 5210)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-CIT', NULL, N'AL-CIT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ALK', NULL, N'Alkalinity', N'Water', N'INDIVIDUAL TESTS', 7096, NULL, 1, 7200)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-KCL', NULL, N'Aluminum (Al) - KCl Extraction', N'Soil', N'FERTILITY TESTS', 3290, NULL, 1, 2230)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ALK-WX', NULL, N'ALK-WX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-OX', NULL, N'Aluminum (Al) - Oxalate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4710, NULL, 1, 2405)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-PY', NULL, N'Aluminum (Al) - Pyrophosphate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4750, NULL, 1, 2440)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-W', NULL, N'Aluminum (Al)', N'Water', N'SOLUBLE MINERALS', 7150, NULL, 1, 7408)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AL-WT', NULL, N'Aluminum (Al)', N'Water', N'ACID DIGESTIBLE MINERALS', 7452, NULL, 1, 7608)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ASCORBIC', NULL, N'Ascorbic Acid *', N'Plant', N'VITAMINS', 5610, N'Please contact the lab before submitting samples.', 1, 5675)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ASH', NULL, N'Ash Content', N'Plant', N'FEED TESTS', 5062, NULL, 1, 5550)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AS-PT', NULL, N'Arsenic (As)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5315, NULL, 1, 5220)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AS-ST', NULL, N'Arsenic (As)', N'Soil', N'ACID DIGESTIBLES', 3610, NULL, 1, 2905)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AS-WT', NULL, N'Arsenic (As)', N'Water', N'ACID DIGESTIBLE MINERALS', 7604, NULL, 1, 7610)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM1', NULL, N'Moisture Retention: 1 atm', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4410, NULL, 1, 2765)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM10', NULL, N'Moisture Retention: 10 atm', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4430, NULL, 1, 2775)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM15', NULL, N'Moisture Retention: 15 atm	', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4440, NULL, 1, 2780)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM1P5', NULL, N'ATM1P5', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM2', NULL, N'ATM2', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATM5', NULL, N'Moisture Retention: 5 atm', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4420, NULL, 1, 2770)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATMP1', NULL, N'ATMP1', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATMP3', NULL, N'Moisture Retention: 0.33 atm', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4499, NULL, 1, 2760)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATMP5', NULL, N'ATMP5', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ATMP7', NULL, N'ATMP7', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'AU', NULL, N'AU', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'BA', NULL, N'Barium (Ba)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5265, NULL, 1, 5230)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'BA-PMF', NULL, N'Barium (Ba)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5265, NULL, 1, 5230)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'BD', N'Enter soil core diameter and length (required for bulk density):', N'Bulk Density', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4300, NULL, 1, 2750)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'B-PMF', NULL, N'Boron (B)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5225, NULL, 1, 5240)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'BRAY-P', NULL, N'Phosphate - Bray Extraction (Bray-P) - acidic soil', N'Soil', N'FERTILITY TESTS', 3240, N'Use on soils with a pH under pH 6.5. Use Olsen-P for soils over pH 6.5', 1, 2260)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'B-S', NULL, N'Boron (B) - Saturated Paste Extracts', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2355, NULL, 1, 2515)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'B-SX', NULL, N'B-SX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'B-W', NULL, N'Boron (B)', N'Water', N'SOLUBLE MINERALS', 7138, NULL, 1, 7410)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'B-WT', NULL, N'Boron (B)', N'Water', N'ACID DIGESTIBLE MINERALS', 7250, NULL, 1, 7620)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CACO3', NULL, N'Calcium Carbonate (CaCO3)', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4200, NULL, 1, 2740)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CAFFEINE', NULL, N'CAFFEINE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CANCEL', NULL, N'CANCEL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-PMF', NULL, N'Calcium', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5230, NULL, 1, 5275)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CAROTENE', NULL, N'β-Carotene *', N'Plant', N'VITAMINS', 5046, N'Please contact the lab before submitting samples.', 1, 5680)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-S', NULL, N'Calcium (Ca) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2350, NULL, 1, 2520)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-TOX', NULL, N'CA-TOX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-W', NULL, N'Calcium (Ca)', N'Water', N'SOLUBLE MINERALS', 7132, NULL, 1, 7420)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-WT', NULL, N'Calcium (Ca)', N'Water', N'ACID DIGESTIBLE MINERALS', 7204, NULL, 1, 7640)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CA-WX', NULL, N'Ca in mg/L', N'Water', N'SOLUBLE MINERALS:', 29100, NULL, 0, 29100)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD', NULL, N'Cadmium (Cd)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5270, NULL, 1, 5270)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD_TOT', NULL, N'Cadmium (Cd)', N'Soil', N'ACID DIGESTIBLES', 3530, NULL, 1, 2915)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD-HCL', NULL, N'CD-HCL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD-S', NULL, N'CD-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD-W', NULL, N'Cadmium (Cd)', N'Water', N'SOLUBLE MINERALS', 7162, NULL, 1, 7415)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CD-WT', NULL, N'Cadmium (Cd)', N'Water', N'ACID DIGESTIBLE MINERALS', 7402, NULL, 1, 7630)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CEC', NULL, N'Cation Exchange Capacity - Barium Replacement Method (CEC)', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4100, NULL, 1, 2700)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CEC-EST', NULL, N'Cation Exchange Capacity - Estimate from Exchangeable Cations *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4110, N'Requires exchangeable cations', 1, 2710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CLAY', NULL, N'CLAY', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CL-P-IC', NULL, N'Chloride (Cl)', N'Plant', N'EXTRACTABLES', 5465, NULL, 1, 5472)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CL-S', NULL, N'Chloride (Cl) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2354, NULL, 1, 2530)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CL-W', NULL, N'Chloride (Cl)', N'Water', N'INDIVIDUAL TESTS', 7078, NULL, 1, 7280)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CL-W-IC', NULL, N'Chloride (Cl) by Ion Chromatography *', N'Water', N'INDIVIDUAL TESTS', 7704, N'Alternate Method', 1, 7282)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CL-WX', NULL, N'Cl in mg/L', N'Water', N'SOLUBLE MINERALS:', 29000, NULL, 0, 29000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CO', NULL, N'Cobalt (Co)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5280, NULL, 1, 5290)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CO_TOT', NULL, N'CO_TOT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CO3-S', NULL, N'Carbonate (CO3) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2361, NULL, 1, 2525)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CO3-W', NULL, N'Carbonate (CO3)', N'Water', N'INDIVIDUAL TESTS', 7084, NULL, 1, 7240)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CORG', NULL, N'Organic Carbon  (Calculated from Walkley-Black OM) *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4610, N'Alternate method. Requires OM (Walkley-Black)', 1, 2732)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CORG-LOI', NULL, N'Organic Carbon - Calculated from OM (LOI) *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4125, N'Requires OM (LOI)', 1, 2730)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CO-S', NULL, N'CO-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'C-P', NULL, N'Carbon', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5025, NULL, 1, 5260)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'C-P-CW', NULL, N'C-P-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR', NULL, N'Chromium (Cr) *', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5275, N'Does not include Chromium Oxide', 1, 5280)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR_TOT', NULL, N'CR_TOT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR-OXIDE', NULL, N'Chromium Oxide (Cr-oxide) *', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5320, N'Acid digestible chromium. Includes chromium oxide.', 1, 5285)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR-S', NULL, N'CR-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR-W', NULL, N'Chromium (Cr)', N'Water', N'SOLUBLE MINERALS', 7164, NULL, 1, 7425)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CR-WT', NULL, N'Chromium (Cr)', N'Water', N'ACID DIGESTIBLE MINERALS', 7404, NULL, 1, 7650)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'C-S', NULL, N'Carbon - Total (C)', N'Soil', N'FERTILITY TESTS', 3204, NULL, 1, 2235)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'C-S-CW', NULL, N'C-S-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU_TOT', NULL, N'Copper (Cu)', N'Soil', N'ACID DIGESTIBLES', 3525, NULL, 1, 2910)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-PM', NULL, N'Copper (Cu)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5260, NULL, 1, 5300)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-PT', NULL, N'Copper (Cu)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5261, NULL, 0, 5301)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-S', NULL, N'Copper (Cu) - DTPA Extraction', N'Soil', N'FERTILITY TESTS', 3282, NULL, 1, 2330)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-W', NULL, N'Copper (Cu)', N'Water', N'SOLUBLE MINERALS', 7148, NULL, 1, 7430)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-WPPB', NULL, N'CU-WPPB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-WT', NULL, N'Copper (Cu)', N'Water', N'ACID DIGESTIBLE MINERALS', 7308, NULL, 1, 7660)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'CU-WTPPB', NULL, N'CU-WTPPB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'D', NULL, N'% Dry Matter (Sample Prep)', N'Soil|Plant', N'SAMPLE PREPARATION', 1500, NULL, 0, 1500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DHA', NULL, N'DHA', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DM', NULL, N'Dry Matter (DM) *', N'Plant', N'FEED TESTS', 5010, N'Dry matter evaluates the moisture content of dried and ground samples that were (typically) dried at 55 to 60 degrees C in a forced air oven, by heating a sub-sample at 105 degrees C. This value can be used to correct test results to a 100% dry weight basis.', 1, 5580)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DM55', NULL, N'Partial DM (dried at 55OC) *', N'Plant', N'SAMPLE PREPARATION', 4010, N'This test is selected when the moisture content of samples as collected must be measured. Partial dry matter is used to evaluate the moisture content of fresh/undried samples based on heating the samples at 55 degrees C in a forced air oven. NOTE: Samples are typically dried when received, so it is not possible to request this test after samples have been received by the lab.', 1, 4010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DOC-W', NULL, N'Carbon - Dissolved Organic Carbon (DOC)', N'Water', N'INDIVIDUAL TESTS', 7044, NULL, 1, 7270)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DOC-WF', NULL, N'DOC-WF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DUM', NULL, N'DUM', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DUMMY1', NULL, N'Placeholder', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DUMMY2', NULL, N'Place holder', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'DUMMY3', NULL, N'DUMMY3', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'EC1-2', NULL, N'EC1-2', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'EC-M', NULL, N'EC (water 1:5)', N'Plant', N'COMPOST/MANURE TESTS', 5910, NULL, 1, 5910)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'EC-S', NULL, N'Electrical Conductivity (EC)', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2150, NULL, 1, 2535)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'EC-W', NULL, N'Electrical Conductivity (EC)', N'Water', N'INDIVIDUAL TESTS', 7032, NULL, 1, 7290)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ESP-S', NULL, N'Exchangeable Sodium Percentage (ESP) *', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2405, N'Requires Ca, Mg and Na', 1, 2540)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ESP-W', NULL, N'Exchangeable Sodium Percent (ESP) *', N'Water', N'INDIVIDUAL TESTS', 7072, N'Requires selection of Ca, Mg Na', 1, 7300)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'EXTERNAL', NULL, N'EXTERNAL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'F', NULL, N'F', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FAT', NULL, N'Fat *', N'Plant', N'FEED TESTS', 5064, N'Samples with high carbohydrate concentrations typically require a water rinse step (see Fat with Rinse).', 1, 5590)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FAT-R', NULL, N'Fat with Rinse (samples with high carbohydrate concentrations) *', N'Plant', N'FEED TESTS', 5075, N'Select Fat with Rinse for samples with high carbohydrate concentrations', 1, 5600)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE_TOT', NULL, N'Iron (Fe)', N'Soil', N'ACID DIGESTIBLES', 3520, NULL, 1, 2920)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-CIT', NULL, N'FE-CIT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-OX', NULL, N'Iron (Fe) - Oxalate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4720, NULL, 1, 2410)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-PM', NULL, N'Iron (Fe)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5255, NULL, 1, 5310)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-PT', NULL, N'Iron (Fe)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5256, NULL, 0, 5311)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-PY', NULL, N'Iron (Fe) - Pyrophosphate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4760, NULL, 1, 2450)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-S', NULL, N'Iron (Fe) - DTPA Extraction', N'Soil', N'FERTILITY TESTS', 3284, NULL, 1, 2340)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-W', NULL, N'Iron (Fe)', N'Water', N'SOLUBLE MINERALS', 7146, NULL, 1, 7440)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FE-WT', NULL, N'Iron (Fe)', N'Water', N'ACID DIGESTIBLE MINERALS', 7306, NULL, 1, 7670)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FILTER', NULL, N'Sample FIltration', N'Water', N'SAMPLE PREPARATION', 7000, NULL, 1, 7000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FREEZEDRY', NULL, N'FREEZEDRY', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRUC', NULL, N'Fructose', N'Plant', N'CARBOHYDRATES', 5730, NULL, 1, 5710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRUCL', NULL, N'FRUCL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRUCTAN', NULL, N'FRUCTAN', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRUC-TOT', NULL, N'FRUC-TOT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRUS', NULL, N'FRUS', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'FRZDRY', NULL, N'FRZDRY', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G', NULL, N'G', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-ADFAF', NULL, N'Acid Detergent Fiber (ash free)', N'Plant', N'FEED TESTS', 5044, NULL, 1, 5540)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-AD-HM', NULL, N'Acid Digestible Heavy Metals [Cd, Cr, Pb, Ni]', N'Water', N'ACID DIGESTIBLE MINERALS - DISCOUNTED TEST GROUPS', 7400, NULL, 1, 7604)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-ADIN', NULL, N'Acid Detergent Insoluble Nitrogen (includes ADF)', N'Plant', N'FEED TESTS', 5054, NULL, 1, 5520)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-AD-MICR', NULL, N'Acid Digestible Micronutrients [Zn, Mn, Fe, Cu]', N'Water', N'ACID DIGESTIBLE MINERALS - DISCOUNTED TEST GROUPS', 7300, NULL, 1, 7602)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-AD-SALTS', NULL, N'Acid Digestible Salts [K, Ca, Mg, Na]', N'Water', N'ACID DIGESTIBLE MINERALS - DISCOUNTED TEST GROUPS', 7200, NULL, 1, 7600)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-ANIONS', NULL, N'Anion Panel [Cl, SO4-S (soluble S), NO3-N, HCO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7052, NULL, 1, 7040)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CARBS', NULL, N'Soluble Carbohydrates Group 1 [Fructose, Glucose, Sucrose]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5702, NULL, 1, 5702)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CARBS2', NULL, N'Soluble Carbohydrates Group 2 [Fructose, Glucose, Sucrose, Sorbitol]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5704, NULL, 1, 5704)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CAWWX', NULL, N'G-CAWWX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CELLULOS', NULL, N'Cellulose (includes ADF)', N'Plant', N'FEED TESTS', 5050, NULL, 1, 5560)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CLWWX', NULL, N'G-CLWWX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-CRBBI', NULL, N'Bicarbonate & Carbonate [HCO3, CO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7080, NULL, 1, 7030)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'GE-W', NULL, N'GE-W', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-FEED1', NULL, N'Feed Group 1 (DM, Protein, ADF, TDN)', N'Plant', N'FEED TESTS - DISCOUNTED GROUPS', 5002, NULL, 1, 5500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-FEED2', NULL, N'Feed Group 2 (DM, Protein, ADF, TDN, Ash, Fat)', N'Plant', N'FEED TESTS - DISCOUNTED GROUPS', 5004, NULL, 1, 5505)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-FERT', NULL, N'Soil Fertility Group 1 [NO3-N, Olsen-P, X-K]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3225, NULL, 1, 2205)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-FERT2', NULL, N'Soil Fertility Group 2 [NO3-N, Olsen-P, X-K, X-Na, X-Ca, X-Mg, OM (LOI), pH, CEC (Estimated)]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3228, NULL, 1, 2210)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-FRUCTAN', NULL, N'G-FRUCTAN', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-IC-PANEL', NULL, N'Ion Chromatography Panel [Cl, SO4]', N'Water', N'DISCOUNTED TEST GROUPS', 7700, NULL, 1, 7050)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-LIGAF', NULL, N'Lignin', N'Plant', N'FEED TESTS', 5048, NULL, 1, 5620)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'GLUC', NULL, N'Glucose', N'Plant', N'CARBOHYDRATES', 5735, NULL, 1, 5720)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'GLUCL', NULL, N'GLUCL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-M-CARB', NULL, N'G-M-CARB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-METALS-S', NULL, N'G-METALS-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-MICRE', NULL, N'Extractable (DTPA) Micronutrient Group [DTPA: Zn, Mn, Fe, Cu]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3280, NULL, 1, 2225)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-MICRS', NULL, N'Soluble Micronutrients [Zn, Mn, Fe, Cu]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS', 7140, NULL, 1, 7402)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-MICRT', NULL, N'Acid Digestible Micronutrient Group (Zn, Mn, Fe, Cu)', N'Soil', N'ACID DIGESTIBLE TESTS - DISCOUNTED TEST GROUP', 3500, NULL, 1, 2900)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NA-E', NULL, N'Nitrate & Ammonium [NO3-N, NH4-N]', N'Water', N'DISCOUNTED TEST GROUPS', 7050, NULL, 1, 7060)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NA-EXT', NULL, N'Nitrate-N & Ammonium-N Group - Client Provided Extract', N'Soil', N'CLIENT-PROVIDED EXTRACTS', 4810, NULL, 1, 3500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NAF-S', NULL, N'Nitrate & Ammonium Group [NO3-N, NH4-N]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3220, NULL, 1, 2215)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NA-P', NULL, N'Nitrate & Ammonium [NO3-N, NH4-N]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5400, NULL, 1, 5080)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NC-P', NULL, N'Total Nitrogen & Carbon [N, C]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5100, NULL, 1, 5070)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NC-P-CW', NULL, N'G-NC-P-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NC-S', NULL, N'Total Nitrogen & Carbon [N, C]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3202, NULL, 1, 2200)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NC-S-CW', NULL, N'G-NC-S-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NDFAF', NULL, N'Neutral Detergent Fiber (ash free)', N'Plant', N'FEED TESTS', 5058, NULL, 1, 5640)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NUTRA', NULL, N'G-NUTRA', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NUTRA2', NULL, N'Nutrient Panel A [N, P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5120, NULL, 1, 5010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NUTRB', NULL, N'Nutrient Panel B [S, B, Ca, Mg]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5125, NULL, 1, 5020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NUTRC', NULL, N'Nutrient Panel C [Zn, Mn, Fe, Cu] ', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5130, NULL, 1, 5030)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-NUTRF', NULL, N'G-NUTRF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-PLANT-D2', NULL, N'Nutrient Panel D [Panels A, B & C tests] Bulk Discounted', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5136, NULL, 0, 5041)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-PLANT-D3', NULL, N'Nutrient Panel D [Panels A, B & C tests]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5135, NULL, 1, 5040)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-PLANT-E', NULL, N'Nutrient Panel E [NO3-N, PO4-P, K, Panels B & C tests] ', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5140, NULL, 1, 5050)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-PROT', NULL, N'Crude Protein', N'Plant', N'FEED TESTS', 5040, NULL, 1, 5570)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-PSA', NULL, N'Particle Size (Sand/Silt/Clay)', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4500, NULL, 1, 2800)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'GRIND', NULL, N'Grind', N'Soil|Plant', N'SAMPLE PREPARATION', 2004, NULL, 1, 1020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'GRNDONLY', NULL, N'GRNDONLY', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-SALIN', NULL, N'Soil Salinity Group 1 (SP, pH, EC, Ca, Mg, Na, Cl, B, HCO3, CO3)', N'Soil', N'SALINITY/SATURATED PASTE TESTS - DISCOUNTED GROUPS', 2005, NULL, 1, 2500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-SALIN-2', NULL, N'Soil Salinity Group 2 (SP, pH, EC, Ca, Mg, Na, Cl, B)', N'Soil', N'SALINITY/SATURATED PASTE TESTS - DISCOUNTED GROUPS', 2020, NULL, 1, 2505)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-SLSLT', NULL, N'Soluble Salts [K, Ca, Mg, Na]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS', 7030, NULL, 1, 7400)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-SLSLTX', NULL, N'G-SLSLTX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-SOL-HM', NULL, N'Soluble Heavy Metals [Cd, Cr, Pb, Ni]', N'Water', N'SOLUBLE MINERALS -DISCOUNTED TEST GROUPS ', 7160, NULL, 1, 7404)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-STARCH', NULL, N'Starch (includes Glucose and Total Glucose)', N'Plant', N'CARBOHYDRATES', 5710, NULL, 1, 5710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-TCARB', NULL, N'Carbohydrate Panel [TNC, Starch, Fructose, Glucose, Sucrose, Total Glucose]', N'Plant', N'CARBOHYDRATES - DISCOUNTED PANELS', 5706, NULL, 1, 5706)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-TCARBL', NULL, N'G-TCARBL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-TNC', NULL, N'Total Non-Structural Carbohydrates (includes Frucose, Sucrose and Total Glucose)', N'Plant', N'CARBOHYDRATES', 5720, NULL, 1, 5720)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-VITC', NULL, N'G-VITC', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-VITFAT', NULL, N'G-VITFAT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-WSUIT', NULL, N'Water Suitability Group 1 [pH, EC, SAR, Ca, Mg, Na, Cl, B, HCO3, CO3]', N'Water', N'DISCOUNTED TEST GROUPS', 7010, NULL, 1, 7010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-WSUIT-2', NULL, N'Water Suitability Group 2 [pH, EC, SAR, Ca, Mg, Na, Cl, B]', N'Water', N'DISCOUNTED TEST GROUPS', 7020, NULL, 1, 7020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-XCAT', NULL, N'Exchangeable Cation Group [X-K, X-Na, X-Ca, X-Mg]', N'Soil', N'FERTILITY TESTS - DISCOUNTED GROUPS', 3270, NULL, 1, 2220)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-XK-X', NULL, N'Exchangeable Potassium (X-K)', N'Soil', N'FERTILITY TESTS', 3276, NULL, 1, 2305)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-X-NA', NULL, N'G-X-NA', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-XNPK', NULL, N'Extractable N-P-K Group 1 [NO3-N, NH4-N, PO4-P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5410, NULL, 1, 5090)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-XNPKF', NULL, N'G-XNPKF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'G-XNPKF-2', NULL, N'Extractable N-P-K Group 2 [NO3-N, PO4-P, K]', N'Plant', N'DISCOUNTED NUTRIENT PANELS', 5420, NULL, 1, 5100)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'HARD', NULL, N'Hardness *', N'Water', N'INDIVIDUAL TESTS', 7074, N'Requires selection of Ca, Mg ', 1, 7310)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'HCO3-S', NULL, N'Bicarbonate (HCO3) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2360, NULL, 1, 2510)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'HCO3-W', NULL, N'Bicarbonate (HCO3)', N'Water', N'INDIVIDUAL TESTS', 7082, NULL, 1, 7230)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'HEMICELL', NULL, N'Hemicellulose', N'Plant', N'FEED TESTS', 5060, NULL, 1, 5610)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'HOLD', NULL, N'HOLD', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'INOS', NULL, N'INOS', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'K-SOLS', NULL, N'Potassium (K) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2356, NULL, 1, 2555)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'K-SOLW', NULL, N'Potassium (K)', N'Water', N'SOLUBLE MINERALS', 7120, NULL, 1, 7470)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'K-TMW', NULL, N'Potassium (K)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5215, NULL, 1, 5400)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'K-TOT', NULL, N'Potassium (K)', N'Plant', N'EXTRACTABLES', 5460, NULL, 1, 5477)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'K-WT', NULL, N'Potassium (K)', N'Water', N'ACID DIGESTIBLE MINERALS', 7202, NULL, 1, 7740)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'LACTOSE', NULL, N'LACTOSE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'LI', NULL, N'LI', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'LIG-AF', NULL, N'LIG-AF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'LIR', NULL, N'LIR', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'M', NULL, N'Microwave sample prep', N'Soil|Plant', N'SAMPLE PREPARATION', 1501, NULL, 0, 1501)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MALTOSE', NULL, N'MALTOSE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MATRIX', NULL, N'MATRIX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MELEZITO', NULL, N'MELEZITO', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MELIBIOS', NULL, N'MELIBIOS', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'METH', NULL, N'METH', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-PMF', NULL, N'Magnesium (Mg)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5235, NULL, 1, 5330)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-S', NULL, N'Magnesium (Mg) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2351, NULL, 1, 2545)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-TOX', NULL, N'MG-TOX', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-W', NULL, N'Magnesium (Mg)', N'Water', N'SOLUBLE MINERALS', 7134, NULL, 1, 7450)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-WT', NULL, N'Magnesium (Mg)', N'Water', N'ACID DIGESTIBLE MINERALS', 7206, NULL, 1, 7690)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MG-WX', NULL, N'Mg in mg/L', N'Water', N'SOLUBLE MINERALS:', 29200, NULL, 0, 29200)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MICRO', NULL, N'Acid Digestion (for analysis by ICP-MS)', N'Plant', N'OTHER SERVICES', 6010, NULL, 1, 6020)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN_TOT', NULL, N'Manganese (Mn)', N'Soil', N'ACID DIGESTIBLES', 3515, NULL, 1, 2925)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-PM', NULL, N'Manganese (Mn)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5250, NULL, 1, 5340)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-PT', NULL, N'Manganese (Mn)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5251, NULL, 0, 5341)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-S', NULL, N'Manganese (Mn) - DTPA Extraction', N'Soil', N'FERTILITY TESTS', 3286, NULL, 1, 2350)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-W', NULL, N'Manganese (Mn)', N'Water', N'SOLUBLE MINERALS', 7144, NULL, 1, 7460)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-WPPB', NULL, N'MN-WPPB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MN-WT', NULL, N'Manganese (Mn)', N'Water', N'ACID DIGESTIBLE MINERALS', 7304, NULL, 1, 7700)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO', NULL, N'Molybdenum (Mo)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5290, NULL, 1, 5350)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MOISTURE', NULL, N'MOISTURE`', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO-S', NULL, N'MO-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO-SP', NULL, N'MO-SP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO-ST', NULL, N'MO-ST', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO-W', NULL, N'MO-W', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'MO-WT', NULL, N'Molybdenum (Mo)', N'Water', N'ACID DIGESTIBLE MINERALS', 7450, NULL, 1, 7710)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NA-PMF', NULL, N'Sodium (Na)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5240, NULL, 1, 5430)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NA-S', NULL, N'Sodium (Na) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2352, NULL, 1, 2565)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NA-W', NULL, N'Sodium (Na)', N'Water', N'SOLUBLE MINERALS', 7136, NULL, 1, 7485)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NA-WT', NULL, N'Sodium (Na)', N'Water', N'ACID DIGESTIBLE MINERALS', 7208, NULL, 1, 7760)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NA-WX', NULL, N'Na in mg/L', N'Water', N'SOLUBLE MINERALS:', 29300, NULL, 0, 29300)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'N-CE-S', NULL, N'Nitrogen - Total (N)', N'Soil', N'FERTILITY TESTS', 3206, NULL, 1, 2240)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NCF', NULL, N'NCF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NDFAF', NULL, N'NDFAF', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NDFRF', NULL, N'Neutral Detergent Fiber (NDF)', N'Plant', N'FEED TESTS', 5056, NULL, 1, 5630)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NH4F-S', NULL, N'Ammonium-Nitrogen (NH4-N)', N'Soil', N'FERTILITY TESTS', 3235, NULL, 1, 2250)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NH4-P', NULL, N'Ammonium-Nitrogen (NH4-N)', N'Plant', N'EXTRACTABLES', 5455, NULL, 1, 5470)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NH4S-WET', NULL, N'Ammonium-Nitrogen (NH4-N) - Extracted from undried soil', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4920, NULL, 1, 2490)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NH4-W', NULL, N'Ammonium-Nitrogen (NH4-N)', N'Water', N'INDIVIDUAL TESTS', 7058, NULL, 1, 7220)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NH4-X', NULL, N'Ammonium Nitrogen (NH4-N) - Client Provided Extract', N'Soil', N'CLIENT-PROVIDED EXTRACTS', 4830, NULL, 1, 3520)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI', NULL, N'Nickel (Ni)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5294, NULL, 1, 5360)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI_TOT', NULL, N'NI_TOT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NICOTINE', NULL, N'NICOTINE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI-S', NULL, N'NI-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI-W', NULL, N'Nickel (Ni)', N'Water', N'SOLUBLE MINERALS', 7168, NULL, 1, 7465)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI-WPPB', NULL, N'NI-WPPB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI-WT', NULL, N'Nickel (Ni)', N'Water', N'ACID DIGESTIBLE MINERALS', 7408, NULL, 1, 7720)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NI-WTPPB', NULL, N'NI-WTPPB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO2-W', NULL, N'NO2-W', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3D-P', NULL, N'NO3D-P', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3-P', NULL, N'Nitrate-Nitrogen (NO3-N)', N'Plant', N'EXTRACTABLES', 5450, NULL, 1, 5474)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3-S', NULL, N'Nitrate-Nitrogen (NO3-N)', N'Soil', N'FERTILITY TESTS', 3230, NULL, 1, 2255)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3-SP', NULL, N'Nitrate-Nitrogen (NO3-N) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2358, NULL, 1, 2548)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3S-WET', NULL, N'Nitrate-Nitrogen (NO3-N) Extracted from undried soil', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4910, NULL, 1, 2480)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3-W', NULL, N'Nitrate-Nitrogen (NO3-N)', N'Water', N'INDIVIDUAL TESTS', 7056, NULL, 1, 7320)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'NO3-X', NULL, N'Nitrate Nitrogen (NO3-N) - Client Provided Extract', N'Soil', N'CLIENT-PROVIDED EXTRACTS', 4820, NULL, 1, 3510)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'N-P', NULL, N'Nitrogen', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5030, NULL, 1, 5370)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'N-P-CW', NULL, N'N-P-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'N-S-CW', NULL, N'N-S-CW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'OM', NULL, N'Organic Matter - Walkley-Black Method *', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4600, N'Alternate Method', 1, 2722)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'OM-LOI', NULL, N'Organic Matter - Loss-On-Ignition (OM (LOI)', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4120, NULL, 1, 2720)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P', NULL, N'P', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PASTE', NULL, N'PASTE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PB', NULL, N'Lead (Pb)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5285, NULL, 1, 5320)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PB_TOT', NULL, N'PB_TOT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PB-S', NULL, N'PB-S', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PB-W', NULL, N'Lead (Pb)', N'Water', N'SOLUBLE MINERALS', 7166, NULL, 1, 7445)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PB-WT', NULL, N'Lead (Pb)', N'Water', N'ACID DIGESTIBLE MINERALS', 7406, NULL, 1, 7680)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PHENOLS', NULL, N'Total Phenols *', N'Plant', N'FEED TESTS', 5650, N'Please contact the lab before submitting samlples', 1, 5660)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PH-M', NULL, N'pH (water 1:5)', N'Plant', N'COMPOST/MANURE TESTS', 5920, NULL, 1, 5920)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PH-S', NULL, N'pH', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2050, NULL, 1, 2550)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PH-W', NULL, N'pH', N'Water', N'INDIVIDUAL TESTS', 7031, NULL, 1, 7330)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PO4-P', NULL, N'Phosphate-Phosphorus (PO4-P)', N'Plant', N'EXTRACTABLES', 5470, NULL, 1, 5476)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-OS', NULL, N'Phosphate  - Olsen Extraction (Olsen-P) - neutral/alkaline soil', N'Soil', N'FERTILITY TESTS', 3250, N'Use on soils with a pH over pH 6.5. Use Bray-P for soils under pH 6.5', 1, 2270)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-PPM', NULL, N'P-PPM', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PRESERVE', NULL, N'PRESERVE', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PROC', NULL, N'Processing Fee', N'Soil|Plant', N'Special', 1000, NULL, 0, 1000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'PROT', NULL, N'PROT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-ST', NULL, N'Phosphorus (P)', N'Soil', N'ACID DIGESTIBLES', 3505, NULL, 1, 2925)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-TOT', NULL, N'Phosphorus (P)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5210, NULL, 1, 5390)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-W', NULL, N'Phosphate-Phosphorus (PO4-P, soluble P) by Flow Injection Analyzer', N'Water', N'INDIVIDUAL TESTS', 7086, NULL, 1, 7340)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-W-ICP', NULL, N'Phosporus (soluble P) by ICP *', N'Water', N'INDIVIDUAL TESTS', 7802, N'Alternate method', 1, 7342)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'P-WT', NULL, N'Phosphorus (P)', N'Water', N'ACID DIGESTIBLE MINERALS', 7196, NULL, 1, 7730)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'RAFFINOS', NULL, N'RAFFINOS', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'RB', NULL, N'RB', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'RIBOFLAVIN', NULL, N'RIBOFLAVIN', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SAMPPREP', NULL, N'SAMPPREP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SAND', NULL, N'SAND', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SANDVF', NULL, N'Very Fine Sand', N'Soil', N'PHYSIO-CHEMICAL TESTS', 4510, NULL, 1, 2810)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SAR-S', NULL, N'Sodium Adsorption Ration (SAR) *', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2400, N'Requires selection of Ca, Mg and Na ', 1, 2567)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SAR-W', NULL, N'Sodium Adsorption Ratio (SAR) *', N'Water', N'INDIVIDUAL TESTS', 7070, N'Requires selection of Ca, Mg, Na', 1, 7350)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SE', NULL, N'Selenium (Se)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5310, NULL, 1, 5410)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SE-SP', NULL, N'SE-SP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SE-ST', NULL, N'Selenium (Se)', N'Soil', N'ACID DIGESTIBLES', 3600, NULL, 1, 2930)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SETUP', NULL, N'SETUP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SE-W', NULL, N'Selenium (Se)', N'Water', N'ACID DIGESTIBLE MINERALS', 7602, NULL, 1, 7750)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-%', NULL, N'Silicon (Si)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5350, NULL, 1, 5420)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-BT', NULL, N'SI-BT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-CIT', NULL, N'SI-CIT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SILT', NULL, N'SILT', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-OX', NULL, N'Silicon (Si)- Oxalate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4730, NULL, 1, 2430)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-PY', NULL, N'Silicon (Si) - Pyrophosphate Extraction', N'Soil', N'FERTILITY TESTS - ALTERNATE METHODS', 4770, NULL, 1, 2460)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SI-W', NULL, N'Silicon (Si)', N'Water', N'SOLUBLE MINERALS', 7152, NULL, 1, 7480)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SO4-PM', NULL, N'Sulfate-Sulfur (SO4-S)', N'Plant', N'EXTRACTABLES', 3260, NULL, 1, 5478)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SO4-S', NULL, N'Sulfate-Sulfur (SO4-S) - calcium phosphate extract', N'Soil', N'FERTILITY TESTS', 3260, NULL, 1, 2280)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SO4-SP', NULL, N'Sulfate-Sulfur (SO4-S) - Saturated Paste Extract', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2365, NULL, 1, 2570)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SO4-W', NULL, N'Sulfate-Sulfur (SO4-S, soluble S) *', N'Water', N'INDIVIDUAL TESTS', 7122, N'This test uses the assumption that all the sulfur present is in the sulfate form. To measure the sulfate ion, select the method Sulfate by Ion Chromatography ', 1, 7354)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SO4-W-IC', NULL, N'Sulfate by Ion Chromatography (SO4)*', N'Water', N'INDIVIDUAL TESTS', 7702, N'Alternate method', 1, 7356)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SORB', NULL, N'Sorbitol', N'Plant', N'CARBOHYDRATES', 5745, NULL, 1, 5730)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP', NULL, N'Saturation Percentage (SP)', N'Soil', N'SALINITY/SATURATED PASTE TESTS', 2040, NULL, 1, 2560)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-FOR', NULL, N'Foreign Soil Processing - Required for foreign soils', N'Soil', N'SAMPLE PREPARATION', 2002, NULL, 1, 1010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-GEN', NULL, N'SP-GEN', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SPPROC', NULL, N'SPPROC', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVPROC', NULL, N'SP-REVPROC', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSETUP', NULL, N'SP-REVSETUP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF01', NULL, N'SP-REVSF01', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF02', NULL, N'SP-REVSF02', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF03', NULL, N'SP-REVSF03', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF04', NULL, N'SP-REVSF04', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF05', NULL, N'SP-REVSF05', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF06', NULL, N'SP-REVSF06', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF07', NULL, N'SP-REVSF07', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF08', NULL, N'SP-REVSF08', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF09', NULL, N'SP-REVSF09', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF10', NULL, N'SP-REVSF10', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF11', NULL, N'SP-REVSF11', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-REVSF12', NULL, N'SP-REVSF12', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-SETUP', NULL, N'SP-SETUP', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SP-WW', NULL, N'SP-WW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SR', NULL, N'SR', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'STARCH', NULL, N'STARCH', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'S-TOT', NULL, N'Sulfur (S)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5220, NULL, 1, 5450)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SUCR', NULL, N'Sucrose', N'Plant', N'CARBOHYDRATES', 5740, NULL, 1, 5740)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'SUCRL', NULL, N'SUCRL', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'S-WT', NULL, N'Sulfur (S)', N'Water', N'ACID DIGESTIBLE MINERALS', 7198, NULL, 1, 7770)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TA', NULL, N'TA', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TANNINS', NULL, N'Tannins *', N'Plant', N'FEED TESTS', 5630, N'Please contact the lab before submitting samples', 1, 5650)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TC-W', NULL, N'Carbon -Total (C)', N'Water', N'INDIVIDUAL TESTS', 7040, NULL, 1, 7250)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TDNRF', NULL, N'Total Digestible Nutrients (TDN) *', N'Plant', N'FEED TESTS', 5640, N'Requires selection of ADF', 1, 5655)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TDS', NULL, N'Total Dissolved Solids (TDS)', N'Water', N'INDIVIDUAL TESTS', 7088, NULL, 1, 7360)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TEST', NULL, N'TEST', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TFRUC', NULL, N'TFRUC', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TGLUC', NULL, N'Total Glucose', N'Plant', N'CARBOHYDRATES', 5750, NULL, 1, 5750)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'THAW', NULL, N'THAW', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TI', NULL, N'TI', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TKN-P', NULL, N'Nitrogen (Total Kjeldahl Nitrogen) *', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5035, N'Alternate method', 1, 5380)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TKN-S', NULL, N'Nitrogen (Total Kjeldahl Nitrogen) *', N'Soil', N'FERTILITY TESTS', 3210, N'Alternate method', 1, 2245)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TKN-W', NULL, N'Nitrogen (Total Kjeldahl Nitrogen) *', N'Water', N'INDIVIDUAL TESTS', 7060, N'Recommended for samples with high solids content', 1, 7324)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TNC', NULL, N'TNC', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TN-W', NULL, N'Nitrogen - Total (N) *', N'Water', N'INDIVIDUAL TESTS', 7046, N'Recommended for samples with low solids content', 1, 7322)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TOCOPH', NULL, N'α-Tocopherol *', N'Plant', N'VITAMINS', 5620, NULL, 1, 5690)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TOC-S', NULL, N'Carbon - Total Organic Carbon (TOC)', N'Soil', N'FERTILITY TESTS', 3200, NULL, 1, 2234)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TOC-W', NULL, N'Carbon - Total Organic Carbon (TOC)', N'Water', N'INDIVIDUAL TESTS', 7042, NULL, 1, 7260)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TS', NULL, N'Total Solids (TS)', N'Water', N'INDIVIDUAL TESTS', 7090, NULL, 1, 7370)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TSS', NULL, N'Total Suspended Solids (TSS)', N'Water', N'INDIVIDUAL TESTS', 7092, NULL, 1, 7380)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TSUCR', NULL, N'TSUCR', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'TURBID', NULL, N'Turbidity', N'Water', N'INDIVIDUAL TESTS', 7098, NULL, 1, 7385)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'V', NULL, N'Vanadium (V)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5298, NULL, 1, 5455)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'VIT-E', NULL, N'VIT-E', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'VSS', NULL, N'Volatile Suspended Solids (VSS) *', N'Water', N'INDIVIDUAL TESTS', 7094, N'Requires selection of TSS', 1, 7390)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'V-W	 ', NULL, N'V', N'Water', N'SOLUBLE MINERALS:', 28500, NULL, 1, 28500)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'WEIGHTS', NULL, N'WEIGHTS', N'Soil|Plant|Water', N'NA', 10000, NULL, 0, 10000)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'WRAP', NULL, N'Sample Encapsulation (for N &/or C isotope testing)', N'Soil|Plant', N'OTHER SERVICES', 6020, NULL, 1, 6010)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'X-CA', NULL, N'Exchangeable Calcium (X-Ca)', N'Soil', N'FERTILITY TESTS', 3272, NULL, 1, 2300)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'XK', NULL, N'XK', N'Soil', N'Special', 5400, NULL, 0, 5400)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'XK-X', NULL, N'XK-X', N'Soil', N'Special', 5200, NULL, 0, 5200)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'X-MG', NULL, N'Exchangeable Magnesium (X-Mg )', N'Soil', N'FERTILITY TESTS', 3274, NULL, 1, 2310)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'X-NA', NULL, N'Exchangeable Sodium (X-Na)', N'Soil', N'FERTILITY TESTS', 3278, NULL, 1, 2315)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN_TOT', NULL, N'Zinc (ZN)', N'Soil', N'ACID DIGESTIBLES', 3510, NULL, 1, 2935)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN-PM', NULL, N'Zinc (Zn)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5245, NULL, 1, 5460)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN-PT', NULL, N'Zinc (Zn)', N'Plant', N'TOTALS AND ACID DIGESTIBLES', 5246, NULL, 0, 5461)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN-S', NULL, N'Zinc (Zn) - DTPA Extraction', N'Soil', N'FERTILITY TESTS', 3288, NULL, 1, 2360)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN-W', NULL, N'Zinc (Zn)', N'Water', N'SOLUBLE MINERALS', 7142, NULL, 1, 7510)
  INSERT [dbo].[TestItems] ([Id], [AdditionalInfoPrompt], [Analysis], [Category], [Group], [LabOrder], [Notes], [Public], [RequestOrder]) VALUES (N'ZN-WT', NULL, N'Zinc (Zn)', N'Water', N'ACID DIGESTIBLE MINERALS', 7302, NULL, 1, 7780)
  