Analytical Results II

<< Click to Display Table of Contents >>

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

Analytical Results II

Report Name: Analytical Results II (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install, EQuIS Enterprise install

Language: English

Output Type: Report Grid1

 

Description - Analytical Results II: The primary report for analytical data in EQuIS. When this report is executed, it combines the data from the Sample, Test, Result, Field Sample, Location and Analyte tables at a minimum. Data from other tables are included, based on report parameter selections.

 

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

 

Overview:

Additional columns, with names that begin with "REPORT_RESULT_*", are included in the report output to provide consistent, configurable formatting for final presentations. (See logic used to populate those extra columns here).

In EQuIS Professional, the report outputs to the standard grid with toolbar menus that display data in formats such as XY Chart, Trend Plot, Crosstab, and customizable RDLs.

The Additional Fields input parameter enables supplementing the report output with data from additional table/column(s).

Analytical Results II is a 'class' report, while the original Analytical Results is a 'function' report. Distinctions between these reports include:

oImproved Performance: Analytical Results II is designed to execute faster than the legacy Analytical Results Report.

oThe Analytical Results II Report must be published before it can be saved as a User Report (formerly Pick Report).

oThe saved User Report from Analytical Results II can only be used by other 'class' type reports.

 

Source Tables DT_FACILITY, VW_LOCATION, DT_SAMPLE, DT_TEST, DT_RESULT, RT_ANALYTE, DT_LOCATION, DT_SUBFACILITY, DT_WELL, DT_FIELD_SAMPLE, DT_STATIC_PROPS, DT_LITHOLOGY, DT_TASK, DT_RESULT_QC, RT_MATRIX, RT_SAMPLE_TYPE, RT_ANALYTIC_METHOD, RT_GROUP, RT_GROUP_MEMBER, ST_EDD_BATCH, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_ANALYTE_VAR, DT_WATER_LEVEL, DT_PURGE

 

Report Parameters:

Location

Sample

Test

Result

Additional Fields

Workflow Status(es)

Hidden Parameters

Transformation(s)

Unit Conversion

 

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. Default: False.

Sample


Type(s)

Select one or more sample types

Date Range

Section to select the start date, end date, most recent sampling (False), and the option to use date range to select the most recent sampling events (False).

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 SDG.

Depth

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

Minimum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.

Maximum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.

Maximum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) below that value will be included. Sample with null START_DEPTH will be excluded.

Minimum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) above that value will be included. Sample with null END_DEPTH will be excluded.

Unit

Select the desired unit for sample depth min/max.

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

Enter the desired non-detect qualifier (e.g., "U") to have that qualifier override the DETECT_FLAG column.

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_VALUE and REPORT_RESULT_LIMIT and defaults to empty with no formats applied.

Additional Fields

Additional Fields parameter

Workflow Status(es)

Select one or more Workflow Status values within the table(s) in which you wish to filter on this field.

* The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.

 

Report Output

CAS_RN

CHEMICAL_NAME

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

SAMPLE_NAME

SYS_SAMPLE_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

LOOKUP_SOURCE

LOOKUP_CODE

LOOKUP_METHOD

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

GEOLOGIC_UNIT_CODE

TASK_CODE

TASK_CODE_2

TASK_DESC

FIELD_SDG

PARENT_SAMPLE_CODE

ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD

ANALYSIS_DATE

COLUMN_NUMBER

PERMIT_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

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

SAMPLEDATE

SAMPLETIME

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

MAG_REPORT_ORDER (if analyte group is selected)

METHOD_ANALYTE_GROUP (if analyte group is selected)

WORKFLOW_STATUS (if present and a worflow_status is selected)

 

Extra fields: Any fields chosen in this parameter.

 

Location

 

Analytical Results II Location

Location | Individual(s): Multi-select for individual SYS_LOC_CODE(s) to filter report output.

Location | Group(s): Multi-select Location Group codes to filter report output. Can be combined with the individual location selections.

Location | Use DT_GEOGRAPHY for coordinate data: Check box to toggle between using data from DT_COORDINATE and DT_GEOGRAPHY to populate X_COORD, Y_COORD, LONGITUDE and LATITUDE columns. When the check box parameter, "Use DT_GEOGRAPHY for coordinate data" is selected, the report will look for POINT data in DT_GEOGRAPHY to fill the X_COORD, Y_COORD, LONGITUDE, and LATITUDE columns.

 

Notes regarding DT_GEOGRAPHY parameter:

This parameter will only work when coordinates are set in DT_GEOGRAPHY for a sample; it will not work for locations. Therefore, to use this parameter, DT_GEOGRAPHY.OBJECT_EUID = DT_SAMPLE.EUID is required.

The DT_GEOGRAPHY Lat\Long data is used for X_COORD and Y_COORD, regardless of the value in DT_FACILITY.COORD_TYPE_CODE. In addition, if altitude and distance values are included in the geography POINT data, they are not used. If no data are found for a sample in DT_GEOGRAPHY, then the DT_COORDINATE data, if available, are used as in previous versions of the report. This parameter defaults to unchecked.

 

Sample

 

Analytical Results II Sample       Analytical Results II Sample Depth

 

The columns referred to below are from DT_SAMPLE, unless otherwise noted.

 

Sample | Type(s): Multi-select for SAMPLE_TYPE_CODE(s) to filter report output.

Sample | Date Range | Start, End: Enter or select date range to filter report output. Defaults to first and last dates in DT_SAMPLE for the facility.

Sample | Most Recent Sampling: Check box to only include results from the most recent sampling event for each location (based on a unique list of [FACILITY_ID, SYS_LOC_CODE, CAS_RN, FRACTION, most recent sample_date(s)]).

Sample | Use Date Range in Finding Most Recent Sampling: Check box to activate the dates in Date Range to restrict the data used to determine the Most Recent Sampling event. If this check box is not checked and Most Recent Sampling is checked, then all of the samples for the facility are used to determine the most recent sampling events.

Sample | Matrix(es): Multi-select for MATRIX_CODE(s) to filter report output.

Sample | Task(s): Multi-select for TASK_CODE(s) to filter report output.

Sample | Task_Code_2(s): Multi-select for TASK_CODE_2(s) to filter report output.

Sample | Field SDG(s): Multi-select for DT_FIELD_SAMPLE.FIELD_SDG(s) to filter report output.

Sample | Depth | Min Start; Max End; Max Start; Min End; Unit: Enter depth range and unit to filter report output.

Sample | DQM Status: Multi-select for DQM_STATUS(s) to filter report output.

 

Test

 

Analytical Results II Test

 

The columns referred to below are from DT_TEST, unless otherwise noted.

 

Test | Method(s): Multi-select for ANALYTIC_METHOD(s) to filter report output.

Test | Fraction(s): Multi-select for FRACTION(s) to filter report output.

Test | Column Number(s): Multi-select for COLUMN_NUMBER(s) to filter report output.

Test | Type(s): Multi-select for TEST_TYPE(s) to filter report output.

Test | Lab Matrix(es): Multi-select for LAB_MATRIX_CODE(s) to filter report output.

Test | Prep Method(s): Multi-select for PREP_METHOD(s) to filter report output.

Test | Lab SDG(s): Multi-select for LAB_SDG(s) to filter report output.

 

Result

 

Analytical Results II Result       Analytical Results II Result Format

 

The columns referred to below are from DT_RESULT unless otherwise noted.

 

Result | Individual(s): Multi-select individual for CAS_RN(s) to filter report output.

Result | Group(s): Multi-select for Method Analyte Group Code(s) (MAGs) to filter report output. Within a chosen MAG, if there is a reporting_unit specified for an analyte (either within the Groups GUI - see below - or RT_MTH_ANL_GRP_MEMBER.REPORTING_UNITS), that unit will be used for that analyte instead of the default unit set by report parameters. Can be combined with the individual location selections.

 
30007-ARII_multiunitMAG

 

Result | Unit: Single-select for a UNIT to which all results will be converted. See sections on Unit Conversions and Skip Missing Unit Conversions below.

Result | Type(s): Multi-select for RESULT_TYPE_CODE(s) to filter report output.

Result | Detect Flag(s): Multi-select for DETECT_FLAG(s) to filter report output.

Result | Non-Detect Multiplier: Enter number to multiply the Reporting Limit by when populating the REPORT_RESULT_TEXT and REPORT_RESULT_VALUE columns for Non-Detect results.

See Non-Detect Multiplier to Report_Result_Value Only under Hidden Parameters below to only apply the multiplier to the REPORT_RESULT_VALUE column.

Result | Non-Detect Symbol: Enter the symbol and a '?' to have the symbol placed in front of the number used when populating the REPORT_RESULT_TEXT column for Non-Detect results. Enter text without the '?', such as 'ND', to have the text itself used when populating the REPORT_RESULT_TEXT column for Non-Detect results.

Result | Non-Detect Qualifier: Enter a qualifier, such as 'U', to be used, in addition to DETECT_FLAG, to determine if a result is a detected concentration or Non-Detect. This allows a data validator's qualifier (in either the VALIDATOR_QUALIFIER or the INTERPRETED_QUALIFIER column) to supercede the lab's DETECT_FLAG. If a value is entered into this parameter, then the report will search for that value in all three qualifier columns (only in the results with a DETECT_FLAG = 'Y' or 'TR'). If found, then the detect_flag will be changed to "Q" (in the report output only, not in the database) and the result will be displayed as a non-detect value," e.g., <0.1 where 0.1 is the reporting_detection_limit.

Result | Reportable: Multi-select for REPORTABLE_RESULT(s) to filter report output.

Result | Validated: Multi-select for VALIDATED_YN(s) to filter report output.

Result | Reporting Limit: Single-select for which column should populate the REPORT_RESULT_LIMIT output column.

Result | Format Results | Format Code: This parameter can be used to format REPORT_RESULT_TEXT, REPORT_RESULT_LIMIT, and in some circumstances REPORT_RESULT_VALUE. The default value = NULL. The selection list for the Format Code parameter is automatically populated with values for a range of standard formats, such as 0.00, 0.0########, 0.0E+0, N1, etc. Users can add more format codes to the selection list by adding records to the RT_LOOKUP table with LOOKUP_TYPE ='ARII_FORMAT' and LOOKUP_CODE = LOOKUP_DESC = any valid values for a Format Code. If a value is selected for this parameter, then the format code will be applied to both REPORT_RESULT_TEXT and REPORT_RESULT_LIMIT because these two columns contain text values. However, only the significant figures of the selected format code is applied to REPORT_RESULT_VALUE due to its numeric type.

oExample: format code = '#,##.00': a RESULT_TEXT of 1234.125 is presented as a REPORT_RESULT_TEXT of 1,234.13 and the RESULT_NUMERIC of 1234.125 as a REPORT_RESULT_VALUE of 1234.13.

 

Note: Currently the Analytical Results II does not have a format option for results that contain a comma separator (e.g. 1,000) and significant figures (e.g. 1,000.10). If a Format Code containing a comma separator is selected, significant figures will not be maintained (any trailing 0s will be left off of the REPORT_RESULT_TEXT). In an upcoming build of EQuIS Professional, a new report parameter will be added that will allow both 'comma as thousand separator' and 'significant digits' to be applied to the results.

 

Reporting Non-Detects:

 

The logic for populating the REPORT_RESULT_TEXT and REPORT_RESULT_VALUE columns for non-detects.

 

1.Where DT_RESULT.DETECT_FLAG = 'N', depends on several user inputs, including:

a.Result | Reporting Limit report parameter selection:

i.reporting_detection_limit. This is the default selection.

ii.quantitation_limit

iii.method_detection_limit

iv.mag_reporting_detect_limit (RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT) or

v.result_text

 

Note that if any of ii-v is selected and that field is null, the default REPORTING_DETECTION_LIMIT will be used. If that too is null, result_numeric will be used. The logic is explained in the REPORT_RESULT_LIMIT section of the REPORT_RESULT * Column Logic table below.

 

b.REPORT_RESULT_UNIT of the non-detect record, determined in the following order:

i.Result | Unit input selection

ii.Result | Analyte | Group (RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS)

iii.DT_RESULT.DETECTION_LIMIT_UNIT

iv.DT_RESULT.RESULT_UNIT

c.The value of the Result | Non-Detect Multiplier report parameter

d.The value of the Result | Use Non-Detect Multiplier to Report_Result_Value Only report parameter (hidden by default with default value = False)

2.Where DT_RESULT.DETECT_FLAG = '<', '<=', '>', OR '>=':

a.Then that DETECT_FLAG value is concatenated with the REPORT_RESULT_VALUE to populate REPORT_RESULT_TEXT

 

Additional Fields

 

Additional Fields: Multi-select for additional table/column(s) to include in the report output. This does not include additional filtering (i.e. the additional fields are not available as input parameters for further input selections). Certain tables and fields are availlable by default. Read here for information on how to add tables and fields to the Additional Fields Parameter.

 

For DT_WELL_SEGMENT, the default value of SEGMENT_TYPE is SCREEN. The value can be modified over ST_CONFIG by populating a new SEGMENT_TYPE in STRING_VALUE of ST_CONFIG where CONFIG_SECTION=ar and CONFIG_KEY=SEGMENT_TYPE.

Additional Fields' columns may be renamed using RT_REMAP_DETAIL: enter en-US to remap_code, an Additional Field of ARII, e.g. DT_RESULT.APPROVAL_A, to internal_value, and a new name, e.g. remapped_A, to external_field (also make sure status_flag='A'). After DT_RESULT.APPROVAL_A is selected from the Additional Fields parameter, remapped_A is included in the report output.

To select a field of RT_GROUP, the Location - Group(s) parameter must be selected.

 

Workflow Status(es)

This multi-select parameter list is dynamically populated from RT_WORKFLOW_STATUS joined to XT_TABLE.
 

Only data tables (DT_*) that appear within the Additional Fields report parameter will be eligible to appear in the selections for this report parameter.
 

For any table where you select one or more values, the workflow_status must match one of the values selected for that table, and the table's workflow_status field will be included in the report output.
 

If values in multiple tables are selected, the workflow_status for EACH table with any values selected must match one of the values selected.
 

Note: For information about adding WORKFLOW_STATUS to an existing table, please see the documentation on equis.add_workflow.

 

Hidden Parameters

 

The following Analytical Results II Report input parameters are hidden by default (ST_REPORT_PARAMETER.VISIBILITY=N). If needed, these parameters may be changed to visible by updating the ST_REPORT_PARAMETER.VISIBILITY of the appropriate PARAM_NAME.

 

Location | Individual(s)-Facilities

 

The Location\Individual(s)-facilities parameter lists locations with facility associations. This enables distinguishing between SYS_LOC_CODEs when connected to a facility group that includes the same SYS_LOC_CODE(s) in more than one facility member. The Location\Individual(s) parameter is ignored when Location\Individual(s)-facilities is selected. To use this parameter, change the ST_REPORT_PARAMETER.VISIBILITY of PARAM_NAME = @location_euids for the target REPORT_ID from N to Y. It is recommended that this be done after publishing the Analytical Results II Report with a different REPORT_NAME; the Location\Individual(s) parameter may then be removed from display to avoid confusion, since it is ignored when the Location\Individual(s)-facilities parameter is used.

 

Result | Use Non-Detect Multiplier to Report_Result_Value Only

 

When this is checked, the non detect multiplier is applied only to REPORT_RESULT_VALUE and not REPORT_RESULT_TEXT.

 

Result | Format Results | Custom (Overwrites Format Code if Format Code is also selected)

 

The "Result\Format Results\Custom" accommodates any valid values for user-specified Format Code to be applied as discussed above. Note that the Custom parameter overwrites the Format Code parameter if both are populated.

 

Extra Selects

 

The Extra Selects or @extra_select is available for advanced users to configure in ST_REPORT_PARAMETER, and allows for supplementing report output with a combination result or formatted result using the fields available in the Additional Fields parameter. Please see additional documentation regarding Extra Selects here.

 

Skip Missing Unit Conversions:

 

A hidden parameter, Skip Missing Unit Conversions is available for configuring the ARII Report to skip failed result unit conversions and generate REPORT_RESULT_VALUE, REPORT_RESULT_TEXT, REPORT_RESULT_UNIT and REPORT_RESULT_LIMIT with original values and units for the results that fail unit conversions. The Skip Missing Unit Conversions parameter defaults to unchecked (default_value=false) and can be set in the database (ST_REPORT_PARAMETER) and made visible, if necessary.

 

Note: User Reports maintain the System Report parameters as defined at the time they are created, so users should ensure the default is maintained or any change is intended/explicit when User Reports of ARII or ARII-based reports are created.

 

Transformation(s)

 

The Transformation(s) parameter lists Standard ARII Transformation and Custom ARII Transformations from ST_MODULE that can be run on the report. For transformation setup, see the online help article Report Transformations in Analytical Results II.

 

Unit Conversion

 

Unit Conversion is handled by the unit conversion function within the database, which relies on the conversion factors stored in the RT_UNIT_CONVERSION_FACTOR table. If the report fails to convert units, it generates an informative error message of either "MISSING UNIT CONVERSION FACTOR - cannot convert ..." or "Actual unit value EQUALS the special "NO CONVERSION" value specified..." Note only the first encountered missing unit conversion factor will be included in the error message; additional errors may occur after the initial error is resolved.

 

ARII generates a unit conversion error message when unit conversion fails on start_depth, end_depth, Z_COORD_AVG, ZFROM or ZTO even if Skip Missing Unit Conversions is set to TRUE. The Z_COORD_AVG, ZFROM and ZTO columns require a valid conversion between DT_SAMPLE.DEPTH_UNIT and VW_LOCATION.ELEV_UNIT, where the latter is determined using the following logic:

 

Use DT_FACILITY.ELEV_UNIT if present

If not, use DT_LOCATION.UNITS if present

If not, use DT_COORDINATE.ELEV_UNIT if present

If not, a NULL value will be returned.

 

Note: By default, the available input units are limited to those where RT_UNIT.UNIT_TYPE= cpv (concentration per volume) or cpw (concentration per weight). The default may be revised. For additional information see the online help article Adding Unit Types to Report Parameter Selections.

 

For User Reports

 

Save input parameters to the database

Load input parameters by selecting named report from User Reports drop-down list

Available in EQuIS Enterprise User Reports list (formerly called Pick Reports)

Available as input for other (report-dependent) reports

 

For Trend Plots

 

Group charts by

Group series by

Advanced properties include:

oIndividual Chart

oAll charts

oAll series

Set of series - this adds all series for a specific analyte to a secondary axis

 

Special Features: A new feature is added to the Analytical Results II Report (ARII). The feature solves the issue where the report fails if RESULT_TEXT is selected as the reporting limit, but some RESULT_TEXT are not numeric. The feature is that ARII presents RESULT_TEXT to REPORT_RESULT_TEXT in its output whenever the RESULT_TEXT is not numeric and not null, and presents null to REPORT_RESULT_LIMIT of a row where a RESULT_TEXT is not numeric and not null if RESULT_TEXT is selected as the reporting limit.

 

Occasionally a report will be run without knowing exactly how much data will be returned. The ARII Report has a feature that allows you to preview the number of records. The feature only works in EQuIS Professional, it does not currently work in EQuIS Enterprise. To use this feature, hold the CTRL (Control) key on the keyboard while clicking the green Go button to run the report. When the CTRL key is pressed, the report will return a single row, single column value that is the number of records the report will return with the currently selected parameters. To run the report, click the Refresh button. If the CTRL key is not pressed while running the report, then the report will function normally and will return the actual records.

 

The following is the logic that the ARII report uses for Z_COORD_AVG, ZFROM, and ZTO.

Z_COORD_AVG: If VW_LOCATION.SURF_ELEV, DT_SAMPLE.START_DEPTH or DT_SAMPLE.END_DEPTH is NULL then Z_COORD_AVG returns NULL; otherwise, the report computes the value by averaging the START_DEPTH and END_DEPTH

 For example: (START_DEPTH + END_DEPTH)/2)  

ZFROM: If either VW_LOCATION.SURF_ELEV or DT_SAMPLE.START_DEPTH is NULL then ZFROM returns NULL; otherwise, the report computes the value by subtracting the START_DEPTH from the SURF_ELEV

 For example: (SURF_ELEV - START_DEPTH)

ZTO: If either VW_LOCATION.SURF_ELEV or DT_SAMPLE.END_DEPTH is NULL then ZTO returns NULL; otherwise, the report computes the value by subtracting the END_DEPTH from the SURF_ELEV

 For example: (SURF_ELEV - END_DEPTH)

 

Unit conversions are performed for each of the above fields as follows:

ORIG_UNIT: Looks first at DT_SAMPLE.DEPTH_UNIT. If NULL, then looks at VW_LOCATION.ELEV_UNIT

TARGET_UNIT: Looks first at VW_LOCATION.ELEV_UNIT. If NULL, then looks at DT_SAMPLE.DEPTH_UNIT

 

REPORT_* Column Logic: The table below shows the logic of the ARII output, whether original or converted values, as related to various input conditions. If there is more than one output listed, the logic applied is prioritized from high to low, based on detect_flag ('Y' or 'TR' identifies detects or D and others non-detects or ND) and other conditions:

 

ARII Column

Input Condition(s)

Detect

Original or Converted Output

REPORT_RESULT_UNIT

RESULT_TEXT= non-numeric text

 

DT_RESULT.RESULT_UNIT


unit conversion succeeds

D

The Result/Unit parameter, RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS, DT_RESULT.RESULT_UNIT


when @reporting_limit <> 'result_text'
unit conversion succeeds

ND

The Result/Unit parameter, RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS, DT_RESULT.DETECTION_LIMIT_UNIT, DT_RESULT.RESULT_UNIT


when @reporting_limit = 'result_text'

unit conversion succeeds

ND

The Result/Unit parameter,
RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS,
DT_RESULT.RESULT_UNIT,
DT_RESULT.DETECTION_LIMIT_UNIT


when @skip missing_unit_conversions = true

unit conversion fails so skipped

D

DT_RESULT.RESULT_UNIT


when @reporting_limit <> 'result_text' and
@skip_missing_unit_conversions = true
unit conversion fails so skipped

ND

detection_limit_unit, result_unit


when @reporting_limit = 'result_text' and
@skip_missing_unit_conversions = true
unit conversion fails so skipped

ND

result_unit, detection_limit_unit

REPORT_RESULT_LIMIT

@reporting_limit = 'reporting_detection_limit'

 

converted* DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'quantitation_limit'

 

converted DT_RESULT.QUANTITATION_LIMIT, if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'method_detection_limit'

 

converted DT_RESULT.METHOD_DETECTION_LIMIT, if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'mag_reporting_detect_limit'

 

converted RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT, if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'result_text'
result_text = number

 

converted DT_RESULT.RESULT_TEXT, if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'result_text'

result_text = text

 

null


when @skip_missing_unit_conversions = true

unit conversion fails so skipped

 

original REPORT_RESULT_LIMIT

REPORT_METHOD_DETECTION_LIMIT

unit conversion succeeds

 

converted DT_RESULT.METHOD_DETECTION_LIMIT


when @skip_missing_unit_conversions" = true
unit conversion fails so skipped

 

Original
DT_RESULT.METHOD_DETECTION_LIMIT

REPORT_REPORTING_LIMIT

unit conversion succeeds

 

converted REPORT_REPORTING_LIMIT


when "skip_missing_unit_ conversions = true
unit conversion fails so skipped

 

Original
DT_RESULT.REPORT_REPORTING_LIMIT

REPORT_QUANTITATION_LIMIT

unit conversion succeeds

 

converted
DT_RESULT.QUANTITATION_LIMIT


when "skip_missing_unit_conversions" = true
unit conversion fails so skipped

 

Original
DT_RESULT.QUANTITATION_LIMIT

REPORT_RESULT_VALUE

For small numbers (those with 5 decimal places or more), REPORT_RESULT_VALUE will be reported in scientific notation after following logic below:

 



unit conversion succeeds

D

converted DT_RESULT.RESULT_NUMERIC


unit conversion succeeds

ND

converted (REPORT_RESULT_LIMIT, if that is null then DT_RESULT.RESULT_NUMERIC) * @nd_multiplier


when @skip_missing_unit_conversions = true

unit conversion fails so skipped

D

DT_RESULT.RESULT_NUMERIC


when @skip_missing_unit_conversions = true

unit conversion fails so skipped

ND

original (REPORT_RESULT_LIMIT, if that is null then DT_RESULT.RESULT_NUMERIC) * @nd_multiplier

REPORT_RESULT_TEXT

RESULT_TEXT is non numeric text

 

DT_RESULT.RESULT_TEXT


RESULT_TEXT is null

D

DT_RESULT.RESULT_NUMERIC


REPORT_RESULT_LIMIT is null or not numeric

D

DT_RESULT.RESULT_NUMERIC


RESULT_TEXT is numeric

ND

symbol** + (REPORT_RESULT_LIMIT, if that is null then DT_RESULT.RESULT_NUMERIC)


Use Non-Detect Multipler for Report_Result_Value only='false'

D

converted DT_RESULT.RESULT_NUMERIC


Use Non-Detect Multipler for Report_Result_Value only='false'

ND

symbol + converted DT_RESULT.RESULT_NUMERIC * @nd_multiplier


Use Non-Detect Multipler for Report_Result_Value only='true'

@nd_multiplier<>0

ND

symbol + converted (REPORT_RESULT_LIMIT, if that is null then DT_RESULT.RESULT_NUMERIC)


Use Non-Detect Multipler for Report_Result_Value only='false'

@nd_multiplier=0

ND

symbol + 0


Use Non-Detect Multipler for Report_Result_Value only='true'

@nd_multiplier=0

ND

symbol + converted (REPORT_RESULT_LIMIT, if that is null then DT_RESULT.RESULT_NUMERIC)


when @skip_missing_unit_conversions = true

unit conversion fails so skipped

Use Non-Detect Multipler for Report_Result_Value only='true'

D

DT_RESULT.RESULT_TEXT, if that is null then DT_RESULT.RESULT_NUMERIC


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

Use Non-Detect Multipler for Report_Result_Value only='true'

ND

symbol + original REPORT_RESULT_LIMIT


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

Use Non-Detect Multipler for Report_Result_Value only='false'

D

DT_RESULT.RESULT_NUMERIC


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

Use Non-Detect Multipler for Report_Result_Value only='false'

ND

symbol + original REPORT_RESULT_LIMIT * @nd_multiplier0

 

For the "Use Non-Detect Multiplier to Report_Result_Value Only" parameter, check the box to apply Non-detect Multipliers to only report_result_value. Otherwise, Non-detect Multipliers is applied to both report_result_value and report_result_text.

 

*Means converted from original unit to report_result_unit.

 

The original unit of REPORT_RESULT_LIMIT is result_unit if @reporting_limit = 'result_text' and result_text is a text, one of (RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS, DT_RESULT.DETECTION_LIMIT_UNIT or DT_RESULT.RESULT_UNIT in order) if @reporting_limit = 'mag_reporting_detect_limit' and one of (detection_limit_unit or result_unit) if @reporting_limit is one of other reporting_limit selections.

 

The original unit of REPORT_RESULT_VALUE is result_unit for D or one of (RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS, DT_RESULT.DETECTION_LIMIT_UNIT or DT_RESULT.RESULT_UNIT in order) for ND if @reporting_limit = 'mag_reporting_detect_limit', or one of (detection_limit_unit or result_unit) for ND if @reporting_limit is one of other reporting_limit selections.

 

** If DT_RESULT.DETECT_FLAG is '<', '>', '>=' or '<=', then 'symbol' = DETECT_FLAG; otherwise 'symbol' = @nd_symbol.

 

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