EDGE COC Completeness Report

Report Name: EDGE COC Completeness Report (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: The EDGE COC Completeness Report reports on the presence of analytical result data expected to be returned for field samples, as assigned through an EDGE Chain of Custody (COC).

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:

Report Parameters

COC
Select COC(s)	Parameter to select one or more COCs.
Date Range	Section to select start and end data range for COCs.
Sample
Delivery Group(s)	Please select one or more sample delivery groups (field or lab).
Task Filter
Date Range	Section to select start and end date range for tasks.
Department(s)	Parameter for selecting department(s).
Monitoring Program(s)	Parameter for selecting monitoring program(s).
Project(s)	Parameter for selecting project(s).
Monitorying 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(s)	Parameter for selecting Custom Field 1(s).
Custom Field 2(s)	Parameter for selecting Custom Field 2(s).
Custom Field 3(s)	Parameter for selecting Custom Field 3(s).
Custom Field 4(s)	Parameter for selecting Custom Field 4(s).
Custom Field 5(s)	Parameter for selecting Custom Field 5(s).
Status Flag(s)	Parameter for selecting Status Flag(s).
Task Code(s)	Parameter for selecting Task Code(s).
Check by Method	Check box for enabling check by method. Default: True.
Check by Lab	Check box for enabling check by lab. Default: True.
Completeness Status	Parameter for selectin completeness status: C or I.

Report Output
FACILTY_ID FACILITY_CODE SYS_LOC_CODE LOC_NAME LOC_GROUP	LOC_REPORT_ORDER DEPTH PARAM_CODE PARAM_DESC PARAM_VALUE	PARAM_UNIT X_COORD Y_COORD LONGITUDE LATITUDE

Report Output

FACILTY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

DEPTH

PARAM_CODE

PARAM_DESC

PARAM_VALUE

PARAM_UNIT

X_COORD

Y_COORD

LONGITUDE

LATITUDE

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