EQuIS Reference Tables Used in EnviroInsite

<< Click to Display Table of Contents >>

Navigation:  EnviroInsite > EQuIS Database > EQuIS Tables >

EQuIS Reference Tables Used in EnviroInsite

RT_ANALYTE

RT_ANALYTE_DETAIL

RT_ANALYTIC_METHOD

RT_COORD_TYPE

RT_DOWNHOLE_POINT_PARAM_TYPE

RT_GEOLOGIC_UNIT

RT_GROUP

RT_LOCATION_TYPE

RT_MATERIAL

RT_MTH_ANL_GROUP_MEMBER

RT_SAMPLE_TYPE

RT_UNIT_CONVERSION_FACTOR

RT_WELL_SEGMENT_TYPE

 

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_COORD_TYPE

 

Field Name

Obligatory to Populate

Notes

COORD_TYPE_CODE

Yes

Used to define the coordinate type, such as Lat/Long or UTM. Supported SRID values are 4326 (for LAT LONG), 2256, 102700 (both for Montana), 32601 - 32660 (UTM for the Northern Hemisphere) and 32701 - 32760 (UTM for the Southern Hemisphere).

 

 

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 determine the list of SEGMENT_TYPE values considered to be a screen or sampling interval within DT_WELL_SEGMENT based on the contents of the SEGMENT_TYPE, MATERIAL_TYPE_CODE, and IS_SCREEN_YN = ‘Y’ or ‘y’ in the associated record in the RT_WELL_SEGMENT table.

IS_SCREEN_YN

No

Used to determine the default list of SEGMENT_TYPE values considered to be a screen or sample interval within DT_WELL_SEGMENT. Values of ‘Y’ or ‘y’ in the IS_SCREEN_YN field indicate that the associated SEGMENT_TYPE value in that record describes a sample interval or well screen.

MATERIAL_TYPE_CODE

No

See SEGMENT_TYPE field above.

MATERIAL_TYPE_DESC

No

Used for Well Construction text description in boring logs if DT_WELL_SEGMENT.REMARK is not populated.