Sample Preparation Information Table

<< Click to Display Table of Contents >>

Navigation:  Table Descriptions > Group 3 >

Sample Preparation Information Table

Name

Test Procedure

Short Name

TEST

ERPIMS Supplied

No

Number of Fields

Prime 27 / Lab 18

Total Record Length

Prime 221 / Lab 152

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.

 


Prime Format File

 

Short Field Name

Import Required?

Delivery Required

Start

End

AFIID

Yes

C

1

5

LOCID

Yes

Y

7

21

LOGDATE

Yes

Y

23

33

LOGTIME

Yes

Y

35

38

MATRIX

Yes

Y

40

41

SBD

Yes

Y

43

50

SED

Yes

Y

52

59

SACODE

Yes

Y

61

62

SAMPNO

Yes

Y

64

65

LABCODE

Yes

V

67

70

ANMCODE

Yes

V

72

78

EXMCODE

Yes

V

80

86

LCHMETH

Yes

V

88

94

RUN_NUMBER

Yes

Y

96

97

LABSAMPID

No

Y

99

118

EXTDATE

No

C

120

130

EXTTIME

No

C

132

135

LCHDATE

No

C

137

147

LCHTIME

No

C

149

152

LCHLOT

No

N

154

163

ANADATE

No

Y

165

175

ANATIME

No

Y

177

180

ANALOT

No

N

182

191

LABLOTCTL

No

C

193

202

CALREFID

No

N

204

213

RTTYPE

No

V

215

219

BASIS

No

V

221

221

 

 

 


Lab Format File

Short Field Name

Import Required?

Delivery Required

Start

End

LABSAMPID

No

Y

1

20

MATRIX

No

Y

22

23

ANMCODE

Yes

V

25

31

EXMCODE

Yes

V

33

39

LCHMETH

Yes

V

41

47

RUN_NUMBER

Yes

Y

49

50

LABCODE

No

V

52

55

EXTDATE

No

C

57

67

EXTTIME

No

C

69

72

LCHDATE

No

C

74

84

LCHTIME

No

C

86

89

LCHLOT

Yes

[****]

91

100

ANADATE

No

Y

102

112

ANATIME

No

Y

114

117

ANALOT

Yes

[****]

119

128

LABLOTCTL

No

C

130

139

BASIS

No

V

141

141

CALREFID

Yes

[****]

143

152