Data Loading Handbook

- 1 -

1C Value Qualifier

- A -

Accuracy Lower Limit

Accuracy Upper Limit

AFCEE Reporting Limit

Air Force Center for Engineering and the Environment

Air Force Installation Identification

Air Force Wide Environmental Resources Program Information Management System

Ambient Blank Field Lot Identifier

Ambient Blank Field Lot Identifier Field

Analytical Laboratory Code

Analytical Method Code

Analytical Results

Aquifer Base Depth

Aquifer Test Information

Aquifer Thickness

ASTM Soil Classification Code

- B -

Beginning Depth

Benchmark Designator

Benchmark Elevation

Benchmark North

Bibliographic Reference

Bore Hole Angle

Bore Hole Azimuth

Bore Hole Depth

Bore Hole Diameter

Bottom Interval Depth

- C -

Calculated Hydrologic Parameters

Calculation Method

Calculation Parameter

Calibration Reference Identification

Chain of Custody Identification

Composite Sample Diameter

Confirm Value Precision

Confirming Value

Construction Method Code

Contents

Data Loading Definitions and Terms

Data Submission Rules and Timelines

Field Descriptions

Lot Control Numbering Rules

Processing Information with Environmental Resources Program Tools (ERPTools X)

Table Descriptions

The AIR FORCE-WIDE Environmental Resources Program Information Management System (AFW-ERPIMS)

Using this Document

Coordinate Measuring Units

Coordinate Method

Coordinate Type

Coordinate Uncertainty

- D -

Date Established

Delivery Required Values

Dilution Required

Drilling Company Code

- E -

Easting Coordinate

Elevation Exactitude

Elevation Method

Elevation UNITS

Entering_SLX_data

Environmental Measurements

Environmental Sampling Data

Equipment Blank Field Lot Identifier

Establishing Company Code

Excavating Company Code

Expected Result

Expected Value Precision

Extraction Date

Extraction Method Code

Extraction Time

- F -

Field Descriptions

Field Duplicates

Field Lot Control Numbers

Field Replicates

	FR
	FR _2
	FR _2_2

Field Sample Identification

Field Test Required

First Column Parameter Value

First Column Value Precision

FLD_TEST_REQUIRED

	FR
	FR _2
	FR _2_2

- G -

General Information Section

Geohydrologic Flow Classification

Geologic Completion

Geologic Completion Zone

Geophysical Log

Ground Water Data Measurement

Ground Water Data Measurement Required

Groundwater Level Data

	Table Descriptions
	AFIID

Group 2

Group 3

Group 4

	Table Descriptions
	OUC

	Table Descriptions
	RSI

- H -

Hydrostratigraphic Unit

Hydrostratigraphic Unit Description

Hydrostratigraphic Unit Name

Hydrostratigraphic Unit Type

- I -

IAW Draft AFI 32-7020

Import Specifications Section

Short Field Name

Installation Date

Interval Beginning Depth

Interval Classification

Interval Ending Depth

- K -

- L -

Lab Lot Control

Lab Sample Identification

Laboratory Data Qualifier Type

Laboratory Quality Control Flag

Leachate Method

Lithologic Description Information

Lithology Data Required

Location Classification Code

Location Definition Information Table

Location Description

Location Identification

Location Proximity Code

Location, Operable Unit Cross-Reference

Location, Remediation System Cross-Reference

Location, Remediation Technology Cross-Reference

Location, Zone Cross-Reference

Logging Company Code

Lower Left East Value

Lower Left North Value

- M -

Maintenance Type

Map Description

Map Drawing Scale

Map Reference Identification

Map Reference Information

Measurement Method

Measuring Point Elevation

Measuring Point Flag

Medium In Action

Method Detection Limit

- N -

No Field Test Justification

No Ground Water Data Justification

No Lithology Justification

NO_FLD_TEST_JUST

Northing Coordinate

Number of Samples

- O -

Observation Well Distance

Observation Well Location

Observation Well Water Level

Observed Measuring Point Elevation

Operable Unit Code

Operable Unit Contaminant

Operable Unit Description

Operable Unit Name

	OU_PERIMETER
	OUNAME

- P -

PA_SI_START_DATE

Par Uncertainty

Parameter Class Code

Parameter Label Code

Parameter Value

Parameter Value Qualifier

Parent Field Identification

Parent Lab Identification

Percent Open Area

Percent Recovery

PERCENT_RECOVERY

Performance Parameter

Perimeter Units of Measure

Preliminary Assessment / Site Investigation End Date

Preliminary Assessment / Site Investigation Start Date

Prime Data Qualifier Type

Project Sampling

Pumping Interval

- Q -

Qualifying Code

- R -

Record of Decision End Date

Record of Decision Start Date

Relative Percent Difference

Remark Comments

REMED_ACT_START

REMED_DES_START

Remedial Action Design Phase End Date

Remedial Action Design Phase Start Date

Remedial Action End Date

Remedial Action Start Date

Remedial Investigation End Date

Remedial Investigation Start Date

Remediation System Description

Remediation System Identification

Remediation System Information

Remediation System Name

Remediation System Performance

Remediation System Stage

Remediation System, Operable Cross-Reference

Remediation System, Site Cross-Reference

Remediation Technology

	RTI
	RTTYPE

Remediation Technology Class

Remediation Technology Description

Remediation Technology Identification

Remediation Technology Name

Remediation Technology Performance

- S -

Sample Beginning Depth

Sample Delivery Group

Sample Ending Depth

Sample Method Code

Sample Preparation Information

Sampling Matrix

Sampling Matrix Type

Screen Diameter

Site and Location Cross-Reference

Site Contamination

Site Proximity Code

Site, Operable Unit Cross-Reference

Sole Source Aquifer Code

Spike Amount Added

Spike Amount Added Precision

Spike Duplicates

SPIKE_ADDED_PREC

State Plane Zone

Statement of Work

Static Water Depth

Stratigraphic Order

Stratigraphic Unit

Stratigraphic Unit Description

Stratigraphic Unit Name

Submission Requirements

Supporting Data

Surface Elevation

Surrogate Number

SURROGATE_NUMBER

- T -

Table Description

Table Information Section

Name of the Table

Number of Fields

Short Name of the Table

Total Record Length

Test Blank Field Lot Identifier

Test Well Information

Top Interval Depth

Total Casting Depth

Tracer Concentration

Tracer Injection

Tracer Observation Well

Tracer Volume Units

- U -

Units of Measure

Universal Transverse Mercator Zone

Upper Relative Percent Difference

Upper Right East Value

Upper Right North Value

- V -

Valid Value Lists

validation rules

Value Qualifying Confirmation

Visual Description

- W -

Water Table Depth

Well Completion Information

Well Completion Method

Well Construction Interval

Well Development Procedure Code

Well Head Direction

Well Maintenance

Well Owner Code

Well Type Classification Code

Well_Interval_Data

- Z -

Zone Description

Zone Identifier