<< 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 * |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
* This report contains hidden parameters: facility_id and ebatch
Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report that allows saving of user reports). These paramaters cannot be viewed or changed in unpublished reports outside of a report parameter file.
|
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:
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2022 EarthSoft, Inc • Modified: 08 Sep 2022