EDGE Field Results Export

<< Click to Display Table of Contents >>

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

EDGE Field Results Export

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

 

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