Facility Detects by Chemical

Report Name: Facility Detects by Chemical

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

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EarthSoft Community Center Downloads Dashboard under Products > Additional Resources > v7.0 for each organization's EarthSoft Primary Point of Contact (POC)

Language: English

Output Type: Excel1

Description: This report uses Analytical Results as input and performs a crosstab that counts the number of detects for each chemical across the entire facility.

Installation Instructions: Download the Facility Detects by Chemical report from the EarthSoft Community Center. Starting in 7.24.3, the report is packaged together with other standard-by-request reports, i.e., "EQuIS_By_Request_Reports_All_7.24.3.zip"..

Unblock the *.zip file, and extract the DLL to the EQuIS Professional installation folder. For standard installations, this directory is C:\Program Files\EarthSoft\EQuIS; for per-user installations, this directory is %localappdata%\Programs\EarthSoft\EQuIS by default. After the user reopens Professional or refreshes the Open window, the report will appear in the Reports list.

Overview:

This report has the same input parameters as Analytical Results Report.

Tables: All the tables used by the Analytical Results Report

Report Parameters

Analytical Results (Aggregate)	Parameter to select a saved Analytical Results (Aggregate) user report.
FACILITY_ID	Parameter to select a facility.
EBATCH	Parameter to select an EBATCH.
SYS_LOC_CODES	Parameter to select locations.
LOCATION_GROUP	Parameter to select location groups.
SAMPLE_TYPE	Parameter to select sample type.
START_DATE	Parameter to select start date.
END_DATE	Parameter to select end date.
Matrix	Parameter to select matrix.
Task	Parameter to select task.
Sdg	Parameter to select sample delivery group (SDG).
ANL_METHOD	Parameter to select analytical method.
Fraction	Parameter to select fraction.
COLUMN_NUMBER	Parameter to select column number.
CAS_RN	Parameter to select analytes.
ANALYTE_GROUP	Parameter to select analyte groups.
REPORTING_UNIT	Parameter to select reporting unit.
RESULT_TYPE	Parameter to select result types.
DETECT_FLAG	Parameter to select detect flags.
ND_MULTIPLIER	Input for non-detect multiplier.
ND_SYMBOL	Input for non-detect symbol.
REPORTABLE_RESULT	Input for reportable results.

Report Output
SYS_LOC_CODE SYS_SAMPLE_CODE SAMPLE_DATE SAMPLE_DATE_CODE START_DEPTH END_DEPTH MATRIX_CODE TASK_CODE TASK_DESC FIELD_SDG LAB_MATRIX_CODE ANALYTIC_METHOD COLUMN_NUMBER	FRACTION LEACHATE_METHOD LEACHATE_DATE LAB_SDG METHOD_ANALYTE_GROUP REPORT_ORDER CAS_RN CHEMICAL_NAME ORGANIC_YN REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT REPORTABLE_RESULT	DETECT_FLAG INTERPRETED_QUALIFIERS REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT APPROVAL_CODE RESULT_TEXT RESULT_NUMERIC RESULT_UNIT X_COORD Y_COORD Z_COORD_AVG ZFROM ZTO

Report Output

SYS_LOC_CODE

SYS_SAMPLE_CODE

SAMPLE_DATE
SAMPLE_DATE_CODE
START_DEPTH
END_DEPTH
MATRIX_CODE
TASK_CODE
TASK_DESC
FIELD_SDG
LAB_MATRIX_CODE
ANALYTIC_METHOD

COLUMN_NUMBER

FRACTION

LEACHATE_METHOD
LEACHATE_DATE
LAB_SDG
METHOD_ANALYTE_GROUP
REPORT_ORDER
CAS_RN
CHEMICAL_NAME

ORGANIC_YN
REPORT_RESULT_TEXT
REPORT_RESULT_VALUE
REPORT_RESULT_UNIT
REPORTABLE_RESULT

DETECT_FLAG
INTERPRETED_QUALIFIERS
REPORTING_DETECTION_LIMIT
DETECTION_LIMIT_UNIT
APPROVAL_CODE
RESULT_TEXT
RESULT_NUMERIC
RESULT_UNIT
X_COORD
Y_COORD
Z_COORD_AVG

ZFROM

ZTO

1Excel report output requires a valid license of Microsoft Excel to view the output.