Column Name

Definition

Example

ChemCode

ESdat ChemCode

7440-66-6

ChemName

ChemName as used in the Environmental Standard

zinc

MatrixType

Matrix Type as used in the Environmental Standard, must have a matching Matrix Type in ESdat

water

ActionLevelSource

Name of the Environmental Standard

Site Specific Standard A

ActionLevel

The maximum trigger level

2000

ActionLevel_Min

The minimum trigger level

Units

The unites of the Action Level

µg/L

Leached

Whether the Action Level applies to leached soil results (If true it indicates that the Action Level units are of a liquid type, ie mg/L)

Comments

Comments that apply to the standard, and will be optionally summarised in the table footer

ActionLevel_Prefix

Any prefix text that applies to the Action Level and will be displayed on output tables in front of the Action Level.

ActionLevel_Suffix

Any suffix text that applies to the Action Level and will be displayed on output tables after of the Action Level.

Conditional_Matrix_Type

This differs from the Matrix Type, in that a Matrix Type of "Water" will be applied to any results with a  Matrix Type that is of the same Matrix State (ie liquid).  The Conditional Matrix Type is used if the result should only be applied to a specific Matrix Type (ie Surface Water)

SW

Conditional_Depth_From

The Samples average depth must be greater than this value for results to be compared.

0

Conditional_Depth_To

The Samples average depth must be less than this value for results to be compared.

10

Conditional_ChemCode1

ESdat ChemCode: Used for pH or Hardness (or similar) dependant standards, which determine if the Action Level will be applied.  For example an Action Level for Zinc may apply only over a specific pH range.

pH_Field

Conditional_ChemCode1_Units

Units for above

-

Conditional_ChemCode1_Value_Min

Minimum Concentration for ChemCode1

6

Conditional_ChemCode1_Min_Value_Prefix

The prefix (> or >=) for ChemCode1 Minimum Concentration. To indicate if the minimum concentration is inclusive or exclusive.

>=

Conditional_ChemCode1_Value_Max

Maximum Concentration for ChemCode1

7

Conditional_ChemCode1_Max_Value_Prefix

The prefix (< or<=) for ChemCode1 Maximum Concentration. To indicate if the maximum concentration is inclusive or exclusive.

<

Conditional_ChemCode2

As for ChemCode 1, if two Conditional ChemCodes are needed.

Conditional_ChemCode2_Units

Conditional_ChemCode2_Value_Min

Conditional_ChemCode2_Min_Value_Prefix

Conditional_ChemCode2_Value_Max

Conditional_ChemCode2_Max_Value_Prefix

Applies_To_Total_Result

Applies to results that are indicated as Total concentrations in Chemistry_Results.Total_or_Filtered, default is True

TRUE

Applies_To_Filtered_Result

Applies to results that are indicated as Filtered concentrations in Chemistry_Results.Total_or_Filtered, default is True

TRUE