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

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.

ANALYTIC_METHOD

Yes

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

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).

PARAM

Yes

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

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.

GROUP_CODE

Yes

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

GROUP_TYPE

Yes

LOCATION_TYPE_CODE

Yes

LOCATION_TYPE_DESC

Yes

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

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.

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.

SAMPLE_TYPE_CODE

Yes

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

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.

REPORTED_UNIT

Yes

TARGET_UNIT

Yes

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

CONVERSION_FACTOR

Yes

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.