EDGE Sample Summary Report

Report Name: EDGE Sample Summary (example)

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

Dependencies: Licensed EDGE Module and EDGE Schema

Software: EDGE

Source: EDGE install

Language: English

Output Type: Excel1

Description: Summarizes EDGE field samples and related analysis and COCs.

Installation Instructions: This report requires a licensed EDGE Module and the EDGE Schema applied to the database. For EQuIS Professional use, copy the EarthSoft.Reports.Library.40338.dll file from the EDGE\reports installation directory to the EQuIS Professional installation folder. For default installations, this directory is C:\Program Files\EarthSoft\EQuIS. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview:

Notes Regarding Table Below

•Sample dates filter applies to DT_SAMPLE.SAMPLE_DATE

•Task dates filter applies to DT_TASK.START_DATE

•Compact Format: The report output can be set to compact format where rows are grouped by facility, sample, and lab.

Tables: DT_TASK, DT_CHAIN_OF_CUSTODY, DT_SAMPLE, DT_FIELD_SAMPLE, DT_TEST, DT_CHAIN_OF_CUSTODY_MAG

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Sample Date Range	Section to select the start date, end date.
Task Filter
Date Range
Start	Start date parameter selection.
End	End date parameter selection.
Department(s)	Parameter for selecting department(s).
Monitoring Program(s)	Parameter for selecting monitoring program(s).
Project(s)	Parameter for selecting project(s).
Monitoring Type(s)	Parameter for selecting monitoring type(s).
Authority(s)	Parameter for selecting authority(s).
Authority Type(s)	Parameter for selecting authority type(s).
Task Type(s)	Parameter for selecting task type(s).
Priority Ranking(s)	Parameter for selecting priority ranking(s).
Custom Field 1	Parameter for selecting Custom Field 1(s).
Custom Field 2	Parameter for selecting Custom Field 2(s).
Custom Field 3	Parameter for selecting Custom Field 3(s).
Custom Field 4	Parameter for selecting Custom Field 4(s).
Custom Field 5	Parameter for selecting Custom Field 5(s).
Status Flag(s)	Parameter for selecting status flag(s).
Task Code(s)	Parameter for selecting SPM task code(s).
Compact Format?	Check box to compact the format to show only one row per sample and COC. Default: True.

Report Output
SYS_LOC_CODE GROUP_TYPE SAMPLE_DATE START_DATE END_DATE CLIENT MONITORING_PROGRAM	TASK_CODE *where TASK_TYPE=project MONITORING_TYPE AUTHORITY AUTHORITY_TYPE TASK_TYPE DELIVERY_ORDER	CUSTOM_FIELD_1 CUSTOM_FIELD_2 CUSTOM_FIELD_3 CUSTOM_FIELD_4 CUSTOM_FIELD_5 STATUS_FLAG TASK_CODE

Report Output

SYS_LOC_CODE

GROUP_TYPE

SAMPLE_DATE

START_DATE

END_DATE

CLIENT

MONITORING_PROGRAM

TASK_CODE

*where TASK_TYPE=project

MONITORING_TYPE

AUTHORITY

AUTHORITY_TYPE

TASK_TYPE

DELIVERY_ORDER

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

STATUS_FLAG

TASK_CODE

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