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