Using Locations in DT_ACTION_LEVEL_LOOKUP
Copyright © 2019 EarthSoft, Inc • Modified: 05 Aug 2019
EQuIS supports location-specific action levels from the DT_ACTION_LEVEL_LOOKUP table.
For information about how to set up the Action Level to use the Lookup table and how to populate the necessary rows in DT_ACTION_LEVEL_LOOKUP, read this help article. For using the other LOOKUP_METHODs, refer to the articles below.
There is only one kind of LOCATION Method, but it allows for three COMPARISON_OPERATOR values to be entered.
1.SINGLE - for individual SYS_LOC_CODEs
2.GROUP - for Location GROUP_CODEs. If a SYS_LOC_CODE is in more than one GROUP_CODE listed, then the lowest ACTION_LEVEL will be selected.
3.DEFAULT - required for Locations not covered by either of the above. If there is no default ACTION_LEVEL value, then enter the word "NULL".
An example EDD with all three values populated is shown below.
•LOOKUP_SOURCE (25 char): If this action level is from an environmental agency, the agency's name or an abbreviation of the name is appropriate for the source column.
•LOOKUP_CODE (40 char): This column is used to create different categories for each source. Combining land use and matrix would be common entries for the code column.
•LOOKUP_METHOD (255 char): The entries in this column must match the method name exactly. In this case, that would be LOCATION.
•PARAM_CODE (CAS_RN in the EDD) (20 char): This entry must equal the value in the PARAM_CODE column of DT_ACTION_LEVEL_PARAMETER.
The first four columns above are the link between DT_ACTION_LEVEL_PARAMETER and DT_ACTION_LEVEL_LOOKUP.
•COMPARISON_GROUP (integer): This column is not used in the LOCATION process.
•COMPARISON_ID (20 char): The SYS_LOC_CODE of the location or GROUP_CODE of the location group for whom the location-specific action level will be processed.
•COMPARISON_OPERATOR (10 char): This column is populated with SINGLE, GROUP or DEFAULT.
oThe SINGLE value is used when listing an action level for a single SYS_LOC_CODE. If a location is included in a SINGLE action level as well as a GROUP, the SINGLE value takes precedence.
oThe GROUP value is used when listing an action level for a Location Group.
oThe DEFAULT value is used to create a default action level if the sample's SYS_LOC_CODE does not match any of those listed.
•COMPARISON_VALUE (19 char): This column is not used in the LOCATION process.
•COMPARISON_UNIT (15 char): This column is not used in the LOCATION process.
•ACTION_LEVEL (19 char): The value to use as the location-specific action level for the PARAM_CODE analyte.
•ACTION_LEVEL_UNIT (15 char): The units for the location-specific action level.
•REMARK (2000 char): A remark that will be placed in ACTION_LEVEL_NOTE. (only first 255 characters will fit in ACTION_LEVEL_NOTE).
During the execution of the Action Level Exceedance II Report, for each PARAM_CODE sample result, the Advance Action Level processor will find the matching
SYS_LOC_CODE or GROUP_CODE in the COMPARISON_ID column and use that row's ACTION_LEVEL as the location-specific action level for the sample result.