Analytical Results II - No Sample Taken

Report Name: Analytical Results II - No Sample Taken (example)

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

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: This report returns analytical results and also includes sample data, even if that sample does not have any tests/results. The sample must still satisfy the sample-specific defined parameters such as date range or sample type. All of the other parameters are related to tests and results.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview: A sample is considered a No Sample Taken (NST) sample if it has a record in DT_SAMPLE but:

A.no associated records in both DT_TEST and DT_RESULT

B.associated records in DT_TEST but no associated records in DT_RESULT

In EQuIS Build 7.22.1 and up:

•For scenario A, the report will show NST sample data in its results when the sample satisfies its defined parameters (e.g. Sample\Date Range), regardless of what the report parameters under Result and/or Test sections are selected.

•For scenario B, the report will present the NST sample data in its results when the sample satisfies its defined parameters (e.g.Sample\Date Range) and the test satisfies its defined parameters (e.g. Test\Method(s)), regardless of which report parameters under the Result section are selected.

Prior to Build 7.22.1, selecting report parameters from the Test and Result sections excluded any No Sample Taken results as those are only associated with Sample-related parameters. As a workaround, a user can select Test Method: NULL/BLANK to return all No Sample Taken records, then use the "Go (Append)" functionality with other test- and result-based report parameters to append records with results to this dataset.

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.

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

Source 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

Report Parameters *

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Use DT_GEOGRAPHY for coordinate data	Toggle to use DT_GEOGRAPHY for coordinate data.
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.
Task_Code_2(s)
Field SDG(s)	Select one or more Field SDGs.
Depth	Section for selecting the minimum and maximum start and end depths as well as depth unit.
DQM Status
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.
Lab SDG(s)	Select one or more Lab SDGs.
Result
Analyte	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 non-detect multiplier.
Non-Detect Qualifier	Select one or more non-detect qualifiers.
Reportable	Select one or more options for reportable result.
Validated	Selection for whether the result is validated or not.
Reporting Limit	Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)
Format Results\Format Code:	Select one format code (e.g. 0.########, 0.0E-00 etc.) predefined or defined in rt_lookup.lookup_desc with lookup_type='ARII_FORMAT'. It applies to REPORT_RESULT_TEXT, REPORT_RESULT_LIMIT, REPORT_METHOD_DETECTION_LIMIT, REPORT_REPORTING_LIMIT, REPORT_QUANTITATION_LIMIT and defaults to empty with no formats applied. It also applies to REPORT_RESULT_VALUE when it can be used to control rounding decimals of a value.
Additional Fields	Additional fields parameter.

* This report contains the following hidden parameter(s):

•facility_id

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Report Output
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.

Report Output

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.

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