Analytical Results Table

Top  Previous  Next

Name

Analytical Results

Short Name

RESULT

AFCEE Supplied

No

Number of Fields

Prime 8 / Lab 9

Total Record Length

Prime 66 / Lab 301

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.

In cases where the SOW requires confirmation of gas chromatography (GC) or high performance liquid chromatography (HPLC) 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

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

No

80

86

LCHMETH

No

88

94

RUN_NUMBER

Yes

96

97

PARLABEL

Yes

99

110

PRCCODE

No

112

114

PARVQ

No

116

117

PARVAL

No

119

135

PARUN

No

137

149

PRECISION

No

151

151

EXPECTED

No

153

169

EVPREC

No

171

171

MDL

No

173

189

RL

No

191

207

UNITS

No

209

218

VQ_1C

No

220

221

VAL_1C

No

223

239

FCVALPREC

No

241

241

VQ_CONFIRM

No

243

244

VAL_CONFIRM

No

246

262

CNFVALPREC

No

264

264

DILUTION

No

266

282

PRIME_DQT

No

284

288

PRIME_FLAG

No

290

295

LAB_DQT

No

297

301

LAB_QC_FLAG

No

303

308

BEST_RESULT

No

310

310

REASON_CODE

No

312

341

PERCENT_RECOVERY

No

343

357

RPD

No

359

373

UPPER_RPD

No

375

389

UPPER_ACCURACY

No

391

405

LOWER_ACCURACY

No

407

421

SPIKE_ADDED

No

423

439

SPIKE_ADDED_PREC

No

441

441

 


Lab Format File

Short Field Name

Required?

Start

End

LABSAMPID

No

1

20

MATRIX

No

22

23

ANMCODE

No

25

31

EXMCODE

No

33

39

LCHMETH

No

41

47

RUN_NUMBER

No

49

50

PARLABEL

Yes

52

63

PRCCODE

No

65

67

PARVQ

No

69

70

PARVAL

No

72

88

PARUN

No

90

102

PRECISION

No

104

104

SPIKE_ADDED

No

106

122

EXPECTED

No

124

140

SPIKE_ADDED_PREC

No

142

142

MDL

No

144

160

RL

No

162

178

UNITS

No

180

189

VQ_1C

No

191

192

VAL_1C

No

194

210

FCVALPREC

No

212

212

VQ_CONFIRM

No

214

215

VAL_CONFIRM

No

217

233

CNFVALPREC

No

235

235

DILUTION

No

237

253

LAB_DQT

No

255

259

LAB_QC_FLAG

No

261

266

BEST_RESULT

No

268

268

REASON_CODE

No

270

299

PERCENT_RECOVERY

No

301

315

RPD

No

317

331

UPPER_RPD

No

333

347

UPPER_ACCURACY

No

349

363

LOWER_ACCURACY

No

365

379

EVPREC

No

381

381

 

 




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.