<< Click to Display Table of Contents >> Navigation: Table Descriptions > Group 3 > Sample Preparation Information Table |
|
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 |
Yes |
1 |
5 |
||
Yes |
7 |
21 |
||
Yes |
23 |
33 |
||
Yes |
35 |
38 |
||
Yes |
40 |
41 |
||
Yes |
43 |
50 |
||
Yes |
52 |
59 |
||
Yes |
61 |
62 |
||
Yes |
64 |
65 |
||
Yes |
67 |
70 |
||
Yes |
72 |
78 |
||
Yes |
80 |
86 |
||
Yes |
88 |
94 |
||
Yes |
96 |
97 |
||
No |
99 |
118 |
||
No |
120 |
130 |
||
No |
132 |
135 |
||
No |
137 |
147 |
||
No |
149 |
152 |
||
No |
154 |
163 |
||
No |
165 |
175 |
||
No |
177 |
180 |
||
No |
182 |
191 |
||
No |
193 |
202 |
||
No |
204 |
213 |
||
No |
215 |
219 |
||
No |
221 |
221 |
Lab Format File
Short Field Name |
Import Required? |
Delivery Required |
Start |
End |
No |
1 |
20 |
||
No |
22 |
23 |
||
Yes |
25 |
31 |
||
Yes |
33 |
39 |
||
Yes |
41 |
47 |
||
Yes |
49 |
50 |
||
No |
52 |
55 |
||
No |
57 |
67 |
||
No |
69 |
72 |
||
No |
74 |
84 |
||
No |
86 |
89 |
||
Yes |
91 |
100 |
||
No |
102 |
112 |
||
No |
114 |
117 |
||
Yes |
119 |
128 |
||
No |
130 |
139 |
||
No |
141 |
141 |
||
Yes |
143 |
152 |