AQS Raw Blanks

Report Name: AQS Raw Blanks (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 Blanks 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 BLANK_TYPE BLANK_DATE BLANK_TIME BLANK_VALUE NULL_DATA_CODE SCREENING_GROUP_CODE	QUALIFIER_CODE_1 ... QUALIFIER_CODE_10 ALTERNATE_METHOD_DETECTION_LIMIT UNCERTAINTY_VALUE COLUMN_NUMBER FRACTION TEST_TYPE

Report Output

TRANSACTION TYPE

ACTION_INDICATOR

STATE_CODE

COUNTY_CODE

SITE_NUMBER

PARAMETER

POC

DURATION_CODE

REPORTED_UNIT

METHOD_CODE

BLANK_TYPE

BLANK_DATE

BLANK_TIME

BLANK_VALUE

NULL_DATA_CODE

SCREENING_GROUP_CODE

QUALIFIER_CODE_1

...

QUALIFIER_CODE_10

ALTERNATE_METHOD_DETECTION_LIMIT

UNCERTAINTY_VALUE

COLUMN_NUMBER

FRACTION

TEST_TYPE

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