EDGE Sample Summary

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with EDGE Module >

EDGE Sample Summary

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?

Checkbox 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

 

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