<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports > Sample Summary by Analyte Group |
Report Name: Sample Summary by Analyte Group (example)
File Name: EarthSoft.Reports.Library.67032.dll
Dependencies: Location Parameters (Extra Fields)
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install
Language: English
Output Type: Excel1 or PDF
Description: The Sample Summary by Analyte Group Report generates analysis information of collected samples included in various groups of analytes.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.
Overview:
The analysis information is represented by a combination of x/X, e/E, s/S, t/T, a/A, z/Z, which marks a sample as detected/non-detected regular results as well as if the results use special leachate methods (see the data mapping below). It is a class report based on the Analytical Results Report.
Analysis data mapping:
DT_TEST.LEACHATE_METHOD |
Sample Summary Code |
null, detected, one or more of the analytes in Regular of the group |
X |
null, not detected, all of the analytes in Regular of the group |
x |
detected SPLP/not detected SPLP |
s/S |
detected TCLP/not detected TCLP |
t/T |
detected EPTOX/not detected EPTOX |
e/E |
detected AVS/not detected AVS |
a/A |
detected ZHE/not detected ZHE |
z/Z |
* Note that lower case letters above refer to non-detect, while upper case letters refer to detected.
This report lists RT_SAMPLE_TYPE.SAMPLE_TYPE_CODE if Location ID (SYS_LOC_CODE) is not found. A sample START_DEPTH/END_DEPTH can be replaced by DT_WELL_SEGMENT.START_DEPTH/END_DEPTH if the sample START_DEPTH/END_DEPTH is not available. In this case, the hidden input parameter plays a role, which is that the DT_SAMPLE.MATRIX_CODE and also DT_WELL_SEGMENT.SEGMENT_TYPE is required to be "SCREEN."
Note: Results may appear in one or more analyte groups. When the result is checked for analysis information, the report first checks if it belongs to a specific group that requires RT_ANALYTIC_METHOD.CATEGORY or RT_LOOKUP.LOOKUP_DESC to be populated with the group name that the results belong to. For example, if the RT_ANALYTIC_METHOD.CATEGORY (e.g. VOCS) of a result is equal to RT_MTH_ANL_GROUP.METHOD_ANALYTE_GROUP_CODE (e.g. VOCS), the result only belongs to the VOCS group when analysis information is checked.
If RT_ANALYTIC_METHOD.CATEGORY does not exist in the database, RT_LOOKUP.LOOKUP_DESC can be used to replace it where RT_LOOKUP.LOOKUP_CODE=ANALYTIC_METHOD and RT_LOOKUP.LOOKUP_TYPE='analytic_method_category'. |
Tables: The Sample Summary Report uses the same tables by the Analytical Results Report in addition to the following tables: DT_WELL_SEGMENT, RT_SAMPLE_TYPE.
Report Parameters |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.
** This report includes hidden parameter: Matrix code for groundwater |
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021