MAG Sum and TEQ Sum 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 >

MAG Sum and TEQ Sum in DT_ACTION_LEVEL_LOOKUP

EQuIS supports sample-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 the help article Setup - DT_ACTION_LEVEL_LOOKUP. Refer to the articles below for additional information on lookups, formulas, and locations.

 

Advanced Action Levels - Using Lookups in DT_ACTION_LEVEL_LOOKUP

Advanced Action Levels - Using Formulas in DT_ACTION_LEVEL_LOOKUP

Advanced Action Levels - Using Locations in DT_ACTION_LEVEL_LOOKUP

 

Creation of Sample-Specific Action Level using MAG_SUM / TEQ_SUM Methods

 

There are two summing LOOKUP_METHODs.

 

1.MAG_SUM: For each sample in the analytical results, adds a row to the Action Level Exceedance Report output with AL_REPORT_RESULT_VALUE = the sum of the results of the members of a Method Analyte Group (MAG) and compares that sum to the action level value entered into DT_ACTION_LEVEL_PARAMETER for that MAG Code.

2.TEQ_SUM: For each sample in the analytical results, while performing the MAG Sum, each member result is multiplied by a Toxic Equivalency Factor (TEF) before adding the result to the sum, which is then labeled the Toxic Equivalency Quotient (TEQ) Sum. The TEQ Sum for each sample is then compared to the action level value stored in DT_ACTION_LEVEL_PARAMETER for that MAG Code.

 

MAG_SUM

 

DT_ACTION_LEVEL_LOOKUP

 

15391-aal_mag_sum_zoom72

 

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

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 and the METHOD_ANALYTE_GROUP_CODE column of RT_MTH_ANL_GROUP.
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 MAG_SUM.

COMPARISON_ID (20 char): This column is not used in the MAG_SUM, but it cannot be NULL.

COMPARISON_OPERATOR (10 char): This must be ND_X for the Non-Detect Multiplier to be activated.

COMPARISON_VALUE (19 char): The value to multiply, times the Non-Detect analytical result detection limits, before adding to the MAG_SUM.

COMPARISON_UNIT (15 char): The ND_X does not have units.

REMARK (2000 char): A remark that will be placed in ACTION_LEVEL_NOTE (only the first 255 characters will fit in ACTION_LEVEL_NOTE).

 

DT_ACTION_LEVEL_PARAMETER

 

15391-alp_zoom87

 

TEQ_SUM

 

DT_ACTION_LEVEL_LOOKUP

 

15391-aal_zoom75

 

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

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 and the METHOD_ANALYTE_GROUP_CODE column of RT_MTH_ANL_GROUP.
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 TEQ_SUM.

COMPARISON_ID (20 char): The CAS_RN of the analyte to multiply by the TEF.

COMPARISON_OPERATOR (10 char): TEF

COMPARISON_VALUE (19 char): The TEF value to multiply by the COMPARISON_IDs analytical result value, before adding to the TEQ_SUM.

COMPARISON_UNIT (15 char): The TEF does not have units.

REMARK (2000 char): A remark that will be placed in ACTION_LEVEL_NOTE (only the first 255 characters will fit in ACTION_LEVEL_NOTE).

 

DT_ACTION_LEVEL_PARAMETER

 

#ACTION_LEVEL_CODE

PARAM_CODE

UNIT

ACTION_LEVEL

LOOKKUP_SOURCE

LOOKUP_CODE

LOOKUP_METHOD

new TEQ sum

79-01-6



TEST

TEST

TEQ_SUM

new TEQ sum

156-59-2



TEST

TEST

TEQ_SUM

new TEQ sum

75-01-4



TEST

TEST

TEQ_SUM

new TEQ sum

_PERC DAUGHTERS

mg/L

0.099

TEST

TEST

TEQ_SUM