Analytical Results Table

<< Click to Display Table of Contents >>

Navigation:  Table Descriptions > Group 3 >

Analytical Results Table

Name

Analytical Results

Short Name

RESULT

ERPIMS Supplied

No

Number of Fields

Prime 45 / Lab 35

Total Record Length

Prime 441 / Lab 381

Child Tables

 

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

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

Y

67

70

ANMCODE

Yes

Y

72

78

EXMCODE

No

Y

80

86

LCHMETH

No

Y

88

94

RUN_NUMBER

Yes

Y

96

97

PARLABEL

Yes

V

99

110

PRCCODE

No

V

112

114

PARVQ

No

V

116

117

PARVAL

No

Y

119

135

PARUN

No

C

137

149

PRECISION

No

Y

151

151

EXPECTED

No

C

153

169

EVPREC

No

C

171

171

MDL

No

C

173

189

RL

No

C

191

207

UNITS

No

V

209

218

VQ_1C

No

V

220

221

VAL_1C

No

C

223

239

FCVALPREC

No

C

241

241

VQ_CONFIRM

No

V

243

244

VAL_CONFIRM

No

C

246

262

CNFVALPREC

No

C

264

264

DILUTION

No

Y

266

282

PRIME_DQT

No

V

284

288

PRIME_FLAG

No

C

290

295

LAB_DQT

No

V

297

301

LAB_QC_FLAG

No

C

303

308

BEST_RESULT

No

C

310

310

REASON_CODE

No

N

312

341

PERCENT_RECOVERY

No

C

343

357

RPD

No

C

359

373

UPPER_RPD

No

N

375

389

UPPER_ACCURACY

No

N

391

405

LOWER_ACCURACY

No

N

407

421

SPIKE_ADDED

No

C

423

439

SPIKE_ADDED_PREC

Yes

[****]

441

441

 

 


Lab Format File

Short Field Name

Import Required?

Delivery Required

Start

End

LABSAMPID

No

Y

1

20

MATRIX

No

Y

22

23

ANMCODE

No

Y

25

31

EXMCODE

No

Y

33

39

LCHMETH

No

Y

41

47

RUN_NUMBER

No

Y

49

50

PARLABEL

Yes

V

52

63

PRCCODE

No

V

65

67

PARVQ

No

V

69

70

PARVAL

No

Y

72

88

PARUN

No

C

90

102

PRECISION

No

Y

104

104

SPIKE_ADDED

No

C

106

122

EXPECTED

No

C

124

140

SPIKE_ADDED_PREC

No

C

142

142

MDL

No

C

144

160

RL

No

C

162

178

UNITS

No

V

180

189

VQ_1C

No

V

191

192

VAL_1C

No

C

194

210

FCVALPREC

No

C

212

212

VQ_CONFIRM

No

V

214

215

VAL_CONFIRM

No

C

217

233

CNFVALPREC

No

C

235

235

DILUTION

No

Y

237

253

LAB_DQT

No

V

255

259

LAB_QC_FLAG

No

C

261

266

BEST_RESULT

No

C

268

268

REASON_CODE

No

N

270

299

PERCENT_RECOVERY

No

C

301

315

RPD

Yes

[****]

317

331

UPPER_RPD

No

N

333

347

UPPER_ACCURACY

No

N

349

363

LOWER_ACCURACY

No

N

365

379

EVPREC

Yes

[****]

381

381