SWRCB Geotracker – ESI Compliance management Solutions
(949) 732-0084

How To Create and Upload an EDF to Geotracker?

Instructions For Creating an EDF Upload File

  1. To create a valid EDF upload you must create several text documents and zip them up into a single file for uploading.
  2. There are two ways of creating the ZIP file for uploading an EDF File (see detailed instructions below)
  3. Each file in the uploaded zip, except the narrative, must be in either FIXED-LENGTH or CSV format.
  4. Once you have all the files, zip them together using a program like winzip. The Geotracker EDF uploading system will only accept ZIP files.
  5. Click here to download an example of a properly made EDF upload. The files are in FIXED-LENGTH format.
  6. Plesae make sure to Delete the first row of the spreadsheet if it contains the column headings. Column headings are not allowed in the submitted file.
  7. Once you have a ZIP file with all the necessary files in it you are ready to upload.

EDF Creation – Option One (most common)

    • A Quality Control Limits file with the name: EDFCL.TXT – This file contains control limit information concerning the QC results.
    • A Quality Control file with the name: EDFQC.TXT – This file contains the quality assurance information associated with the results file
    • A Results file with the name: EDFRES.TXT – This file contains the analytical results generated by the laboratory
    • A Sample file with the name: EDFSAMP.TXT – This file contains the administrative information associated with sampling points
    • A Test file with the name: EDFTEST.TXT – This file contains information concerning the analytical test associated with the sample

The tables below contain field information guidelines for EDF Creation – Option One
 

QUALITY CONTROL LIMITS FILE FIELD GUIDELINES (EDFCL.TXT)

A Quality Control Limits file with the name: EDFCL.TXT

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-4 LABCODE YES The code identifying the laboratory that analyzes the sample
2 5-6 MATRIX YES The code identifying the sample matrix as determined by the laboratory
3 7-13 ANMCODE YES The code identifying the method of analysis
4 14-20 EXMCODE YES The code identifying the method of preparation
5 21-32 PARLABEL YES The code or CAS number identifying the analyte
6 33-40 CLREVDATE YES The date a control limit is established
7 41-46 CLCODE YES The code identifying the type of a quality control limit
8 47-50 UPPERCL YES The upper control limit of a quality control criterion
9 51-54 LOWERCL NO The lower control limit of a quality control criterion
10 55-294 (PROCEDURE_NAME) NO The method title as defined by the analysis laboratory
11 295-319 (LAB_METH_GRP) NO The unique identifier for a group of methods as defined by the laboratory
12 320-344 (METH_DESIGN_ID) NO The unique identifier for the design of an analytical method
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

———

QUALITY CONTROL FILE FIELD GUIDELINES (EDFQC.TXT)

A Quality Control file with the name: EDFQC.TXT
This file contains the quality assurance information associated with the results file

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-2 MATRIX YES The code identifying the sample matrix as determined by the laboratory
2 3-6 LABCODE YES The code identifying the laboratory that analyzes the sample
3 7-16 LABLOTCTL YES The unique identifier for a preparation and handling batch
4 17-23 ANMCODE YES The code identifying the method of analysis
5 24-35 PARLABEL YES The code or CAS number identifying the analyte
6 36-38 QCCODE YES The code identifying the type of sample
7 39-50 LABQCID YES The unique identification number assigned to the sample by the laboratory
8 51-62 LABREFID YES The laboratory sample ID of the quality control sample
9 63-76 EXPECTED YES The target result for a quality control sample or surrogate spike
10 77-86 UNITS YES The units for the parameter value measurement
11 87-326 (PROCEDURE_NAME) NO The method title as defined by the analysis laboratory
12 327-351 (LAB_METH_GRP) NO The unique identifier for a group of methods as defined by the laboratory
13 352-376 (METH_DESIGN_ID) NO The unique identifier for the design of an analytical method
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

——–

RESULTS FILE FIELD GUIDELINES (EDFRES.TXT)

A Results file with the name: EDFRES.TXT
This file contains the analytical results generated by the laboratory

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-2 MATRIX YES The code identifying the sample matrix
2 3-4 LABCODE YES The code identifying the laboratory that analyzes the sample
3 7-18 LABSAMPID YES The unique identification number assigned to the sample by the laboratory
4 19-21 QCCODE YES The code identifying the type of sample
5 22-28 ANMCODE YES The code identifying the method of analyzis
6 29-35 EXMCODE YES The code identifying the method of preparation
7 36-37 PVCCODE YES The code identifying whether a sample result is a primary or a confirmatory value
8 38-45 ANADATE YES The date the sample is analyzed
9 46-47 RUN_NUMBER YES The numeric code distinguishing multiple or repeat analysis of a sample by the same method on the same day
10 48-59 PARLABEL YES The code or CAS number identifying the analyte
11 60-73 PARVAL YES The analytical value for a compound, analyte, or physical parameter
12 74-75 PARVQ YES The code identifying the qualifier of an analytical result
13 76-84 LABDL NO The laboratory-established method detection limit
14 85-93 REPDL NO The laboratory-established method detection limit, adjusted for the particular sample preparation
15 94-96 REPDLVQ YES The code identifying the type of reporting limit
16 97-108 PARUN NO The uncertainty of a measured value due to a measuring technique
17 109-118 UNITS YES The units for the parameter value measurement
18 119-125 RT NO The retention time of a tentatively identified compound (TIC), reported in minutes
19 126-135 DILFAC YES The numeric factor indicating the level of sample dilution
20 136-143 CLREVDATE NO The date a control limit is established
21 144-155 SRM YES The code identifying the standard reference material used in the analysis
22 156-175 LNOTE NO The code identifying notes pertaining to analytical performance irregularities that apply to a single analyte
23 176-415 (PROCEDURE_NAME) NO The method title as defined by the analysis laboratory
24 416-440 (LAB_METH_GRP) NO The unique identifier for a group of methods as defined by the laboratory
25 441-465 (METH_DESIGN_ID) NO The unique identifier for the design of an analytical method
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

————

SAMPLE FILE FIELD GUIDELINES (EDFSAMP.TXT)

A Sample file with the name: EDFSAMP.TXT
This file contains the administrative information associated with sampling points

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-10 LOCID YES The Unique identifier for the samples location.
2 11-18 LOGDATE YES The Date a field sample is collected
3 19-22 LOGTIME YES The time a filed sample is collected (24-hour miltary time)
4 23-26 LOGCODE YES The code identifying the company collecting the sample
5 27-51 SAMPID YES The unique identifier representing a sample
6 52-53 MATRIX YES The code identifying the sample matrix as determined by the laboratory
7 54-78 PROJNAME YES The identification assigned to the project by the org. performing the work
8 79-85 LABWO YES A delivery order number associated with the contract
9 86-97 GLOBAL_ID YES The unique identifier for a regulated facility or site
10 98-101 LABCODE YES The code identifying the laboratory that analyzes the sample
11 102-126 (COOLER_ID) NO The unique identifier representing a cooler used to transport samples
12 152-153 (COC_MATRIX) NO The Code identifying the sample matrix as noted on the chain-of-custody
13 154-178 (DQO_ID) NO The unique identifier rpresenting the data quality objectives
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

———-

TEST FILE FIELD GUIDELINES (EDFTEST.TXT)

A Test file with the name: EDFTEST.TXT
This file contains information concerning the analytical test associated with the sample

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-10 LOCID NO The unique identidier for the samples location
2 11-18 LOGDATE YES The date a field sample is collected
3 19-22 LOGTIME YES The time that a field sample is collected, recorded using 24-hour military time
4 23-26 LOGCODE YES The code identifying the company collecting the samples or performing field tests
5 27-51 SAMPID YES The unique identifier representing a sample, assigned by the consultant, as submitted to the laboratory on a chain-of-custody
6 52-53 MATRIX YES The code identifying the sample matrix as determined by the laboratory
7 54-57 LABCODE YES The code identifying the laboratory that analyzes the sample
8 58-69 LABSAMPID YES The unique identification number assigned to the sample by the laboratory
9 70-72 QCCODE YES The code identifying the type of sample
10 73-79 ANMCODE YES The code identifying the method of analysis
11 80-80 MODPARLIST YES A field indicating whether the parameter list of an analytical method has been modified
12 81-87 EXMCODE YES The code identifying the method of preparation
13 88-97 LABLOTCTL YES The unique identifier for a preparation and handling batch
14 98-107 LCHMETH NO The code identifying the method of leaching performed
15 108-115 ANADATE YES The date the sample is analyzed
16 116-123 EXTDATE YES The date that a sample is prepared for analysis
17 124-125 RUN_NUMBER YES The numeric code distinguishing multiple or repeat analysis of a sample by the same method on the same day
18 126-133 RECDATE YES The date the sample is recieved by the laboratory doing the analysis
19 134-149 COCNUM NO The number assigned to the chain-of-custody
20 150-150 BASIS YES The code used to distinguish whether a sample is reported as dry or wet weight, filtered or not filtered
21 151-165 PRESCODE NO The code identifying the type of preservative added to the sample
22 166-169 SUB YES The code identifying the subcontracted laboratory
23 170-177 REP_DATE NO The date of the laboratory report
24 178-197 LAB_REPNO NO The unique identifier for the laboratory report, assigned by the laboratory
25 198-200 APPRVD NO The initials of the individual approving the laboratory report
26 201-220 LNOTE NO The code identifying notes pertaining to analytical performance irregularities that apply to the entire test
27 221-245 (REQ_METHOD_GRP) NO The unique identifier for the method or group of methods requested by the client for analysis of the sample
28 246-485 (PROCEDURE_NAME) NO The method title as defined by the analysis laboratory
29 486-510 (LAB_METH_GRP) NO The unique identifier for a group of methods as defined by the laboratory
30 511-535 (METH_DESIGN_ID) NO The unique identifier for the design of an analytical method
31 536-550 (CLEANUP) NO The code identifying the method of cleanup performed
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

———————————————————————————————————————————————————————————

EDF Creation – Option Two (less common)

  • A Flat file with the name: EDFFLAT.TXT – This file contains the analytical results generated by the laboratory, as well as the administrative information associated with the sampling points, and the quality insurance information.
  • A Quality Control Limits file with the name: EDFCL.TXT – This file contains control limit information concerning the QC results.

QUALITY CONTROL LIMITS FILE FIELD GUIDELINES (EDFCL.TXT)

A Quality Control Limits file with the name: EDFCL.TXT. This file contains control limit information concerning the QC results.
The table below contains field information guidelines for EDF Creation – Option One

  Field   Fixed-Length Pos.   Field Name   Required   Description
1 1-4 LABCODE YES The code identifying the laboratory that analyzes the sample
2 5-6 MATRIX YES The code identifying the sample matrix as determined by the laboratory
3 7-13 ANMCODE YES The code identifying the method of analysis
4 14-20 EXMCODE YES The code identifying the method of preparation
5 21-32 PARLABEL YES The code or CAS number identifying the analyte
6 33-40 CLREVDATE YES The date a control limit is established
7 41-46 CLCODE YES The code identifying the type of a quality control limit
8 47-50 UPPERCL YES The upper control limit of a quality control criterion
9 51-54 LOWERCL NO The lower control limit of a quality control criterion
10 55-294 (PROCEDURE_NAME) NO The method title as defined by the analysis laboratory
11 295-319 (LAB_METH_GRP) NO The unique identifier for a group of methods as defined by the laboratory
12 320-344 (METH_DESIGN_ID) NO The unique identifier for the design of an analytical method
NOTE: You cannot give NULL values for required fields
NOTE: Fields in parentheses can be omitted

To learn more about how to Manually prepare an EDF file, please refer to The Electronic Deliverable Format (EDF) Version 1.2i GUIDELINES & RESTRICTIONS and the The Electronic
Deliverable Format Training Manual (below)