EQuIS WQX Reports and Views

EQuIS WQX reports are used to export WQX data from EQuIS as a Microsoft Excel spreadsheet file or text file that can then be uploaded to WQXWeb. These reports are generated as a Microsoft Excel spreadsheet file or text file and can be uploaded to WQXWeb.

Database Views

The following Views are created within the database with the application of the EQuIS WQX Schema (schema.WQX.xme) file:

•WQX.ACTIVITY – Returns data that details a sampling activity or observation.

•WQX.ACTIVITYGROUP – Returns data detailing the sampling activity group.

•WQX.ACTIVITYMETRIC – Returns data detailing the metrics of a sampling activity.

•WQX.BINARYOBJECT – Returns details of the file(s) associated with WQX data.

•WQX.BIOLOGICALHABITATINDEX – Returns data detailing the biological index score of a particular habitat.

•WQX.MONITORINGLOCATION – Returns data that details the monitoring location referenced in sampling activities and observations.

•WQX.ORGANIZATION – Returns details about the WQX organization.

•WQX.PROJECT – Returns details about the WQX project.

•WQX.PROJMONLOC – Returns details of the project monitoring location.

•WQX.RESULT – Returns data detailing the results of a sampling activity or observation.

•WQX.RESULTDETECTQUANTLIMIT – Returns data detailing the detection and/or quantitation limit of a sampling activity.

Database Reports

The following reports are created within the database with the application of the EQuIS WQX Schema (schema.WQX.xme) file:

•WQX: Activity – Gives a summary of a sampling activity.

•WQX: Activity Metric – Gives the metrics of a sampling activity.

•WQX: Binary Object – Gives the file information associated with a sampling activity.

•WQX: Biological Habitat Index – Gives the index for locations associated with a sampling activity.

•WQX: Monitoring Location – Gives the details of locations associated with a sampling activity.

•WQX: Project – Gives the details of projects associated with a sampling activity.

•WQX: Result – Gives the results and sampling details associated with a sampling activity.

•WQX: Result Detection Quantitation Limit – Gives a summary of analytical result details for a sampling activity.

DLL Report Files

The following report files are available with the EQuIS WQX format package:

•WQX: PhysicalChemical_Result config7043 Report (Earthsoft.Reports.Library.d51374.dll) – Used to export physical and chemical data from an EQuIS database to the WQX data warehouse. The report is configured for the WQX 3.0 - Physical/Chemical template.

•WQX: Habitat_Result config7044 Report (Earthsoft.Reports.Library.d52163.dll) – Used to export habitat data from an EQuIS database to the WQX data warehouse. The report is configured for the WQX 3.0. - Habitat template.

•WQX: Biological_Result config7045 Report (Earthsoft.Reports.Library.d52163.dll) – Used to export biological data from an EQuIS database to the WQX data warehouse. The report is configured for the WQX 3.0 - Biological template.