Analytical Results (v54)

<< Click to Display Table of Contents >>

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

Analytical Results (v54)

Report Name: Analytical Results (example)

Function Name: v54.analytical_results

Dependencies: None

Software: EQuIS Professional

Source: EQuIS Professional install (StandardReports schema)

Language: English

Output Type: Report Grid1

 

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Analytical Results report was replaced by Analytical Results II. EarthSoft recommends using the Analytical Results II report rather than Analytical Results to take advantage of additional features, fixes, and performance optimization.

 

Description: Analytical Results originated in EQuIS 5.4 as the core table-valued function for reporting analytical data. It has been superseded by the class report Analytical Results II, which adds features like Additional Fields, Extra Selects, and Transformations.

 

Installation Instructions: This report is part of the EQuIS StandardReports Schema and is created upon applying that Schema (required by EQuIS) to an EQuIS database.

 

Overview:

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample


Type(s)

Select one or more sample types

Date Range

Section to select the start date and end date.

Matrix(es)

Select one or more sample matrix.

Task(s)

Select one or more tasks.

Delivery Group(s)

Select one or more delivery group.

Geologic Unit(s)*

Select one or more geologic units (from DT_STATIC_PROPS.GEOLOGIC_UNIT_CODE) to filter the data.

Depth

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

 

If depths are specified, depth unit is required, and samples with corresponding NULL values in the depths specified (start depth and/or end depth) will be excluded.

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.

Result


Analyte [Individual(s) or Group(s)]

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 the non-detect multiplier.

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.)

* This report includes hidden parameters that could affect the output of the report:

facility_id, ebatch, and geologic_units

 

Consult an EQuIS administrator if these parameters should be visible or use different default values.

 

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

GEOLOGIC_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.