Using Locations in DT_ACTION_LEVEL_LOOKUP

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Groups and Action Levels > Advanced Action Levels > User Configured Advanced Action Levels >

Using Locations in DT_ACTION_LEVEL_LOOKUP

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.

 

Using Formulas in DT_ACTION_LEVEL_LOOKUP

Using Lookups in DT_ACTION_LEVEL_LOOKUP

MAG Sum and TEQ Sum in DT_ACTION_LEVEL_LOOKUP

 

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

2.GROUP

3.DEFAULT

 

An example EDD with all three values populated is shown below.

 

15284-ex.edd.3.values_zoom76

 

LOCATION

 

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.

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.