Sample Parameters (Exceedance)

Report Name: Sample Parameters (Exceedance) (example)

Stored Procedure: v54.sample_parameter_exceedance

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: The Sample Parameters (Exceedance) Report examines PARAM_VALUES of DT_SAMPLE_PARAMETER a user-entered action level value over the user interface and generates a report with exceedances. It is an EarthSoft database function 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:

Note: If the EXCEEDANCE_FLAG is empty, only records with exceedances are listed while all records are listed if EXCEEDANCE_FLAG is entered.

Source Tables DT_FACILITY, DT_LOCATION, DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, VW_LOCATION

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.

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 SYS_SAMPLE_CODE SAMPLE_NAME

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

SYS_SAMPLE_CODE

SAMPLE_NAME

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