EDGE Field Results Export Report

Report Name: EDGE Field Results Export (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: Exports a summary of data taken in the field. The analyte groups available in the parameters list are based on method analyte groups (MAGS) with Type set to FIELD.

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:

Tables: DT_SAMPLE, RT_MATRIX, DT_SAMPLE_PARAMETER, DT_FIELD_SAMPLE, RT_ANALYTE, DT_RESULT, DT_TEST, DT_TASK

Input Parameters

Date Range
Start	Select a start date.
End	Select an end date.
Analyte Groups(s)	Parameter for selecting analyte group(s).
Set fraction to	Parameter for selecting fraction(s).

Report Output
SYS_SAMPLE_CODE SAMPLE_NAME MATRIX_CODE SAMPLE_TYPE_CODE SAMPLE_SOURCE PARENT_SAMPLE_CODE FIELD_SDG SAMPLE_DATE SYS_LOC_CODE START_DEPTH END_DEPTH DEPTH_UNIT CHAIN_OF_CUSTODY SENT_TO_LAB_DATE SAMPLE_RECEIPT_DATE SAMPLER SAMPLING_COMPANY_CODE SAMPLING_REASON SAMPLE_METHOD	TASK_CODE COLLECTION_QUARTER COMPOSITE_YN COMPOSITE_DESC SAMPLE_CLASS CUSTOM_FIELD_1 (2,3,4,5) MATERIAL_NAME REMARK FILTER_TYPE EQUIPMENT_CODE WEATHER_CONDITION WEATHER_2 FLD_QUALIFIER FLD_QUALIFIER_NOTE EDGE_ID SAMPLE_START_DATE FILTERED_DATE FIELD_LAB_CODE MEDIUM_CODE	DATA_PROVIDER CAS_RN CHEMICAL_NAME ANALYSIS_DATE RESULT_TEXT RESULT_UNIT QUANTITATION_LIMIT QUANTITATION_LIMIT INTERPRETED_QUALIFIERS REPORTABLE_RESULT VALUE_TYPE DETECT_FLAG FRACTION ANALYTIC_METHOD ANALYSIS_LOCATION COLUMN_NUMBER RESULT_TYPE_CODE TEST_TYPE LAB_NAME_CODE

Report Output

SYS_SAMPLE_CODE

SAMPLE_NAME

MATRIX_CODE

SAMPLE_TYPE_CODE

SAMPLE_SOURCE

PARENT_SAMPLE_CODE

FIELD_SDG

SAMPLE_DATE

SYS_LOC_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

CHAIN_OF_CUSTODY

SENT_TO_LAB_DATE

SAMPLE_RECEIPT_DATE

SAMPLER

SAMPLING_COMPANY_CODE

SAMPLING_REASON

SAMPLE_METHOD

TASK_CODE

COLLECTION_QUARTER

COMPOSITE_YN

COMPOSITE_DESC

SAMPLE_CLASS

CUSTOM_FIELD_1 (2,3,4,5)

MATERIAL_NAME

REMARK

FILTER_TYPE

EQUIPMENT_CODE

WEATHER_CONDITION

WEATHER_2

FLD_QUALIFIER

FLD_QUALIFIER_NOTE

EDGE_ID

SAMPLE_START_DATE

FILTERED_DATE

FIELD_LAB_CODE

MEDIUM_CODE

DATA_PROVIDER

CAS_RN

CHEMICAL_NAME

ANALYSIS_DATE

RESULT_TEXT

RESULT_UNIT

QUANTITATION_LIMIT

INTERPRETED_QUALIFIERS

REPORTABLE_RESULT

VALUE_TYPE

DETECT_FLAG

FRACTION

ANALYTIC_METHOD

ANALYSIS_LOCATION

COLUMN_NUMBER

RESULT_TYPE_CODE

TEST_TYPE

LAB_NAME_CODE

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