Action Level Exceedance - Standard
Copyright © 2019 EarthSoft, Inc • Modified: 31 May 2019
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.
•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 email@example.com for a direct file link.
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
Note: * refers to hidden parameters.
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.