Advanced Field Alerts and Stabilization Criteria

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDGE > EDGE Features >

Advanced Field Alerts and Stabilization Criteria

Advanced field alerts (also known as range checks) and stabilization criteria allow the user to select the action levels and field Method Analyte Groups (MAGs) to be used for individual locations, or groups of locations. These alerts support several new stabilization calculations and allow the combination of such criteria for a given parameter. This feature also grants new ways to determine the minimum required purge volume for the sampling of a location:

 

Calculated from equipment measurements—various options are available: pump + tubing, pump + tubing + flowcell, etc.

Use a historical minimum purge volume stored in the database.

 

The following steps will set up the EQuIS database and EDGE to use these advanced action levels:

 

1.Set up Field Method Analyte Groups (MAGs)

2.Set up Action Levels

3.Run the "EDGE Setup Advanced Field Alerts and Acton Levels" Report

4.Export files for EDGE (Reference Values File, EDGE Field EDD)

 

Note: If the UseAdvancedActionLevels enumeration is set to have 'N' at the top of the list, Action Levels can be set up using the Range Checks process.

 

Set up Field Method Analyte Groups (MAGs)

 

If not already set up, follow the instructions found in the article titled Create Groups for Field Results Tab. To use a MAG in EDGE for field measurements, the group's Type must be set to Field. Also note that the DEFAULT_UNITS must be set.

 

25019_MAGImage

 

 

Note: There are several special field parameters, with special CAS_RN values listed below, that that will trigger automatic functions in EDGE when they are added to a Field analyte group:

DTW_FIELD - will copy values recorded into the Water Levels section of the EDGE EDD

VOL_PURGE - records cumulative volume of water purged at a location

ELAPSED_TIME - counts the number of seconds between readings

FLOW_RATE - calculates the flow rate by taking the difference between consecutive VOL_PURGE values and dividing by the ELAPSED_TIME

 

Set up Action Levels

 

1.In EQuIS Professional, open the Action Levels form.

2.Add an Action Level Code.

3.In the Action Level Parameters tab, add the field parameters from the Available Parameters list that will be used in EDGE (presumably including the same parameters as in the MAG set up previously).

 

The next step will depend on which type of action level you wish to set up: Field Alerts or Stabilization Criteria (with or without Minimum Purge Volume calculations).

 

Action Levels for Field Alerts

 

Enter values in WARNING_LEVEL and WARNING_LEVEL_MIN fields that describe that maximum and minimum allowable values (respectively) for the parameter. Set the UNIT used for the parameter.

 

Note: Field Alert Actions Levels' action_level_type CANNOT contain the word "purge."

 

For example, to create a warning whenever the values entered for pH exceed 10 or are less than 4, the limits would be:

 

WARNING_LEVEL = 10

WARNING_LEVEL _MIN = 4

 

Note: You can set multiple Field Alert (range check) Action Levels for a given location. In this case, EDGE will combine overlapping Action Levels to compare each parameter to the most stringent range. For example, a location could be assigned to multiple criteria with varying acceptable pH ranges.

 

 

Action Level A

Action Level B

Combined Level in EDGE

WARNING_LEVEL (max)

11

10

10

WARNING_LEVEL_MIN (min)

5

4

5

 

Action Levels for Stabilization Criteria

 

1.In the Action Level Code Details tab, set Type to an action_level_type that contains the text "purge." If needed, add the Action Level type.

2.Enter ACTION_LEVEL, UNIT and ACTION_LEVEL_NOTE to set the type of stabilization check and the associated value.

 

25019-ActionLevelCode

 

The following table names the available options for ACTION_LEVEL_NOTE:

 

ACTION_LEVEL_NOTE

Description

+-%

Stabilized when the variation of the last three consecutive readings, as percent, fall within the set range

+-highlow

The range between the highest and the lowest values for the last three measurements cannot exceed the stated limits.

+-%highlow

The range between the highest and the lowest values for the last three measurements cannot exceed the stated percentage

drophighlow

The range between the highest and the lowest values for the last three measurements cannot exceed the stated limits. The criteria will not apply to water levels that are rising.

<

Last three consecutive readings are less than established limit

<=

Last three consecutive readings are less than or equal to established limit

<last

Final reading is less than established limit

<overall

Overall average of readings are less than the established limit. Used for flow rate.

v

Used with parameter representing the volume of water purged from the location. The parameter is stabilized when it exceeds minimum required purge volume (see Minimum Purge Value Criteria section (below).

 

Note: Two criteria may be used for a given field parameter simultaneously. This is done by adding the second criterion's value and type into ACTION_LEVEL_MIN and ACTION_LEVEL_MIN_NOTE, respectively. It does not matter which criterion is placed in which of these two sets of fields.

 

Examples of stabilization criteria:

 

Example

action_level

action_level_note

action_level_min

action_level_min_note

pH +-0.2

0.2

+-highlow

 

 

Specific conductivity +-10%

10

+-%highlow

 

 

< 0.05 ft drop (no criteria for water levels that are rising) - The range between the highest and the lowest values for the last three measurements cannot exceed the stated limits.

0.05

drophighlow

 

 

Minimum Purge Volume = 1 pump & tubing volume. Populate custom_field_5 with "Pump+Tubing".

1

v

 

 

Turbidity < 10 NTU (final reading only)

10

<last

 

 

Overall Flow Rate (average) <500 mL/min

500

<overall

 

 

Specific Conductance:  + 5% STABILIZATION CRITERIA FOR RANGE OF VARIATION OF LAST THREE CONSECUTIVE READINGS

5

+-%

 

 

Depth to water <0.33 ft . STABILIZATION CRITERIA FOR RANGE OF VARIATION OF LAST THREE CONSECUTIVE READINGS

0.33

<

 

 

Turbidity <= 20 NTU . STABILIZATION CRITERIA FOR RANGE OF VARIATION OF LAST THREE CONSECUTIVE READINGS

20

<=

 

 

Overall Flow Rate (average) >100 and < 400 mL/min

400

<overall

100

>overall

Turbidiy ± 5 NTU or ± 10%, whichever is greater and the range between the highest and the lowest values for the last three measurements cannot exceed the stated limits.

10

+-%highlow

5

+-highlow

 

Minimum Purge Volume Criteria

 

ACTION_LEVEL_NOTE="v" is used with parameters that reflect the cumulative volume purged from the location (e.g. VOLUME_PURGED). EDGE will consider this parameter stabilized when the most recent value entered has exceeded the minimum purge volume. Depending on the setting used, this volume is calculated using either:

 

1.Well and/or equipment measurements.  These can be seen in either:

the Initial Water Level/Purge sub-tab of the Field Samples data tab, or

the Volume Purge section of the FieldSampleForm

2.Historical minimum purge volume, stored in DT_LOCATION_PARAMETER

 

The value in ACTION_LEVEL represents the multiplier that is applied to the volume calculated using the method chosen. Choose the minimum purge volume calculation by entering one of the following values in CUSTOM_FIELD_5 for the Action Level parameter where ACTION_LEVEL_NOTE="v":

 

CUSTOM_FIELD_5 Value

Description

Pump+Tubing

Pump + Tubing Volume

Pump+Flowcell+Tubing

Pump + Flowcell + Tubing volume

Well (or NULL)

Well volume

Historical

The minimum volume required is defined in DT_LOCATION_PARAMETER where param_code = "MICROPURGE_VOLUME"

Well_l/f

The purge volume is calculated using: (depth of well-depth to water)*0.03 L/ft

 

Run the "EDGE Setup Advanced Field Alerts and Action Levels" Report

 

The EDGE report called EDGE Setup Advanced Field Alerts and Action Levels facilitates the configuration of the new action levels. Run the report to link location(s), MAG(s) and Action Level(s) together. Already established criteria may be added later by entering the same criteria text in the Action Level Criteria and selecting new locations, MAGs or Action Levels.

 

25019-InputParameterScreenshot

 

Input Parameters

Action Level Criteria: Enter the text (criteria) that will be used to link locations to MAGs and Action Levels. The text cannot contain the following characters: “{“ or “}”

 

Locations: Choose individual locations and/or groups of locations

 

Method Analyte Group(s): select MAGs that pertain to this criteria

 

Action Level: select Field Alert and/or Stabilization Criteria action level codes

 

Add or Remove: decides whether running the report will apply or remove the value entered in the Action Level Criteria parameter when the report is run

 

The criteria text entered in the Action Level Criteria parameter is written to the following fields when the report is run with the selections made as indicated:

 

Locations: DT_LOCATION.ALERT_PURGE_CRITERIA

MAGs: RT_MTH_ANL_GROUP.METHOD_ANALYTE_GROUP_OWNER

Action Levels: DT_ACTION_LEVEL.ACTION_LEVEL_DESC

 

Export files for EDGE (Reference Values File, EDGE Field EDD)

 

Recreate an EDGE Reference Value File (RVF) or reconnect to the database using EDGE's EQuIS Database Connection feature. It is also helpful to export an EDD using the EDGE Field EDD report. This EDD will push forward the needed information to link up sys_loc_codes in EDGE to MAGs and field alerts/stabilization criteria, as set up previously using the EDGE Setup Advanced Field Alerts and Action Levels report. The value is in Location_v1.alert_purge_criteria.

 

Location_v1 and alert_purge_criteria

Location_v1 and alert_purge_criteria

 

Use Advanced Field Alerts and Action Levels in EDGE

 

1.Open EDGE

2.Select the previously created RVF file

3.Load an EDD generated from the EDGE Field EDD report

4.On the FieldSampleForm or Field Samples tab, show the desired field results groups

5.Enter field result data. When field result values are entered that trigger the field alerts or stabilization criteria, the values will be highlighted.

 

Field Results outside the established ranges

Field Results outside the established ranges