Analytical Results II - No Sample Taken

<< Click to Display Table of Contents >>

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

Analytical Results II - No Sample Taken

Report Name: Analytical Results II - No Sample Taken*

*previously called (Beta) Analytical Results - No Sample Taken

 

Report Type: Standard Report

 

Description: The sample must still satisfy the defined parameters (date range, sample type, etc.). All of the other parameters are related to samples/test/results (date range, sample type, etc.). This report also includes sample data, even if that sample does not have any tests/results.

 

An option is available to allow report of locations without samples. This option is hidden by default. To enable visibility on this option, publish the report, then change the PARAM_NAME=@include_loc_without_samp in ST_REPORT_PARAMETER and set this VISIBILITY=Y. This will display a new input parameter called "Location\Include locations without samples". Checking this box will show locations within the facility that do not have any samples within the report criteria in the facility, regardless of whether those locations have or do not have samples that match the criteria. The included locations may have other samples (that do not match the criteria) or they may have no samples at all.

 

Notes:

The report only returns SYS_LOC_CODE information if DT_COORDINATE data is populated.

The report will return 'no sample taken' information if there is sample information in DT_SAMPLE without corresponding data in DT_TEST and DT_RESULT.

 

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

 

Language: English

 

Input Parameters: Note that the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Facility



Ebatch



Location

Individual(s)



Group(s)



Include locations without matching samples?*


Sample




Type(s)



Date range




Start Date



End Date


Matrix(es)



Task(s)



Delivery Group(s)



Depth




Minimum Start Depth



Maximum End Depth



Maximum Start Depth



Minimum End Depth


Geologic Unit(s)*



Delivery Group(s):
is ignored if Field SDG and/or Lab
SDG are selected*



Field SDG(s)*


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)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Reportable



Reporting Limit


Additional Fields



Extra Selects*









                                               

30175-(B)AR

ACTION_LEVEL_CODE

CAS_RN

CHEMICAL_NAME

FLAG

ACTION_LEVEL

ACTION_LEVEL_MIN

AL_RESULT_TEXT

AL_RESULT_VALUE

ACTION_LEVEL_UNIT

WARNING_FLAG

WARNING_LEVEL

WARNING_LEVEL_MIN

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

SAMPLE_NAME

SYS_SAMPLE_CODE

AL_SUBFACILITY_CODE

ACTION_LEVEL_TYPE

AL_MATRIX

AL_FRACTION

AL_ANALYTICAL_METHOD

AL_REMARK

OBJECT_NAME

ACTION_LEVEL_NOTE

ACTION_LEVEL_MIN_NOTE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

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_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

METHOD_ANALYTE_GROUP

REPORT ORDER

TEST_ID

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

AL_LAND_USE

ALP_REMARK

PERMIT_NUMBER

ACTION_LEVEL_DESC

LOOKUP_SOURCE

LOOKUP_CODE

LOOKUP_METHOD

SAMPLEDATE

SAMPLETIME

TASK_CODE_2

 

Extra fields: Any fields chosen in this parameter.

Note: *refers to hidden parameters

 

Tables: FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, LOC_NAME, SAMPLE_ID, SYS_SAMPLE_CODE, SAMPLE_NAME, SAMPLE_DATE, SAMPLE_TYPE_CODE, START_DEPTH, END_DEPTH, DEPTH_UNIT, MATRIX_CODE, TASK_CODE, 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, 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, LONGTITUDE, LATITUDE, LOC_GROUP_CODE, LOC_REPORT_ORDER

 

Database Type: SQL

 

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

 

Database Version: EQuIS 6.2+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel                      

 

Example Output: View the following example.

 

30175-nst.ex.output_zoom60