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 includes the following hidden parameter(s) that could affect the output of the report:

• facility_id

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

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

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.