Analytical Results by EDDs

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Analytical Results by EDDs

Report Name: Analytical Results by EDDs (example)

File Name: EarthSoft.Reports.Library.55396.dll

Dependencies: Analytical Results II (EarthSoft.Reports.Library.50943.dll)

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The Analytical Results by EDDs Report is an advanced version of the Analytical Results II Report. This report includes a new group of input parameters, "EDD". The EDD date range will query Analytical Results on the dates the results were loaded to EQuIS.

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

 

Overview:

When "Use EDD Date Range" is not checked, the report will function as the Analytical Results II Report, using the date range specified in the Sample input parameter group. If the "Use EDD Date Range" input parameter is checked, the date range specified in the EDD input parameter group will override the date range specified in the Sample input parameter group. These dates are found in the ST_EDD_BATCH.EDD_DATE field.

 

Source Tables DT_FIELD_SAMPLE, DT_LITHOLOGY, DT_LOCATION, DT_RESULT_QC, DT_SAMPLE, DT_STATIC_PROPS, DT_SUBFACILITY, DT_TASK, DT_WATER_LEVEL, DT_WELL

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Use DT_GEOGRAPHY for coordinate data

Toggle to use DT_GEOGRAPHY for coordinate data

Sample


Type(s)

Select one or more sample types

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events

Matrix(es)

Select one or more sample matrix

Task(s)

Select one or more tasks

Task_Code_2(s)


Field SDG(s)

Select one or more Field SDGs

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit

DQM Status

Select the DQM status.

Test


Method(s)

Select one or more test method

Fraction(s)

Select one or more fraction

Column Number(s)

Select one or more column number

Type(s)

Select one or more test type

Lab Matrix(es)

Select one or more lab matrixes

Prep Method(s)

Select one or more prep methods

Lab SDG(s)

Select one or more Lab SDGs

Result


Analyte

Section for selecting analytes and/or analyte groups

Unit

Selection for report result units

Type(s)

Select one or more result type

Detect Flag(s)

Select one or more options for detect flag.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Non-Detect Qualifier

Select one or more non-detect qualifiers

Reportable

Select one or more options for reportable result.

Reporting Limit

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Additional Fields

Additional fields parameter

EDD


Use EDD date range

Check box to use an EDD date range

Date range

Section for choosing the EDD date range start and end dates.

Check to match dt_sample.ebatch and dt_result.ebatch; Uncheck to match only dt_sample.ebatch

Check to match dt_sample.ebatch and dt_result.ebatch; Uncheck to match only dt_sample.ebatch

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter

 

 

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

GEOLOGICAL_UNIT_CODE TASK_CODE

TASK_DESC

FIELD_SDG

PARENT_SAMPLE_CODE ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD ANALYSIS_DATE

COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_METHOD

LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR METHOD_ANALYTE_GROUP

REPORT_ORDER

TEST_ID

CAS_RN

CHEMICAL_NAME

ORGANIC_YN REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT REPORT_RESULT_LIMIT

REPORTABLE_RESULT DETECT_FLAG

INTERPRETED_QUALIFIERS VALIDATOR_QUALIFIERS

LAB_QUALIFIERS

QUANTITATION_LIMIT METHOD_DETECTION_LIMIT REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT

APPROVAL_CODE

RESULT_TEXT

RESULT_NUMERIC

RESULT_UNIT

RESULT_TYPE_CODE

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

 

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.