######lab__REPORcolle_SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAMEtLABORATORY___ID_datedate_TIME_depth_EXTRACTION_analysis_METHODMETHOD--METHODstoreLR-LIMITlr-unitsRESULTSRESULlnoRES-UNITdilutdilutLQ1LQ2LQ3LQ4LQ5LQ6LQ7LQ8LQ9LQtORGINUSEABpComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______Comment The header line above may be copied and pasted into your text data file. Please use this to see if your format is accurate and the data elements are in straight lines top to bottom. Often the header line can help identify if a data element has a truncated leading zero for a month or day or some other imperfection. This will be noted as there are not straight lines for the data elements. When there is a format problem, you will find the elements are not in a staight line top to bottom. Find the ones out of place and evaluate the data element field lenght to see what may be amiss. Below is a key with the data elements in the header line identified above. Also there is information on the field length for the data element. If there are valid value or if a value must be captured in a reference table before use it will reference a reference table. The data elements and data records in the notepad or text file should line up under the header line. If it does not, check to see if there is an error in the data elements and record. Hopefully, the header line and the definitions for the data elements represented in the header line will help ensure accurate and complete text file submittals. Please remove the header line before transmitting the file to ADEQ or placement in the Uploaded File List table in the database. Let us know of any questions or suggestions for improvement. ###### = ADEQ Well number (field length 6 characters - left justified blanks spaces make up unpopulated character spaces) lab__ = Lab Name* (field length 5 characters - left justified Use license code. Code for the laboratory conducting the analysis. In most instances this should be the lab license code. Truncate the A and use Z####. This is for the lab doing the analysis not first receiving the samples REPOR = reporting agency code same as source agency code - Who paid for water quality sample to be collected organizationally or consultant firm (field length 5 characters - valid values see REF_AGENCY - left justified blanks spaces make up unpopulated character spaces) colle = collecting agency code same as source agency code - Who took collected water quality sample organizationally/consulting firm (field length 5 characters - valid values see REF_AGENCY - left justified blanks spaces make up unpopulated character spaces) _SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAME_SAMPLE_NAME = Sample ID aka Sample identifier given by the sampler (usually name for sample on chain of custody form (field length 60 characters - left justified blanks spaces make up unpopulated character spaces) t = Sample type Type of sample collected. Note the new look up (usually name for sample on chain of custody form (field length 15 characters - left justified blanks spaces make up unpopulated character spaces) table has F for field conditions and P for physical, 0 for physical duplicate and Q for physical split. see older WQR227-2 lookup table. (field length 1 - populate with single character code) LABORATORY___ID = Lab ID* aka Sample identifier assigned by the lab. _datedate_ = mm/dd/yyyy Sample Date aka Date of Water Quality Sample collection (field length 10 characters - 01/31/2020 example - must include leading zeros -left justified blanks spaces make up unpopulated character spaces) TIME = time - 24 hour or miltary time (e.g. 1330) (field length 4 characters - 0001 to 2359 hhmm hh 0-23 mm 0-59 left justified blanks spaces make up unpopulated character spaces) _depth_ = #.# number value only Sample Depth aka the depth to the intake of the pump, the depth to the sample collection opening on the bailer, or the depth to the center of a passive diffusion bag sampler or a depth specific sampling device. (field length 7 characters - left justified blanks spaces make up unpopulated character spaces) EXTRACTION = mm/dd/yyyy Extraction Date aka Date of laboratory extraction of sample (field length 10 characters - 01/31/2020 example - must include leading zeros -left justified blanks spaces make up unpopulated character spaces) _analysis_ = mm/dd/yyyy Analysis Date aka Date of laboratory analysis of sample (field length 10 characters - 01/31/2020 example - must include leading zeros -left justified blanks spaces make up unpopulated character spaces) METHODMETHOD--METHOD = Method Name - pull from ADHS Active Lab Info File for date of analysis. (field length 20 characters - EPA 8260C example - must include leading zeros -left justified - blanks spaces make up unpopulated character spaces) store = STORET aka STTORET Code- Include leading zeros in STORET code. A STORET code is a numeric ID number for analytes based on media & analysis type (field length 5 characters - 00010 example - must include leading zeros -left justified blanks spaces make up unpopulated character spaces - usually includes 5 characters) LR-LIMIT = Lab Reporting Limit* aka Lab reporting limit of the analyte. Lab Reporting Limit Units must also be filled in. May change depending on what lab achieves. (field length 8 characters - 0.1 example - must include leading zeros -left justified blanks spaces make up unpopulated character spaces) lr-units = Lab Reporting Limit Units* aka Units in which limits are detected. Must be included with Lab Reporting Limit field. (field length 8 characters must be from reference table values - left justified blanks spaces make up unpopulated character spaces) RESULTSRESUL = Results aka Sample result. Must be numeric value or null value only. (field length 12 characters must be number or blank spaces - left justified blanks spaces make up unpopulated character spaces) lno = Lab Notation aka The laboratory notation of a result value. This may include ND, "not detected"; LT, "Less Than", NR, "Not Reported", GT, "Greater Than", or PR, "Presence" or a null value (blank spaces) RES-UNIT = Result Units aka Sample Result Units must be valid values only when there are numeral results. (field length 8 characters must be from reference table values - left justified blanks spaces make up unpopulated character spaces) dilutdilut = Dilution* aka Dilution factor for the analysis, if any. If no dilution was applied, enter a “1”. The dilution factor field can accept real numbers including numbers less than 1 for concentration of metals or other samples. LQ1 = Arizona Data Qualifier1* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ2 = Arizona Data Qualifier2* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ3 = Arizona Data Qualifier3* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ4 = Arizona Data Qualifier4* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ5 = Arizona Data Qualifier5* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ6 = Arizona Data Qualifier6* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ7 = Arizona Data Qualifier7* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ8 = Arizona Data Qualifier8* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQ9 = Arizona Data Qualifier9* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character space) LQt = Arizona Data Qualifier10* aka Arizona Data Qualifiers are reported on lab sheets by the analyzing laboratory. Arizona Data Qualifiers provide an additional description about the result. (field length 3 characters - example R1 - must be Arziona Data Qualifiers from reference table values - left justified blank space if needed makes up unpopulated character spacs) ORGIN = Originator Usability Code (similar to Colle and Repor) Name of agency/consulting firm that created Usability code to be used/reported to ADEQ. see Reference table Usability Type - (field length 5 characters - valid values see REF_AGENCY - left justified blanks spaces make up unpopulated character spaces) USEAB = Usability Code aka Usability Code Reported – see Reference table Usability Type (field length 5 characters - valid values see Reference table Usability Type - left justified blanks spaces make up unpopulated character spaces) p = This data element is for ADEQ Use only. populate with blank space - (field length 1 characters - fill with blank space) Comment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______CommentComment______Comment No Guidance for comment. Add any comment up to 1000 characters. However, all other data records in the data file with this comment must also end on the same position as the record with the comment. You may want to have a data file for records with comments and then a separate no comment data submittal due to lenght of data line issues.