<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Action Level Reports > 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 |
||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 |
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2023 EarthSoft, Inc • Modified: 25 Nov 2021