WQX: Result Report

Report Name: WQX: Result

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 report gives the results and sampling details associated with 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.RESULT views table are also present in the WQX: Result report. This report automatically filters by ORIGID (facility where this report is being generated).

Tables: DT_BIOLOGICAL_RESULT, DT_FACILITY, DT_FILE, DT_RESULT, DT_RESULT_PARAMETER, DT_SAMPLE, DT_TEST, RT_ANALYTE, RT_ANALYTIC_METHOD, RT_PREP_METHOD

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
ANALYSIS_DATE ANALYSIS_DATE_TIMEZONE ANALYSIS_END_DATE ANALYTIC_METHOD APPROVAL_CODE AUTHOR BASIS BIOLOGICAL_INTENT CAS_RN CELL_FORM CELL_SHAPE CHEMICAL_NAME CONTEXT CUSTOM_FIELD_2 DILUTION_FACTOR DURATION_BASIS FACILITY_CODE FEEDING_GROUP_1 FEEDING_GROUP_2 FEEDING_GROUP_3 FILE_DATE FILE_NAME FRACTION	FREQUENCY_CLASS_1 FREQUENCY_CLASS_1_LBND FREQUENCY_CLASS_1_UBND FREQUENCY_CLASS_1_UNIT FREQUENCY_CLASS_2 FREQUENCY_CLASS_2_LBND FREQUENCY_CLASS_2_UBND FREQUENCY_CLASS_2_UNIT FREQUENCY_CLASS_3 FREQUENCY_CLASS_3_LBND FREQUENCY_CLASS_3_UBND FREQUENCY_CLASS_3_UNITGROUP_SUMMARY_UNIT GROUP_SUMMARY_VALUE HABIT_1 HABIT_2 HABIT_3 INDIVIDUAL_ID INTERPRETED_QUALIFIERS LAB_NAME_CODE METHOD_SPECIATION PARAM_UNIT PARAM_VALUE	POLLUTION_TOLERANCE POLLUTION_TOLERANCE_SCALE PREFERRED_NAME PREP_DATE PREP_DATE_TIMEZONE PREP_END_DATE PREP_METHOD PUBLISHER QUALIFIER_TYPE REMARK RESULT_TEXT RESULT_UNIT SYS_LOC_CODE SYS_SAMPLE_CODE TAXON TEMP_BASIS TISSUE_ANATOMY TITLE TROPHIC_LEVEL UNKNOWN_SPECIES_IDENTIFIER VALUE_TYPE VOLTINISM

Report Output

ANALYSIS_DATE

ANALYSIS_DATE_TIMEZONE

ANALYSIS_END_DATE

ANALYTIC_METHOD

APPROVAL_CODE

AUTHOR

BASIS

BIOLOGICAL_INTENT

CAS_RN

CELL_FORM

CELL_SHAPE

CHEMICAL_NAME

CONTEXT

CUSTOM_FIELD_2

DILUTION_FACTOR

DURATION_BASIS

FACILITY_CODE

FEEDING_GROUP_1

FEEDING_GROUP_2

FEEDING_GROUP_3

FILE_DATE

FILE_NAME

FRACTION

FREQUENCY_CLASS_1

FREQUENCY_CLASS_1_LBND

FREQUENCY_CLASS_1_UBND

FREQUENCY_CLASS_1_UNIT

FREQUENCY_CLASS_2

FREQUENCY_CLASS_2_LBND

FREQUENCY_CLASS_2_UBND

FREQUENCY_CLASS_2_UNIT

FREQUENCY_CLASS_3

FREQUENCY_CLASS_3_LBND

FREQUENCY_CLASS_3_UBND

FREQUENCY_CLASS_3_UNITGROUP_SUMMARY_UNIT

GROUP_SUMMARY_VALUE

HABIT_1

HABIT_2

HABIT_3

INDIVIDUAL_ID

INTERPRETED_QUALIFIERS

LAB_NAME_CODE

METHOD_SPECIATION

PARAM_UNIT

PARAM_VALUE

POLLUTION_TOLERANCE

POLLUTION_TOLERANCE_SCALE

PREFERRED_NAME

PREP_DATE

PREP_DATE_TIMEZONE

PREP_END_DATE

PREP_METHOD

PUBLISHER

QUALIFIER_TYPE

REMARK

RESULT_TEXT

RESULT_UNIT

SYS_LOC_CODE

SYS_SAMPLE_CODE

TAXON

TEMP_BASIS

TISSUE_ANATOMY

TITLE

TROPHIC_LEVEL

UNKNOWN_SPECIES_IDENTIFIER

VALUE_TYPE

VOLTINISM

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