DLH Release Notes

Product Release Information

Product:	Data Loading Handbook
Release Number:	6.0
Release Date:	March 2012
Customer Support:	For more information or support, please visit our website or email us at afcec.czra.erpims@us.af.mil

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 6.0. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous releases should upgrade to this release.

What's New?

•Corrections to the DLH Tables.

PERFORMANCE
FREQUENCY
GWD

Performance - Prime

Short Field Name	Required?	Start	End
ANMCODE	No	1	7
PARLABEL	Yes	9	20
MATRIX_TYPE	No	22	22
SURROGATE	Yes	24	24
SURROGATE_NUMBER	No	26	28
LOWER_ACCURACY	No	30	44
UPPER_ACCURACY	No	46	60
RPD	No	62	76
REFERENCE	No	78	332
MDL	No	334	350
RL	No	352	368
UNITS	No	370	379

Performance - Lab

Short Field Name	Required?	Start	End
ANMCODE	No	1	7
PARLABEL	Yes	9	20
MATRIX_TYPE	No	22	22
SURROGATE	No	24	24
SURROGATE_NUMBER	No	26	28
LOWER_ACCURACY	No	30	44
UPPER_ACCURACY	No	46	60
RPD	No	62	76
REFERENCE	No	78	332
MDL	No	334	350
RL	No	352	368
UNITS	No	370	379

Frequency

Short Field Name	Required?	Start	End
ANMCODE	Yes	1	7
MATRIX_TYPE	Yes	9	9
FD	No	11	15
FR	No	17	21
MS	No	23	27
SD	No	29	33
LB	No	35	39
BS	No	41	45
REFERENCE	No	47	301

GWD

Short Field Name	Required?	Start	End
AFIID	Yes	1	5
LOCID	Yes	7	21
LOGDATE	Yes	23	33
LOGTIME	Yes	35	38
IBDEPTH	Yes	40	49
IEDEPTH	Yes	51	60
LOGCODE	No	62	65
STATDEP	No	67	74
SOUNDING	No	76	83
FTCODE	No	85	85
MEASMETH	No	87	91
DRY	No	93	93
OBS_MPELEV	No	95	102
REMARKS	No	104	343

•Previously SITE_ID column was a numerical field of length 3. This has been changed to incorporate SITE_IDs with a length of 4. This change affects the following tables:

RSX
SCC
SLX
SOX

RSX

Short Field Name	Required?	Start	End
AFIID	Yes	1	5
SITEID	Yes	7	10
RSID	Yes	12	21
RSSTAGE	Yes	23	25

SCC

Short Field Name	Required?	Start	End
AFIID	Yes	1	5
GROUPCODE	Yes	7	16
SITEID	Yes	18	21

SLX

Short Field Name	Required?	Start	End
AFIID	Yes	1	5
SITEID	Yes	7	10
LOCID	Yes	12	26
GFCCODE	No	28	28
SPCODE	No	30	30

SOX

Short Field Name	Required?	Start	End
AFIID	Yes	1	5
SITEID	Yes	7	10
OUCODE	Yes	12	14

•The following DLH Fields have changes to their descriptions.

•The VVL was changed to RRC for REASON_CODE.

•Submission Date was removed from the Definitions.

•Email and surface mail addresses were updated.

Known Caveats and Workarounds

•NONE

Data Loading Handbook 5.1.1222

Product Release Information

Product:	Data Loading Handbook
Release Number:	5.1.1222
Release Date:	2009/DECEMBER/22
Customer Support:	For more information or support, please visit our website or email us at erpims.helpdesk@brooks.af.mil.

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 5.1.1222. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous 5.1 releases should upgrade to this release.

What's New?

•Corrections to the DLH Tables.
PERFORMANCE
PROJSAMP
RESULT
WCI

Recent Changes

PERFORMANCE

Project Type	Field Name	Start Position	End Position
Prime	RL	352	368
Prime	UNITS	370	379
Lab	RL	352	368
Lab	UNITS	370	379

PROJSAMP

Project Type	Field Name	Start Position	End Position
Prime	NUMBER_SAMPLES	8	14
Prime	GWD_REQUIRED	16	16
Prime	NO_GWD_JUST	18	2017
Prime	LTD_REQUIRED	2019	2019
Prime	NO_LTD_JUST	2021	4020
Prime	FLD_TEST_REQUIRED	4022	4022
Prime	NO_FLD_TEST_JUST	4024	6023

RESULT

Project Type	Field Name	Start Position	End Position
Prime	RL	191	207
Prime	UNITS	209	218
Prime	VQ_1C	220	221
Prime	VAL_1C	223	239
Prime	FCVALPREC	241	241
Prime	VQ_CONFIRM	243	244
Prime	VAL_CONFIRM	246	262
Prime	CNFVALPREC	264	264
Prime	DILUTION	266	282
Prime	PRIME_DQT	284	288
Prime	PRIME_FLAG	290	295
Prime	LAB_DQT	297	301
Prime	LAB_QC_FLAG	303	308
Prime	BEST_RESULT	310	310
Prime	REASON_CODE	312	341
Prime	PERCENT_RECOVERY	343	357
Prime	RPD	359	373
Prime	UPPER_RPD	375	389
Prime	UPPER_ACCURACY	391	405
Prime	LOWER_ACCURACY	407	421
Prime	SPIKE_ADDED	423	439
Prime	SPIKE_ADDED_PREC	441	441
Lab	RL	162	178
Lab	UNITS	180	189
Lab	VQ_1C	191	192
Lab	VAL_1C	194	210
Lab	FCVALPREC	212	212
Lab	VQ_CONFIRM	214	215
Lab	VAL_CONFIRM	217	233
Lab	CNFVALPREC	235	235
Lab	DILUTION	237	253
Lab	LAB_DQT	255	259
Lab	LAB_QC_FLAG	261	266
Lab	BEST_RESULT	268	268
Lab	REASON_CODE	270	299
Lab	PERCENT_RECOVERY	301	315
Lab	RPD	317	331
Lab	UPPER_RPD	333	347
Lab	UPPER_ACCURACY	349	363
Lab	LOWER_ACCURACY	365	379

WCI

Project Type	Field Name	Start Position	End Position
Prime	TOTDEPTH	71	77
Prime	REMARKS	79	318

Known Caveats and Workarounds

•NONE

Data Loading Handbook 5.1.904: Release Notes

Product Release Information

Product:	Data Loading Handbook
Release Number:	5.1.904
Release Date:	2009/SEPTEMBER/04
Customer Support:	For more information or support, please visit our website or email us at erpims.helpdesk@brooks.af.mil.

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 5.1.904. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous 5.1 releases should upgrade to this release.

What's New?

•Corrections to the DLH Tables in anticipation of the ErpTools X 5.0.7.0 release.
FREQUENCY
PERFORMANCE
PROJSAMP
RESULT
WCI

Recent Changes

•CORRECTION Field length for ParendLabId field corrected to a length of 20.

•CORRECTION Field length for TrcVolUnits field corrected to a length of 10.

•CORRECTION Field length for SAQCode field corrected to a length of 4.

•CORRECTION Field length for EndDepth field corrected to a length of 9,2.

•CORRECTION Changed end number of TotDepth on the WCI table to correct number space for 7,2.

•FIX Field length for MDL changed from 16,6 to 14,6.

•FIX Field length for RL changed from 16,6 to 14,6.

•FIX Field length for Number_Samples changed from 7 to 7,0.

•FIX Changed Start/End Numbers on Frequency Table to reflect the removal of Source field.

•FIX Changed Start/End Numbers on Performance Table to reflect the removal of Source field.

•FIX Changed Start/End Numbers on Performance Tables to reflect the change in length of MDL field.

•FIX Changed Start/End Numbers on Performance Tables to reflect the change in length of RL field.

•FIX Changed Start/End Numbers on ProjSamp Table to reflect the change in length of Number_Samples field.

•FIX Changed Start/End Numbers on Result Table to reflect the change in length of MDL field.

•FIX Changed Start/End Numbers on Result Table to reflect the change in length of RL field.

•FIX Changed Start/End Numbers on WCI Table to reflect the correction in length of TotDepth field.

•ENHANCEMENT Removed Source Field from DLH due to removal from Erptools X database.

Known Caveats and Workarounds

•NONE

Product Release Information

Product:	Data Loading Handbook
Release Number:	5.1.819
Release Date:	2009/AUGUST/19
Customer Support:	For more information or support, please visit our website or email us at erpims.helpdesk@brooks.af.mil.

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 5.1.819. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous 5.1 releases should upgrade to this release.

What's New?

•Field Descriptions index listed in a table to reduce scrolling.

•Keyword Index has been fleshed out.

•Group 3 submission timeline stretched from 30 days to 60 days.

Recent Changes

•CORRECTION Submission Timeline changed from 30 days after results returned to 60 days after results have been returned form lab.

•FIX Corrected incorrect links on Erptoolsx page.

•FIX Added AF Approved Copyright information to Files

•ENHANCEMENT Added more Keywords to the document to increase index usability.

•ENHANCEMENT Edited layout of Lechmeth for improved viewing on page.

•ENHANCEMENT Removed Draft watermark from pages.

Known Caveats and Workarounds

•NONE

Product Release Information

Product:	Data Loading Handbook
Release Number:	5.1.615
Release Date:	2009/JUNE/15
Customer Support:	For more information or support, please visit our website or email us at erpims.helpdesk@brooks.af.mil.

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 5.1.615. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous 5.1 releases should upgrade to this release.

What's New?

•Corrected the PRIME.TEST format table.

•Added DLH Release Notes Page.

Recent Changes

•FIX Format file for PRIME.TEST had a short field name labeled for the field in 67-70 block. It now reads LABCODE instead of LOGCODE.

•ENHANCEMENT Added a DLH Release Notes Section. This section will define and list all new changes to the DLH based on release number.

•ENHANCEMENT Added a navigation link to the main page directing users to the Release Notes Section.

Known Caveats and Workarounds

•NONE

Product Release Information

Product:	Data Loading Handbook
Release Number:	5.1.427
Release Date:	2009/APRIL/27
Customer Support:	For more information or support, please visit our website or email us at erpims.helpdesk@brooks.af.mil.

Introduction

This document contains the release notes for ERPIMS Data Loading Handbook version 5.1.427. The following sections describe the release in detail and provide late-breaking or other information that supplements the main documentation.

This is a maintenance release that improves quality, reliability, and performance without adding any new functionality. All users of previous 5.1 releases should upgrade to this release.

What's New?

•Changes Descriptions on 6 fields to reduce confusion on the fields.

•Made Corrections to many starting and ending numbers of fields.

•Added a LAB version of the PERFORMANCE format file.

Recent Changes

•FIX Changed the description of each of the following fields to read similarly to the description given for the Frequency Table. This is to help reduce confusion on the fields.

oFD

oFR

oMS

oSD

oLB

oBS

•FIX Changed the description notes for the FREQUENCY Table.

o== FREQUENCY Table – Child Tables: None
The correct Child Tables: PERFORMANCE

o2 == For the FREQUENCY Table.
Field SOURCE – VVL Name: PAR
The correct VVL Name is PJTT

o3 == For the FREQUENCY Table.
Field SOURCE – Description
“Method of Code Source is a coded value indicating whether the entered data is specified within the laboratory or prime QAPP or DQO.”

•FIX Corrected the broken hyperlink to GSI from Group 1 Table page.

•FIX Changed the table properties to increase the cell padding on the Group 4 Table Page to eliminate the combo link look.

•FIX Changed the ending values on the GWD table for the following fields.

oSTATDEP From 73 To 74

oOBS_MPELEV From 101 To 102

•FIX Changed the ending values on the OWL table for the following fields.

oDEPWAT From 81 To 82

•FIX Changed the ending values on the PERFORMANCE table for the following field.

oLOWER_ACCURACY From 45 To 46

•ENHANCEMENT Added a Lab version of PERFORMANCE with all the performance fields + LABCODE

•FIX Changed the starting values on the PUMPINT table for the following fields

oUNITS From 107 To 108

oREMARKS From 118 To 119

•FIX Changed the ending values on the PUMPINT table for the following fields.

oBEGDEPTH From 65 To 66

oEND DEPTH From 76 To 77

oPUMPDEPTH From 96 To 97

oPUMPINGRATE From 105 To 106

oUNITS From 116 To 117

oREMARKS From 357 To 358

•FIX Changed the ending values on the PUMPRATE Table for the following value.

oPUMPINGRATE From 82 To 81

•FIX Changed the ending value on the RESULT table for the prime project for the following values.

oSBD From 49 To 50

oSED From 58 To 59

•FIX Changed the ending value on the RESULT table for the lab project for the following values.

oLAB_QC_FLAG From 268 To 266

oREASON_CODE From 258 To 268

•FIX Changed the ending values on the SAMPLE table for both the prime and lab project for the following values.

oSBD From 49 To 50

oSED From 58 To 59

Known Caveats and Workarounds

•NONE

All photos contained in this online document are linked to full sided images of the imbedded image. Simply click on the image to have a browser view the image in its full size.