Location Parameters (Action Level Exceedance)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Location Parameter Reports >

Location Parameters (Action Level Exceedance)

Report Name: Location Parameters (Action Level Exceedance)

 

Report Type: Standard

 

Description: This report checks PARAM_VALUE of the Location Parameters report against the action levels of the Action Levels Report and then generates an Action Level Exceedance Report. Note that significant digits of ACTION_LEVEL Location Parameters (Extra Fields) affect the results of the report. For example, if PARAM_VALUE=0.96, the ACTION_LEVEL=1 and Operator is >=, the report reports one exceedance because the 0.96 is rounded to 1.0 which (=AL_RESULT_VALE in the report) equals the ACTION_LEVEL value of 1; if ACTION_LEVEL is changed to 1.0, the report reports no exceedances because AL_RESULT_VALUE = 0.96 which is less than 1.0.

 

File Name: v54.location_parameter_exceedance_al

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Saved Location Parameter Report


Action Levels


Comparison



Operator

Exceedance Flag


Comparison



Unit







                                               

30069-input.params.scrnsht

FLAG, ACTION_LEVEL_CODE, ACTION_LEVEL_NOTE, ACTION_LEVEL, 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, MEASUREMENT_DATE, PARAM_CODE, PARAM_VALUE, PARAM_TEXT, PARAM_UNIT, MEASUREMENT_METHOD, TASK_CODE, X_COORD, Y_COORD, LONGITUDE, LATITUDE

 

Tables: All tables used by the Location Parameters Report, plus DT_ACTION_LEVEL and DT_ACTION_LEVEL_PARAMETER.

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.5.1+

 

Data Requirements: N/A

 

Report Requirements: Igrid

 

Output Type: Igrid          

 

Example Output: View the following example.

 

30069-ex.output_zoom75

 

v54.location_parameter_exceedance_al