Name: Advanced Action Level - Action Level Parameters Sum - 13270
Type: Advanced Action Level API
Description: There are two types of Advanced Action Levels that compare a Sum to an Action Level. This Action Level Parameters Sum sums the result concentrations of the analytes defined in the Action Level Parameters of the Action Level for each sample in an Action Level Exceedance Report, and compares each sample's result sum to the Sum action level parameter (as added in number three below).
This is distinct from the Analyte Group Sum Advanced Action Level, which creates a sum for a Method Analyte Group that does not necessarily include all of the action level parameters listed for that action level.
To set up the Action Level Parameters Sum Advanced Action Level, follow the steps below.
1.If not already present in the EQuIS folder, request the required file from EarthSoft Support. Extract the DLL from EarthSoft.ActionLevels.Library.13270.zip and save the DLL to the EQuIS folder.
2.Open the RT_ACTION_LEVEL_TYPE table and create a new row. Add "Advanced" as a new report type. Make sure the value in the STATUS_FLAG column is set to A.
3.Open the Action Levels form interface and create a new action level code in the Advanced Reports folder (e.g., TCEandVC). Add the desired analytes for summing by dragging and dropping from the Available Parameters list (e.g., Trichloroethane and Vinyl Chloride). All, some, or none of the member analytes may have their individual action levels entered at this time. To add an action level for the sum to an existing action level code, skip this step and apply the following steps to the existing action level code. Save.
4.Open the DT_ACTION_LEVEL_PARAMETER table. Add a new row to record the Sum and use the following values: (Sum PARAM_CODE ensures a new entry for sum is created in the output).
a.PARAM_CODE = Sum.
b.ACTION_LEVEL_CODE = The action level code created/updated per Step 3.
c.ACTION_LEVEL = Action level for the sum of analytes; this does not have to be the sum of the individual action levels, where they have been entered.
d.Unit = The desired unit.
5.Save and close the DT_ACTION_LEVEL_PARAMETER table.
6.Open DT_ACTION_LEVEL and filter to the new Sum action level.
7.In the OBJECT_NAME column, enter the following:
EarthSoft.ActionLevels.Library.13270,EarthSoft.ActionLevels.Library._13270.ActionLevelSum.
The DT_ACTION_LEVEL.OBJECT_NAME specifies the assembly and class name where additional logic for computing the sum and applying the action level on the sum is implemented.
8.Save and close the DT_ACTION_LEVEL table.
9.Run one of the Action Level Exceedance reports on the new sum action level.
Report Dependencies: None
File Name: EarthSoft.ActionLevels.Library.13270.dll
Contact EarthSoft Support if this file is not already in the EQuIS folder.
Language: English
Input Parameters: None
Tables: DT_ACTION_LEVEL; DT_ACTION_LEVEL_PARAMETER
Database Type: SQL
Database Schema: Standard
Data Requirements: Add Sum as an action level parameter to an existing action level, and specify units.
Output Type: Included in Action Level Exceedance reports