Post Review EDD Export Specifications - Analytical Results (A1) - PDF document

Post Review EDD Export Specifications - Analytical Results (A1) Comma Delimited Text File Field Field Order Field Name* Field Description Type Length 1 RecordID Record number. Number Single 2 ClientSampleID Client field sample identifier. Text 25 3 LabAnalysisRefMethodID Laboratory reference method (i.e. 8260B, Text 25 6010B, etc.). 4 AnalysisType Defines type of analysis (i.e. dilution, reanalysis, Text 10 etc.). 5 LabSampleID Internal laboratory sample tracking number for Text 25 samples and lab generated QC. 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, Text 10 etc.). 11 LabQualifiers A string of letter or symbol qualifiers assigned Text 7 by the lab based on contractor defined rules and values. 12 DetectionLimit Detection limit for the analyte being measured. Text 10 13 DetectionLimitType Specifies the type of detection limit (i.e. MDL, Text 10 IDL, etc.). 14 RetentionTime The time expressed in decimal minutes Text 5 between injection and detection for GC/MS TICs only. 15 AnalyteType Defines the type of result such as surrogate, Text 7 spike, or target analyte. 16 PercentRecovery The percent recovery of a spiked QC compound Text 5 such as a matrix spike, LCS spike, or surrogate. 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, Text 10 etc.). 20 ReportableResult (YES or NO) Indicates which result is the Text 3 useable result when results from two or more analyses for the same sample and method (ie dilutions, reanalyses, etc) are reported in the EDD. 21 Filename File name of the EDD. The same as the Text 12 LabReportingBatch in the Sample Analysis table (A3). 22 DVModifiedConcentration ADR modified analyte result due to blank Text 10 contamination. 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 Text 5 from sampling time to analysis time. 26 DVQualHTSamplingToExtraction Data review qualifier for holding time violation Text 5 from sampling time to extraction. 27 DVQualHTExtractionToAnalysis Data review qualifier for holding time violation Text 5 from extraction time to analysis time. 28 DVQualHoldingTime Overall data review qualifier for holding time Text 5 violation. 29 DVQualMethodBlanks Data review qualifier for contamination in an Text 5 associated method blank. 30 DVQualSurrogateRecovery Data review qualifier for surrogate recovery Text 5 outlier. 31 DVQualMS Overall data review qualifier for associated MS Text 5 and MSD recovery and/or RPD outlier. 32 DVQualMSRecovery Data review qualifier for MS and/or MSD Text 5 recovery outlier. Page 1 of 5

Post Review EDD Export Specifications - Analytical Results (A1) Comma Delimited Text File Field Field Order Field Name* Field Description Type Length 33 DVQualMSRPD Data review qualifier for MS/MSD RPD .outlier. Text 5 34 DVQualLCS Overall data review qualifier for LCS and LCS Text 5 recovery and/or RPD outlier. 35 DVQualLCSRecovery Data review qualifier for associated LCS and/or Text 5 LCSD recovery outlier. 36 DVQualLCSRPD Data review qualifier for LCS/LCSD RPD Text 5 outlier. 37 DVQualRepLimits Data review qualifier for result reported below Text 5 the reporting limit. 38 DVQualReportingLimits Data review comment (“OutX”) when reporting Text 5 limit exceeds the project reporting limit. 39 DVQualFieldQC Overall data review qualifier for Field QC. Text 5 40 DVQualFieldBlank Data review qualifier for contamination in an Text 5 associated Field Blank. 41 DVQualEquipmentBlank Data review qualifier for contamination in an Text 5 associated Equipment Rinsate or Equipment Blank. 42 DVQualTripBlank Data review qualifier for contamination in an Text 5 associated Trip Blank. 43 DVQualFieldDuplicate Data review qualifier for an associated Field Text 5 Duplicate RPD outlier. 44 DVQualIC Overall data review qualifier for associated Text 5 initial calibration outliers. 45 DVQualInitialCalibrationRRF Data review qualifier for an associated initial Text 5 calibration relative response factor outlier. 46 DVQualInitialCalibrationRSD Data review qualifier for an associated initial Text 5 calibration relative percent difference outlier. 47 DVQualInitialCalibrationCC Data review qualifier for an associated initial Text 5 calibration corrrelation coefficient outlier. 48 DVQualICV Overall data review qualifier for an associated Text 5 initial calibration verification. 49 DVQualInitialCalibration Data review qualifier for an associated initial Text 5 VerificationRRF calibration verification relative response factor outlier. 50 DVQualInitialCalibration Data review qualifier for an associated initial Text 5 VerificationPD calibration verification percent difference outlier. 51 DVQualCCV Overall data review qualifier for associated Text 5 continuing calibration outliers. 52 DVQualContinuingCalibration Data review qualifier for an associated Text 5 VerificationRRF continuing calibration relative response factor outlier. 53 DVQualContinuingCalibration Data review qualifier for an associated Text 5 VerificationPD continuing calibration percent difference outlier. 54 DVQualOverall Overall data review qualifier for all QC and Text 7 calibration qualifiers. 55 TagLabSampleID (see comment) Temporary placeholder. Text 5 56 TagDetQual01 (see comment) Temporary placeholder. Text 5 57 TagNonDetQual01 (see comment) Temporary placeholder. Text 5 58 TagDetQual02 (see comment) Temporary placeholder. Text 5 59 TagNonDetQual02 (see comment) Temporary placeholder. Text 5 60 surDVQualDet (see comment) Temporary placeholder. Text 5 61 surDVQualNonDet (see comment) Temporary placeholder Text 5 62 DVQualInstrumentPerformance Data review qualifier for GC/MS Tune outlier Text 5 CheckRunBatch related to initial calibration. 63 DVQualInstrumentPerformance Data review qualifier for GC/MS Tune outlier Text 5 CheckAnaBatch related to continuing calibration. 64 DVQualIPC Overall data review qualifier for GC/MS tune Text 5 outliers. Page 2 of 5

Post Review EDD Export Specifications - Analytical Results (A1) Comma Delimited Text File Field Field Order Field Name* Field Description Type Length 65 DVQualLabDup Data review qualifier for RPD outlier in Text 5 laboratory duplicate. 66 DVQualCode User-defined Reason Code Text 15 67 FieldDupRPD RPD calculated from Field duplicate and parent Text 50 sample 68 DVQualMergedQualifier Merged lab and data review qualifiers Text 7 69 DVQualMergedResult Final result (modified concentration if Text 10 applicable) DVQualPercMoi 1 70 Data review qualifier for percent moisture Text 5 DVQualLabDupNR 1 71 Data review qualifier for laboratory duplicate not Text 5 reported DVQualLcsNR 1 72 Data review qualifier for laboratory control Text 5 sample(s) not reported DVQualDissTotDiff 1 73 Data review qualifier for dissolved and total Text 5 fraction differing by more than 10% 74 Error Radiochemistry error Text 10 DVQualSampleDupCount 1 75 Data review qualifier for sample count being Text 5 >20 in a duplicate batch DVQualMsSampleCoun 1 t 76 Data review qualifier for sample count being Text 5 >20 in a matrix spike batch DVQualLcsCount 1 77 Data review qualifier for sample count being Text 5 >20 in a laboratory control sample batch DVQualMbMissing 1 78 Data review for missing method blank Text 5 DVQualPercMoiDissTotDiff 1 79 Combined data review qualifier for percent Text 5 moisture and total vs dissolved difference outliers DVQualInternalStandard 2 80 Data review qualifier for internal standard outlier Text 5 DVQualCalibrationBlank 2 81 Data review qualifier for calibration blank Text 5 contamination DVQualRcm 2 82 Data review qualifier for resolution check Text 5 mixture problem DVQualPem 2 83 Data review qualifier for performance evaluation Text 5 mixture problem DVQualProfessionalJudgement 2 84 Data review qualifier for any reason deemed Text 5 necessary by data-review chemist Comment: Fields that contain temporary placeholders hold information contributed during the review process that is used in generating reports. This information is kept with the output file so that if the file is ever imported back into the application, reports can be generated without having to rerun the review module. * Field Names in bold font are added to the EDD during review and included in the exported validated EDD file 1 Data review qualifiers in these cases are added as applicable by automated data review if the option for EPA Region II assessment is selected.. 2 Data review qualifiers in these cases are added manually by the user and not assessed by automated data review. Page 3 of 5