<< Click to Display Table of Contents >> Analytical Results Table |
|
Analytical Chemistry Results Information.
This table records analytical results for one or more analytes obtained from a single extraction and testing event. Each record in the table provides the analytical result for a single analyte and the associated unit of measure. This table also contains information such as data qualifiers, data flags, uncertainties, precision, and dilution factors. RESULTS records also include the method detection limit (MDL) and the required reporting limit (RL). To be accepted by ERPIMS, each RESULTS record must have corresponding parent records in the TESTS and SAMPLES tables.
All results above the Method Detection Limits (MDLs) should be submitted as quantifiable results. All non-detectable results should be entered with PARVAL = 0 and PARVQ = ND. Note, for these records, MDLs are of particular importance. Non-detectable results must be entered so that ERPIMS has an affirmation record of environmental contaminants for which analysis was performed, but contaminants were not found. Regarding PARVQ and the Uniformed Federal Policy Quality Assurance Project Plan (UFP-QAPP): Contractors should report consistent with the guidance in the most current Quality Systems Manual (QSM). If the reported result is a "Non-Detect", report parval=0 and MDL = LOD. Report LOQ for RL. If the reported result is a "Trace", report the estimated value and MDL = DL. Report LOQ for the RL
PARVQ MDL RL = LOD LOQ ND LOD LOQ TR DL LOQ
In cases where the Statement of Work (SOW) requires dual column analyses (HPLC or GC), or second column or GC/MS confirmation results, three confirming data pairs (PARVAL & PARVQ, VAL_1C & VQ_1C, and VAL_CONFIRM & VQ_CONFIRM) will be entered for each RESULTS records. The PARVAL and PARVQ for each first and second column result will be entered in the fields VAL_1C, VQ_1C, VAL_CONFIRM and VQ_CONFIRM, respectively. The primary result, which is the one chosen as most reliable by the laboratory, must be consistently entered in the fields PARVAL and PARVQ for each RESULTS record. Averaging the first column and confirming results to get the primary result is not allowed.
|
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 |
||
No |
80 |
86 |
||
No |
88 |
94 |
||
Yes |
96 |
97 |
||
Yes |
99 |
110 |
||
No |
112 |
114 |
||
No |
116 |
117 |
||
No |
119 |
135 |
||
No |
137 |
149 |
||
No |
151 |
151 |
||
No |
153 |
169 |
||
No |
171 |
171 |
||
No |
173 |
189 |
||
No |
191 |
207 |
||
No |
209 |
218 |
||
No |
220 |
221 |
||
No |
223 |
239 |
||
No |
241 |
241 |
||
No |
243 |
244 |
||
No |
246 |
262 |
||
No |
264 |
264 |
||
No |
266 |
282 |
||
No |
284 |
288 |
||
No |
290 |
295 |
||
No |
297 |
301 |
||
No |
303 |
308 |
||
No |
310 |
310 |
||
No |
312 |
341 |
||
No |
343 |
357 |
||
No |
359 |
373 |
||
No |
375 |
389 |
||
No |
391 |
405 |
||
No |
407 |
421 |
||
No |
423 |
439 |
||
Yes |
441 |
441 |
Lab Format File
Short Field Name |
Import Required? |
Delivery Required |
Start |
End |
No |
1 |
20 |
||
No |
22 |
23 |
||
No |
25 |
31 |
||
No |
33 |
39 |
||
No |
41 |
47 |
||
No |
49 |
50 |
||
Yes |
52 |
63 |
||
No |
65 |
67 |
||
No |
69 |
70 |
||
No |
72 |
88 |
||
No |
90 |
102 |
||
No |
104 |
104 |
||
No |
106 |
122 |
||
No |
124 |
140 |
||
No |
142 |
142 |
||
No |
144 |
160 |
||
No |
162 |
178 |
||
No |
180 |
189 |
||
No |
191 |
192 |
||
No |
194 |
210 |
||
No |
212 |
212 |
||
No |
214 |
215 |
||
No |
217 |
233 |
||
No |
235 |
235 |
||
No |
237 |
253 |
||
No |
255 |
259 |
||
No |
261 |
266 |
||
No |
268 |
268 |
||
No |
270 |
299 |
||
No |
301 |
315 |
||
Yes |
317 |
331 |
||
No |
333 |
347 |
||
No |
349 |
363 |
||
No |
365 |
379 |
||
Yes |
381 |
381 |