Location Parameter Exceedance

Report Name: Location Parameter Exceedance (example)

Stored Procedure: v54.location_parameter_exceedance

Dependencies: Location Parameters Report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Location Parameter Exceedance report was replaced by Location Parameters (Action Level Exceedance). EarthSoft recommends using the Location Parameters (Action Level Exceedance) report rather than Location Parameter Exceedance to take advantage of additional features, fixes, and performance optimization.

Description: The report compares PARAM_VALUE of DT_LOCATION_PARAMETER with a value provided over the user interface and generates an exceedance report. It calls the Location Parameters Report.

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps necessary.

Overview:

Tables: All the tables used by the Location Parameters Report.

Report Parameters *

Measurement
Date Range	Section to select the start date and end date measurement date range.
Parameter
Code	Select the desired location parameter code.
Value	Enter the desired exceedance value.
Unit	Select a comparison unit: action_level_unit or report_result_unit
Comparison	Select an operator: <, <=, >, >=
Exceedance Flag	Character for flagging exeedances. Leaving blank will return only exceedances in the report output.

* This report may include hidden parameters that could affect the output of the report.

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report
that allows saving of user reports). These paramaters cannot be viewed or changed in unpublished reports outside of a
report parameter file.

Report Output
FLAG 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

Report Output

FLAG

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

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML or a printer.