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

Report Output

ANALYSIS_DATE

ANALYSIS_LOCATION

ANALYTIC_METHOD

CAS_RN

CHAIN_OF_CUSTODY

CHEMICAL_NAME

COLLECTION_QUARTER

COLUMN_NUMBER

COMPOSITE_DESC

COMPOSITE_YN

CUSTOM_FIELD_1 (2,3,4,5)

DATA_PROVIDER

DEPTH_UNIT

DETECT_FLAG

EDGE_ID

END_DEPTH

EQUIPMENT_CODE

FIELD_LAB_CODE

FIELD_SDG

FILTER_TYPE

FILTERED_DATE

FLD_QUALIFIER

FLD_QUALIFIER_NOTE

FRACTION

INTERPRETED_QUALIFIERS

LAB_NAME_CODE

MATERIAL_NAME

MATRIX_CODE

MEDIUM_CODE

PARENT_SAMPLE_CODE

QUANTITATION_LIMIT

REMARK

REPORTABLE_RESULT

RESULT_TEXT

RESULT_TYPE_CODE

RESULT_UNIT

SAMPLE_CLASS

SAMPLE_DATE

SAMPLE_METHOD

SAMPLE_NAME

SAMPLE_RECEIPT_DATE

SAMPLE_SOURCE

SAMPLE_START_DATE

SAMPLE_TYPE_CODE

SAMPLER

SAMPLING_COMPANY_CODE

SAMPLING_REASON

SENT_TO_LAB_DATE

START_DEPTH

SYS_LOC_CODE

SYS_SAMPLE_CODE

TASK_CODE

TEST_TYPE

VALUE_TYPE

WEATHER_2

WEATHER_CONDITION

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