Data Loading Handbook

Introduction
Using this Document
- AFW-ERPIMS
ERPToolsX
Table Descriptions
- Group 1
  - LDI
  - SLX
  - SCC
  - ZDI
  - ZLX
  - MRI
  - WCI
  - WINT
  - WMI
  - PROJSAMP
- Group 2
  - STU
  - HSU
  - LTD
  - CALC
  - GWD
  - ATI
  - PUMPRATE
  - TWI
  - OWL
  - TRI
  - TOW
  - PUMPINT
- Group 3
  - SAMPLE
  - TEST
  - RESULT
  - EMI
  - FREQUENCY
  - PERFORMANCE
- Group 4
  - OU
  - OUC
  - SOX
  - LOX
  - RSI
  - RSP
  - RSX
  - LSX
  - ROX
  - RTI
  - RTP
  - LTX
Field Descriptions
- ABC
  - ABLOT
  - AFIID
  - ANADATE
  - ANALOT
  - ANATIME
  - ANATYPE
  - ANMCODE
  - AQBASEDEPTH
  - AQTHICK
  - ASTMCODE
  - BASIS
  - BEDNAME
  - BEGDATE
  - BEGDEPTH
  - BEGTIME
  - BEST_RESULT
  - BHANGLE
  - BHAZIM
  - BHDIAM
  - BIDEPTH
  - BMDESIG
  - BMEAST
  - BMELEV
  - BMNORTH
  - BS
  - CALCMETH
  - CALCPARCODE
  - CALREFID
  - CLASS
  - CMCCODE
  - CNFVALPREC
  - COCID
  - COOLER
  - CP_DIAM
  - CRDMETH
  - CRDTYPE
  - CRDUN
  - CRDUNITS
- DEF
  - DATUM
  - DEPTH
  - DEPWAT
  - DILUTION
  - DRLCODE
  - DRY
  - EBLOT
  - ECOORD
  - ELEV
  - ELEVMETH
  - ELEVUN
  - ELEVUNITS
  - ELFLAG
  - ENDDATE
  - ENDDEPTH
  - ENDTIME
  - ESCCODE
  - ESTDATE
  - EVPREC
  - EXCCODE
  - EXMCODE
  - EXPECTED
  - EXTDATE
  - EXTTIME
  - FCVALPREC
  - FD
  - FLDSAMPID
  - FLD_TEST_REQUIRED
  - FORMATION
  - FR
  - FTCODE
- GHI
  - GEOLOG
  - GFCCODE
  - GROUPCODE
  - GRPNAME
  - GWD_REQUIRED
  - GZCCODE
  - HEADDIR
  - HSDESC
  - HSTYPE
  - HS_UNIT
  - IBDEPTH
  - IEDEPTH
  - INSDATE
- JKL
  - LABCODE
  - LABLOTCTL
  - LABSAMPID
  - LAB_DQT
  - LAB_QC_FLAG
  - LB
  - LCHDATE
  - LCHLOT
  - LCHMETH
  - LCHTIME
  - LITHCODE
  - LLEAST
  - LLNORTH
  - LOCDESC
  - LOCID
  - LOGCODE
  - LOGDATE
  - LOGTIME
  - LOWER_ACCURACY
  - LPRCODE
  - LTCCODE
  - LTD_REQUIRED
- MNO
  - MAPCODE
  - MAPDESC
  - MAPRID
  - MAPSCALE
  - MATERIAL
  - MATRIX
  - MATRIX_TYPE
  - MBRNAME
  - MCCCODE
  - MDL
  - MEASDATE
  - MEASMETH
  - MEASTIME
  - MEDIA
  - MPELEV
  - MPFLAG
  - MS
  - MTCCODE
  - MTYPE
  - NCOORD
  - NEW_LOCATIONS
  - NO_FLD_TEST_JUST
  - NO_GWD_JUST
  - NO_LTD_JUST
  - NUMBER_SAMPLES
  - OBS_LOCATION
  - OBS_MPELEV
  - OUCODE
  - OUDESC
  - OUNAME
- PQRS
  - PARAMETER
  - PARENTFLDID
  - PARENTLABID
  - PARLABEL
  - PARUN
  - PARVAL
  - PARVQ
  - PCTOPEN
  - PERCENT_RECOVERY
  - PRCCODE
  - PRECISION
  - PRIME_DQT
  - PRIME_FLAG
  - PUMPDEPTH
  - PUMPINGRATE
  - QUALIFIER
  - REASON_CODE
  - REFERENCE
  - REMARKS
  - RL
  - RPD
  - RSDESC
  - RSID
  - RSNAME
  - RSSTAGE
  - RTCLASS
  - RTDESC
  - RTID
  - RTNAME
  - RTTYPE
  - RUN_NUMBER
  - SACODE
  - SAMPNO
  - SAQCODE
  - SBD
  - SCRNO
  - SD
  - SDG
  - SDIAM
  - SED
  - SITEID
  - SLUGVOL
  - SMCODE
  - SOUA
  - SOUNDING
  - SPCODE
  - SPIKE_ADDED
  - SPIKE_ADDED_PREC
  - ST_UNIT
  - STARTDATE
  - STARTTIME
  - STATDEP
  - STPZONE
  - STRATORDER
  - SUDESC
  - SUPPDATA
  - SURROGATE
  - SURROGATE_NUMBER
- TUV
  - TBLOT
  - TESTMETH
  - TIDEPTH
  - TOTDEPTH
  - TRCTYPE
  - TRCUNITS
  - TRCVOL
  - TRCVOLUNITS
  - TRC_CONC
  - UNITS
  - UPPER_ACCURACY
  - UPPER_RPD
  - UREAST
  - UTMZONE
  - URNORTH
  - VAL_1C
  - VAL_CONFIRM
  - VISDESC
  - VQ_1C
  - VQ_CONFIRM
- WXYZ
  - WCMCODE
  - WDPROC
  - WELCODE
  - WELLDIST
  - WTCCODE
  - WTDEPTH
  - ZNAME
  - ZONEDESC
  - ZONEID
Definitions
Lot Control
Submission
AFCEE Supplied
Helpdesk Contact
DLH Release Notes