EQuIS Reference Tables

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > EQuIS Database > EQuIS Tables >

EQuIS Reference Tables

RT_ANALYTE

 

Field Name

Obligatory to Populate

Notes

CAS_RN

Yes

 

ANL_SHORT_NAME

No

Used in data table plots and pie charts when ‘Use Short Name’ option is selected. If not populated, then the CHEMICAL_NAME is returned and used in place of the designated short name.

CHEMICAL_NAME

Yes

 

 

 

RT_ANALYTE_DETAIL

 

This table can be used for geochemistry plots such as Stiff diagrams, Piper diagrams, Durov diagrams, and Schoeller diagrams. If these plot types are not going to be generated, then it is not necessary to create records in RT_ANALYTE_DETAIL to use in EnviroInsite.

 

Field Name

Obligatory to Populate

Notes

CAS_RN

Yes

 

EQUIVALENT_WEIGHT

No

Should be populated for analytes to be selected in geochemistry plots (Stiff diagrams, Piper diagram, Schoeller diagram, and Durov chart) to convert concentrations to equivalents per liter. Typically, concentrations for these graphs would be entered in mg/L and the equivalent weights would be entered as mg/equivalent.

SPECIFIC_GRAVITY

No

Should be populated for Light Non-Aqueous Phase Liquids (LNAPLs) in case of calculated water level depth with ‘Calculate Based on Product Density’.  The LNAPL CAS number is specified in DT_WATER_LEVEL.LNAPL_CAS_RN.

 

 

RT_ANALYTIC_METHOD

 

Field Name

Obligatory to Populate

Notes

ANALYTIC_METHOD

Yes

Used to populate method selection list for filtering of test results based on the value of DT_TEST.ANALYTIC_METHOD.

 

 

RT_DOWNHOLE_POINT_PARAM_TYPE

 

Field Name

Obligatory to Populate

Notes

PARAM

Yes

Used to populate parameter selection list for strip logs and downhole charts on cross-sections.

 

 

RT_GEOLOGIC_UNIT

 

Field Name

Obligatory to Populate

Notes

GEOLOGIC_UNIT_CODE

Yes

 

GEOLOGIC_UNIT-DESC

No

The contents of this field, if populated, are used in constructed legends for 3D and cross-section stratigraphy plots. If not used, then the field contents from GEO_UNIT_CODE_# in DT_LITHOLOGY are used, where “#” may be 1 – 5.

 

 

RT_GROUP

 

Field Name

Obligatory to Populate

Notes

GROUP_CODE

Yes

Used for selection of location groups. Only read for records with GROUP_TYPE = ‘SYS_LOC_CODE’.

GROUP_TYPE

Yes

 

 

 

RT_LOCATION_TYPE

 

Field Name

Obligatory to Populate

Notes

LOCATION_TYPE_CODE

Yes

 

LOCATION_TYPE_DESC

Yes

Used to populate location type selection list from which to filter plotted results.

 

 

RT_MATERIAL

 

Field Name

Obligatory to Populate

Notes

MATERIAL_NAME

Yes

 

MATERIAL_DESC

Yes

The contents of this field, if populated, are used in legends for 3D and cross-section borehole plots. If not used, then the MATERIAL_NAME value is used.

 

 

RT_MTH_ANL_GROUP_MEMBER

 

This table stores information regarding location groups. This table and RT_MTH_ANL_GROUP can be used jointly to specify the default concentration units. Refer to Concentration Units for information on specifying the default units. Contents also used for selection of multiple analytes for data tables, radial diagrams, bar charts, and pie charts.

 

Field Name

Obligatory to Populate

Notes

METHOD_ANALYTE_GROUP_CODE

Yes

 

METHOD_ANALYTE_GROUP_DESC

Yes

 

DISPLAY_ORDER

 

Not needed if the analyte group is only being used to determine the default output units for a particular analyte / matrix / fraction value. Used and obligatory for selection of analyte groups to plot data tables, radial diagrams, or pie charts.

CAS_RN

Yes

 

MATRIX

Yes

 

TOTAL_OR_DISSOLVED

Yes

 

DEFAULT_UNITS

REPORTING_UNITS

Yes

Must populate either DEFAULT_UNITS or REPORTING_UNITS. If both are populated, then preference is given to value in DEFAULT_UNITS.

 

 

RT_SAMPLE_TYPE

 

Field Name

Obligatory to Populate

Notes

SAMPLE_TYPE_CODE

Yes

Used to populate the sample type selection list from which to filter plotted results.

 

 

RT_SOIL_GAS_PARAM_TYPE

 

Field Name

Obligatory to Populate

Notes

PARAM_CODE

Yes

Links to records in DT_SOIL_GAS_SURVEY.

PARAM_DESC

Yes

The contents of this field will be used in legends and selection lists.

 

 

RT_UNIT_CONVERSION_FACTOR

 

Field Name

Obligatory to Populate

Notes

REPORTED_UNIT

Yes

 

TARGET_UNIT

Yes

Populate for conversion from and to all concentration units and to DT_FACILITY.ELEV_UNITS.

CONVERSION_FACTOR

Yes

 

 

 

RT_WELL_SEGMENT_TYPE

 

Field Name

Obligatory to Populate

Notes

SEGMENT_TYPE

Yes

Used to populate segment type list from which to select the field value that indicates DT_WELL_SEGMENT record refers to a well screen.