AQS Raw Data

Report Name: AQS Raw Data (example)

File Name: EarthSoft.Reports.Library.197368.dll

Dependencies: Licensed AQS and AQS Schema

Software: EQuIS Professional

Source: AQS Module on the EarthSoft Community Center > Products > AQS Module > 2022 for those who have Download access

Language: English

Output Type: Report Grid1

Description: This report indicates sample, test and result data under selected parameters such as locations, analytes, etc. associated with the AQS Raw Data transaction type.

Installation Instructions: Download the AQS_QA_Reports.zip, unblock the *.zip file and extract the EarthSoft.Reports.Library.197368.dll to 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 use in EQuIS Enterprise, an administrator must publish the report to the database in EQuIS Professional.

Overview:

Tables: DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_FIELD_SAMPLE, DT_TEST, DT_RESULT

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Test
Analytic Method	Parameter for selecting individual analytical methods.
Result > Analyte
Individual(s)	Parameter for selecting individual analytes.
Group(s)	Parameter for selecting analytic groups.
Date Range
Start	Section to select the start date.
End	Section to select the end date

Report Output
TRANSACTION TYPE ACTION_INDICATOR STATE_CODE COUNTY_CODE SITE_NUMBER PARAMETER POC DURATION_CODE	REPORTED_UNIT METHOD_CODE SAMPLE_DATE SAMPLE_BEGIN_TIME REPORTED_SAMPLE_VALUE NULL_DATA_CODE COLLECTION_FREQUENCY_CODE MONITOR_PROTOCOL_ID	QUALIFIER_CODE_1 ... QUALIFIER_CODE_10 ALTERNATE_METHOD_DETECTION_LIMIT UNCERTAINTY_VALUE COLUMN_NUMBER FRACTION TEST_TYPE SCREENING_GROUP_CODE

Report Output

TRANSACTION TYPE

ACTION_INDICATOR

STATE_CODE

COUNTY_CODE

SITE_NUMBER

PARAMETER

POC

DURATION_CODE

REPORTED_UNIT

METHOD_CODE

SAMPLE_DATE

SAMPLE_BEGIN_TIME

REPORTED_SAMPLE_VALUE

NULL_DATA_CODE

COLLECTION_FREQUENCY_CODE

MONITOR_PROTOCOL_ID

QUALIFIER_CODE_1

...

QUALIFIER_CODE_10

ALTERNATE_METHOD_DETECTION_LIMIT

UNCERTAINTY_VALUE

COLUMN_NUMBER

FRACTION

TEST_TYPE

SCREENING_GROUP_CODE

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