WQX: Result Detection Quantitation Limit Report

Report Name: WQX: Result Detection Quantitation Limit

File Name: schema.WQX.xme

Dependencies: EQuIS WQX Schema

Software: EQuIS Professional and EQuIS Enterprise

Source: Available in the EQuIS WQX package (EQEDD_WQX_FormatPackage.zip) on the EarthSoft Community Center downloads dashboard from the All Items > Formats folder for users who have Download access.

Language: English

Output Type: Report Grid1

Description: The Water Quality eXchange (WQX) is a standardized data framework and submission mechanism for sharing water quality data that is administered by the United States Environmental Protection Agency (USEPA). The fields in the output of the WQX: Result Detection Quantitation Limit report gives a summary of analytical result details for a sampling activity.

See the EQuIS WQX Package Overview for more information on WQX, related terminology, and anticipated workflow for using EQuIS to submit data to WQX.

Installation Instructions: This report is automatically created when the EQuIS WQX Schema is applied to the EQuIS database. The EQuIS WQX Schema available as part of a format package (EQEDD_WQX_FormatPackage.zip). See the WQX Package Installation and Configuration article for more details.

Notes:

•The EQuIS WQX Schema (schema.WQX.xme) is not included with the standard EQuIS installation and must be manually applied. See Apply Additional Modules/Schemas to a Database for additional information.  

•A Premium Enterprise license is required to apply the EQuIS WQX Schema to an EQuIS Enterprise site. See Applying Licenses in EQuIS Enterprise for additional information.

Overview: Many fields in the WQX.RESULTDETECTQUANTLIMIT views table are also present in the WQX: Result Detection Quantitation Limit report. This report automatically filters by ORIGID (facility where this report is being generated).

Tables: DT_RESULT_PARAMETER, WQX.RESULT

Report Parameters

Project
Identifier	Code used to identify the parent task under which the field sample was retrieved (aka DT_TASK.PARENT_TASK_CODE associated with DT_SAMPLE.TASK_CODE).
Monitoring Location
HUC (Eight Digit)	Parameter for the 8-digit Hydraulic Unit Code (LOC_MAJOR_BASIN).
HUC (Eight Digit)
HUC (Twelve Digit)	Parameter for the 12-digit Hydraulic Unit Code (LOC_MINOR_BASIN).
State	The monitoring location’s state code (LOC_STATE_CODE).
State
County	The monitoring location’s county code (LOC_COUNTY_CODE).
Identifier	Name of the monitoring location (SYS_LOC_CODE).
Activity
Type	Parameter for the WQX activity type (SAMPLE_TYPE_CODE).
Media	Parameter for the WQX activity media (MEDIUM_CODE).
Media
Subdivision	Parameter for the WQX activity media subdivision (MATRIX_CODE).
Biological
Assemblage	Parameter for the WQX activity assemblage (ASSEMBLAGE).
Date Range
Start	Start date of the WQX activity.
End	End date of the WQX activity.
Result
Characteristic
Individual(s)	Parameter to select one or more analytes.
Group(s)	Parameter to select one or more analyte groups.
Biological
Intent	Parameter for the WQX biological intent (BIOLOGICAL_INTENT).
Taxon (Prefix)	Parameter for the prefix of the WQX taxon name.
Taxon (Prefix)
Taxon	Parameter for the WQX taxon name.

Report Output
ACTIVITYID ANALYTICALMETHODID BIOLRESULTINTENT BIORESULTSUBJECTTAXONOMIC CAS_RN CHARACTERISTICNAME	FACILITY_CODE FACILITY_ID LABANALYSISSTARTDATE LABANALYSISSTARTTIME ORGID	PARAM_CODE PARAM_UNIT PARAM_VALUE RECORDID RESULTSAMPFRACTION TEST_ID

Report Output

ACTIVITYID

ANALYTICALMETHODID

BIOLRESULTINTENT

BIORESULTSUBJECTTAXONOMIC

CAS_RN

CHARACTERISTICNAME

FACILITY_CODE

FACILITY_ID

LABANALYSISSTARTDATE

LABANALYSISSTARTTIME

ORGID

PARAM_CODE

PARAM_UNIT

PARAM_VALUE

RECORDID

RESULTSAMPFRACTION

TEST_ID

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.