Sample Parameters (Action Level Exceedance)

<< Click to Display Table of Contents >>

Sample Parameters (Action Level Exceedance)

Report Name: Sample Parameters (Action Level Exceedance)

 

Report Type: Standard Report

 

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. It is an EarthSoft database procedure report.

 

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

 

File Name: v54.sample_parameter_exceedance_al

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Saved Sample Parameter Report


Action Level(s)


Comparison



Operator

Exceedance


Comparison



Unit

                                               

30084-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 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

Note * refers to hidden parameters.

 

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

 

Database Type: SQL

 

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

 

Databse Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following example.

 

30084-ex.output-sample_parameters_-action_evel_exceedance_zoom50

 

v54.sample_parameter_exceedance_al