Action Level Exceedance (by EDD)

Report Name: Action Level Exceedance (by EDD) (example)

Stored Procedure: v54.action_level_exceedance_ebatch

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Excel1

Description: The Action Level Exceedance (by EDD) report is a stored procedure report used for checking exceedances within an EDD rather than using a saved pick/user report. This report is commonly used as an EQuIS Information Agent (EIA), or trigger within EQuIS Enterprise.

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created.

Overview:

Report Parameters

EDD(s)	Select one or more EDDs to check the action levels against.
Action Levels	Select one or more Action Levels. Leaving this field blank will compare all applicable action levels.
Comparison
Operator	Select an operator: <, <=, >, >=
Unit	Select a comparison unit: action_level_unit or report_result_unit.
Exceedance Flag	Character for flagging exeedances. Leaving blank will return only exceedances in the report output.
Result
Detect Flags	Select one or more options for detect flag.
Non-Detect Multipllier	Enter the desired non-detect multiplier value.
Non-Detect Symbol	Enter the desired non-detect symbol ("< ?", "ND", ...). "?" will be replaced with reporting limit multiplied by non-detect multiplier.
Reportable	Select one or more options for reportable result.
Reporting Limit	Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Comparison | Operator Parameter: There are four options for the Comparison | Operator parameter:

•"<" Within Limits (Exclusive): The analytical result is flagged as an exceedance if it is less than the action level and, if one exists, greater than the action_level_min. Equalities are not considered exceedances.

•"<=" Within Limits (Inclusive): Same as above, but equalities are considered exceedances.

• ">" Exceeds Limits (Exclusive): The analytical result is flagged as an exceedance if it is greater than the action level or, if one exists, less than the action_level_min. Equalities are not considered exceedances.

•">=" Exceeds Limits (Inclusive) (the default): Same as above, but equalities are considered exceedances.

Comparison | Unit Parameter: There are two options for the Comparison | Unit parameter:

•"report_result_unit": Values will be displayed in the units of the REPORT_RESULT column. Other columns will be converted to matching units as necessary.

•"action_level_unit": Values will be displayed in the units of the ACTION_LEVEL column. Other columns will be converted to matching units as necessary.

Exceedance Flag Parameter: If an exceedance flag is not defined (i.e. the Exceedance Flag parameter field is blank), only results which exceed the applicable action levels are reported and the default character is shown in the flag column for all records. If an exceedance flag is defined in the Exceedance Flag parameter field, all of the results are reported and exceedances are shown by entering that value in the flag column for the exceeding results.

Report Output
FLAG ACTION_LEVEL_CODE ACTION_LEVEL_NOTE ACTION_LEVEL AL_RESULT_TEXT AL_RESULT_VALUE ACTION_LEVEL_MIN ACTION_LEVEL_UNIT ACTION_LEVEL_MIN_NOTE WARNING_LEVEL WARNING_LEVEL_MIN ACTION_LEVEL_TYPE REMARK OBJECT_NAME FACILITY_ID FACILITY_CODE SYS_LOC_CODE LOC_NAME LOC_GROUP LOC_REPORT_ORDER SYS_SAMPLE_CODE SAMPLE_NAME SAMPLE_DATE SAMPLE_TYPE_CODE START_DEPTH END_DEPTH DEPTH_UNIT	MATRIX_CODE GEOLOGIC_UNIT_CODE TASK_CODE TASK_DESC FIELD_SDG PARENT_SAMPLE_CODE ANALYSIS_LOCATION LAB_SAMPLE_ID LAB_MATRIX_CODE LAB_NAME_CODE ANALYTIC_METHOD ANALYSIS_DATE COLUMN_NUMBER FRACTION TEST_TYPE PREP_METHOD LEACHATE_METHOD LEACHATE_DATE LAB_SDG PERCENT_MOISTURE DILUTION_FACTOR METHOD_ANALYTE_GROUP REPORT_ORDER TEST_ID CAS_RN CHEMICAL_NAME ORGANIC_YN	REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT REPORT_RESULT_LIMIT REPORTABLE_RESULT DETECT_FLAG INTERPRETED_QUALIFIERS VALIDATOR_QUALIFIERS LAB_QUALIFIERS QUANTITATION_LIMIT METHOD_DETECTION_LIMIT REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT APPROVAL_CODE RESULT_TEXT RESULT_NUMERIC RESULT_UNIT RESULT_TYPE_CODE X_COORD Y_COORD Z_COORD_AVG ZFROM ZTO LONGITUDE LATITUDE

Report Output

FLAG

ACTION_LEVEL_CODE

ACTION_LEVEL_NOTE

ACTION_LEVEL

AL_RESULT_TEXT

AL_RESULT_VALUE

ACTION_LEVEL_MIN

ACTION_LEVEL_UNIT

ACTION_LEVEL_MIN_NOTE

WARNING_LEVEL

WARNING_LEVEL_MIN

ACTION_LEVEL_TYPE

REMARK

OBJECT_NAME

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

GEOLOGIC_UNIT_CODE

TASK_CODE

TASK_DESC

FIELD_SDG

PARENT_SAMPLE_CODE

ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD

ANALYSIS_DATE

COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_METHOD

LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

METHOD_ANALYTE_GROUP

REPORT_ORDER

TEST_ID

CAS_RN

CHEMICAL_NAME

ORGANIC_YN

REPORT_RESULT_TEXT

REPORT_RESULT_VALUE

REPORT_RESULT_UNIT

REPORT_RESULT_LIMIT

REPORTABLE_RESULT

DETECT_FLAG

INTERPRETED_QUALIFIERS

VALIDATOR_QUALIFIERS

LAB_QUALIFIERS

QUANTITATION_LIMIT

METHOD_DETECTION_LIMIT REPORTING_DETECTION_LIMIT

DETECTION_LIMIT_UNIT

APPROVAL_CODE

RESULT_TEXT

RESULT_NUMERIC

RESULT_UNIT

RESULT_TYPE_CODE

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.