Sample Parameters (Action Level Exceedance)

Report Name: Sample Parameters (Action Level Exceedance) (example)

Stored Procedure: v54.sample_parameter_exceedance_al

Report Dependencies: saved Sample Parameters report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

Description: The Sample Parameters (Action Level Exceedance) Report is similar to the Sample Parameters (Exceedance) Report with the exception that it uses a saved Sample Parameters Report; action levels from DT_ACTION_LEVEL and DT_ACTION_LEVEL_PARAMETER, rather than a user-entered action level value over the user interface; and more output fields.

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 report parameter is empty, only records with exceedances are listed, while all records are listed if EXCEEDANCE_FLAG is entered.

Tables: All tables used by the Sample Parameters Report in addition to DT_ACTION_LEVEL... tables and ST_USER_REPORT

Report Parameters

Saved Sample Parameters Report	Select a saved Sample Parameters user report.
Action Level(s)	Select one or more action levels.
Comparison
Operator	Select an operator: <, <=, >, >=
Unit	Select a comparison unit: action_level_unit or param_unit.
Exceedance Flag	Character for flagging exeedances. Leaving blank will return only exceedances in the report output.

* This report contains hidden parameter: facility_id

Report Output
FLAG ACTION_LEVEL_CODE ACTION_LEVEL_NOTE ACTION_LEVEL AL_RESULT_VALUE ACTION_LEVEL_MIN ACTION_LEVEL_UNIT ACTION_LEVEL_MIN_NOTE 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 SYS_SAMPLE_CODE SAMPLE_NAME START_DEPTH END_DEPTH DEPTH_UNIT

Report Output

FLAG

ACTION_LEVEL_CODE ACTION_LEVEL_NOTE

ACTION_LEVEL

AL_RESULT_VALUE

ACTION_LEVEL_MIN ACTION_LEVEL_UNIT ACTION_LEVEL_MIN_NOTE 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

SYS_SAMPLE_CODE

SAMPLE_NAME

START_DEPTH

END_DEPTH

DEPTH_UNIT

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