SLIDE 1
Page 1 of 5
Post Review EDD Export Specifications - Analytical Results (A1) Comma Delimited Text File
Order Field Name* Field Description Field Type Field Length 1 RecordID Record number. Number Single 2 ClientSampleID Client field sample identifier. Text 25 3 LabAnalysisRefMethodID Laboratory reference method (i.e. 8260B, 6010B, etc.). Text 25 4 AnalysisType Defines type of analysis (i.e. dilution, reanalysis, etc.). Text 10 5 LabSampleID Internal laboratory sample tracking number for samples and lab generated QC. Text 25 6 LabID Identifier of laboratory performing the analysis. Text 7 7 ClientAnalyteID CAS number or unique analyte identifier. Text 12 8 AnalyteName Chemical name for analyte. Text 60 9 Result Reportable result for the analyte. Text 10 10 ResultUnits Units of measure for the result (i.e. mg/Kg, ug/L, etc.). Text 10 11 LabQualifiers A string of letter or symbol qualifiers assigned by the lab based on contractor defined rules and values. Text 7 12 DetectionLimit Detection limit for the analyte being measured. Text 10 13 DetectionLimitType Specifies the type of detection limit (i.e. MDL, IDL, etc.). Text 10 14 RetentionTime The time expressed in decimal minutes between injection and detection for GC/MS TICs only. Text 5 15 AnalyteType Defines the type of result such as surrogate, spike, or target analyte. Text 7 16 PercentRecovery The percent recovery of a spiked QC compound such as a matrix spike, LCS spike, or surrogate. Text 5 17 RelativePercentDifference RPD between to QC results such as MS/MSD. Number Single 18 ReportingLimit Analyte reporting limit. Text 10 19 ReportingLimitType Defines the type of reporting limit (PQL, CRQL, etc.). Text 10 20 ReportableResult (YES or NO) Indicates which result is the useable result when results from two or more analyses for the same sample and method (ie dilutions, reanalyses, etc) are reported in the EDD. Text 3 21 Filename File name of the EDD. The same as the LabReportingBatch in the Sample Analysis table (A3). Text 12 22 DVModifiedConcentration ADR modified analyte result due to blank contamination. Text 10 23 DVQualTemperature Data review qualifier for temperature outlier. Text 5 24 DVQualPreservation Data review qualifier for preservation anomaly. Text 5 25 DVQualHTSamplingToAnalysis Data review qualifier for holding time violation from sampling time to analysis time. Text 5 26 DVQualHTSamplingToExtraction Data review qualifier for holding time violation from sampling time to extraction. Text 5 27 DVQualHTExtractionToAnalysis Data review qualifier for holding time violation from extraction time to analysis time. Text 5 28 DVQualHoldingTime Overall data review qualifier for holding time violation. Text 5 29 DVQualMethodBlanks Data review qualifier for contamination in an associated method blank. Text 5 30 DVQualSurrogateRecovery Data review qualifier for surrogate recovery
- utlier.