(EDF) 1.2a
Contents
1. 3 4 NPDLQC Quality Control File The quality assurance information in the NPDLQC file is associated with an analytical result contained in the NPDLRES file The NPDLQC records will contain information on blanks spikes duplicates and standard reference materials No calculated results are required for this file All quality assurance calculations are performed by the database receiving the electronic deliverable Quality assurance samples are entered into the NPDLQC file based upon the quality assurance batch LABLOTCTL with which they are associated The LABLOTCTL allows the environmental samples to be grouped with their quality control samples in order to evaluate the quality of the analytical results The LABLOTCTL is an arbitrary number assigned by the laboratory to represent a group of samples prepared together sharing the same quality assurance samples Table 4 on page 15 23 presents the NPDLQC file structure and field attributes A populated NPDLQC file is available in the binder pocket NPDLQC FILE Guidelines and Restrictions e MATRIX LABCODE LABLOTCTL ANMCODE PARLABEL QCCODE and LABQCID comprise the primary key e All spiked or split samples and all laboratory generated quality control samples need to be entered into this file e All quality assurance data from subcontracted laboratories must be entered into this file EDF 1 2a Rev 4 04 17 2000 NPDLOC FIELD Guidelines and Restrictions e MATRIX LABCODE OC2. AII fields reguire values The LABCODE LOGCODE and MATRIX fields reguire valid value entries Refer to Appendix A for valid value codes The LABCODE field reflects the laboratory that received the sample and is responsible for generating the electronic deliverable 3 2 NPDLTEST Test Data File The NPDLTEST file contains information concerning the analytical test associated with the sample Each time a test is performed that results in usable data a test record is generated Five fields LOGDATE LOGTIME LOGCODE SAMPID and LABCODE from the NPDLSAMP file are carried over to the NPDLTEST file Most of the information in the NPDLTEST file can be located at the top portion of a standard laboratory bench sheet Table 2 on page 15 20 presents the NPDLTEST file structure and attributes A populated NPDLTEST file is available in the binder pocket NPDLTEST FILE Guidelines and Restrictions MATRIX LABCODE LABSAMPID QCCODE ANMCODE EXMCODE ANADATE EXTDATE and RUN_NUMBER comprise the primary key Each NPDLTEST record must have a corresponding NPDLRES record All sample types must be entered into this file NPDLTEST FIELD Guidelines and Restrictions EDF 1 2a The LABCODE LOGCODE MATRIX QCCODE ANMCODE EXMCODE BASIS PRESCODE SUB and LNOTE fields require valid value entries Refer to Appendix A for valid value codes Modified parameter list MODPARLIST requires a T entry true if a parameter from the USACE approved
3. DILUTION FACTOR N10 3 Numeric factor indicating level of sample dilution CONTROL LIMIT REVISION DATE D8 The date the control limit is established STANDARD REFERENCE MATERIAL C12 A code identifying the source of the reference material for the calibration method LABORATORY NOTES C20 Analytical notes providing descriptive information Rev 4 04 17 2000 22 TABLE 4 NPDLQC FILE INFORMATION FIELD NAME MATRIX LABCODE LABLOTCL ANMCODE PARLABEL QCCODE LABQCID LABREFID EXPECTED UNITS EDF 1 2a DEFINITION MATRIX C2 The medium or make up of the sample LABORATORY C4 The code identifying the laboratory receiving the sample LABORATORY CONTROL NUMBER C10 A unique number identifying a group of samples prepared together sharing the same quality assurance information ANALYTICAL METHOD CODE C7 The code identifying the analytical method used to perform the analysis PARAMETER CODE C12 The code assigned to the measurement parameter QUALITY CONTROL CODE C3 The code identifying laboratory generated quality control samples LABORATORY QUALITY CONTROL SAMPLE IDENTIFICATION C12 The laboratory assigned sample identification number for a quality control sample e g MS MSD LCS LCSD This number is equivalent to the LABSAMPID LABORATORY REFERENCE IDENTIFICATION C12 The laboratory assigned reference sample identification number EXPECTED PARAMETER VALUE N14 4
4. The target result for a quality control sample or surrogate spike UNITS OF MEASURE C10 Units of measure used to report a result Rev 4 04 17 2000 23 TABLE 5 NPDLCL FILE INFORMATION FIELD NAME DEFINITION LABCODE LABORATORY C4 The code identifying the laboratory performing the analysis MATRIX MATRIX C2 The medium or make up of the sample ANMCODE ANALYTICAL METHOD CODE C7 The code identifying the analytical method of analysis EXMCODE EXTRACTION METHOD CODE C7 The code identifying the extraction method of analysis PARLABEL PARAMETER CODE C12 The code assigned to the measurement parameter CLREVDATE CONTROL LIMIT REVISION DATE D8 The date a control limit is established CLCODE CONTROL LIMIT CODE C6 The code identifying the type of quality control limit UPPERCL UPPER CONTROL LIMIT N4 The upper control limit of a quality control criterion LOWERCL LOWER CONTROL LIMIT N4 The lower control limit of a quality control criterion EDF 1 2a Rev 4 04 17 2000 24 TABLE 6 VALUES USED FOR ENTRY OF QUALITY CONTROL SAMPLES C Sample Type Matrix CCode Expected Blank Spike xQ BS1 Amount added Blank Spike Duplicate BD1 Amount added Lab Blank xQ LB1 0 Lab Matrix Spike Actual MS1 Amount added amount in original sample Lab Matrix Spike Duplicate Actual Amount added amount in original duplicate sample Lab Replicate Actual Concentration amount in the
5. one determination for each analytical method report the percent moisture results PARLABEL and PARVAL within the analytical method for that particular ANMCODE Note Not all analytical methods require percent moisture determinations When entering surrogates and internal standards use the units of measure given below QUALIFIER UNITS SU PERCENT IN PERCENT EDF 1 2a Rev 4 04 17 2000 12 5 FILE RECORD AND DATA FIELD REQUIREMENTS File record and data field reguirements identified below must be strictly followed in order to generate acceptable electronic deliverables 5 1 File and Record Reguirements Each line of data is eguivalent to a single record in the data submission Each record is made up of distinct fields of information A record must not be dependent on another record or field for data Valid data must be entered in each record Listed below are the ASCII file and record specifications for entering each record of data in its specified file e Do not enter the column heading or field name in the ASCII file This information is not part of the file Only authorized codes from the valid value list should be keyed into fields reguiring valid values e Do not create left margins In each file every record starts in the farthest left position of position number 1 If entering the data via a spreadsheet set the left margin at zero and the right margin at the end position of the last field of the record The first rec
6. EP Toxicity Test W A C F L N T E EDF 1 2a Rev 4 04 17 2000 If a sample preparation includes a leaching procedure the EXMCODE assigned to the sample is not the leachate method but the preparation procedure listed in the analytical method that has been performed on the leachate 4 3 CLCODE The guality control limit file is used to transfer the guality control limits associated with a given result The EDF provides a mechanism for identifying the type of control limit associated with a given result In order to define the type of control limit used to validate the data a CLCODE needs to be assigned CLCODEs are assigned based upon the type of quality assurance sample being analyzed as well as the system of validation being used 4 4 EXMCODE There are five categories to differentiate the extraction or digestion procedure used in the analysis of a sample They are e NONE Selected when no extraction procedure is used or called for in the analytical method Examples include determinations such as pH temperature percent moisture etc e METHOD Most commonly used with EPA drinking water procedure or laboratory modified methods where the extraction procedure is directly specified within the analytical method e DI Sample is directly injected into the instrument e Specific EPA methods Documented published methods for which a code exists in the EXMCODE valid value list e Field Preparation For Method AK101 Gas
7. It is conceivable that a sampling technician may assign sample numbers seguentially starting over with the number one at each site There are many instances of MW 1 i e a sample from monitoring well 1 having been assigned to a variety of separate sites Certainly this does not represent a unique sample identifier However given the frequency of use it would seem to have universal appeal The information carried in the site related fields in the NPDLTEST file will EDF 1 2a Rev 4 04 17 2000 allow the EDF to distinguish among samples collected from different sites yet having been assigned the same sample number The NPDLRES file contains information on results generated by the laboratory The NPDLTEST file relates to the NPDLRES file through lab sample ID and analytical information There is also a one to many relationship between the NPDLTEST file and the NPDLRES file as noted above i e there can be more than one result generated for a test Each NPDLRES record contains information from a specific result The NPDLQC file contains data relating to laboratory quality control samples Each quality control sample is identified as belonging to a particular quality control batch which serves to relate the NPDLOC and NPDLTEST files However the actual result for a quality control sample and its related reference sample 1 e the original sample of a duplicate or a spike is stored in the NPDLRES file The NPDLCL file contains da
8. REP DATE Report Date Date that the laboratory generates the hard copy report The format for this field is YY YYMMDD D8 REPDL Reported Detection Limit The detection limit reported by the laboratory to determine whether a parameter is detectable N9 4 REPDLVO Reported Laboratory Detection Limit Qualifier A qualifier used to define the type of detection limit that the laboratory is reporting 4 e practical quantitation limits instrument detection limits etc Refer to Appendix A for valid value codes C3 RT Retention Time Retention time of a TIC It is reported in minutes N7 2 RUN_NUMBER Run Number This field permits the numerical coding of multiple or repeat analyses of a sample one LABSAMPID by the same analytical method N2 SAMPID Field Assigned Sample Number The number assigned during sample collection in the field C25 SRM Standard Reference Material Code identifying source of reference material for calibration standard confirmation Refer to Appendix A for valid value code descriptions C12 SUB Subcontracted Field identifying the subcontracted laboratory C4 UPPERCL Upper Control Limit The upper limit of a quality control acceptance criterion Enter relative percent difference and percent difference limits into the UPPERCL N4 UNITS Units The units of measure used to report a result e g for soil or for water Refer to Section 4 8 for field guidelines and descripti
9. air or MX multiple phases 4 6 PARVA Gualifier The PARVO field may be used in several ways The field is most commonly used with qualified results Standard analytical results will be qualified with or ND The PARVO field may also be used to identify a special type of parameter such as a tentatively identified compound TD surrogates SU or internal standards IN And last the PARVO field may be used to indicate that data is not usable for a given parameter such as NR for Not Reported 4 7 PVCCODE The PVCCODE distinguishes between primary and confirmatory results PVCCODEs are used to report supporting gas chromatography GC confirmation information used to verify compound identification The confirmation results are entered using the first column 1C second column 2C and Gas Chromatography Mass Spectroscopy MS PVCCODEs For example if the sample is confirmed using the first column 1C is entered into the PVCCODE field of the confirmation result The primary result PVCCODE PR will be assigned to the column result in which the laboratory places the most confidence The primary result will generally be assigned to the first column results 4 8 QCCODE The OCCODE field provides a means by which the type of sample can be distinguished Standard field samples are assigned a OCCODE of CS Tests performed on spiked field samples are assigned QCCODEs of MS or SD Tests performed on replicates of a field sample are assig
10. the laboratory physically assumes custody of the sample CHAIN OF CUSTODY NUMBER C16 The number assigned to the chain of custody BASIS C1 Wet or Dry Basis for Soil Samples This field is also used to indicate filtration and leaching procedures PRESERVATIVE CODE C15 The code identifying the type of preservative added to the sample SUBCONTRACTED LABORATORY C4 The LABCODE of the subcontracted laboratory Rev 4 04 17 2000 20 TABLE 2 NPDLTEST FILE INFORMATION CONTINUED REP DATE REPORT DATE D8 The date of the laboratory report LAB REPNO LABORATORY REPORT NUMBER C20 The laboratory assigned number uniguely identifying the hard copy report APPRVD APPROVED BY C3 The initials of the individual approving the laboratory report LNOTE LABORATORY NOTES C20 Analytical notes providing descriptive information EDF 1 2a Rev 4 04 17 2000 21 TABLE 3 NPDLRES FILE INFORMATION FIELD NAME MATRIX LABCODE LABSAMPID QCCODE ANMCODE EXMCODE PVCCODE ANADATE RUN_NUMBER PARLABEL PARVAL PARVO LABDL REPDL REPDLVO PARUN UNITS RT DILFAC CLREVDATE SRM LNOTE EDF 1 2a DEFINITION MATRIX C2 The medium or make up of the sample LABORATORY C4 The code identifying the laboratory receiving the sample LABORATORY SAMPLE IDENTIFICATION C12 The identification number assigned to a sample by the laboratory performing the analyses OU
11. time that the sample is collected SAMPLE COLLECTION COMPANY C4 The company that collected the sample or performed the field test FIELD ASSIGNED SAMPLE NUMBER C25 The number assigned to the sample at the time of collection MATRIX C2 The medium or make up of the sample LABORATORY C4 The code identifying the laboratory receiving the sample LABORATORY SAMPLE IDENTIFICATION C12 The unique identification number assigned to the sample by the laboratory QUALITY CONTROL CODE C3 The code identifying laboratory generated quality control samples All samples require a QCCODE ANALYTICAL METHOD CODE C7 The code identifying the analytical method of analysis MODIFIED PARAMETER LIST L1 A database field indicating whether the parameter list of an analytical method has been modified EXTRACTION METHOD CODE C7 The code identifying the extraction or digestion method used during sample preparation LABORATORY CONTROL NUMBER C10 A number identifying a group of samples prepared together sharing the same quality assurance information EXTRACTION LABORATORY LOT NUMBER obsolete field ANALYSIS DATE D8 The date the sample aliquot extract digest and or leachate is analyzed EXTRACTION DATE D8 The date the sample is prepared or extracted RUN_NUMBER N2 The numeric code distinguishing multiple or repeat analysis of a sample one SAMPID by the same method RECEIVED DATE D8 The date that
12. ALITY CONTROL CODE C3 The code identifying laboratory generated guality control samples ANALYTICAL METHOD CODE C7 The code identifying the analytical method of analysis EXTRACTION METHOD CODE C7 The code identifying the extraction or digestion method PRIMARY VALUE CODE C2 The code identifying whether a sample result is a primary or a confirmatory value ANALYSIS DATE D8 The date the sample aliquot extract digest and or leachate is analyzed RUN NUMBER N2 The numeric code distinguishing multiple or repeat analysis of a sample by the same method PARAMETER LABEL C12 The parameter label associated with a given parameter PARAMETER VALUE N14 4 The analytical value for a compound or analyte PARAMETER VALUE QUALIFIER C2 A code for qualifying analytical results i e greater than equal to etc METHOD DETECTION LIMIT N9 4 The laboratory established method detection limit REPORTED DETECTION LIMIT N9 4 The detection limit reported by the laboratory to determine whether a parameter is detectable REPORTED DETECTION LIMIT QUALIFIER C3 A code identifying the type of reporting limit i e practical quantitation limit instrument detection limit etc PARAMETER UNCERTAINTY N12 4 The uncertainty associated with a test result UNITS C10 The units of measure used to report a result RETENTION TIME N7 2 The retention time of a tentatively identified compound TIC
13. CODE ANMCODE PARLABEL and UNITS fields require valid value entries Refer to Appendix A for valid value codes e The valid value entered into the OCCODE field is the OCCODE of the LABOCID sample e The EXPECTED value is the expected result of the LABQCID sample i e the EXPECTED field result for a matrix spike is the value of the spike plus the value of the original sample LABREFID e Enter spaces into the EXPECTED field for laboratory generated blanks QCCODEs LB and RS e Enter spaces into the LABREFID field for laboratory generated blanks reference materials calibration standards and spiked blanks QCCODEs LB RS RM KD IC CC BS and BDF e LABCODE reflects the laboratory that receives the sample even if the sample has been subcontracted out 3 5 NPDLCL Quality Control Limit File This data file contains control limit information concerning the quality control result The file does not have to be revised unless new control charts are generated However for tracking purposes it must be submitted with each digital deliverable Table 5 on page 15 24 presents the NPDLCL file structure and field attributes NPDLCL FILE Guidelines and Restrictions e MATRIX LABCODE ANMCODE EXMCODE PARLABEL CLCODE and CLREVDATE comprise the primary key e All results with associated quality control criteria must have an associated entry in this file NPDLCL FIELD Guidelines and Restrictions e MATRIX LABCODE C
14. ELECTRONIC DELIVERABLE FORMAT EDF VERSION 1 2a May 1997 Prepared by Arsenault Associates Inc 9600 Main Tree Drive Anchorage Alaska 99516 phone 907 346 3827 fax 907 346 1577 information Oarsenault com TABLE OF CONTENTS FIELD DEFINITIONS AND ATTRIBUTES 15 TABLES 19 1 INTRODUCTION The Electronic Deliverable Format EDF is a relational database organized to facilitate the transfer of data files from the laboratory to the end user This structure is loosely based on the Air Force Center for Environmental Excellence AFCEE Installation Restoration Program Information Management System IRPIMS incorporating similar data file organization and utilizing many IRPIMS field definitions and valid value codes However the EDF contains many fields and data files that have no IRPIMS counterparts Moreover occasionally EDF applies the IRPIMS valid value codes in a more restrictive fashion Therefore while IRPIMS provided a design model for the EDF IRPIMS guidelines and documentation do not directly apply to the resultant EDF Reference to IRPIMS has been maintained throughout this document in efforts to assist and facilitate transition to the EDF for those laboratories currently familiar with the preparation of IRPIMS deliverables 2 DATABASE DESCRIPTION The EDF is a relational database consisting of five files related to one another through key fields Three of the files NPDLSAMP NPDLTEST and NPDLRES will be fami
15. LABDL REPDL REPDLVO PARUN UNITS RT DILFAC CLREVDATE SRM LNOTE MATRIX LABCODE LABLOTCTL ANMCODE PARLABEL OCCODE LABOCID LABREFID EXPECTED UNITS LABCODE MATRIX ANMCODE EXMCODE PARLABEL CLREVDATE CLCODE UPPERCL LOWERCL 21 START END 1 232 3 6 7 18 19 21 22 28 29 35 36 37 38 45 46 47 48 59 60 73 76 84 85 93 94 96 97 108 109 118 119 125 126 135 136 143 144 155 156 175 1 2 3 6 7 16 17 23 24 35 36 38 39 50 51 62 63 76 77 86 1 4 5 6 7 13 14 20 21 32 33 40 41 46 47 50 51 54 Rev 4 04 17 2000
16. LCODE ANMCODE EXMCODE and PARLABEL fields require valid value entries Refer to Appendix A for valid value codes e Use UPPERCL for relative percent difference RPD and upper recovery limit entries EDF 1 2a Rev 4 04 17 2000 e Enter spaces into LOWERCL for RPD e The LABCODE field reflects the laboratory that performed the analysis 1 e if a sub contracted laboratory performed the analysis the LABCODE would be the valid value for the sub contracted laboratory 3 6 NPDLNARR Narrative File The NPDLNARR file provides a means to transfer descriptive information about analyses that do not easily fit in a standardized format This file does not require a specific format but should be delivered as an ASCII file A populated NPDLNARR file is available in the binder pocket 4 VALID VALUE GUIDELINES AND RESTRICTIONS Choosing the correct valid values for many of the valid value fields requires little interpretation as they are only abbreviations of common and proper names However there are several valid values that must be applied within a group of specific guidelines The following section details these guidelines 4 1 ANMCODE Samples are assigned an analytical method using the ANMCODE field Although many of the analytical methods are similar compound lists are often slightly different 1 e SW8260 and E524 2 Each ANMCODE implies a specific list of analytes refer to Appendix B These analytes must all be reported or the lis
17. ber assigned to the chain of custody C16 DILFAC Dilution Factor Numeric factor indicating level of sample dilution N10 3 EXLABLOT Extraction QC Lot Number An obsolete field into which spaces need to be entered C10 EXMCODE Extraction Method A code showing the method that was used to extract or prepare a sample for analysis Refer to Section 4 3 for field guidelines and restrictions and Appendix A for valid value codes C7 EXTDATE Extraction Date The date a sample is extracted or prepared for analysis The format of this field is YY Y YMMDD D8 EXPECTED Expected Value The target result for a quality control sample Samples that are reported in units of PERCENT have expected values of 100 N14 4 LABCODE Laboratory A code identifying the analytical laboratory Refer to Appendix A for valid value code descriptions C4 EDF 1 2a Rev 4 04 17 2000 15 LABDL Detection Limit The laboratory established method detection limit i e the minimum detectable concentration of an analyte that can be measured and reported with 99 confidence that the analyte concentration is different from a blank for a given matrix This limit must be adjusted for dilution The LABDL field may or may not contain the same value as the REPDL field depending on the reporting format of the individual laboratory Regardless the laboratory must enter a value into LABDL unless the parameter is a tentatively identified compound
18. cific diskette Write protect all disks before submittal Provide a hard copy of the laboratory report Include an EDCC Error Report with each submittal Rev 4 04 17 2000 14 FIELD DEFINITIONS AND ATTRIBUTES ANADATE Analysis Date The date a sample or extract is analyzed The date format for this field is YYYYMMDD D8 ANMCODE Analytical Method The code identifying the method of analysis by which the sample was analyzed Refer to Section 4 1 for field guidelines and descriptions and Appendix A for valid value codes C7 APPRVD Approved By Initials of the individual approving the laboratory report C3 BASIS Basis Identifies the basis W wet D dry F field filtered L lab filtered or N not filtered on which analytical results are reported for all matrices This field is also used to indicate leaching procedures Refer to page 15 9 for codes C1 CLCODE Control Limit Code The code identifying the type of quality control limits CLCODEs are assigned based upon the type of quality assurance sample as well as the source of validation criteria Refer to Section 4 2 for field guidelines and descriptions and Appendix A for valid value codes C6 CLREVDATE Control Limit Revision Date The date that the control limit is established The format of this field is YY Y YMMDD D8 CNTSHNUM Control Sheet Number USACE assigned administration number C12 COCNUM Chain of Custody Number The num
19. compounds analyzed within a method as listed in SW 846 L1 NPDLWO Work Order Number Administrative number assigned by the USACE C7 PARLABEL Parameter Label The parameter label is the code assigned to a measurement parameter The code is generally a common acronym representing the parameter or analyte The PARLABEL is used in the database instead of the full analyte name to reduce the error inherent in transferring large names with numbers commas and spaces Refer to Appendix A for valid value codes C12 PARUN Parameter Uncertainty The analytical uncertainty associated with a laboratory result This field is present only for radiochemical results For all other analytes enter a zero N12 4 PARVAL Parameter Value This field represents the actual analytical value for a compound or analyte It is the result generated after a sample has been analyzed or a test performed For parameter results not calculated due to multiple runs or if the analyte is below the LABDL enter a zero into this field N14 4 PARVO Parameter Value Qualifier A code qualifying the analytical result The parameter value qualifier is designed to describe to what the analytical value is equivalent i e not detected equals to or not reported These codes also identify TICs and surrogates Refer to Section 4 5 for field guidelines and descriptions and Appendix A for valid value codes C2 PRESCODE Preservative Added Code This is the code
20. econd column confirmation Results and detection limits are to be adjusted for dilution prior to data entry Dilution adjustments are the only calculations necessary prior to entering values into the format All other quality control calculations will be performed in the database receiving the electronic deliverable Note The exception to this is surrogates which must be reported in PERCENT Table 3 on page 15 22 presents the NPDLRES file structure and field attributes A populated NPDLRES file is available in the binder pocket NPDLRES FILE Guidelines and Restrictions e MATRIX LABCODE LABSAMPID OCCODE ANMCODE EXMCODE PVCCODE ANADATE PARLABEL and RUN_NUMBER comprise the primary key e Each NPDLRES record must have a corresponding NPDLTEST record e All sample types must be entered into this file EDF 1 2a Rev 4 04 17 2000 NPDLRES FIELD Guidelines and Restrictions e MATRIX LABCODE OCCODE ANMCODE EXMCODE PVCCODE PARLABEL PARVQ REPDLVO UNITS SRM and LNOTE fields require valid value entries Refer to Appendix A for valid value codes e LABCODE reflects the laboratory that receives the sample e RUN NUMBER should have a value of one or greater e Values less than detection must have a PARVQ of ND e Multiple LNOTEs may be entered into the LNOTE field separated by commas If the test does not require qualification spaces may be entered into this field e Enter blank spaces into the CLREVDATE field for environ
21. identifying the type of chemical preservative added to the sample This code only applies to the chemical additives holding temperature and container selection is assumed to be within EPA guidelines unless otherwise identified in the LNOTE field More than one PRESCODE may be entered into this field Use commas to separate multiple code entries If the sample is not chemically preserved enter spaces into this field Refer to Appendix A for valid value code descriptions C15 PROJNAME Corps of Engineers Project Name USACE assigned project name C25 EDF 1 2a Rev 4 04 17 2000 17 PVCCODE PVC Code This allows the coding of Gas Chromatography or Gas Chromatography Mass Spectroscopy results to show whether the reported result was obtained from a primary or a confirmatory analysis Methods or analytes not reguiring confirmation and requiring only one analysis run should be reported with the PVCCODE of PR Refer to Section 4 6 for field guidelines and descriptions and Appendix A for valid value codes C2 OCCODE Ouality Control Code A code identifying the sample type 1 e field samples or laboratory generated guality control samples Refer to Section 4 7 for field guidelines and description Appendix A for valid value codes or Table 6 page 15 25 for further clarification C3 RECDATE Date Laboratory Received Sample Date that the laboratory physically takes custody of the sample The format of this field is YYYYMMDD D8
22. liar to those with IRPIMS experience These files include most of the mandatory IRPIMS fields with the exception of the site and boring information which for EDF has been replaced by SAMPID for ease of laboratory use as well as additional fields to collect non IRPIMS information required by the U S Army Corps of Engineers USACE The remaining two files NPDLQC and NPDLCL containing QC and control limit information respectively do not have IRPIMS equivalents The structure of each of these files is discussed below The NPDLSAMP file contains site and administrative information concerning field samples Most of the information in this file should be available on the chain of custody form The NPDLTEST file containing information regarding analytical tests performed on samples is related to the NPDLSAMP file by sample collection information and field sample number There is a one to many relationship between the NPDLSAMP file and the NPDLTEST file Meaning one record in the NPDLSAMP file can link to many NPDLTEST records The files are linked through a group of fields that are the same in each file These fields collectively are called the primary key and make the records unigue One may envision that the sample collection information is unnecessary in the NPDLTEST file and that the field sample identification should be sufficient to link the NPDLSAMP file to the NPDLTEST file However not all consultants provide unigue field sample numbers
23. mental samples QCCODE of CS or NC laboratory generated blanks QCCODE of LB or RS and non spiked parameter results except for surrogate results PARVO of SU e Enter zero into the LABDL and REPDL fields for parameters with units of PERCENT e Blank spaces are entered into the EXPECTED field for all environmental sample results For spiked samples enter the AMOUNT OF THE SPIKE PLUS THE SAMPLE VALUE in this field For non spiked samples enter the value expected into this field i e for a distilled water blank enter zero e CLREVDATE requires an entry for the following OCCODEs MS SD BS BD RM KD LR IC CC e CLREVDATE requires an entry for PARVQs SU and IN Field Guidelines and Restrictions for Surrogate Compounds e SU needs to be entered into the PARVO field e The units of a surrogate record need to be PERCENT e Enter 100 into the EXPECTED field EDF 1 2a Rev 4 04 17 2000 Field Guidelines and Restrictions for Tentatively Identified Compounds TICs e TI needs to be entered into the PARVO field e Chemical Abstract Service CAS numbers may be used FOR TICs ONLY instead of valid value PARLABELs to identify the parameter being reported It is recommended that TICs without CAS numbers have PARLABEL valid values e TIC entry does not require a LABDL or REPDL entry Additionally not applicable NA may be entered into the REPDLVO and SRM fields e Retention Time RT is a recommended entry field for TIC results
24. ned codes of LR All other available QCCODEs are assigned to laboratory generated quality assurance samples with the exception of the NC code that identifies non client samples that have been included in the database to provide quality assurance information QCCODEs follow a form of alphanumeric coding where in most cases the first two characters define the type of sample and the third character is for sequential numbering For example if two laboratory blanks were associated with an analytical batch the first blank would be assigned the QCCODE of LB1 and the second blank prepared would be assigned the OCCODE of LB2 EDF 1 2a Rev 4 04 17 2000 11 4 9 UNITS The codes for units can be found in the UNITS valid value list Blank spikes blank spike duplicates matrix spike and matrix spike duplicates must be expressed in absolute units For all analytes reporting as PERCENT enter zero into the LABDL field and REPDL fields and NA into the REPDLVO field When entering percent moisture and solids data use the PARLABEL and the unit of measure given below PARLABEL UNITS SOLIDVOA PERCENT MOIST PERCENT SOLID PERCENT SS per unit volume TDS per unit volume TSO per unit volume TVS per unit volume If soil samples are expressed on a dry weight basis then percent moisture must be reported and detection limits should be provided on a dry weight basis Whenever multiple percent moisture determinations have been performed on a sample i e
25. oline Range Organics refer to the COELT User s Manual Version 1 2a May 1997 page 5 31a for details 4 5 MATRIX Laboratory generated quality assurance samples using only laboratory reagents are assigned quality control matrix codes such as WQ water quality control matrix for a blank spike The use of Q matrix codes is recommended for data that will be converted into IRPIMS formats but is not required Laboratory generated samples which use the original environmental sample matrix are assigned the MATRIX valid value code that describes the original sample matrix rather than the quality assurance sample matrix e g a matrix spiked waste water sample would be assigned WW waste water rather than WQ water quality control matrix Refer to Table 6 on page 15 25 for matrix valid values associated with quality control samples EDF 1 2a Rev 4 04 17 2000 10 When the laboratory is not completely informed about the exact sample matrix it should enter the more general MATRIX codes such as WX This indicates that the sample is an agueous matrix but does not specify the water source 1 e it is not specifically understood to be waste water More specific valid value codes such as WW should be assigned only when there is sufficient information to do so 1 e the sample origin is actually known If the laboratory is unsure of the exact sample matrix they should use the following codes SX soil WX water TX tissue AX
26. ons and Appendix A for valid value codes C10 EDF 1 2a Rev 4 04 17 2000 18 TABLE 1 NPDLSAMP FILE INFORMATION FIELD NAME VVL DEFINITION LOCID LOCATION C10 The location from which the sample is collected LOGDATE SAMPLE COLLECTION DATE D8 The date that the sample is collected LOGTIME SAMPLE COLLECTION TIME C4 The time that the sample is collected LOGCODE SAMPLE COLLECTION COMPANY C4 The company that collected the sample or performed the field test SAMPID FIELD ASSIGNED SAMPLE NUMBER C25 The number assigned to the sample at the time of collection MATRIX MATRIX C2 The medium or make up of the sample PROJNAME PROJECT NAME C25 USACE assigned project name NPDLWO WORK ORDER NUMBER C7 USACE assigned administrative number CNTSHNUM CONTROL SHEET NUMBER C12 An administrative number assigned by the USACE LABCODE LABORATORY C4 The code identifying the laboratory receiving the sample EDF 1 2a Rev 4 04 17 2000 19 TABLE 2 NPDLTEST FILE INFORMATION FIELD NAME LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX LABCODE LABSAMPID QCCODE ANMCODE MODPARLIST EXMCODE LABLOTCTL EXLABLOT ANADATE EXTDATE RUN_NUMBER RECDATE COCNUM BASIS PRESCODE SUB EDF 1 2a DEFINITION LOCATION C10 The location from which the sample is collected SAMPLE COLLECTION DATE D8 The date that the sample is collected SAMPLE COLLECTION TIME C4 The
27. or has units of PERCENT N9 4 LABLOTCTL Lab QC Lot Number A unique number identifying an autonomous batch or group of environmental samples prepared together and sharing the same quality control within the same time period This group is equivalent to the EPA SW 846 concept of a Quality Assurance Batch C10 LABOCID Laboratory QC Sample ID The laboratory assigned QC sample ID number All quality assurance samples are entered into this field including laboratory generated samples blanks and laboratory control samples as well as environmental samples that have been altered by the laboratory matrix spike This field requires unique laboratory assigned sample identifiers C12 LABREFID Laboratory Reference Sample ID The reference sample is the sample upon which the quality control sample is referenced in order to calculate the quality assurance result A reference sample is used in conjunction with a quality control sample LABQCID to determine precision and accuracy C12 LAB_REPNO Laboratory Report Number Laboratory assigned number uniquely identifying the hard copy report C20 LABSAMPID Lab Sample ID The unique identification number assigned to a sample by the laboratory doing the testing C12 LNOTE Laboratory Notes These are data qualifiers describing various observations and difficulties with the analysis associated with a test or analyte Multiple data qualifiers may be entered into this field se
28. ord or row in the file and every subsequent record or row must contain valid data Blank or empty rows lines or records are not allowed in ASCII files e Every record within a file must be unique If for each key field a record s data appears exactly the same in another record these two records are considered to be duplicate records Do not enter data that refers to another record Data formats attributes must be strictly followed Valid data must be entered for every field Do not add delete or otherwise omit any fields Data fields in a file are limited to a certain number of spaces and the data must be in a specific position Character data must be left justified within a field Numeric data must be right justified within a field If the information to be entered is shorter than the field width insert blank spaces in the field s remaining positions If the data to be entered is longer than the allowed field width the data must be shortened to a unique identifier or significant value The start and end position numbers indicate the exact character locations where the applicable data must be placed in the file refer to Table 7 on page 15 26 There are some cases where the field is a single character wide It therefore will have the same start and end position number The single character of data must be put in that position of the record EDF 1 2a Rev 4 04 17 2000 13 5 2 Diskette Submittal Data disks are submitted on a
29. original sample Reference Material xQ Amount present in reference material Reference Material Duplicate Amount present in reference material duplicate Continuing Calibration xQ CC1 Amount added Initial Calibration xQ IC1 Amount added Note x Use of WQ SQ AQ or TO for aqueous solid gaseous and tissue quality control samples is recommended for data that will be converted from EDF to IRPIMS but is not required EDF 1 2a Rev 4 04 17 2000 29 TABLE 7 DATA FIELD POSITIONS POSITION NPDLSAMP NPDLTEST EDF 1 2a FIELD LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX PROJNAME NPDLWO CNTSHNUM LABCODE LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX LABCODE LABSAMPID OCCODE ANMCODE MODPARLIST EXMCODE LABLOTCTL EXLABLOT ANADATE EXTDATE RUN NUMBER RECDATE COCNUM BASIS PRESCODE SUB REP DATE LAB REPNO APPRVD LNOTE 26 START END 1 10 11 18 19 22 23 26 27 51 52 53 54 78 79 85 86 97 98 101 1 10 11 18 19 22 23 26 27 51 52 53 54 57 58 69 70 72 73 79 80 80 81 87 88 97 98 107 obsolete 108 115 116 123 124 125 126 133 134 149 150 150 151 165 166 169 170 177 178 197 198 200 201 220 Rev 4 04 17 2000 TABLE 7 DATA FIELD POSITIONS continued POSITION NPDLRES NPDLOC NPDLCL EDF 1 2a FIELD MATRIX LABCODE LABSAMPID OCCODE ANMCODE EXMCODE PVCCODE ANADATE RUN NUMBER PARLABEL PARVAL PARVO
30. parameter list Appendix B is not reported The parameter list is not considered modified if extra parameters are reported LABSAMPID must be unique RUN_NUMBER should have a value of one or greater Rev 4 04 17 2000 e Multiple PRESCODEs may be entered into the PRESCODE field separated by commas If the test sample was not preserved spaces may be entered in this field e Multiple LNOTEs may be entered into the LNOTE field separated by commas If the test does not reguire gualification spaces may be entered into this field e LABLOTCTL must uniquely distinguish a group of samples that are prepared together e LABCODE reflects the laboratory that first receives the sample e Enter a LABCODE other than NA in the SUB field if the lab performing the analysis is not the laboratory that received the sample NA must be entered into this field unless the test is subcontracted out Additional LABCODEs are available upon request e Blank spaces are entered in the LOCID LOGDATE LOGTIME SAMPID LOGCODE LAB_REPNO REP_DATE and COCNUM fields for laboratory generated and NC samples e Enter spaces into the APPRVD field for NC samples 3 3 NPDLRES Results Data File The NPDLRES data file contains information concerning analytical results generated by the laboratory Each record contains a parameter result Parameter results are coded using the PVCCODE to distinguish whether they are primary results or supporting analytical data 1 e s
31. parated by commas For laboratory data without qualifiers spaces may be entered into this field Refer to Appendix A for the valid value code descriptions C20 LOCID Location Identification This is a unique identifier assigned to a specific point location where measurements or samples are taken C10 LOGCODE Logging Company A code identifying the company responsible for the collection of samples or the performing of field tests environmental sampling information Refer to Appendix A for valid value code descriptions C4 LOGDATE Log Date This is the date that a sample is collected The format of this field is YYYYMMDD D8 EDF 1 2a Rev 4 04 17 2000 16 LOGTIME Sample Collection Time The time that an environmental sample is collected The format of this field is a 24 hour military clock HHMM C4 LOWERCL Lower Control Limit The lower limit of a quality control acceptance criterion Enter spaces into this field for relative percent difference N4 MATRIX Matrix A code identifying a sample s medium or makeup e g soil water air etc Refer to Section 4 4 for field guidelines and descriptions Appendix A for valid value codes or Table 6 page 15 25 for further clarification C2 MODPARLIST Modified Parameter List A field indicating whether the compound list of a method has been amended If the parameter list is modified enter T true into this field A modification indicates the deletion of
32. per laboratory report basis Hence as a laboratory report is completed and converted into the electronic deliverable format it then must be processed for submittal The submittal process is outlined below EDF 1 2a Copy files onto an MS DOS formatted disk Check the consistency of the file formats by loading them into the Electronic Deliverable Consistency Checker EDCC The EDCC is a stand alone software program that checks each data submission for the proper EDF format warns the user of potential formatting problems and reports the results of the consistency check The EDF deliverable that does not pass the EDCC will not be accepted Each of the five files must be named exactly as specified in this document e NPDLSAMP TXT NPDLTEST TXT NPDLRES TXT NPDLQC TXT and NPDLCL TXT Try to place all five files associated with one laboratory report on a single diskette If the files are too large compress each file individually with PKZIP 2 04g and attempt to place all of the compressed files onto one diskette Note if the files are compressed they must be delivered with a ZIP file extension The files then would be named NPDLSAMP ZIP NPDLTEST ZIP NPDLRES ZIP etc Use multiple diskettes only if all five of the compressed files will not fit on a single diskette Each diskette must be externally labeled with the laboratory name date the Report Number the Work Order Number and the names of the files supplied on that spe
33. t must be indicated as modified by entering true T into the modified parameter list field MODPARLIST of the NPDLTEST file The fuel methods are groups of methods that generally do not have well defined parameter lists Since data comparability is difficult without fuel parameter lists the USACE has established the following lists EDF 1 2a Rev 4 04 17 2000 Fuel Method List Code AK101 AK102 AK103 AKD AKG CENPD Parlabel GRO DRO RRO DRO GRO DIESEL2 GASOLINE KEROSENE OILM JETFUEL BUNKERC OTHERS PHC GRO DRO DIESEL2 DIESEL2 DIESEL2 DIESEL2 GASOLINE Name Gasoline Range Organics Diesel Range Organics Residual Range Organics Diesel Range Organics Gasoline Range Organics Diesel Fuel 2 Gasoline Kerosene Oil Misc Jet Fuel Bunker C Others Petroleum Hydrocarbons TPH418 1 Gasoline Range Organics Diesel Range Organics Diesel Fuel 2 Diesel Fuel 2 Diesel Fuel 2 Diesel Fuel 2 Gasoline If a fuel parameter does not match the USACE designated parameter for a given method use an appropriate LNOTE or enter a T into the MODPARLIST field 4 2 BASIS The Basis field is used to indicate wet or dry weight filtration and leaching procedures and is coded as follows J Dry Wet Air California Waste Extraction Test WET Title 22 of CAC Field Filtered Lab Filtered Not Filtered SW Method 1311 Toxicity Characteristic Leaching Procedure SW Method 1310A Extraction Procedure
34. ta associated with analytical control limits Each record contains control limit information for a parameter analyzed by a particular analytical method The NPDLCL file and the NPDLRES file are related through the analytical method parameter and control limit revision date collectively 3 FILE FORMATS AND RESTRICTIONS The following sections describe the format and restrictions associated with each of the five EDF data files 3 1 NPDLSAMP Sample Data File The purpose of the NPDLSAMP file is to track the administrative and site information associated with a sample For every field generated sample entering the laboratory one record will be added to this file Most of the information in this file should be available on the chain of custody form and is to be entered exactly as it appears on that form Table 1 on page 15 19 presents the NPDLSAMP file structure and field attributes A populated NPDLSAMP file is available in the binder pocket NPDLSAMP FILE Guidelines and Restrictions e LOCID LOGDATE LOGTIME LOGCODE SAMPID MATRIX and LABCODE comprise the primary key e Non Client NC and laboratory generated quality assurance samples prepared in the laboratory are not to be entered into this file NC samples are samples that do not originate from a client s sites but were used to generate quality assurance results for a client s group of samples CS EDF 1 2a Rev 4 04 17 2000 NPDLSAMP FIELD Guidelines and Restrictions
Download Pdf Manuals
Related Search