Analytical Results (Hits) - Standard

<< Click to Display Table of Contents >>

Analytical Results (Hits) - Standard

Report Name: Analytical Results (Hits)

 

Report Type: Standard

 

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.

 

Report Dependencies: Analytical Results (v54)

 

File Name: v54.analytical_results_hits

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

facility_id*



ebatch*



Location




Individual(s)



Group(s)


Sample




Date Range

Start Date



End Date


Matrix(es)



Task(s)



Delivery Group(s)



Geologic Unit(s)*



Depth




Minimum Start Depth



Maximum End Depth



Unit

Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Method(s)


Result




Analyte




Individual(s)



Group(s)


Unit



Type(s)



Reporting Limit



Hit Flag


detect_ flags



nd_ multiplier



nd_symbol



reportable_results



                                               

30379_ARhit_param1

30379_ARhit_param2

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

Note: * refers to hidden parameters

 

Tables: All tables used by the Analytical Results Report. Contact support@earthsoft.com for further information.

 

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

 

Data Requirements:

 

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 Requirements: N/A

 

Output Type: Report Grid with options for Excel and CrossTab

 

Example Output: Download the attachment.

 

Analytical Results (Hits) Logic

 

30379_ARhit_logic