Chemistry Lookup Table

Navigation:  Data Types > Chemistry (Water, Soil, Gas etc..) >

Chemistry Lookup Table

Previous pageReturn to chapter overviewNext page

The zRef_Chemistry_Lookup table is critical for controlling outputs of your chemistry data.  The table is accessed under the "Data Tables" datatype button.

If using a SQL Server database you will need DBO permissions to edit data (although Read-Write users can added new compounds to this particular reference table).

 

ChemCode

ChemName

ChemName Abbrev

OutputUnits (LiquidMatrix)

OutputUnits (SolidMatrix)

OutputUnits (GasMatrix)

Chem_Group

Alternative Name1,2,3,4

Volatility

Equivalent Weight

Validate OriginalChemNames

Chem_Order

100-00-5

4-Chloronitrobenzene


µg/L

mg/kg

µg/m3



SVOC


0

189

100-01-6

4-nitroaniline


µg/L

mg/kg

µg/m3

SVOC


SVOC


0

198

100-02-7

4-nitrophenol


µg/L

mg/kg

µg/m3

PAH/Phenols


SVOC


0

199

100-21-0

Terephthalic Acid


mg/L

mg/kg

mg/L



other


0

1048

1002-53-5

Dibutyltin


µg/L

mg/kg

µg/m3

Organotins


Other


0

496

100-25-4

1,4-dinitrobenzene


µg/L

mg/kg

µg/m3

SVOC


SVOC


0

49

100-41-4

Ethylbenzene

E

µg/L

mg/kg

µg/m3

BTEX


VOC


0

587

100-42-5

Styrene


µg/L

mg/kg

µg/m3

MAH


VOC


0

1017

 

In the SQL Server version of ESdat, the values in gray are not controlled in the zRef_Chemistry_Lookup table, but are controlled in the  zRef_Chemistry_Lookup_Profiles table.  Multiple Profiles can be created with different Units, Chem Order, and Chem Grouping.  The user can nominate which Profile they wish to use under Setup - Chemistry.

 

The fields for the table are as follows:

ChemCode: A unique code for each compound, usually a CAS (Chemistry Abstract Service) code.  All chemistry data imported into the database gets assigned one of these codes.

ChemName:  The output name used for chemistry data assigned this code.

ChemName_Abbrev: The output name used in map displays, if given.

Output Units (Liquid, Solid & Gas Matrix): The units in which data is output for each of the matrix states.

Chem Group:  A method of grouping compounds for outputs, used in particular for chemistry output tables.

Alternative Names (1,2,3,4): Alternative names for the compound.  Used to automatically match a ChemCode during import.

Volatility: Used for holding time periods in the Chemistry QA.

Equivalent_Weight: Used for calculating outputs in geochemical units (milli equivalents)

Validate_OriginalChemNames: If True (or 1) all the original names for chemistry data assigned this ChemCode are checked against the ChemName and the Alternative Names.  If there is no match the data is shown in the Chemistry QA report for users to ensure the correct code has been assigned.  This is usually checked if the user has reason to think a particular compound in the data may have been given a wrong code by mistake.

Chem_Order: Used to set the order in which compounds will appear in the Chemistry Output and QA tables.