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.
|