Reference Tables

 

 

EQuIS Reference Tables

 

RT_ANALYTE

Field Name

Obligatory to Populate

Notes

CAS_RN

Yes

 

ANL_SHORT_NAME

No

Used in data table plots when Use Short Nameoption 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 one of these plot types is 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.  Link for equivalent weight documentation.

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_# from DT_LITHOLOGY are used, where “#” in the former 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 constructed 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.  Link 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 for determining the default output units for a particular analyte / matrix / fraction value.  It is used and obligatory for selection of analyte groups for plotting of 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

Make sure to populate this 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 the segment type list from which to select the field value that indicates DT_WELL_SEGMENT record refers to a well screen.