Analytical Results by EDDs

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Analytical Results by EDDs

Report Name: Analytical Results by EDDs

 

Report Type: Standard Report

 

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". 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. The EDD date range will query Analytical Results on the dates the results were loaded to EQuIS. These dates are found in the ST_EDD_BATCH.EDD_DATE field.

 

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.

 

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

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report. Note the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start



End



Most Recent Samplling


Matrix(es)



Task(s)



Field SDG(s)



Depth




Minimum
Start Depth



Maximum
End Depth



Maximum
Start Depth



Minimum
End Depth



Unit

Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Method(s)



Lab SDG(s)


Result




Analyte




Individual(s)



Group(s)


Unit



Type(s)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Non-Detect Qualifier



Reportable



Reporting Limit


Additional Fields



EDD




Use EDD
Date Range



Date Range




Start Date



End Date

 

30181-input.param.scrnsht

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

Note: * refers to hidden parameters

 

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

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 6.3+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: IGrid

 

Example Output: View the following example or download the Analytical Results by EDDs.xlsx.

 

30181-ex.output_zoom60