Analytical Results (Hits)

<< Click to Display Table of Contents >>

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

Analytical Results (Hits)

Report Name: Analytical Results (Hits) (example)

Function: v54.analytical_results_hits

Dependencies: v54.analytical_results

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Report Grid1

 

Description: The Analytical Results (Hits) Report is for analyzing analytical hits. Specific logic is used within the report for determining whether or not a result is a hit. For more information, see the Analytical Hits Logic diagram below.

 

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps are necessary.

 

Overview:

Without a 'Hit Flag' parameter specified in the Analytical Results (Hits) Report, the report will only report values with a detect flag of 'Y' and if a reported analyte meets the following conditions:

- An analyte is organic_yn='Y' and its rt.qualifer.organic_hit = 'Y'

or

- An analyte is organic_yn='N' and its rt.qualifer.inorganic_hit = 'Y'

 

With a 'Hit Flag' specified, the report output reflects not only the conditions above but also results not identified as hits.

 

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, 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

Delivery Groups(s)

Select one or more delivery groups

Depth

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

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

Section for selecting analyte groups

Unit

Selection for report result units

Type(s)

Select one or more result type

Reporting Limit

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

Hit Flag

Enter a character(s) for flagging hits.  If null, then only hits will be displayed.

detect_flags

Select one or more options for detect flag.

nd_multiplier

Enter the desired non-detect multiplier value.

nd_symbol

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

reportable_results

Select one or more options for reportable result.

* This report contains hidden paramters: facility_id and ebatch

 

 

Report Output

FLAG

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

 

 

Analytical Results (Hits) logic:

30379_ARHitsLogic

 

 

 

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