<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Action Levels > Action Level Exceedance II by EDD |
Report Name: Action Level Exceedance II by EDD (example)
File Name: EarthSoft.Reports.Library.51729.dll
Dependencies: N/A
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install, EQuIS Enterprise install
Language: English
Output Type: Report Grid1
Description: This version of the Action Level Exceedance II report is used for checking exceedances within an EDD (instead of within a saved report), and is commonly used as an EQuIS Information Agent (EIA), or trigger within EQuIS Enterprise. The report generates results by filtering DT_RESULT.EBATCH with the Ebatch parameter.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Overview:
In this Report, the AL_REMARK column is no longer being used in the comparison for duplicates. The AutoCrosstab_ActionLevel method now ignores that field when doing the AutoCrosstab for the ALE Report.
When using this report in crosstab, data that exceeds the WARNING_LEVEL can be highlighted in one format and/or color while data that also exceeds the ACTION_LEVEL can be highlighted in another format and/or color. Assuming the relationship where 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 these formatting results. Otherwise, the "Exceeds Action Level" color will be set first and then be over-written by the "Exceeds Warning Level" color since any value that exceeds the higher Action Level will also exceed the Warning Level.
Source Tables DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_LOCATION, DT_SAMPLE, DT_SUBFACILITY, DT_TEST, RT_GROUP, ST_REPORT, ST_USER_REPORT, DT_SAMPLE, DT_TEST, ST_EDD_BATCH, DT_FACILITY, DT_FIELD_SAMPLE, DT_LITHOLOGY, DT_LOCATION, DT_PURGE, DT_RESULT, DT_RESULT_QC, DT_SAMPLE, DT_SDG, DT_STATIC_PROPS, DT_SUBFACILITY, DT_TASK, DT_TEST, DT_WATER_LEVEL, DT_WELL, RT_ANALYTE, RT_ANALYTE_VAR, RT_ANALYTIC_METHOD, RT_FRACTION, RT_GROUP, RT_GROUP_MEMBER, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_RESULT_TYPE, RT_SAMPLE_TYPE, RT_TEST_TYPE, RT_UNIT, VW_LOCATION
Report Parameters |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Report Output |
||
---|---|---|
ACTION_LEVEL_CODE CAS_RN CHEMICAL_NAME FLAG ACTION_LEVEL ACTION_LEVEL_MIN AL_RESULT_TEXT AL_RESULT_VALUE ACTION_LEVEL_UNIT WARNING_FLAG WARNING_LEVEL WARNING_LEVEL_MIN FACILITY_ID FACILITY_CODE SYS_LOC_CODE SAMPLE_NAME SYS_SAMPLE_CODE AL_SUBFACILITY_CODE ACTION_LEVEL_TYPE AL_MATRIX AL_FRACTION AL_ANALYTICAL_METHOD AL_REMARK OBJECT_NAME ACTION_LEVEL_NOTE ACTION_LEVEL_MIN_NOTE LOC_NAME LOC_GROUP |
LOC_REPORT_ORDER 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_DATE LAB_SDG PERCENT_MOISTURE DILUTION_FACTOR METHOD_ANALYTE_GROUP REPORT ORDER |
TEST_ID, 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 ACTION_LEVEL_VALUE ACTION_LEVEL_MIN_VALUE WARNING_LEVEL_VALUE WARNING_LEVEL_MIN_VALUE
Extra fields: Any fields chosen in this parameter |
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2022 EarthSoft, Inc • Modified: 23 Jul 2022