WQX: Biological_Result config7045 Report

Report Name: WQX: Biological_Result config7045

File Name: Earthsoft.Reports.Library.d43736.dll

Dependencies: Not Applicable

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: Biological_Result config7045 report correspond to the fields in the WQX Biological Template. This report can be used to export properly formatted water quality data that can then be manually uploaded to WQX via WQXWeb, an online tool used to upload and share data with the USEPA and the public. The WQX Biological Template can be accessed from Water Quality eXchange Web Template Files | US EPA.

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 available as part of a format package (EQEDD_WQX_FormatPackage.zip). See the WQX Package Installation and Configuration article for more details.

Place the report file (Earthsoft.Reports.Library.d43736.dll) in the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS or (for per-user installation) %localappdata%\Programs\EarthSoft\EQuIS\. The report will be available for selection once Professional has been relaunched.

For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

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: The WQX: Biological_Result config7045 report uses the same parameters as the WQX: Result report, which is included in the EQuIS WQX Schema. The report output is structured like the WQX Biological Template (specifically the "Results - config#7045) and is used to upload data from EQuIS to WQXWeb. The report is configured for the WQX 3.0 - Biological template.

The following file types are acceptable for upload to WQXWeb:

•CSV (Comma delimited)

•Microsoft Excel (xlsx)

•Microsoft Excel 97-2003 (xls)

•Text (Pipe delimited)

•Text (Tab delimited)

•Text (Tilde delimited)

Tables: DT_BIOLOGICAL_RESULT, DT_BIOLOGICAL_SAMPLE, DT_COORDINATE, DT_RESULT, DT_RESULT_PARAMETER, DT_SAMPLE, DT_TASK, DT_TEST, RT_EQUIPMENT_TYPE, RT_SAMPLE_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 ANALYTIC_METHOD APPROVAL_CODE ASSEMBLAGE BASIS BIOLOGICAL_INTENT BOAT_SPEED BOAT_SPPED_UNIT CAS_RN CELL_FORM CELL_SHAPE CHARACTERISTIC_NAME_USER_SUPPLIED COMPONENT_NAME COMPONENT_SEQUENCE CONTEXT CUSTOM_FIELD_2 CUSTOM_FIELD_5 DEPTH_UNIT DETECTION_LIMIT_UNIT DURATION DURATION_UNIT EQUIPMENT_TYPE EQUIPMENT_TYPE_DESC FEEDING_GROUP FRACTION GEOMETRIC_TYPE_CODE	GROUP_SUMMARY_COUNT GROUP_SUMMARY_UNIT GROUP_SUMMARY_VALUE HABIT_1 HABITAT_SELECTION_METHOD INDIVIDUAL_ID MEDIUM_CODE METHOD_SPECIATION NET_MESH_SIZE NET_MESH_SIZE_UNIT NET_SURFACE_AREA NET_SURFACE_AREA_UNIT NET_TYPE PARENT_TASK_CODE POLLUTION_TOLERANCE POLLUTION_TOLERANCE_SCALE PROPORTION_SAMPLE_PROCESSED_NUMERIC REACH_LENGTH REACH_LENGTH_UNIT REACH_WIDTH REACH_WIDTH_UNIT REMARK REPORTING_DETECTION_LIMIT RESULT_DEPTH_REFERENCE_POINT RESULT_NUMERIC	RESULT_SAMPLING_POINT RESULT_SAMPLING_POINT_COMMENT RESULT_TEXT RESULT_UNIT SAMPLE_DATE SAMPLE_DATE_TIMEZONE SAMPLE_METHOD SAMPLE_NAME SAMPLE_TYPE_CODE START_DEPTH STAT_TYPE SYS_LOC_CODE SYS_SAMPLE_CODE TARGET_COUNT TASK_CODE TASK_DESC TASK_TYPE TAXON TAXON_NAME_USER_SUPPLIED TAXON_NAME_USER_SUPPLIED_REF_TEXT TISSUE_ANATOMY TROPHIC_LEVEL UNKNOWN_SPECIES_IDENTIFIER VALUE_TYPE VOLTINISM

Report Output

ANALYSIS_DATE

ANALYTIC_METHOD

APPROVAL_CODE

ASSEMBLAGE

BASIS

BIOLOGICAL_INTENT

BOAT_SPEED

BOAT_SPPED_UNIT

CAS_RN

CELL_FORM

CELL_SHAPE

CHARACTERISTIC_NAME_USER_SUPPLIED

COMPONENT_NAME

COMPONENT_SEQUENCE

CONTEXT

CUSTOM_FIELD_2

CUSTOM_FIELD_5

DEPTH_UNIT

DETECTION_LIMIT_UNIT

DURATION

DURATION_UNIT

EQUIPMENT_TYPE

EQUIPMENT_TYPE_DESC

FEEDING_GROUP

FRACTION

GEOMETRIC_TYPE_CODE

GROUP_SUMMARY_COUNT

GROUP_SUMMARY_UNIT

GROUP_SUMMARY_VALUE

HABIT_1

HABITAT_SELECTION_METHOD

INDIVIDUAL_ID

MEDIUM_CODE

METHOD_SPECIATION

NET_MESH_SIZE

NET_MESH_SIZE_UNIT

NET_SURFACE_AREA

NET_SURFACE_AREA_UNIT

NET_TYPE

PARENT_TASK_CODE

POLLUTION_TOLERANCE

POLLUTION_TOLERANCE_SCALE

PROPORTION_SAMPLE_PROCESSED_NUMERIC

REACH_LENGTH

REACH_LENGTH_UNIT

REACH_WIDTH

REACH_WIDTH_UNIT

REMARK

REPORTING_DETECTION_LIMIT

RESULT_DEPTH_REFERENCE_POINT

RESULT_NUMERIC

RESULT_SAMPLING_POINT

RESULT_SAMPLING_POINT_COMMENT

RESULT_TEXT

RESULT_UNIT

SAMPLE_DATE

SAMPLE_DATE_TIMEZONE

SAMPLE_METHOD

SAMPLE_NAME

SAMPLE_TYPE_CODE

START_DEPTH

STAT_TYPE

SYS_LOC_CODE

SYS_SAMPLE_CODE

TARGET_COUNT

TASK_CODE

TASK_DESC

TASK_TYPE

TAXON

TAXON_NAME_USER_SUPPLIED

TAXON_NAME_USER_SUPPLIED_REF_TEXT

TISSUE_ANATOMY

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.