Sample Preparation Information Table

Top  Previous  Next

Name

Test Procedure

Short Name

TEST

AFCEE Supplied

No

Number of Fields

Prime 8 / Lab 9

Total Record Length

Prime 66 / Lab 301

Child Tables

RESULT

Environmental Sample Preparation Information.

 

This table contains information pertinent to environmental sample preparation and handling.  Each TESTS record captures data concerning a single extraction or preparation.  Every TESTS record must have a parent SAMPLES record to which it is related by installation, location, log date, log time, matrix, beginning and ending depths, sample code, and sample number.  TESTS must also have at least one related RESULTS record in order to be included in the data submission.  A separate record must be entered for every combination of analytical method, extraction method, leachate method, lab code, and run number that has the same parent sample record. ERPToolsX accommodates multiple runs for a given extraction/analytical method combination performed on a single sample using the RUN_NUMBER field.

 

Tests such as methods E120.1 (specific conductance), E150.1 (pH), E170.1 (temperature) and E180.1 (turbidity) should be performed during monitoring well purging for groundwater sampling and well development.  These field tests may be performed multiple times during monitoring well purging or development.  Only the final result prior to groundwater sampling at the conclusion of well development (after stabilization of field test parameters) should be recorded in ERPIMS.

 


Prime Format File

 

Short Field Name

Required?

Start

End

AFIID

Yes

1

5

LOCID

Yes

7

21

LOGDATE

Yes

23

33

LOGTIME

Yes

35

38

MATRIX

Yes

40

41

SBD

Yes

43

50

SED

Yes

52

59

SACODE

Yes

61

62

SAMPNO

Yes

64

65

LABCODE

Yes

67

70

ANMCODE

Yes

72

78

EXMCODE

Yes

80

86

LCHMETH

Yes

88

94

RUN_NUMBER

Yes

96

97

LABSAMPID

No

99

118

EXTDATE

No

120

130

EXTTIME

No

132

135

LCHDATE

No

137

147

LCHTIME

No

149

152

LCHLOT

No

154

163

ANADATE

No

165

175

ANATIME

No

177

180

ANALOT

No

182

191

LABLOTCTL

No

193

202

CALREFID

No

204

213

RTTYPE

No

215

219

BASIS

No

221

221

 

 


Lab Format File

Short Field Name

Required?

Start

End

LABSAMPID

No

1

20

MATRIX

No

22

23

ANMCODE

Yes

25

31

EXMCODE

Yes

33

39

LCHMETH

Yes

41

47

RUN_NUMBER

Yes

49

50

LABCODE

No

52

55

EXTDATE

No

57

67

EXTTIME

No

69

72

LCHDATE

No

74

84

LCHTIME

No

86

89

LCHLOT

No

91

100

ANADATE

No

102

112

ANATIME

No

114

117

ANALOT

No

119

128

LABLOTCTL

No

130

139

BASIS

No

141

141

CALREFID

No

143

152

 




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.


For questions or concerns on any information on this page please Email ERPIMS Help Desk.
This page last updated 9/4/2012
© 2014 United States Government, as represented by the Secretary of the Air Force.  All rights reserved.