Embed
Email

Activity

Document Sample

Shared by: qingyunliuliu
Categories
Tags
Stats
views:
10
posted:
11/18/2011
language:
English
pages:
110
No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type

1 ActivityID Client’s identifier for a sample. Yes Text(35) No • ActivityID cannot be null

• One distinct ActivityID for a given combination of: OrgID,

MonitoringLocationID, BeginCollectionDateTime, ActivityType, Depth,

Matrix, and LabSampleID.

• Length(ActivityID) ≤ 35

• Each ActivityID must be associated to a valid ProjectID. ActivityIDs

can be associated to more than one ProjectID.

• If a sample is analyzed as a lab replicate, matrix spike, or matrix

spike duplicate, append suffixes “DUP”, “MS”, and “MSD”

respectively. For Lab QC samples such as blanks and LCS enter the

LabSampleID in this field.

• Each ActivityID must be associated to a valid MonitoringLocationID if

ActivityType is not in ('Laboratory Control Sample', 'Laboratory

Control Sample Duplicate', 'Method Blank', 'Trip Blank', 'Surrogate',

'Field Blank', 'Lab Replicate')



2 BeginCollectionDateTIme The date and time the sample collection Conditional Date/Time No • Valid date/time value

began. • Correctly formatted according to configuration definition

• BeginCollectionDateTime is required except for ActivityType in

('Laboratory Control Sample', 'Laboratory Control Sample Duplicate',

'Method Blank', 'Trip Blank', 'Surrogate', 'Field Blank')



• Logical Order: BeginCollectionDateTime 0 if MonitoringLocationType 'Well'

• If TotalDepth = 0, then SampleDepth must = 0.









Activity Page 2

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type

10 SampleTopDepth A measurement of the upper vertical Conditional Number(12, 4) No • May not exist with SampleDepth

location of a vertical location range • Required if ActivityType is 'Sample-Integrated Vertical Profile'

(measured from a reference point) at • SampleTopDepth must be a number (12,4).

which an activity occurred. • SampleTopDepth > 0 if MonitoringLocationType 'Well'









11 SampleBottomDepth A measurement of the lower vertical Conditional Number(12,4) No • May not exist with SampleDepth

location of a vertical location range • Required if ActivityType is 'Sample-Integrated Vertical Profile'

(measured from a reference point) at • SampleBottomDepth must be a number (12,4).

which an activity occurred. • SampleTopDepth > 0 if MonitoringLocationType 'Well'

• Absolute Value (SampleTopDepth) 0 if MonitoringLocationTYpe 'Well'

sampling. • Absolute Value (SampleDepth) 0

15 PQL Practical quantitation limit for the Conditional Number(12,7) No • Required if AnalyteType in ('TRG', 'SPK') and AnalyteName is not

measured analyte. Also used as the on PQL exception list (TBD) and if ActivityType not in ('Field', 'Data

reporting limit Logger')

• PQL must be a number (12,7)

• MDL ≤ PQL

• PQL > 0



16 DetectionUnit Unit for the MDL and/or PQL Conditional Text (12) Yes • Required if MDL or PQL are provided.

• Must be null if MDL or PQL are blank.

• SVL check against WIN Domain List (TBD - expanded from ADaPT

list)

• Length (DetectionUnit) ≤ 7

• DetectionUnit, AnalyteName, Matrix, Method combination must

be valid.

17 QCSpikeAdded Value of spike or surrogate compound No Text(5) No • Length (QCSpikeAdded) ≤ 5 if reported

entered as a numeric character









Result Page 42

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



18 Error The two sigma error for Conditional Number(10) No • Required for radiochemistry result, spike, tracer or carrier

radiochemistry results. Do not enter records.

the “+” or “-“ character in this field • Numeric with length of 10 or less.



19 PercentMoisture Percent of sample composed of Conditional Number(10) No • PercentMoisture must be a number with length ≤ 10

water. Enter value for soil and • PercentMoisture is required if Matrix in ('SED-Fresh', 'SED-Saline',

sediments sample only. 'SOILS') and if Activity Type is not in ('Field', 'Data Logger')





20 PercentRecovery Percent recovery value of a spiked or Conditional Text(5) No • Required if LabApproved = 'Yes' and AnalyteType = “SURR”,

surrogate compound. If sample “SPK”, or “TRACER”

dilution yields no or very low recovery • Length (PercentRecovery) ≤ 5

enter “DIL”. If sample matrix • Numeric or “DIL”, “INT”, or “NS”

interference yields no recovery, enter

“INT”. If the spike or surrogate was

not added to a sample with

AnalyteType = “SPK” or “SURR”enter

“NS”.

21 RelativePercentDifference Relative percent difference between Conditional Number(5) No • RelativePercentDifference must be a number with length ≤ 5

two QC results • Required if LabApproved = 'Yes' and AnalyteType = “SPK” and

ActivityType in ('Laboratory Control Sample Duplicate', 'Matrix

Spike Duplicate', 'Lab Replicate')

22 ReceiptComments Information related to the samples Conditional Text (255) No • Required if PreservationIntact = “No”

received by the laboratory that is not • Length (ReceiptComments) ≤ 255

captured in other fields



23 ResultComments Free text with general comments Conditional Text(4000) No • Length (ResultComments) ≤ 4000

concerning the result. • ResultComments cannot be null if ValueQualifier contains a "J".









Result Page 43

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



24 ResultStatusIdentifier Status identifier for ResultValue Yes Text(5) Yes • ResultStatusIdentifer will be set to 'Final' when ADaPT

required by WQX to indicate (Generated) Reportable_Result = "YES" or Reportable_Result is not provided. If

acceptability of the result with Reportable_Result = "NO", ResultStatusIdentifier will be set to

respect to QA/QC criteria. "Preliminary".

• Length(ResultStatusIdentifier) ≤ 5







25 ResultValueTypeName A name that qualifies the process Conditional Text(20) Yes • Required if ResultValue is reported. Can be defaulted.

which was used in the determination • SVL check against WIN Domain List for ResultValueTypeName:

of the result value (e.g., actual, "Actual", "Calculated", "Control Adjusted", "Estimated"

estimated, calculated).

• Length(ResultValueTypeName) ≤ 20



26 StatisticalBase The code for the method used to No Text(25) Yes • Length (StatisticalBase) ≤ 13

calculate derived results. • SVL check against WIN Domain Values

27 LabID Identification of the laboratory Conditional Text (8) Yes • LabID is required when ActivityType not in ('Field', 'Data) Logger')

performing the analysis. Use DOH • SVL check against WIN Domain List (expand ADaPT list - TBD)

certification number if possible. • Length (LabID) ≤ 8

• LabID must exist in WIN through WIN Library Administrator.



28 AnalyticalMethodSource Identifies the source or data system Yes Text(120) Yes • AnalyticalMethodSource cannot be null

that created or defined the associated • Length(AnalyticalMethodSource) ≤ 120

AnalyticalMethodNumber (e.g., • SVL check against WIN Domain List (TBD)

USEPA, APHA, or Org_ID if method is • AnalyticalMethodSource must be set to OrgID if

not nationally recognized). AnalyticalMethodNumber does not exist in WQX Domain List

(Nationally Recognized).









Result Page 44

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



29 AnalyticalMethodNumber For lab data, the laboratory reference Yes Text(20) Yes • AnalyticalMethodNumber cannot be null

method number (e.g., 200.7). For • Length(AnalyticalMethodNumber) ≤ 20

field data, the method used in • AnalyticalMethodSource and AnalyticalMethodNumber

measuring field parameter (e.g., FT combination must be valid.

1600). • AnalyticalMethodSource and AnalyticalMethodNumber

combination must be valid for a particular analyte and ActivityType.



• AnalyticalMethodNumber must exist in WIN SVL (TBD) or be

added through WIN Library Administrator.



Additional WQX Rules:

• AnalyticalMethodName must be generated from

AnalyticalMethodSource and AnalyticalMethodNumber if

AnalyticalMethodSource/Number does not exist in WQX domain

list.

30 PrepMethodSource Identifies the source or data system Conditional Text(120) Yes • PrepMethodSource required for certain analytes (List TBD - SVOCs

that created or defined the associated and some others)

PrepMethodNumber (e.g., USEPA, • PrepMethodSource must be null for Field Activity Types.

APHA, or Org_ID if method is not • Length(PrepMethodSource) ≤ 120

nationally recognized). • PrepMethodSource must be set to OrgID if PrepMethodNumber

does not exist in WQX Domain List (Nationally Recognized).



• SVL check against WIN Domain List (expand ADaPT list - TBD)









Result Page 45

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



31 PrepMethodNumber The method used to prepare the Conditional Text(20) Yes • PrepMethodNumber required for certain analytes (List TBD -

sample. SVOCs and some others)

• PrepMethodNumber must be null for Field Activity Types.

• Length(PrepMethodNumber) ≤ 20

• PrepMethodNumber must exist in WIN SVL (TBD) or be added

through a WIN Library Administrator.

• PrepMethodSource and PrepMethodNumber combination must

be valid.

• PrepMethodSource and PrepMethodNumber combination must

be valid for a particular analyte and ActivityType.



Additional WQX Rules:

• PrepMethodName must be generated from PrepMethodSource

and PrepMethodNumber if PrepMethodSource/Number does not

exist in WQX domain list.



• When PrepMethodSource/Number are provided,

SampleContainerTypeName, SampleContainerColorName,

SampleTransportStorageDescription,

ChemicalPreservativeUsedName (or

ThermalPreservativeUsedName) will be set to 'Unspecified' (for

purposes of WQX submission).

32 PrepBatchID Unique laboratory identifier for a Conditional Text(13) No • Required if LabApproved = 'Yes' and ActivityType is not in ('Field',

batch of samples of similar matrix 'Data Logger')

prepared together for analysis by one • Length (PrepBatchID) ≤ 13

method and treated as a group for • Each distinct PrepBatchID for a method and matrix has records

method blank, LCS, and LCSD for the same method and matrix where ActivityType in ('Method

association. The PrepBatchID links Blank', 'Laboratory Control Sample')

method blanks and laboratory control • Each distinct PrepBatchID for a method and matrix for each MB

samples (LCS/LCSD) to associated and LCS contains one or more sample records with the same

samples. method, matrix, and PrepBatchID.









Result Page 46

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



33 MethodBatchID Unique laboratory identifier for a Conditional Text(13) No • Required if LabApproved = 'Yes' and ActivityType is not in ('Field',

batch of samples of similar matrix 'Data Logger')

analyzed by one method and treated • Length (MethodBatchID) ≤ 13

as a group for laboratory duplicate, • For non-metal inorganic methods, each distinct MethodBatchID

matrix spike, and matrix spike for a method and matrix has records reported where ActivityType =

duplicate association. The Matrix Spike and Lab Replicate

MethodBatchID links laboratory • For metals each distinct MethodBatchID for a method and matrix

duplicates, matrix spikes, and matrix has records reported where ActivityType = 'Matrix Spike' and

spike duplicates to associated 'Matrix Spike Duplicate' OR ActivityType = 'Matrix Spike' and 'Lab

samples. Replicate'

• For metals each distinct MethodBatchID for a method and matrix

has records reported where ActivityType = 'Matrix Spike' and

'Matrix Spike Duplicate' OR where ActivityType = 'Matrix Spike' and

'Lab Replicate'

• For organic methods each distinct MethodBatchID for a method

and matrix has records where ActivityType = 'Matrix Spike' and

'Matrix Spike Duplicate'

• Each MethodBatchID for a method and matrix has sample records

with the same method, matrix and MethodBatchID

34 LabSampleID Laboratory tracking number for field Conditional Text(50) No • Required if ActivityType is not in ('Field', 'Data Logger')

samples and laboratory generated QC • Length(LabSampleID) ≤ 35

samples

35 ShippingBatchID Unique identifier assigned to a cooler Conditional Text(25) No • Required if LabApproved = 'Yes' and if ActivityType in ('Field

or shipping container or group of Replicate', 'Lab Replicate', 'Matrix Spike', 'Matrix Spike Duplicate',

coolers or shipping containers that 'Sample', 'Sample-Integrated Cross-Sectional Profile','Sample-

links samples together. The Integrated Flow Proportioned', 'Sample-Integrated Horizontal

ShippingBatchID is provided by the Profile', 'Sample-Integrated Time Series', 'Sample-Integrated

client on the chain of custody. Vertical Profile', 'Trip Blank', 'Field Blank', 'Equipment Blank')



• Length (ShippingBatchID) ≤ 25









Result Page 47

No. WIN (Plain English) WIN Definition Required by WIN SVL WIN Minimum Standard Error Checks

Data Element Name WIN Data Type



36 LabReportingBatchID Laboratory identifier for a group of Conditional Text(13) No • Required if LabApproved = 'Yes' and ActivityType is not in ('Field',

samples and laboratory QC all 'Data Logger')

reported within one EDD or batch. • Length (LabReportingBatchID) ≤ 13

The LabReportingBatchID is

equivalent to the sample delivery

group, lab work number, login ID, etc.









Result Page 48

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



DISPLAY_NAME (in Text (60) Yes The name of the environmental CharacteristicName Text (120) Yes The object, property, or

TSRCHAR Table) characteristic as it is to be displayed on substance which is evaluated

windows and reports. or enumerated by either a

direct field measurement, a

direct field observation, or by

laboratory analysis of

material collected in the field.

NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH







VALUE_TEXT (in VALUE_TEXT: Yes The representation of the result of ResultMeasureValue Text (60) Conditional The reportable measure of

TSRRSULT Table). Text (15) analyzing, measuring, or observing a the result for the chemical,

Characteristic. NOTE: For "Not Reported" microbiological or other

results, characteristic being analyzed.

ResultDetectionConditionTe

xt field would be populated

and ResultMeasureValue

would be null.









Result Page 49

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



SHORT_FORM_NAME Text(10) Conditional The abbreviation for the name of the unit MeasureUnitCode Text(12) Conditional The code that represents the

(in TSRUOM Table) of measure. unit for measuring the

chemical substance,

microbiological substance or

other characteristic.



NO MATCH NO MATCH No NO MATCH SubstanceDilutionFactorNu Text(10) No The overall dilution of the

meric substance subjected to this

analysis.

Note: A value of "1"

corresponds to nominal

conditions for the method.

Values greater than one

correspond to dilutions.

Values less than one

correspond to concentrations.

NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









Result Page 50

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



SMPL_FRAC_TYPE_N Text(15) Conditional Description: The text name of the portion ResultSampleFractionText Text(25) Conditional The text name of the portion

M (in TSRRSULT table) of the sample associated with results of the sample associated with

obtained from a physically-partitioned results obtained from a

sample. Examples: - dissolved - physically-partitioned sample.

suspended - tot





NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









NO MATCH NO MATCH No NO MATCH PreparationStartDate Date: No The calendar date/time when

Time YYYY-MM- on which the

DD preparation/extraction of the

sample for analysis began.

Time:

hh:mm:ss









Result Page 51

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



ANALYSIS_DATE (in Date/Time No The date on which laboratory analysis of AnalysisStartDate Date: No The calendar date on which

TSRRSULT table) the sample for this particular result was Time YYYY-MM- the analysis began.

performed. DD



Time:

hh:mm:ss









MIN_DETECT_LIMIT Text(12) No Represents the least amount of the MeasureValue Text(12) No The reportable measure of

(in TSRDQL table) target substance which could be detected the result for the chemical,

by the instrument/analytical process microbiological or other

employed to determine the result. Above characteristic being analyzed.

this value the target substance is

presumed to be present.

MIN_QUANT_LIMIT Text(12) No Represents the least amount of the MeasureValue Text(12) No The reportable measure of

(in TSRDQL table) target substance which could be the result for the chemical,

quantified by the instrument/analytical microbiological or other

process employed to determine the characteristic being analyzed.

result. Values above the minimum and

below the maximum quantitation limits

are reported as valid numeric results.

SHORT_FORM_NAME Text(10) Conditional The abbreviation for the name of the unit MeasureUnitCode Text(12) Conditional The code that represents the

(in TSRUOM Table) of measure. unit for measuring the

chemical substance,

microbiological substance or

other characteristic.







NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









Result Page 52

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



PRECISION_AMT_TEX Text(12) No Estimate of the maximum possible error NO MATCH NO MATCH No NO MATCH

T (in TSRRSULT table) in the result. (e.g., Counting error in

determining radiological beta particle

counts.)

NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









BIAS (in TSRRSULT Text(60) No A consistent deviation of measured BiasValue Text(60) No The systematic or persistent

table) values from the true value, caused by distortion of a measurement

systematic errors in a procedure, as process which causes error in

determined by applying identical one direction.

procedures to a specimen of known

properties.









PRECISION_AMT_TEX Text(12) No Estimate of the maximum possible error PrecisionValue Text(60) No A measure of mutual

T (in TSRRSULT table) in the result. (e.g., Counting error in agreement among individual

determining radiological beta particle measurements of the same

counts.) property usually under

NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No prescribed similar conditions.

NO MATCH









DESCRIPTION_TEXT Text(254) No Text providing further description and ResultCommentText Text(4000) No Free text with general

(in TSMGNTXT table) comment on the detection and/or comments concerning the

quantitation limits, for example result.

"Instrument Detection Limit".









Result Page 53

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



VALUE_STATUS (in Text(1) Conditional Result value is either Preliminary or Final. ResultStatusIdentifier Text(12) Conditional Indicates acceptability of the

TSRRSULT table) This attribute will be used for query result with respect to QA/QC

purposes. Values marked as Preliminary criteria.

are not displayed for public access on

STORET Internet sites.







VALUE_TYPE_NAME Text(10) Conditional A name that represents the process ResultValueTypeName Text(20) Conditional A name that qualifies the

(in TSRRSULT table) which was used in the determination of process which was used in the

the result value(e.g., actual, estimated, determination of the result

calculated). value (e.g., actual, estimated,

calculated).



STATISTIC_TYPE_NM Text(18) No A statistic or calculation type which StatisticalBaseCode Text(25) No The code for the method used

(in TSRRSULT table) describes the reported result (e.g., to calculate derived results.

ID_CODE (in TSRLAB Text (8) No average, mode, or commonly-used name NO MATCH

An abbreviation median, MPN). NO MATCH No NO MATCH

Table) of the laboratory. Used as a shorthand or

abbreviation to represent the Laboratory

in batch data update runs.



SOURCE_ACR (in Text(12) Conditional The user-defined code that uniquely ResultAnalyticalMethod: Text(120) Conditional Identifies the source or data

TSRANLPR table) identifies the Organization to which each MethodIdentifierContext system that created or

occurrence of this table applies. This defined the identifier.

identifying attribute

has been added to this table for purposes

of application security. Security is driven

by user access to a given Organization(s).









Result Page 54

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



PROCEDURE_ID (in Text(15) Conditional The abbreviated name or identifying code ResultAnalyticalMethod: Text(20) Conditional The identification number or

TSRANLPR table) of the analytical procedure. MethodIdentifier code assigned by the method

publisher.









TSRLSPP_ORG_ID (in Text(8) No The user-defined code that uniquely SamplePreparationMethod: Text(120) No Identifies the source or data

TSRLSPP table) identifies the Organization to which each MethodIdentifierContext system that created or

occurrence of this table applies. This defined the identifier.

identifying attribute has been added to

this table for purposes of application

security. Security is driven by user access

to a given Organization(s).









Result Page 55

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



PREPARATION_ID (in Text(15) No The cryptic code that represents a SamplePreparationMethod: Text(20) No The identification number or

TSRLSPP table) particular sample preparation procedure. MethodIdentifier code assigned by the method

Used as a shorthand or abbreviation to publisher.

represent the Sample Preparation

Procedure in batch data update runs.









NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









Result Page 56

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH







NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









Result Page 57

STORET STORET Required by STORET WQX WQX Required by WQX

Data Element Name Data Type STORET Definition Data Element Name Data Type WQX Definition



NO MATCH NO MATCH No NO MATCH NO MATCH NO MATCH No NO MATCH









Result Page 58

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



For Lab Analytes: Analyte_Name Text(60) Yes The chemical name for the analyte. Yes PARAMETER PARAMETER CMN-MD15

Values for Analyte Names are specified (T_PARAMETER) (T_RESULT and (Parameter Names)

by Florida DEP and SFWMD. T_PARAMETER)

For Field Analytes:

Field_Parameter_Name

Text(60) Conditional Name for the field parameter measured.





Client_Analyte_ID Text(30) Yes Unique identifier for an analyte name. Yes CAS_NUMBER (in

This is typically the CAS number, NELAC T_PARAMETER

number, or Florida specified ID number table)

Result Number(10) Yes Reported result for the analyte No VALUE and VALUE and

VALUE_TEXT (in VALUE_TEXT (in

T_RESULT table) T_RESULT table)









Result Page 59

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Result_Units Text(10) Yes Units for the result No UNITS or UNITS (in T_RESULT

STORET_UOM (in table)

T_PARAMETER

table)





Dilution Number(10) Yes Overall dilution of the sample aliquot. A No -- --

value of one (1) corresponds to nominal

method conditions. Insert value of one

(1) for method blanks, LCS, and LCSD.









Lab_Qualifiers/ Text(7) Conditional For lab data, a string of single letter result No VALUE_QUALIFER (in FK_VALUE_QUALIFIE LAB-MD25 (Lab

Field_Parameter_Qualifier_Code qualifiers assigned by the laboratory. T_RESULT table) R_CODE (in Result Qualifier)

Always use the “U” qualifier for non- T_RESULT table)

detects. Other qualifiers may apply. and

Order is insignificant.



For field data, qualifier for the field FLD-MD20 (Field

Preservation_Intact Text(3) Yes Indicates if the sample was preserved No -- -- FLD-MD6 (Field Preservation

properly based on measurement at the

time of sample receipt at the laboratory.

This applies to each bottle collected









Result Page 60

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Total_Or_Dissolved Text(3) Yes Indicates if the result is reported on a No SAMPLE_FRACTION SAMPLE_FRACTION

total or dissolved sample fraction. Report (in T_PARAMETER (in T_PARAMETER

only for aqueous results table) table)









Analyte_Type Text(7) Yes Defines the type of result such as No -- --

surrogate, spike, or target compound.





Analysis_Type Text(10) Yes Indicates the type of analysis (i.e. No -- --

dilutions, re-analyses or re-extracts). This

field provides distinction among records

when multiple analyses are submitted for

the same sample and method. Enter RES

for the initial analysis.



Lab_Receipt_Date Date/Time Yes Date and time sample received by the No --

RECEIVED_DATE (in T_RECEIPT table)

laboratory. . Format as: MM/DD/YYYY

hh:mm where MM = two digit month, DD

= two digit date, YYYY = four digit year, hh

= two digit hour, and mm = two digit

Date_Prepared Date/Time Yes minutes and time of sample preparation No

The date PREPARATION_DATE PREPARATION_DATE

or extraction. Format as: MM/DD/YYYY (in T_RESULT) (in T_RESULT)

hh:mm where MM = two digit month, DD

= two digit date, YYYY = four digit year, hh No No

= two digit hour, and mm = two digit PREPARATION_TIME PREPARATION_TIME

minutes. For analyses with no

preparation, insert the analysis date.









Result Page 61

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Date_Analyzed Date/Time Yes The date and time of sample analysis. No ANALYSIS_DATE and ANALYSIS_DATE and

Format as: MM/DD/YYYY hh:mm where ANALYSIS_TIME (in ANALYSIS_TIME (in

MM = two digit month, DD = two digit T_RESULT table) T_RESULT table)

date, YYYY = four digit year, hh = two digit

hour, and mm = two digit minutes.









Detection_Limit Number(10) Yes Method detection limit for the measure No MDL (in T_RESULT MDL (in T_RESULT LAB-MD23 (MDL

analyte table) table) Reported)









Reporting_Limit Text(10) Conditional Practical quantitation limit for the No PQL (in T_RESULT PQL (in T_RESULT Lab-MD22 (PQL

measured analyte. Also used as the table) table) Reported)

reporting limit









NO MATCH NO MATCH No NO MATCH No -- --









QC_Spike_Added Number(5) Conditional Value of spike or surrogate compound No -- --

entered as a numeric character









Result Page 62

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Error Text(10) Conditional The two sigma error for radiochemistry No -- --

results. Do not enter the “+” or “-“

character in this field



Percent_Moisture Number(10) Conditional Percent of sample composed of water. No -- --

Enter value for soil and sediments sample

only.





Percent_Recovery Text(5) Conditional Percent recovery value of a spiked or No -- --

surrogate compound. If sample dilution

yields no or very low recovery enter

“DIL”. If sample matrix interference yields

no recovery, enter “INT”. If the spike or

surrogate was not added to a sample

with Analyte_Type = “SPK” or

“SURR”enter “NS”.



Relative_Percent_Difference Number(5) Conditional Relative percent difference between two No -- --

QC results







Receipt_Comments Text(255) Conditional Information related to the samples No -- --

received by the laboratory that is not

captured in other fields



Result_Comments/ Text(255) Conditional Free-form text where data provider No RESULT_COMMENT RESULT_COMMENT

Field_Comments relates information they consider (in T_RESULT table) (in T_RESULT table)

relevant to the sample that is not

Text(200) Conditional included in the above fields.



Information about the field sample for

which no specific field has been

designated.









Result Page 63

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Reportable_Result Text(3) Conditional Indication of whether or not the No

laboratory chooses and individual analyte

result as reportable. Enter "YES" if the

result is reportable. Enter "NO" if the

result is not.







NO MATCH NO MATCH No NO MATCH No -- --









NO MATCH NO MATCH No NO MATCH No -- --



LabID Text(7) Yes Identification of the laboratory Yes LAB_NAME (in

performing the analysis. Use DOH T_PARAMETER

certification number if possible table)







For Lab Samples: Text(80) Yes The laboratory reference method ID. Yes ANALYSIS_METHOD ANALYSIS_METHOD

Lab_Analysis_Ref_Method_ID Standard values for methods are (T_RESULT table) (T_RESULT table)

specified by Florida DEP and SFWMD.





For Field Samples: Text(75) Conditional Method used in measuring field

Field_Measurement_Method parameter.









Result Page 64

Lab_Analysis_Ref_Method_ID Standard values for methods are (T_RESULT table) (T_RESULT table)

specified by Florida DEP and SFWMD.





For Field Samples: Text(75) Conditional Method used in measuring field

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Field_Measurement_Method parameter.

Data Element Name Data Type ADaPT Description Admin?









Preparation_Type Text(25) Yes The method used to prepare the sample. Yes PREPARATION_MET PREPARATION_MET

For methods that do not have a HOD (in T_RESULT) HOD (in T_RESULT)

preparation method as part of the

analysis enter “No Prep”.









Result Page 65

preparation method as part of the

analysis enter “No Prep”.





ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?









Prep_Batch_ID Text(13) Yes Unique laboratory identifier for a batch No -- --

of samples of similar matrix prepared

together for analysis by one method and

treated as a group for method blank, LCS,

and LCSD association. The Prep_Batch_ID

links method blanks and laboratory

control samples (LCS/LCSD) to associated

samples.









Result Page 66

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Method_Batch_ID Text(13) Yes Unique laboratory identifier for a batch No QC_BATCH (in --

of samples of similar matrix analyzed by T_RESULT)

one method and treated as a group for

laboratory duplicate, matrix spike, and

matrix spike duplicate association. The

Method_Batch_ID links laboratory

duplicates, matrix spikes, and matrix

spike duplicates to associated samples.









Lab_Sample_ID Text(50) Yes Laboratory tracking number for field No LAB_SAMPLE_ID LAB_SAMPLE_ID

samples and laboratory generated QC (T_RESULT and (T_RESULT table)

samples T_RECEIPT table)

Shipping_Batch_ID Text(25) Conditional Unique identifier assigned to a cooler or No

shipping container or group of coolers or

shipping containers that links samples

together. The Shipping_Batch_ID is

provided by the client on the chain of

custody.









Result Page 67

ADaPT ADaPT Required by ADaPT Library OGWIS GGWIS IDM Standards

Data Element Name Data Type ADaPT Description Admin?



Lab_Reporting_Batch_ID Text(13) Yes Laboratory identifier for a group of No -- --

samples and laboratory QC all reported

within one EDD or batch. The

Lab_Reporting_Batch_ID is equivalent to

the sample delivery group, lab work

number, login ID, etc.









Result Page 68

Questions/Concerns Section Feedback

(Project Team)









Result Page 69

Questions/Concerns Section Feedback

(Project Team)









Result Page 70

Questions/Concerns Section Feedback

(Project Team)









Result Page 71

Questions/Concerns Section Feedback

(Project Team)









Need to get exception list

from Central Lab on MDL.



WQX requires

DetectionQuantitationLim

itTypeName. This will be

done through transposing

and translating the MDL,

PQL, and UQL column

names.









Result Page 72

Questions/Concerns Section Feedback

(Project Team)









Result Page 73

Questions/Concerns Section Feedback

(Project Team)









During LabID setup (via

Library Administrator),

LabName will be entered

into codes tables along

with approval (or not) to

submit LabQC data.

Providers need to have a

pre-translated method

field that stores their

original procedure before

we mandated that they

translate to WIN SVL.



Question for EPA: Can we

add to the nationally

recognized method list?









Result Page 74

pre-translated method

field that stores their

original procedure before

we mandated that they

translate to WIN SVL.

Questions/Concerns Section Feedback

(Project Team)

Question for EPA: Can we

add to the nationally

recognized method list?









Result Page 75

Questions/Concerns Section Feedback

(Project Team)









Result Page 76

Questions/Concerns Section Feedback

(Project Team)









Result Page 77

Questions/Concerns Section Feedback

(Project Team)









Result Page 78

Impossible Results: List Needs to be developed and expanded.

AnalyteName ResultUnit LowThreshold HighThreshold

pH None 3.5 10.5

Water Temperature deg C 0 38

Water Temperature deg F 30 100

DO mg/L 0.5 14

DO % Saturation % None 150

Wind Direction Deg 0 360

Salinity TBD TBD

Turbidity TBD TBD

Specific Conductance TBD TBD

BOD mg/L 0.2 12

COD mg/L None 200

Below needs a critical review and edits

Duplicate Record Check

Duplicate records are reported if two or more records hold identical values among the following fields:



OrgID

ProjectID

MonitoringLocationID

ActivityID

ActivityType

BeginCollectionDateTime

EndCollectionDateTIme

Matrix

SampleDepth

SampleTopDepth

SampleBottomDepth

AnalyteName

ClientAnalyteID

ResultValue

ResultUnit

SampleFraction

AnalysisType

LabSampleID

LabID

AnalyticalMethodSource/Number

ResultUnit

#/100 gal

#/100ml

#/500 ml

#/acre

#/cm2

#/cm3

#/dl

#/ft2

#/ha

#/in2

#/km2

#/l

#/m2

#/m3

#/mi2

#/ml

#/yd2

%

% CaCO3

% Cover

% by vol

% by wt

% sediment

0/00

ADMI value

Angst

BTU

CFU

Deg

FTU

Imp gal

JCU

JTU

Joules

Langleys

MPN

MPN/100ml

MT/km2/yr

Min

Molal

Molar

Mole/l

NTU

None

Normal

PCU

PSS

Pascal

Plate cnt

S/m

Sec

T.U.

TON

TU

Torr

Watts

ac

ac-ft

amps

atm

cal

cfm

cfs

cfu/100ml

cm

cm/sec

cm2

cm3

cm3/hr

cm3/l

cm3/min

cm3/sec

count

days

deg C

deg F

deg K

dl

dm

dm2

drips/min

drops

fc/ft2

fibers/l

ft

ft-candles

ft-lbs

ft/day

ft/min

ft/sec

ft2

ft3

ft3/day

g

g/cm2

g/cm3

g/day

g/hr

g/kg

g/l

g/m2

g/m2/day

g/m2/hr

g/m3

g/m3/day

g/m3/hr

g/min

g/ml

g/sec

gal

gal/day

gal/hr

gal/min

gal/sec

gpg

gpm/ft

ha

hours

hp

in

in/H2O

in/Hg

in2

in3

kcal

kg

kg/m2

kg/m3

kg/t CaCO3

km

km/hr

km/sec

km2

knots

kw

l

l/day

l/hr

l/min

l/sec

lb

lb/acre/yr

lb/day

lb/hr

lb/in

lb/min

lb/sec

lm/ft2

lumens

m

m/sec

m2

m3

m3/hr

m3/min

m3/sec

mS/cm

mV

meq/L

metric ton

mg

mg/cm3

mg/day

mg/g

mg/hr

mg/kg

mg/l

mg/l CaCO3

mg/m2

mg/m2/day

mg/m2/hr

mg/m3

mg/m3/day

mg/m3/hr

mg/min

mg/ml

mg/sec

mgal/mnth

mgal/year

mgd

mho/cm

mi

mi2

minutes

ml

ml/l

mm

mm/H2O

mm/Hg

mm2

mm3/l

mmol/kg

mmol/m2/dy

mmol/m2/hr

months

mosm/kg

mph

mrem/day

mrem/yr

ms

mw

nCi/L

ng

ng/cm3

ng/g

ng/kg

ng/l

ng/m2

ng/m3

nm

nmi

nmi2

nmol/kg

nu

oz

pCi/L

pCi/g

pCi/m2

pCi/m3

pCi/ml

per m

pfu/100ml

pg

pg/cm3

pg/g

pg/kg

pg/l

pg/m2

pg/m3

ppb

ppm

ppt

ppth

psi

pt

qt

seconds

tCaCO3/Kt

tons

tons/ac ft

tons/day

uE/m2/sec

uS/cm

ueq/L

ug

ug/cm2/day

ug/cm3

ug/g

ug/kg

ug/l

ug/m2

ug/m3

um3/l

umho/cm

umol

umol/S/m2

umol/g

umol/m2/s

units/cm

volts

weeks

yd

yd2

yd3

years

Qualifier Description

A Average

B Outside acceptable range - microbiology only

F Female - organism data only

H Field Kits (only available for certain characteristics)

I Result is between MDL and PQL

J Estimated Value

K Off scale low for methods with a calibration

L Off scale high for methods with a calibration

PQL is reported as the result because Actual Result Value < Value Given

M (for chemical analyses)

N Presumptive evidence of presence of material.

O Sampled, but analysis lost or not performed.

Q Sample held beyond the accepted holding time.

T Reported Result Value < MDL

U Compound was analyzed for but not detected



V analyte was detected in both the sample and the associated method blank

Y laboratory analysis was from an improperly preserved sample

Z For microbiology data, too many colonies to count

Data are rejected and should not be used because associated QA data was

? problematic.

* Not reported due to interference.

D Measurement was made in the field

E Indicates that extra samples were taken at composite stations

R Significant rain in the past 48 hours.

! Data deviate from historically established concentration ranges.

Data provider specific qualifier - comment must be provided to explain

+ meaning of qualifier code.

Activity Type Restriction

No restriction

No field related activity types allowed

No restriction

Must be field related activity types

Must be lab related activity types

No restriction

No field related activity types allowed

No field related activity types allowed



No field related activity types allowed

No field related activity types allowed

No restriction

No field related activity types allowed

No field related activity types allowed

No field related activity types allowed



No field related activity types allowed

No field related activity types allowed

No field related activity types allowed



No restriction

No field related activity types allowed

No lab related activity types allowed

No restriction

No restriction

No blanks



No restriction

Value Qualifier Checks

If ResultValue < MDL, then ValueQualifier must contain a "T" or "U".

If ValueQualifier contains a "T", then ResultValue must be less than MDL.

IF ResultValue = MDL, then ValueQualifier must contain a "I" or "U" value qualifier.

Result = Detection_Limit if Lab_Qualifiers contains ‘U”

Result value may not have a value qualifier of "I" and be greater than the PQL.

If an “I” Value Qualifier is present with a sample result, then the PQL cannot be null.

if MDL < ResultValue < PQL, then ValueQualifier must require contain an "I".

Lab_Qualifiers contains “I” or “J” if Detection_Limit < Result < Reporting_Limit

ValueQualifier cannot contain both an "I" and a "U"

Any Value Qualifier not in Rule 62-160 (such as the obsolete “W”) is an ERROR.

No "A" qualifier for the raw data.

B qualifier should only be used for characteristic type of bacteria.

F qualifier should only be used for characteristic type of organisms.

A "field kit" method requires "H" value qualifier.

A record using "H" value qualifier without a "field kit" method must be flagged.

ResultValue must be greater than MDL for "K" value qualifier.

ResultValue must be greater than or equal to PQL for "K" value qualifier.

ResultValue must be equal to PQL for "M" value qualifier.

ResultValue must be "NOT REPORTED" for "O" value qualifier.

For extractables, if the difference between collection date & time and preparation date & time is

greater than the allowable holding time and the "Q" value qualifier is not present, then record

must be flagged as an error.

For extractables, if the difference between collection date & time and preparation date & time is

less than or equal to the allowable holding time and the "Q" value qualifier is present, then record

must be flagged as a warning.

For non-extractables, if the difference between collection date & time and analysis date & time is

greater than the allowable holding time and the "Q" value qualifier is not present, then record

must be flagged as an error.

For non-extractables, if the difference between collection date & time and analysis date & time is

less than or equal to the allowable holding time and the "Q" value qualifier is present, then record

must be flagged as a warning.

The "K" Value Qualifier should not be used for BOD

The "X" Value Qualifier may not be reported until WIN expands to accept SCI data.

The "Z" Value Qualifier is valid only for bacteria

The * (asterisk) Value Qualifier must have Result Value "*Not-Reported"

The "J" Value Qualifier requires a ResultComment

ValueQualifiers contains “Y” in sample result record if PerservationIntact = “No”

PreservationIntact must = “No” if ValueQualifiers in sample result record contains “Y”

Result must be greater than MDL in associated method blank if ValueQualifiers in sample result

record or method blank result record contains “V”



ValueQualifier does NOT contain “J” if ValueQualifier contains “K”, “L“,“M“,“T“,“V“, “Y”, and/or “I”

Value Qualifier must contain a "U" and "J" if ResultValue<10*Blank Value.

If ActivityType in ('Field', 'Data Logger') then ValueQualifier must contain a "D"

WQX ResultSampleFractionText SVLs

Acid Soluble

Comb Available

Dissolved

Filterable

Fixed

Free Available

Non-filterable

Non-settleable

Non-volatile

Pot. Dissolved

Settleable

Supernate

Suspended

Total

Total Recoverable

Total Residual

Vapor

Volatile

ADaPT

AnalyteType Description

IS Internal standard

SPK Spiked analyte

SURR Surrogate

TIC Tentatively identified compound for GC/MS analysis

TRACER Tracer or carrier in radiochemistry

TRG Listed in the target compound list

AnalysisType

DL

DL/2

DL/SPLP

DL/TCLP

DL/WET

DL2

DL2/SPLP

DL2/TCLP

DL3

DL4

RE

RE/DIS

RE/SPLP

RE/TCLP

RE/TOT

RE/WET

RE2

RE2/SPLP

RE2/TCLP

RE2/WET

RE3

RE4

RES

RES/DIS

RES/SPLP

RES/TCLP

RES/TOT

RES/WET

RES2

RES3

Description

Dilution of the original sample

Second dilution for WET analysis

Dilution for SPLP analysis

Dilution for TCLP analysis

Dilution for WET analysis

Second dilution of the original sample

Second dilution for SPLP analysis

Second dilution for TCLP analysis

Third dilution of the original sample

Fourth dilution of the original sample

Reanalysis of the original sample

Reanalysis for dissolved metals

Reanalysis for SPLP analysis

Reanalysis for TCLP analysis

Reanalysis for total metals

Reanalysis for WET analysis

Second reanalysis of the original sample

Second reanalysis for SPLP analysis

Second reanalysis for TCLP analysis

Second reanalysis for WET analysis

Third reanalysis of the original sample

Fourth reanalysis of the original sample

Final result from the original sample.

Initial analysis for dissolved metals

Initial analysis for SPLP analysis

Final result from the original sample for TCLP

Final result from the original sample for Total

Initial analysis for WET analysis

Second initial analysis (applies to metals reported from different analyses on same sample)

Third initial analysis (applies to metals reported from different analyses on same sample)

StatisticalBase

10 Pctl

15 Pctl

20 Pctl

25 Pctl

5 Pctl

75 Pctl

80 Pctl

85 Pctl

90 Pctl

95 Pctl

Geometric Mean

MPN

Maximum

Mean

Median

Minimum

Mode

Standard Deviation

Lab ID Organization

E87425 A & B Laboratories, Inc.

E82031 ABC Research Corporation

E87429 Accura Analytical Laboratory, Inc.

E87628 Accutest Gulf Coast Laboratories, Inc.

E87482 Accutest Laboratories - NJ

E87579 Accutest Laboratories of New England

E83510 Accutest Laboratories Southeast, Inc.

E81350 Ackuritlabs, Inc.

E87212 Advanced Chemistry Laboratories, Inc.

E82574 Advanced Environmental Laboratories, Inc.

E82620 Advanced Environmental Laboratories, Inc. - Gainesville

E84589 Advanced Environmental Laboratories, Inc. - Tampa

E82535 Advanced Technologies and Testing Laboratory, Inc.

E67593 AFIOH/SDC

E87680 Air Toxics Limited

E86198 All State Engineering and Testing Consultants, Inc.

E87687 Allmond Laboratory Services, Inc.

E83806 Alpha Analytics, Inc.

E87777 Alta Analytical Laboratory, Inc.

E87608 Alta Analytical Perspectives

E87597 Altamaha Laboratories

E87558 American Radiation Services

E84572 American Water Services Environmental Laboratory

E87455 Anacon, Inc.

E87582 Analytical Environmental Services, Inc.

E87892 Analytical Management Laboratories, Inc.

E97665 Analytical Mobile Services, Inc.

E81384 Analytical Services Corporation

E87315 Analytical Services, Inc.

E87585 Analytical Services, Inc. - Greenville

E87764 Analytics Corporation

E87893 Anatek Labs, Inc.

E85433 Anti-Pollution Associates, Inc.

E83265 Aqua Pure Water & Sewage Service, Inc.

E86771 Aqua Tech Environmental Laboratories #1 - Marion

E87776 Aqua Tech Environmental Laboratories #2 - Melmore

E87842 Aquatech Environmental Services, Inc.

E87636 AScI Corporation - Environmental Testing Laboratory

E87621 Auburn Environmental Consulting and Testing

E87805 Barry A. Vittor & Associates, Inc.

E41292 Bay County Environmental Laboratory

E81590 Bay Environmental Laboratory Inc.

E87556 Beckton Environmental Laboratories

E85086 Benchmark EA South

E84167 Benchmark EnviroAnalytical, Inc.

E86618 Big Lake Laboratories, Inc.

E83283 Bottorf Associates, Inc.

E53268 Brevard County Water Resources Laboratory

E46053 Broward County Department of Planning and Environmental Protection

E56441 Broward County Office of Environmental Services Laboratory

E86035 Broward Testing Laboratory, Ltd.

E87808 BWXT Services, Inc.

E84432 Cargill Fertilizer, Inc.

E82591 CCDA Waters, L.L.C.

E87573 Ceimic Corporation

E54436 Charlotte County Utilities - East Port Laboratory

E82405 Chemsultants, Inc.

E53258 City of Altamonte Springs Environmental Laboratory

E53844 City of Apopka Wastewater Treatment Facility Laboratory

E54266 City of Auburndale Wastewater Laboratory

E56386 City of Boca Raton Quality Control Laboratory

E56739 City of Boynton Beach Water Plant

E54461 City of Bradenton Water Reclamation Laboratory

E54712 City of Bradenton Water Treatment Plant Laboratory

E53449 City of Cape Canaveral Wastewater Treatment Plant

E55261 City of Cape Coral Water Reclamation Laboratory

E54020 City of Clearwater - Marshall Street Water Pollution Control Laboratory

E54021 City of Clearwater Water Pollution Control Laboratory

E53263 City of Cocoa Beach Water Reclamation Laboratory

E53727 City of Cocoa Water Treatment Plant

E53073 City of Daytona Beach Environmental Monitoring Laboratory

E56716 City of Deerfield Beach Water Treatment Plant

E53362 City of DeLand Environmental Services Laboratory

E56367 City of Delray Beach Environmental Services Laboratory

E54508 City of Dunedin Wastewater Treatment Plant

E53785 City of Edgewater - Alan R. Thomas Water Treatment Plant

E53480 City of Edgewater Advanced Wastewater Treatment Plant

E54211 City of Englewood Water District

E53443 City of Eustis Wastewater Treatment Plant

E52335 City of Fernandina Beach Wastewater Treatment Plant

E56084 City of Fort Lauderdale Environmental Laboratory

E55517 City of Fort Myers, Central Laboratory

E51279 City of Fort Walton Beach Environmental Laboratory

E52741 City of Gainesville Murphree Water Treatment Plant

E51310 City of Graceville Wastewater Treatment Plant Laboratory

E54373 City of Haines City Wastewater Treatment Plant

E56744 City of Hallandale Water Treatment Plant

E53445 City of Holly Hill Water & Wastewater Treatment Plant Laboratory

E56407 City of Hollywood, Florida Utilities Laboratory

E53311 City of Kissimmee S. Bermuda Water Resources Dept. - Environmental Laboratory

E56760 City of Lake Worth Water Treatment Plant Laboratory

E54728 City of Lakeland -Thomas B. Williams Water Treatment Plant

E54180 City of Lakeland Wastewater Treatment Plant - Glendale

E54364 City of Largo Wastewater Treatment Plant

E53306 City of Leesburg Wastewater Utility Laboratory

E56131 City of Margate Utilities

E51497 City of Mary Esther Wastewater Treatment Plant

E53332 City of Melbourne Wastewater Treatment Compliance Monitoring Laboratory

E53730 City of Melbourne Water Treatment Plant Laboratory

E56565 City of Miramar West Water Treatment Plant

E55200 City of Naples Central Laboratory

E54346 City of New Port Richey Wastewater Treatment Plant

E53732 City of New Smyrna Beach Water Treatment Plant Laboratory

E56721 City of North Lauderdale Water Plant

E56733 City of North Miami Beach Quality Control Laboratory

E56722 City of North Miami Water Treatment Plant

E53377 City of Ocala Water Reclamation Facility #2 - Water Quality Laboratory

E54309 City of Oldsmar Wastewater Treatment Plant

E53087 City of Orlando Iron Bridge Laboratory

E53343 City of Ormond Beach Public Utilities

E52474 City of Palatka Wastewater Treatment Plant

E53491 City of Palm Bay Utilities Corporation

E56726 City of Palm Springs Water Treatment Plant

E51269 City of Panama City Area Environmental Laboratory

E56300 City of Pembroke Pines Wastewater Treatment Plant

E56402 City of Plantation Utilities Department Laboratory

E56172 City of Pompano Beach Public Works Water Treatment Plant Laboratory

E53504 City of Port Orange Reclaimed Water Plant

E51289 City of Port St. Joe Wastewater Treatment Plant Laboratory

E56718 City of Port St. Lucie Utility Systems Department

E55724 City of Punta Gorda Water Treatment Plant

E56264 City of Royal Palm Beach Utilities Dept. Wastewater Treatment Plant Laboratory

E53372 City of Sanford Water Reclamation Facility Laboratory

E54348 City of Sarasota Wastewater Treatment Plant Laboratory

E52408 City of St. Augustine Water Pollution Control Laboratory

E54743 City of St. Petersburg - Cosme Water Treatment Plant Laboratory

E56158 City of Sunrise Utilities Laboratory

E51259 City of Tallahassee Water Quality Laboratory

E56725 City of Tamarac Utilities Laboratory

E54737 City of Tampa Water Quality Laboratory

E54369 City of Tarpon Springs Wastewater Treatment Plant

E53313 City of Tavares Wastewater Utilities Laboratory

E53121 City of Titusville Blue Heron Water Reclamation Plant

E54326 City of Venice Water Reclamation Laboratory

E53303 City of Vero Beach Environmental Control Laboratory

E43877 City Of Vero Beach, Wastewater Treatment Plant

E54466 City of Wauchula Wastewater Treatment Plant

E56065 City of West Palm Beach East Central Wastewater Plant

E56738 City of West Palm Beach Public Utilities Water Laboratory

E54490 City of Wildwood Wastewater Treatment Plant

E53321 City of Winter Garden Wastewater Pollution Control Facility

E54305 City of Winter Haven Wastewater Treatment Plant #2 - Lake Conine

E54066 City of Winter Haven Wastewater Treatment Plant #3

E53246 City of Winter Park Central Utilities Laboratory

E53136 City of Winter Park Estates Laboratory

E53416 City of Winter Springs Wastewater Reclamation Facility

E45464 Collier County Pollution Control Laboratory

E55750 Collier County Regional Water Plant Laboratory

E55471 Collier County Water Reclamation Laboratory

E87203 Columbia Analytical Services - Redding CA

E82502 Columbia Analytical Services, Inc. - FL

E87674 Columbia Analytical Services, Inc. - NY

E87611 Columbia Analytical Services, Inc. - TX

E87412 Columbia Analytical Services, Inc. - WA

E87047 CompuChem, a division of Liberty Analytical Corp.

E84365 Constellation Technology Corporation

E87889 Con-Test Analytical Laboratory

E87571 Cosper Environmental Services, Inc.

E87619 CSRA Analytical Laboratories, Inc.

E46126 Dade County Department of Environmental Resources Management (DERM)

E93745 Darden Restaurants, Inc.

E87633 Davis & Floyd, Inc.

E84108 Davis Analytical Laboratories, Inc.

E85222 Davis Water Analysis - Synagro of Florida

E83330 DB Environmental Laboratories, Inc.

E51586 Destin Water Users, Inc

E87559 DHL Analytical - Mobile Lab T-4

E87548 DHL Analytical - Mobile Unit T3

E87544 DHL Analytical, Inc.

E86772 E. M. Analytical, Inc.

E87550 EA Engineering, Science, and Technology - Ecotoxicology Laboratory

E86352 East Coast Laboratory

E87673 Eastern Research Group, Inc.

E87486 Eastman Kodak Company - Environmental Analytical Services

E87037 Ecology & Environment, Inc.

E85394 Ecosystematics, Inc.

E87646 ELAB of Tennessee, LLC

E83079 ELAB, Inc.

E87825 EMAX Laboratories, Inc.

E87788 EMSL Analytical, Inc. - Haddon Avenue

E87786 EMSL Analytical, Inc. - Cooper Street

E86795 EMSL Analytical, Inc. - FL

E87804 EMSL Analytical, Inc. - Orlando

E87855 EnChem, Inc.

E87641 Energy Laboratories Inc.

E87668 Energy Laboratories, Inc. - MT

E87669 Energy Laboratories, Inc. #2

E87286 EnviroData Group, LLC

E86188 Envirodyne, Inc.

E87635 Environmental Chemistry, Inc

E87610 Environmental Conservation Laboratories, Inc. - Cary

E82277 Environmental Conservation Laboratories, Inc. (ENCO) - Jacksonville

E83182 Environmental Conservation Laboratories, Inc. (ENCO) - Orlando

E87833 Environmental Hazards Services, L.L.C.

E87775 Environmental Health Laboratories - IN

E87623 Environmental Management Services, Inc.

E87783 Environmental Quality Laboratories, Inc. - PR

E86563 Environmental Reagent Service

E93351 Environmental Research & Design, Inc.

E87542 Environmental Resource Analysts - AL

E87487 Environmental Science Corporation - TN

E87637 Environmental Services Network - ESN Southeast

E86740 Environmental Services of South Florida, Inc.

E87684 Environmental Testing Laboratories, Inc.

E87807 ERM Southeast Inc.

E87681 ERMI Environmental Laboratories

E51361 Escambia County Utilities Authority Water Quality Laboratory

E87819 ETT Environmental, Inc.

E86048 Everglades Laboratories, Inc.

E76463 Everglades Research and Education Center

E31780 FL DEP - Central Laboratory

E31640 FL DEP - Central Laboratory/Innovation Park Satellite Laboratory

E35834 FL DEP - South District Marathon Branch Laboratory

E16533 FL Department of Health - Miami Branch Laboratory

E11062 FL Department of Health - Pensacola Branch Laboratory

E14157 FL Department of Health - Tampa Branch Laboratory

E16122 FL Department of Health - West Palm Beach Branch Laboratory

E22701 FL Dept. of Health - Alachua County Health Department

E22794 FL Dept. of Health - Bradford County Health Department

E13800 FL Dept. of Health - Bureau of Radiation Control

E24768 FL Dept. of Health - Citrus County Health Department

E22787 FL Dept. of Health - Columbia County Health Department

E25803 FL Dept. of Health - Hendry County Environmental Laboratory

E24704 FL Dept. of Health - Hernando County Health Department

E25705 FL Dept. of Health - Highlands County Health Department

E23759 FL Dept. of Health - Indian River County Health Department

E25706 FL Dept. of Health - Lee County Health Department

E23708 FL Dept. of Health - Marion County Health Department

E24709 FL Dept. of Health - Pinellas County Health Department

E24710 FL Dept. of Health - Polk County Health Department

E22779 FL Dept. of Health - Putnam County Health Department

E24711 FL Dept. of Health - Sarasota County Health Department

E22770 FL Dept. of Health - St. Johns County Health Department - Environmental Eng.

E26789 FL Dept. of Health - St. Lucie County Health Department

E12700 Florida DOH Bureau of Laboratories - Jacksonville

E82382 Florida General Environmental Services

E56717 Florida Keys Aqueduct Authority - Florida City Treatment Plant

E55757 Florida Keys Aqueduct Authority - Stock Island R. O. Plant Lab

E56078 Florida Power & Light Central Laboratory

E83033 Florida Radiochemistry Services, Inc.

E51431 Florida State Hospital Wastewater Treatment Plant

E84817 Florida Water Laboratories

E83018 Flowers Chemical Laboratories

E86562 Flowers Chemical Labs - South

E56729 Fort Pierce Utilities Authority Water Treatment Plant

E86647 Frederick C. Bothe Environmental Consultant

E87872 Frontier Analytical Laboratory

E87575 Frontier Geosciences, Inc.

E81304 Future Laboratories, Inc.

E87156 General Engineering Laboratories, LLC

E87642 Geochemical Testing

E57554 Georgia Power Environmental Laboratory

E87476 GPL Laboratories, LLLP

E87643 Groundwater Analytical, Inc.

E83159 Grove Scientific & Engineering

E87854 Gulf Coast Analytical Laboratories, Inc.

E84109 Gulf Coast Recycling, Inc.

E52417 Harbor Branch Environmental - Amelia Island Laboratory

E83509 Harbor Branch Environmental - Deltona Laboratory

E85370 Harbor Branch Environmental - Lehigh Acres Laboratory

E84418 Harbor Branch Environmental - Spring Hill Laboratory

E96080 Harbor Branch Environmental Laboratory

E82067 Harding ESE, Inc. Toxicology Laboratory

E44057 Hillsborough County Environmental Protection Commission

E44104 Hillsborough County Utilities Environmental Laboratory

E54208 Howard F. Curren Advanced Wastewater Treatment Plant Analytical Laboratory

E82295 Hydrosphere Research Environmental Services, Inc.

E86778 Hygeia Laboratories, Inc. - Florida

E87257 Hygeia Laboratories, Inc. - GA

E86594 I2J Environmental Services, Inc.

E37644 Illinois Environmental Protection Agency - Inorganic Laboratory

E37645 Illinois Environmental Protection Agency - Organic Laboratory

E84578 IMC - Phosphates Environmental Laboratory

E87894 Integrated Analytical Laboratories, LLC

E82496 Integrated Bioassay Services, Inc.

E07686 International Paper Corporate Research Center

E42342 Jacksonville Regulatory and Environmental Services

E52281 JEA - Laboratory Services Analytical/Microbiology Section

E52318 JEA - Laboratory Services Bioassay Section

E52314 JEA - Laboratory Services Metals Section

E52459 JEA Laboratory Services

E52762 JEA Water Quality Laboratory

E53262 Jerry Sellers Advanced Wastewater Treatment Facility

E86546 Jupiter Environmental Laboratories, Inc.

E82815 K B Labs, Inc.; KB-1

E82840 K B Labs, Inc.; KB-2

E82816 K B Labs, Inc.; KB-3

E52099 Kanapaha Laboratory - Gainesville Utilities

E86515 Kappa Laboratories

E87604 Katahdin Analytical Services, Inc.

E87551 KEMRON Environmental Services, Inc.

E63478 Kennedy Space Center Environmental Microbiology Laboratory

E63359 Kennedy Space Center Laboratory for Sewage Treatment Operations

E84025 KNL Laboratory Services

E43183 Lake County Water Resource Management Laboratory

E87661 Lancaster Laboratories, Inc.

E86255 Lansing Laboratories, Inc.

E87617 Laucks Testing Laboratories, Inc.

E87625 Law & Company

E87477 Law Engineering and Environmental Services Laboratory, Inc.

E45049 Lee County Environmental Laboratory

E87813 Lionville Laboratory Inc.

E56026 Loxahatchee River Environmental Control District

E87818 M. B. A. Laboratories

E44247 Manatee County Environmental Management Department

E54560 Manatee County Public Works Central Laboratory

E84191 Marinco Bioassay laboratory

E53284 Marion Correctional Institution

E56751 Martin County Environmental Services - North Water Treatment Plant Laboratory

E87588 Maxxam Analytics Inc.

E81676 McGlynn Laboratories, Inc.

E54719 MCUD Manatee County Water Treatment Plant - QC Laboratory

E84747 Meryman Environmental, Inc.

E87796 Metropolitan Environmental Testing Services, Inc.

E56236 Miami-Dade Central District Wastewater Treatment Plant Laboratory

E96766 Miami-Dade County Public Schools, Department of Materials Testing and Evaluation

E56512 Miami-Dade North District Wastewater Treatment Plant Laboratory

E56227 Miami-Dade South District Wastewater Treatment Plant Laboratory

E56720 Miami-Dade Water & Sewer Authority - Orr Water Treatment Plant Laboratory

E56731 Miami-Dade Water & Sewer Department - John E. Preston Water Quality Laboratory

E86773 Micrim Laboratories, Inc.

E84271 Microbac Laboratories, Inc. - South Atlantic Division

E87832 Microseeps, Inc.

E84567 Mid Florida Water Lab

E87664 Mitkem Corporation

E87821 Morris Testing Laboratories

E84091 Mote Marine Laboratory

E87748 MWH Laboratories, A Division of MWH Americas, Inc.

E87753 National Testing Laboratories, Ltd.

E97841 New Age/Landmark, Inc. #1

E97864 New Age/Landmark, Inc. #2

E97865 New Age/Landmark, Inc. #3

E43334 New Smyrna Beach Utilities Commission - Pollution Control Plant

E51843 Niceville, Valparaiso, Okaloosa County Regional Sewer Board, Inc.

E87820 Northeast Laboratory Services, Inc.

E87752 NSF International - MI

E87280 O'Brien & Gere Laboratories, Inc.

E51050 Okaloosa County Water and Sewer Laboratory

E56584 Okeechobee Utility Authority Wastewater Treatment Plant Laboratory

E53470 Operations Management International, Inc.

E55389 Operations Management International, Inc. - Key West

E43155 Orange County Environmental Protection Division

E43639 Orange County Environmental Protection Division - Mercy Drive

E53398 Orange County Utilities Central Laboratory

E53566 Orlando Utilities Commission

E84098 P.E. LaMoreaux & Associates, Inc.

E87683 Pace Analytical

E87648 PACE Analytical Services, Inc. - Asheville

E87627 PACE Analytical Services, Inc. - Huntersville

E87605 Pace Analytical Services, Inc. - MN

E87595 PACE Analytical Services, Inc. - New Orleans

E87114 PACE Analytical Services, Inc. - TX

E56090 Palm Beach County Water Utilities

E87634 Paradigm Analytical Laboratories

E44123 Pasco County Utilities Environmental Laboratory

E87587 PBS&J Environmental Toxicology Laboratory

E83239 PC&B Environmental Laboratory, Inc.

E84207 PEL Laboratories, Inc.

E84088 Pembroke Laboratory, Inc.

E56428 PGA Wastewater Treatment Facility - Seacoast Utility Authority

E54357 Pinellas County Utilities Laboratory

E44301 Plant City Water Pollution Control Laboratory

E83141 Plant Technicians, Inc.

E44082 Polk County Natural Resources Division

E53758 Port Orange Utility - Garnsey Water Treatment Plant Laboratory

E82001 PPB Environmental Laboratories, Inc.

E87519 PRISM Laboratories, Inc.

E87606 Pure Earth Environmental Laboratory, Inc.

E92860 Rayonier Fernandina Mill Environmental Laboratory

E43069 Reedy Creek Improvement District Environmental Services

E86536 RINKER Environmental Services, Inc.

E87822 Rogers and Callcott Engineers, Inc.

E84492 S.A.C. Environmental Laboratory

E84380 Sanders Laboratories, Inc. - Nokomis

E85457 Sanders Laboratories, Inc. (South)

E53076 Sanlando Utilities Corporation - Wekiva Treatment Plant

E54677 Sarasota County Utilities - Pump Station #2 Laboratory

E54356 Sarasota County Utilities - T. Mabry Carlton Water Treatment Plant Laboratory

E87828 Schneider Laboratories, Inc.

E87891 Scientific Laboratories, Inc.

E56029 Seacoast Utility Authority - Central Lab

E87630 Shealy Environmental Services, Inc.

E87653 Shealy Environmental Services, Inc.

E85458 Short Environmental Laboratories, Inc.

E81140 Solutia - Water Testing Laboratory

E84404 Son Glow Laboratory and Associates, Inc.

E56064 South Bay Environmental Laboratory

E46077 South Florida Water Management District Chemistry Laboratory

E51344 South Walton Utility Company Wastewater Treatment Plant

E76649 Southeast Environmental Research Center (FIU)

E84129 Southern Analytical Laboratories, Inc.

E87245 Southern Petroleum Laboratories, Inc.

E87657 Southern Petroleum Laboratories, Inc.

E83484 Southern Research Laboratories, Inc.

E56489 Southport Wastewater Treatment Plant Laboratory

E44149 Southwest Florida Water Management District

E87376 Southwest Laboratory of Oklahoma, Inc.

E07812 Southwest Research Institute

E87600 Spectrum Analytical, Inc. - MA

E87671 Spectrum Laboratories, Inc. - GA

E86006 Spectrum Laboratories, Inc. - FL

E52485 St. Johns County Utility Department Environmental Laboratory

E52853 St. Johns River Power Park Environmental Laboratory

E42206 St. Johns River Water Management District

E44058 St. Petersburg Environmental Compliance Division Laboratory

E87672 STL - Buffalo

E87667 STL - Denver

E87829 STL - Richland

E87774 STL Billerica

E87467 STL Burlington

E87831 STL Corpus Christi

E87651 STL Houston

E87177 STL Knoxville

E87652 STL Los Angeles

E86349 STL Miami

E86616 STL Miami #2

E87089 STL Mobile

E87225 STL North Canton

E81010 STL Pensacola

E87660 STL Pittsburgh

E87570 STL Sacramento

E87052 STL Savannah

E87689 STL St. Louis

E81005 STL Tallahassee

E84282 STL Tampa

E87688 Summit Environmental Technologies, Inc.

E84809 SunLabs, Inc. - Central Laboratory

E84810 SunLabs, Inc. - Mobile Laboratory

E82790 Suwannee Valley Laboratory

E87202 TAI Environmental Sciences, A Division of Strads

E81782 Talquin Electric Cooperative, Inc.

E54715 Tampa Bay Water

E54272 Tampa Electric Company Laboratory Services

E82016 Technical Services, Inc.

E87839 TestAmerica Analytical Testing Corp. - Dayton, OH

E87626 TestAmerica Analytical Testing Corp. - Indianapolis, IN

E87358 TestAmerica Analytical Testing Corp. - Nashville, TN

E83012 TestAmerica Analytical Testing Corp. - Orlando, FL

E87896 The ADVENT Group, Inc.

E83755 The Water Shed Laboratories, Inc.

E81105 The Water Spigot

E84100 Thornton Laboratories, Inc.

E56749 Town of Jupiter Water System

E86278 Toxikon Corporation - Jupiter

E81181 TRAC - Biomonitoring Services Laboratory

E86659 Translab, Inc.

E87769 Triangle Laboratories, Inc.

E87622 TriMatrix Laboratories, Inc.

E83294 Tri-Tech Laboratories, Inc.

E63507 U.S. Geological Survey, WRD, OWQRL

E86228 United Technologies - Pratt and Whitney Water & Wastewater Laboratory

E71176 University of West Florida Wetlands Research Laboratory

E63483 US Air Force - Cape Canaveral AFS Environmental Laboratory

E67784 US Army Center for HPPM Directorate of Laboratory Sciences

E86240 US Biosystems, Inc.

E84160 US Filter Recovery Services

E67682 USN PWC Environmental Laboratory, Pearl Harbor

E56679 Village of Tequesta

E56514 Village of Wellington Water Treatment Laboratory

E87624 VOA Environmental, Inc.

E23111 Volusia County Environmental Health Laboratory

E83761 Walt Disney World Food Safety and Health Laboratory

E87662 Waste Stream Technology, Inc.

E82792 Water Laboratories

E87609 Westchester County Department of Laboratories and Research

E83393 Wetherell Treatment Systems, Inc.

E83366 Wiltech of Florida Corporation

E37658 Wisconsin State Laboratory of Hygiene

E87814 Woods Hole Analytical Laboratories, Ltd.

E87603 XENCO Laboratories - Houston

E86678 XENCO Laboratories - Miami

E86675 XENCO Laboratories - Tampa

E84793 Zephyrhills Spring Water Company

Data Element Name Source

UQL STORET/WQX

Temperature (LabReceipt) ADaPT

Custody_Intact_Seal ADaPT

Relative Depth STORET/WQX

Limitation IDM (CMN-MD17)

Access Restrictions IDM (CMN-CMN18)

Data Quality Objectives IDM (CMN-MD24)

Ancillary Information IDM (CMN-MD26)

Use Constraints IDM (GEO-MD13)

Update Schedule IDM (GEO-MD12)

Progress Status IDM (GEO-MD20)

Source Scale Denominator IDM (GEO-MD21)

Aerial Remote Sensing Metadata Standards IDM (AER-MD3 to AER-MD32)

Oceans Observing Metadata Standards IDM (OCN-MD4 to OCN-MD27)

Data Validation Method IDM (LAB-MD17)

Entity Accreditation IDM (LAB-MD41)

Biological Measurements Metadata IDM (BIO-MD1 to BIO-MD13)

ResultDetectionConditionText WQX

MeasureQualifierCode WQX

ResultWeightBasisText WQX

ResultTimeBasisText WQX

ResultTemperatureBasisText WQX

ResultParticleSizeBasisText WQX

ConfidenceIntervalValue WQX

UpperConfidenceLimitValue WQX

LowerConfidenceLimitValue WQX

ResultDepthHeightMeasure:MeasureValue WQX

ResultDepthHeightMeasure:MeasureUnitCode WQX

ResultDepthHeightMeasure: ResultDepthAltitudeReferencePointText WQX

ResultDepthHeightMeasure: ResultSamplingPointName WQX

BiologicalIntentName WQX

BiologicalIndividualIdentifier WQX

SubjectTaxonomicName WQX







ExcludedFields Page 106

UnidentifiedSpeciesIdentifier WQX

SampleTissueAnatomyName WQX

GroupSummaryCountWeight: MeasureValue WQX

GroupSummaryCountWeight: MeasureUnitCode WQX

TaxonomicDetails: CellFormName WQX

TaxonomicDetails: CellShapeName WQX

TaxonomicDetails: HabitName WQX

TaxonomicDetails: VoltinismName WQX

TaxonomicDetails: TaxonomicPollutionTolerance WQX

TaxonomicDetails: TaxonomicPollutionToleranceScaleText WQX

TaxonomicDetails: TrophicLevelName WQX

TaxonomicDetails: FunctionalFeedingGroupName WQX

TaxonomicDetailsCitation: ResourceTitleName WQX

TaxonomicDetailsCitation: ResourceCreatorName WQX

TaxonomicDetailsCitation: ResourceSubjectText WQX

TaxonomicDetailsCitation: ResourcePublisherName WQX

TaxonomicDetailsCitation: ResourceDate WQX

TaxonomicDetailsCitation: ResourceDate ResourceIdentifier WQX

FrequencyClassInformation: FrequencyClassDescriptorCode WQX

FrequencyClassInformation: FrequencyClassDescriptorUnitCode WQX

FrequencyClassInformation: LowerClassBoundValue WQX

FrequencyClassInformation: UpperClassBoundValue WQX

ResultAnalyticalMethod:MethodQualifierTypeName WQX

ResultAnalyticalMethod: MethodDescriptionText WQX

AnalysisEndDate WQX

AnalysisEndTime: Time WQX

AnalysisEndTime TimeZoneCode WQX

ResultLaboratoryCommentCode WQX

LaboratoryAccreditationIndicator WQX

LaboratoryAccreditationAuthorityName WQX

TaxonomistAccreditationIndicator WQX

TaxonomistAccreditationAuthorityName WQX

PreparationEndDate WQX

PreparationEndTime: Time WQX







ExcludedFields Page 107

PreparationEndTime: TimeZoneCode WQX

ActivityDepthAltitudeReferencePointText WQX

ActivityLocation: SourceMapScaleNumeric WQX

ActivityLocation (HorizontalAccuracyMeasure):MeasureValue WQX

ActivityLocation (HorizontalAccuracyMeasure):MeasureUnitCode WQX

AssemblageSampledName WQX



BiologicalHabitatCollectionInformation (CollectionDuration): MeasureValue WQX

BiologicalHabitatCollectionInformation

(CollectionDuration):MeasureUnitCode WQX

BiologicalHabitatCollectionInformation (CollectionDuration):

SamplingComponentName WQX

BiologicalHabitatCollectionInformation (CollectionDuration):

SamplingComponentPlaceInSeriesNumeric WQX

ReachLengthMeasure: MeasureValue WQX

ReachLengthMeasure: MeasureUnitCode WQX

ReachWidthMeasure: MeasureValue WQX

ReachWidthMeasure: MeasureUnitCode WQX

PassCount WQX

NetTypeName WQX

NetSurfaceAreaMeasure: MeasureValue WQX

NetSurfaceAreaMeasure: MeasureUnitCode WQX

NetMeshSizeMeasure: MeasureValue WQX

NetMeshSizeMeasure: MeasureUnitCode WQX

BoatSpeedMeasure: MeasureValue WQX

BoatSpeedMeasure: MeasureUnitCode WQX

CurrentSpeedMeasure: MeasureValue WQX

CurrentSpeedMeasure: MeasureUnitCode WQX

ToxicityTestType WQX

SampleCollectionMethod: MethodQualifierTypeName WQX

SampleCollectionMethod: MethodDescriptionText WQX

SampleCollectionEquipmentCommentText WQX

SamplePreparationMethod: MethodQualifierTypeName WQX

SamplePreparationMethod: MethodDescriptionText WQX

SampleContainerTypeName WQX







ExcludedFields Page 108

SampleContainerColorName WQX

ChemicalPreservativeUsedName WQX

ThermalPreservativeUsedName WQX

SampleTransportStorageDescription WQX

ActivityAttachedBinaryObject: BinaryObjectFileName WQX

ActivityAttachedBinaryObject: BinaryObjectFileTypeCodeResult WQX

MOL_FACTOR OGWIS (T_Parameter Table)

MEQ_FACTOR OGWIS (T_Parameter Table)

TDS_FACTOR OGWIS (T_Parameter Table)

PRIMARY OGWIS (T_Parameter Table)

SECONDARY_HIGH OGWIS (T_Parameter Table)

SECONDARY_LOW OGWIS (T_Parameter Table)

GUIDANCE_LIMIT OGWIS (T_Parameter Table)

OTHER_RISK OGWIS (T_Parameter Table)

OTHER_SRA OGWIS (T_Parameter Table)

CLASS3_STANDARD OGWIS (T_Parameter Table)

STATUS_LAKE OGWIS (T_Parameter Table)

STATUS_STREAM OGWIS (T_Parameter Table)

STATUS_AQUIFER OGWIS (T_Parameter Table)

SW_TREND OGWIS (T_Parameter Table)

GW_TREND OGWIS (T_Parameter Table)

INFLUENCES OGWIS (T_Parameter Table)

COMMENTS OGWIS (T_Parameter Table)

STORET_NAME OGWIS (T_Parameter Table)

FK_STATION OGWIS (T_Sample Table)

FK_PROJECT OGWIS (T_Sample Table)

NUMBER_OF_RESULTS OGWIS (T_Sample Table)

REPORTINT UNIT NAME OGWIS (T_Sample Table)

FK RANDOM SAMPLE LOCATION OGWIS (T_Sample Table)

FK_SAMPLE OGWIS (T_Result Table)

FK_PARAM_CODE OGWIS (T_Result Table)

ANALYZING_AGENCY OGWIS (T_Result Table)

JOB_NAME OGWIS (T_Result Table)

VALUE_QUALIFIER_HISTORIC OGWIS (T_Result Table)







ExcludedFields Page 109

T_RQ_LIST (Entire Table) OGWIS (T_RQ_LIST)

JOB_NAME OGWIS (T_RECEIPT)

JOB_DESCRIPTION OGWIS (T_RECEIPT)

BARCODE_ID OGWIS (T_RECEIPT)

LIMS_CUSTOMER_CODE OGWIS (T_RECEIPT)

LIMS_PROJECT_CODE OGWIS (T_RECEIPT)

AGENCY CODE OGWIS (T_RECEIPT)

SAMPLE_COLLECTION_AGENCY OGWIS (T_RECEIPT)

TESTS OGWIS (T_RECEIPT)

FK_PROJECT OGWIS (T_RECEIPT)

COMPLETED OGWIS (T_RECEIPT)

SHIP_TIME_DAYS OGWIS (T_RECEIPT)

DATE_LIMS_OUTPUT OGWIS (T_RECEIPT)

DATE_DATA_RECEIVED OGWIS (T_RECEIPT)

TURNAROUND_TIME_DAYS OGWIS (T_RECEIPT)

QA_SAMPLE OGWIS (T_RECEIPT)

DATE_DATA_TRANSFERRED OGWIS (T_FIELD_DATA/AMBIENT_DATA)

CUSTOMER_ID OGWIS (T_FIELD_DATA/AMBIENT_DATA)

ANALYSIS_ID OGWIS (T_FIELD_DATA/AMBIENT_DATA)

TEST_COMMENT OGWIS (T_FIELD_DATA/AMBIENT_DATA)

SOURCE OGWIS (T_FIELD_DATA/AMBIENT_DATA)

FK_STATION OGWIS (T_FIELD_DATA/AMBIENT_DATA)









ExcludedFields Page 110



Related docs
Other docs by qingyunliuliu
iFebruary 2010 special issue-rr _revised_
Views: 0  |  Downloads: 0
Overview of the New Highway Safety Manual
Views: 9  |  Downloads: 0
60057
Views: 0  |  Downloads: 0
Insure Idaho_
Views: 2  |  Downloads: 0
4-IP_Networking
Views: 0  |  Downloads: 0
01_84_00-Maintenance_Products
Views: 0  |  Downloads: 0
SFO_BP_2010061617
Views: 3  |  Downloads: 0
Reduce + Rusee = Green Preservation
Views: 0  |  Downloads: 0
bog5.31.07
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!