<< Click to Display Table of Contents >>

Navigation:  Professional > Groups and Action Levels > Advanced Action Levels > User Configured Advanced Action Levels >


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.






Creation of Location-Specific Action Level Using LOCATION Method


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.
Example: USEPA

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.
Example: Comm_Surf_Soil

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.

ACTION_LEVEL_MIN (19 char): The value to use as the sample-specific action level minimum for the PARAM_CODE analyte.

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 Advanced 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.


Note: The Action Level Exceedance II reports will only create one row for each sampling result that matches a given action level code. For example, with a single location in multiple location groups, with different action levels assigned to each groups, a separate ACTION_LEVEL_CODE would need to be used for each location group in order for each individual action level to be applied to a sample at that location. This will cause each sample to be listed multiple times in the report output (one time for each applicable ACTION_LEVEL_CODE).


If more than one location group is included in a single location-specific advanced action level and a location is in two or more groups, the lowest ACTION_LEVEL and the highest ACTION_LEVEL_MIN will be used for that locations results.