Action Level Exceedance

Report Name: Action Level Exceedance Report

Report Type: Standard Report

Description: The Action Level Exceedance Report compares values from a saved Analytical Results Report against one or more action levels (e.g. regulatory limits). If you do not select an action level, then the results will be compared against all applicable action levels.

Action levels may apply to the entire database or they may be specific to a certain facility or sub-facility, a limited time period, a particular analytic method, fraction or matrix (by entering data into the related fields in DT_ACTION_LEVEL). Action levels are only matched to analytical results that have matching criteria.

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: As of v5.3.3, if you do not select an exceedance flag (i.e. the Exceedance Flag parameter field is blank), then only results which exceed the applicable action levels are reported and the default character is shown in the flag column for all records. If you do enter a value in the Exceedance Flag parameter field, then all of the results are reported and exceedances are shown by entering that value in the flag column for the exceeding results.

The associated Action Level Exceedance (by EDD) Report is used for checking exceedances within an EDD (instead of within a saved report), and is commonly used as an Environmental Information Agent (EIA) or trigger, within EQuIS Enterprise.

Notes:

•Using the Action Level Exceedance II by User Report or Action Level Exceedance II with Parameters in Crosstab will now allow data that exceeds the WARNING_LEVEL to be highlighted with one format and/or color while data that also exceeds the ACTION_LEVEL is highlighted with another format and/or color. Assuming the normal relationship where the WARNING_LEVEL is less than the ACTION_LEVEL, the WARNING_LEVEL field must be placed before the ACTION_LEVEL field in the column or row header section of the Crosstab interface to get the desired results. Otherwise, the "Exceeds Action Level" color will be set first and then be overwritten by the "Exceeds Warning Level" color since any value that exceeds the higher Action Level will also exceed the Warning Level.

•The Action Level Exceedance II Reports also have several new report parameters to provide more control over Matching, Flagging and report output.

Report Dependencies: This report runs the Saved Analytical Results Report first.

File Name: Contact support@earthsoft.com for a direct file link.

Language: English

Input Parameters: A selection made to customize the output of a report.

Input Parameters

Input Parameter Screenshot

Output Columns

Saved Analytical Results Report
Action Level(s)
Comparison
	Operator
	Unit
Exceedance

30011-input.params.srnsht

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

ACTIONL_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

Note: * refers to hidden parameters.

Tables: ST_USER_REPORT

Database Type: Excel

Database Schema: Standard (no custom or add-on schemas required)

Database Version: Any EQuIS 5.5+

Data Requirements: N/A

Report Requirements: N/A

Output Type: Report Grid with options for Excel and CrossTab

Example Output: View the following example or download the attachment.

Action Level Exceedance - Standard

Action Level Exceedance - Standard