Hardness Based Exceedance

<< Click to Display Table of Contents >>

Navigation:  Professional > Action Levels > Advanced Action Levels > Hard-coded Advanced Action Levels >

Hardness Based Exceedance

Name: Advanced Action Level - Hardness Based Exceedance - 44351

 

Type: Advanced Action Level API

 

Description: The Hardness Based Exceedance Action Level calculates action levels for Copper and Lead for each sample, based on the Hardness value for the sample using the formula below.

 

Copper Action Level Value

 

15157-copper_action_level_value

 

Lead Action Level Value

 

15157-lead_action_level_value

 

The DT_ACTION_LEVEL_LOOKUP table stores values that allow Advanced Action Levels to be looked up or calculated. This hard-coded Hardness-Based Advanced Action Level can be replaced with the new LOOKUP Advanced Action Level.

 

Follow the steps below to use this report.

 

1.If not already present in the EQuIS folder, request the required file from EarthSoft Support. Extract EarthSoft.ActionLevels.Library.44351.zip and save to your EQuIS folder.

2.Open the Action Levels interface and create a new Action Level Code in the Advanced Reports folder (e.g. hardness copper and lead) and Save.

3.Create a new Action Level Code with the Hardness, Copper and/or Lead. Hardness cas_rn is assumed to be Hard. Copper and Lead should be reported in ug/l, Hardness should be reported in mg/l. Leave the ACTION_LEVEL value blank for Hardness, Copper and Lead.

4.Open DT_ACTION_LEVEL. Select the new action level record, and enter the following in the OBJECT_NAME field.
 
EarthSoft.ActionLevels.Library.44351,EarthSoft.ActionLevels.Library._44351.HardnessBasedExceedance
 
Save and close DT_ACTION_LEVEL. The DT_ACTION_LEVEL.OBJECT_NAME will specify the assembly and classname where additional logic for computing the action level is included.

5.Run the Action Level Exceedance II by User Report or the Action Level Exceedance II with Parameters Report on the new Action Level. Make sure the Analytical Results User Report has the necessary results for all the required analytes.

 

File Name: EarthSoft.ActionLevels.Library.44351.dll

 

Language: English

 

Input Parameters: None

 

Tables: DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER

 

Database Type: SQL

 

Database Schema: None

 

Data Requirements: Add Hardness as an action level parameter to the action level. Copper and/or Lead may also need to be added, depending on which analytes require the calculation based on the hardness value. Hardness should be reported in mg/l; Copper and Lead should be reported in ug/l.

 

Output Type: IGrid

 

Example Output: Contact EarthSoft Support