Sample Summary by Analyte Group (67032)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Sample Summary by Analyte Group (67032)

Report Name: Sample Summary by Analyte Group (67032)

 

Report Type: Standard

 

Description: The Sample Summary by Analyte Group Report generates analysis information of collected samples included in various groups of

analytes. 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: 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'.

 

Report Dependencies: Location Parameters (Extra Fields) (65991)

 

File Name: EarthSoft.Reports.Library.67032

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

The Sample Summary Report includes all the input parameters from the Analytical Results Report, in addition to the input parameters shown in the table below.

 

Note the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Sample




Samples




Sample ID (sys_sample_code)

Test




Lab Name (lab_name_code)



Leachate Method


Header




Header Line 1:



Header Line 2:



Header Line 3:



Individual(s)


Footer




Footer Line 1:



Footer Line 2:



Task(s)


Note




Note Line 1:



Note Line 2:



Note Line 3:



Note Line 4:



Note Line 5:


Output File Type



Add a Watermark



Columns per page for pdf



*Matrix code for groundwater



Additional Fields



                                               

Contact support@earthsoft.com

for more information.

Contact support@earthsoft.com for more information.

 

Note: * refers to hidden parameters

 

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.

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: After EQuIS 5.5.1

 

Data Requirements: See the 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

SPLP

*s/S

TCLP

t/T

EPTOX

e/E

AVS

a/A

ZHE

z/Z

* Note that lower case letters above refer to non-detect, while upper case letters refer to detected.

 

1.The report lists  RT_SAMPLE_TYPE.SAMPLE_TYPE_CODE if  Location ID (SYS_LOC_CODE) is not found;

2.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."

 

Report Requirements: N/A

 

Output Type: PDF or Excel

 

Example Output: View the following example.

 

30088-LEA_Summary_report