Setup - DT_ACTION_LEVEL_LOOKUP
Copyright © 2018 EarthSoft, Inc • Modified: 23 Nov 2018
Name: Advanced Action Level - AAL_Lookup - 105851
Type: Advanced Action Level API
Description: The AAL_Lookup Advanced Action Level looks up and/or calculates a sample-specific action level for each sample/analyte based on the value of another analyte in that sample such as pH or hardness (the comparison analyte). The value of the comparison analyte can be compared to a LOOKUP table used in a FORMULA to calculate the sample-specific action level or it can be a Method Analyte Group (MAG). The comparison analyte can also be a SYS_LOC_CODE or Location Group to allow for location-specific action levels.
1.Open the Action Levels interface and Add a New Type, if desired.
2.Create a new Action Level Code in the type folder and Save. All, some or none of the member analytes may have their static action levels entered at this time.
3.Enter the following in the OBJECT_NAME field: EarthSoft.ActionLevels.Library.105851,EarthSoft.ActionLevels.Library._105851.AAL_Lookup. The DT_ACTION_LEVEL.OBJECT_NAME specifies the assembly and class name where additional logic for computing the action level is included.
4.To look up and/or calculate a sample-specific action level for an analyte, populate the values in the lookup fields (added in number two above) for that analyte (as shown in example below). There are five basic types of entries in DT_ACTION_LEVEL_LOOKUP, listed below with links to associated help articles.
5.Run the Action Level Exceedance II by User Report or Action Level Exceedance II with Parameters Report using the new Action Level(s).
Dependencies: None, but only called from one of the Action Level Exceedance II reports
File Name: EarthSoft.ActionLevels.Library.105851.dll
Contact email@example.com if not already in the EQuIS folder.
Input Parameters: None
Tables: DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_ACTION_LEVEL_LOOKUP
Database Type: SQL
Database Schema: Lookup Fields (lookup_source, lookup_code, and lookup_method) in DT_ACTION_LEVEL_PARAMETER required. DT_ACTION_LEVEL_LOOKUP table required.
Data Requirements: Populate the DT_ACTION_LEVEL_PARAMETER.LOOKUP_SOURCE, DT_ACTION_LEVEL_PARAMETER.LOOKUP_CODE,
DT_ACTION_LEVEL_PARAMETER.LOOKUP_METHOD, and DT_ACTION_LEVEL_LOOKUP table as necessary.
Report Requirements: Action Level Exceedance II by User Report or Action Level Exceedance II with Parameters Report
Output Type: Grid
Example Output: Contact firstname.lastname@example.org for more information.