PWS Attachment B Lab Electronic Data Deliverable Specification.pdf

Laboratory Electronic Data Deliverable Specification

June 14, 2024

Data from the laboratory.

FieldName Data Type VVL? Required?

Column Width

Start Position

End Position Description

DISTID varchar True Yes 5 1 5 District identification is the unique 5 letter code used to represent the individual USACE FUDS Districts. This code always starts with US followed by the three letter district code listed on the dropdown in the upper left that allows the user to choose their district upon logging in.

LOCID varchar False Conditional 15 7 21 Location Identification is the unique identifier assigned to a location within a project where measurements or samples are taken.

LOGDATE varchar False Conditional 11 23 33 The date that the groundwater was collected.The format for this field is [DD-MMM- YYYY] where YYYY is the calendar year, MMM is the abbreviated month and DD is the numeric date.

LOGTIME varchar False Conditional 4 35 38 The time of the day (24 hour clock) that a sample is collected, a field measurement is made, or a quality control sample is created.

This value is expressed in the HHMM format of the Local Time.

MATRIX varchar True Yes 2 40 41 Sampling Matrix is a coded value identifying the specific sample medium actually being analyzed. I.e., soil, water, drill cuttings, waste water, etc.

SBD numeric False No 8 43 50 Sample Beginning Depth is the upper depth in feet from the ground surface or the water surface at which a sample is collected or recovered.

SED numeric False No 8 52 59 Sample Ending Depth is the lower depth in feet from the ground surface or the water surface at which a

SACODE varchar True Yes 2 61 62 Sample Code is a coded value identifying whether the sample is a QC or normal.

SAMPNO int False Yes 2 64 65 Sample Number is the numerical identifier for the sample taken.

LOGCODE varchar True No 4 67 70 Logging Company Code is the coded value identifying the company performing the field tests.

SMCODE varchar True No 2 72 73 Sample Method Code is a coded value identifying the sampling method used to collect a sample.

FLDSAMPID varchar False Yes 30 75 104 Field Sample Identification is a unique number assigned to the sample in the field. This number will be a reference to the specific sample regardless of the sample date or location.

COCID varchar False No 12 106 117 Chain of Custody Identification is a unique identification reference to the chain of custody describing the transport of the sample to the laboratory.

COOLER varchar False No 2 119 120 Cooler Number is the unique number assigned to the cooler transporting the sample.

ABLOT varchar False No 8 122 129 Ambient Blank Field Lot Identifier is used to link the lot of normal samples (collected in the field) to the corresponding ambient blank. There will only be an entry for normal samples that are associated to an ambient blank. This field in the sample record for the ambient blank itself will be left blank. The format for the Ambient Blank Field Lot Identifier is [DDMMYYNN] where DD is the numeric date, MM is the number for the month, YY is the last two digits of the calendar year, and NN is the sequentially assigned number for the lot.

EBLOT varchar False No 8 131 138 Equipment Blank Field Lot Identifier is used to link the lot of normal samples (collected in the field) to the corresponding equipment blank.

There will only be an entry for normal samples that are associated to an equipment blank. This field in the sample record for the equipment blank itself will be left blank. The format for the Equipment Blank Field Lot Identifier is [DDMMYYNN] where DD is the numeric date, MM is the number for the month, YY is the last two digits of the calendar year, and NN is the sequentially assigned number for the lot.

TBLOT varchar False No 8 140 147 Trip Blank Field Lot Identifier is used to link the lot of normal samples (collected in the field) to the corresponding trip blank. There will only be an entry for normal samples that are associated to a trip blank. This field in the sample record for the trip blank itself will be left blank. The format for the Trip Blank Field Lot Identifier is [DDMMYYNN] where DD is the numeric date, MM is the number for the month, YY is the last two digits of the calendar year, and NN is the sequentially assigned number for the lot.

REMARKS varchar False No 240 149 388 Contains comments about the sample.

SDG varchar False No 20 390 409 A lab created code used to identify a group or selection of samples. The SDG is used for processing and reporting accuracy by labs. This value is included in a prime project file for integrity references.

LABCODE varchar True Yes 4 411 414 Analytical Laboratory Code is a coded value identifying the laboratory which performed the analysis of the samples.

ANMCODE varchar True Yes 7 416 422 Analytical method code is a coded value representing the method of analyses of a given parameter.

EXMCODE varchar True Yes 7 424 430 Extraction Method Code is a coded value representing the method used to extract or prepare a sample.

LCHMETH varchar True Yes 7 432 438 Leachate Method is a coded value identifying the leachate method used in the test.

RUN_NUMBER int False Yes 2 440 441 This information is stored in the test procedure class and is replaced by the use of test sequence.

LABSAMPID varchar False Yes 20 443 462 Lab Sample Identification is a unique number assigned to a sample by a laboratory and included in the reporting of the results. This number is the prime number that the Lab will use to reference a specific sample for tests and results.

EXTDATE varchar False Conditional 11 464 474 Extraction Date is the data that represents the start of an extraction test or other preparation methods. The format is [DD-MMM-YYYY] where YYYY is the calendar year, MM is the numeric month and DD is the numeric date.

EXTTIME varchar False Conditional 4 476 479 Extraction Time is the time of day (24 hour clock) that represents the start of an extraction test or other preparation methods. This value is expressed in HHMM of the local time.

LCHDATE varchar False Conditional 11 481 491 Leachate Date is the date on which a sample was leached. The format is [DD-MMMYYYY] where YYYY is the calendar year, MM is the numeric month and DD is the numeric date.

LCHTIME varchar False Conditional 4 493 496 Leachate Time is the time of day (24 hour clock) that represents the time a sample was leached.

This value is expressed in HHMM of the local time.

LCHLOT varchar False Conditional 10 498 507 Leachate Lot is the batch designator of an autonomous group of environmental samples and associated quality control samples leached together.

ANADATE varchar False Yes 11 509 519 Analysis Date is a date that represents the start of a test or procedure. The Date represents the date the sample or extraction is analyzed in the laboratory.The format is [DD-MMM-YYYY] where YYYY is the calendar year, MMM is the abbreviated month and DD is the numeric date.

ANATIME varchar False Yes 4 521 524 Analysis Time is the time of day (24 hour clock) that represents the datart of a test or procedure.

This value is expressed in HHMM of the local time.

ANALOT varchar False Yes 10 526 535 Analysis Lot is the batch designator of an autonomous group of environmental samples and associated quality control samples analyzed together.

LABLOTCTL varchar False Yes 10 537 546 Lab Lot Control is a more general identifier to indicate extractions or other preparation methods during the testing process.

CALREFID varchar False No 10 548 557 Calibration Reference Identification is a coded value which establishes a reference link between environmental and quality control samples and their corresponding calibration records.

RTTYPE varchar True No 5 559 563 Remediation Technology Type is a coded value describing the type of remediation technology being used. This value is the coded value for remediation technology like slurry wall, in situ vitrification, bio-reactor, etc.

BASIS varchar True Yes 1 565 565 Basis is a coded value detailing whether tissue or solid sample results are reported on a wet

(W) or dry (D) basis.

PARLABEL varchar True Yes 12 567 578 Parameter Label Code is an abbreviated, common acronym representing a parameter/analyte.

PRCCODE varchar True Yes 3 580 582 Parameter Class Code is a coded value identifying a class or group that a parameter is associated with. I. e., ORG, MET, STD, etc.

PARVQ varchar True Yes 2 584 585 Parameter Value Qualifier is a coded value qualifying the analytical results field (Parameter Value). Note that in general, this field does not indicate QC failures or deficiencies such as accuracy, precision, blank contamination, or holding time violations.

PARVAL numeric False Yes 17 587 603 Parameter value is the value of a calculated parameter reported in units consistent with the Units field.

PARUN numeric False Conditional 13 605 617 Parameter Uncertainty is a value which measures the uncertainty of the measurement.

This value is expressed as positive (+) or negative (-) some value.

PRECISION_ int False Yes 1 619 619 Precision is number indicating the number of digits after the decimal point of the results.

EXPECTED float False Conditional 17 621 637 Expected Result is a number indicating the target result for a quality control sample or surrogate spike.

EVPREC int False Conditional 1 639 639 Expected Value Precision is a number indicating the number of digits after the decimal point in the results of a test.

MDL numeric False Yes 17 641 657 Method detection limit is the smallest quantity of an analyte that can be detected from a prepared sample.

RL numeric False Yes 17 659 675 Reporting Limit is a number which is the smallest quantity of an analyte that should be reported in accordance with the QAPP.

UNITS varchar True Yes 10 677 686 The Units field refers to the units of measure used for the parameter value.

VQ_1C varchar True Conditional 2 688 689 1C Value Qualifier is a coded value qualifying the analytical results field.

VAL_1C numeric False Conditional 17 691 707 First Column Parameter Value is a number field which represents the primary or initial value for a analyte generated from a Gas Chromatography or Gas Chromatography/Mass Spectroscopy results.

FCVALPREC int False Conditional 1 709 709 First Column Value Precision is a number indicating the number of digits after the decimal point of the results of a test.

VQ_CONFIRM varchar True Conditional 2 711 712 Value Qualifying Confirmation is a coded value qualifying the confirming analytical result.

VAL_CONFIRM numeric False Conditional 17 714 730 Confirming Value is a number value of a chromatographic analytical result that requires second column confirmation.

CNFVALPREC int False Conditional 1 732 732 Confirmation Value Precision is a number indicating the number of digits after the decimal point of the results of a test.

DILUTION numeric False Yes 17 734 750 Dilution Required is a numeric expression of the amount of dilution required to bring the analyte concentration in the sample into analysis range.

PRIME_DQT varchar True No 5 752 756 Prime Data Qualifier Type is a coded value identifying the type of data qualifier that the prime used

PRIME_FLAG varchar True No 6 758 763 Prime Flags are codes that are assigned during chemistry data validation.

LAB_DQT varchar True No 5 765 769 Laboratory Data Qualifier Type is a coded value indicating the specific QAPP or DQO document from which the entered performance criteria data originates.

LAB_QC_FLAG varchar True Conditional 6 771 776 Laboratory Quality Control Flag is coded values entered by the laboratory to indicate the existence of a specific quality control exception or condition.

BEST_RESULT varchar False Yes 1 778 778 Best Result is a single value that has been determined to be the best result. I.e., the value reported in the prime contractor’s final report for the sampling event in focus. Appropriate Values are Y (Yes) or N (No)

REASON_CODE varchar False No 30 780 809 Reason Code is a coded value that indicates why a laboratory or contractor flag was issued to a data point.

PERCENT_RECOVERY numeric False Conditional 15 811 825 Percent Recovery is the calculated recovery value for the spiked or surrogate analyte. This value is expressed in percent plus 2 decimals.

RPD numeric False Conditional 15 827 841 Relative Percent Difference is a measure of variability that adjust for the magnitude of observations. This value is used to assess total and analytical precision of duplicate measurements.

UPPER_RPD numeric False Conditional 15 843 857 Upper Relative Percent Difference is a number representing the upper performance limit for relative percent difference.

UPPER_ACCURACY numeric False Conditional 15 859 873 Accuracy Upper Limit is a number representing the upper control limit of percent recovery as measured for a known target analyte spiked into a quality control sample.

LOWER_ACCURACY numeric False Conditional 15 875 889 Accuracy Lower Limit is a number representing the lower control limit of percent recovery as measured for a known target analyte spiked into a quality control sample.

SPIKE_ADDED numeric False Conditional 17 891 907 Spike Amount Added is a number value of a final concentration of an analyte spiked into a sample.

SPIKE_ADDED_PREC smallint False Optional 1 909 909 Spike Amount Added Precision is number indicating the number of digits after the decimal point of the spike added.

VALCODE varchar True No 4 911 914 Coded value identifying the company validating analytical results.

TIC_NAME varchar False No 54 916 969 Name of the Tentatively Identified Compound being reported.

RETENTION_TIME varchar False No 6 971 976 Retention time of a Tentatively Identified Compound.

LOD numeric False No 17 978 994 Limit of Detection

Valid values can be found on the project portal; navigate to Reports, ADR and Submission Reports, Valid Value Lists and select the field of interest from the dropdown menu.

Data Type Descriptions float A number in scientific notation containing a variable number of decimal places int An integer from -2,147,483,648 to 2,147,483,647 numeric A number containing a fixed number of decimal places smallint An integer from -32,768 to 32,767 varchar Text of variable length