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), also known as "AR II"

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, combining data from the Sample, Test, Result, Field Sample, Location and Analyte tables at a minimum. Data from other tables may be included based on report parameter selections. A list of fields used in standard report output is provided in the Report Output table.

 

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 the extra columns in the REPORT_* Column Logic table.

In EQuIS Professional, the report outputs to the standard grid with toolbar menus that can 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

oSignificant Figures

oReporting Non-Detects

Additional Fields

Workflow Status(es)

Hidden Parameters

Transformation(s)

Unit Conversion

oREPORT_* Column Logic

 

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

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 individual analytes, analyte groups, or excluding analytes that were not detected.

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

Format Results\Significant Figures:

Select the desired number of significant figures.

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

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

 

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. In the location group, RT_GROUP_MEMBER.MEMBER_TYPE = sys_loc_code is required for that location to be included in the report output.

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

 

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

 

Disclosure_Triangle-openResult

    Disclosure_Triangle-openAnalyte

               Individual(s):

               Group(s):

               Exclude Analyte(s): None (default)

            Unit:

            Type(s):                                        Reportable:

            Detect Flag(s):                               Validated:

            Non-Detect Mutliplier: 1                Reporting Limit: reporting_detection_limit

            Non-Detect Symbol: < ?                Format Results

         Non-Detect Qualifier:                        Format code:

Significant Figures:

 

 

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

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

Tip: To identify the method analyte group(s) to which an analyte belongs (if any), select the following parameters, then run the report:

Result |Analyte | Individual(s) the analyte

Additional Fields RT_MTH_ANL_GROUP.METHOD_ANALYTE_GROUP_CODE

 

The report output will include rows for each analyte/method analyte group association.

 

Result | Analyte | 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 | Analyte | Exclude Analyte(s): Single-select: None (default) will not exclude any analytes. Without detects under the selected parameters will exclude analytes which do not have at least one detected value under the selected parameters from the output.

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 | Significant Figures: There are three options for the Significant Figures parameter:

1."ignore": (Default) Will display the number of significant figures from the calculated values

2.1, 2, 3, 4, 5, and 6 significant figures: The report uses the selected number for output formatting

3."calc_result": Calculates the significant figures in the column selected for the @reporting_limit parameter and applies that to the report formatting

 

Example: Result = 5.17 ug/L

Result

ignore

calc_result

1

2

3

4

5

6

5.17

5.17

5.17

5

5.2

5.17

5.170

5.1700

5.17000

 

Example: Non-Detect Multiplier

@reporting_limit

@nd_multiplier

ignore

calc_result

1

2

3

4

5

6

0.5

0.5 or 0.500

<0.25

<0.3

<0.3

<0.25

<0.250

<0.2500

<0.25000

<0.250000

0.5

0.25

<0.125

<0.1

<0.1

<0.13

<0.125

<0.1250

<0.12500

<0.125000

0.50

0.5

<0.25

<0.25

<0.3

<0.25

<0.250

<0.2500

<0.25000

<0.250000

0.500

0.5

<0.25

<0.250

<0.3

<0.25

<0.250

<0.2500

<0.25000

<0.250000

 

Note: Signficant Figures cannot be used with Format Codes. If they are both set, the Significant Figures setting will be prioritized.

 

Result | Format Results | Format Code: This parameter can be used to format REPORT_RESULT_TEXT, REPORT_RESULT_LIMIT, REPORT_METHOD_DETECTION_LIMIT, REPORT_REPORTING_LIMIT, REPORT_QUANTITATION_LIMIT and in some circumstances REPORT_RESULT_VALUE. For more information, see the Format Code page.

 

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

 

Reporting Non-Detects:

1. Determine the original unit (nd_unit) as in the order below:  

= dt_result.result_unit if the Result/Reporting Limit parameter selection is result_text, or
= dt_result.result_unit if
 the initial REPORT_RESULT_LIMIT (see below) is null or not numeric and
 REPORT_RESULT_UNIT is determined by Result\Unit or rt_mth_anl_group_member.reporting_units, or
= dt_result.detection_limit_unit if
 result_unit is null or
 if the Result/Reporting Limit parameter selection is not result_text, or
= dt_result.result_unit if dt_result.detection_limit_unit is null

2. Determine the final unit (REPORT_RESULT_UNIT) as in the below order based on the Result/Unit parameter selection and nd_unit:

= the Result/Unit parameter selection, or
= RT_MTH_ANL_GROUP_MEMBER.REPORTING_UNITS if MAG is selected and REPORTING_UNITS is provided, or
= nd_unit if not any of the above.

3. Calculate REPORT_RESULT_LIMIT based on the Result/Reporting Limit parameter selection, nd_unit and REPORT_RESULT_UNIT.

A. Set initial REPORT_RESULT_LIMIT = the Result/Reporting Limit parameter selection which can be one of

i. reporting_detection_limit if the Result/Reporting Limit parameter is not selected, or
ii. quantitation_limit
iii. method_detection_limit
iv. mag_reporting_detect_limit (RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT) or
v. result_text

If any of ii-v is selected and that field is null, the default REPORTING_DETECTION_LIMIT will be used.

B. Convert REPORT_RESULT_LIMIT from nd_unit to REPORT_RESULT_UNIT.

C. Calculate the final REPORT_RESULT_LIMIT as in the below order:  

= the converted REPORT_RESULT_LIMIT if the unit conversion succeeds or
= the initial REPORT_RESULT_LIMIT if
 the unit conversion fails and
 @skip_missing_unit_conversions = true

4. Calculate REPORT_RESULT_VALUE: REPORT_RESULT_LIMIT * the value of the “Non-Detect Multiplier” parameter.

5. Calculate REPORT_RESULT_TEXT based on dt_result.detect_flag, the value of the “Non-Detect Symbol” parameter and REPORT_RESULT_LIMIT.

A. Determine the format of displaying REPORT_RESULT_TEXT:

= {dt_result.detect_flag?} if detect_flag is populated with one of (<, >, >= or <=), or
= {value} of the “Non-Detect Symbol” parameter, which should include ?, or
= {?} if the “Non-Detect Symbol” parameter is empty or not the above.

B. Replace the ? of the format with one of the below values:

i. dt_result.result_text if
 result_text is not empty and
 result_text is not numeric, or
ii. dt_result.result_numeric if
 dt_result.detection_limit_unit is not numeric and
 there are no unit conversions, or
iii. converted dt_result.result_numeric if
 dt_result.detection_limit_unit is not numeric and
 no unit conversion errors occur, or
 if  unit conversion error occurs but @skip_missing_unit_conversion = True, or
iv. AR II outputs ‘MISSING UNIT CONVERSION …’ if
 dt_result.detection_limit_unit is not numeric and
 unit conversion errors occur and
 @skip_missing_unit_conversion = False, or
v. REPORT_RESULT_LIMIT * Non-Detect-Multiplier if none of the above.

For example, an ND has dt_result_detect_flag of N, dt_result.detection_limit_unit of 0.05 and dt_result.result_text of null. AR II has the parameters Non-Detect Multiplier = 1.0 and Non-Detect Symbol = > ?.

AR II calculates REPORT_RESULT_LIMIT to 0.05.  

AR II calculates the REPORT_RESULT_VALUE of the ND to 0.05 * 1.0 = 0.05

After getting the format of {> ?}, AR II displays the REPORT_RESULT_TEXT of the ND as “> 0.05” after replacing the ? of the {> ?} format with REPORT_RESULT_LIMIT * Non-Detect-Multiplier.

 

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.

In Additional Fields for this report, DT_WELL_SEGMENT uses a default SEGMENT_TYPE of SCREEN. An administrator can change this setting in ST_CONFIG with the following entry:

oCONFIG_SECTION = ar

oCONFIG_KEY = SEGMENT_TYPE

oSTRING_VALUE = the SEGMENT_TYPE to use, e.g. CASING

Additional Fields' columns may be renamed using RT_REMAP_DETAIL:

oremap_code = en-US

ointernal_value = an Additional Field of AR II, such as DT_RESULT.APPROVAL_A

oexternal_field = a new name, such as remapped_A

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

 

Note: Adding more additional fields to the Analytical Results II report may result in longer report generation times for large datasets.

 

Workflow Status(es)

 

This multi-select parameter list dynamically populates 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 made visible as described in Hide or Show Parameters.

 

ebatch

Populating ebatch runs the report only for that specific EDD.

 

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.

 

Sample | Delivery Group(s) [ignored if Field SDG and/or Lab SDG are selected]

Select Sample Delivery Groups (SDG) for the facility from DT_SDG, compared to Sample\Field SDG(s) drawing from DT_FIELD_SAMPLE or Test\Lab SDG(s) drawing from DT_TEST.

 

Sample | Geologic Unit(s)

Select GEOLOGIC_UNIT_CODEs for the facility from DT_STATIC_PROPS.

 

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

Enable hidden parameter Skip Missing Unit Conversions for the AR II 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 Add 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 in Analytical Results II (AR II) solves the issue where the report fails if RESULT_TEXT is selected as the reporting limit, but some RESULT_TEXT are not numeric. AR II will use the following logic:

use RESULT_TEXT as REPORT_RESULT_TEXT in its output whenever the RESULT_TEXT is not numeric and not null

if RESULT_TEXT is selected as the reporting limit, use null as REPORT_RESULT_LIMIT of a row where a RESULT_TEXT is not numeric and not null

 

A user may run a report without knowing exactly how much data will be returned. In EQuIS Professional, AR II allows the user to preview the number of records. 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 with 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:

 

AR II 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 Conversion = 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

DT_RESULT.RESULT_TEXT is not numeric

 

Unconverted Reporting Limit if RESULT_TEXT is not numeric

Reporting Limit = 'reporting_detection_limit'

 

converted* DT_RESULT.REPORTING_DETECTION_LIMIT,

if that is null then REPORT_RESULT_LIMIT is null.

Reporting Limit = 'quantitation_limit'

 

converted DT_RESULT.QUANTITATION_LIMIT,

if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT,

if that is null then REPORT_RESULT_LIMIT is null.

Reporting Limit = 'method_detection_limit'

 

converted DT_RESULT.METHOD_DETECTION_LIMIT,

if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT,

if that is null then REPORT_RESULT_LIMIT is null.

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,

if that is null then REPORT_RESULT_LIMIT is null.

Reporting Limit = 'result_text'
result_text = number

 

converted DT_RESULT.RESULT_TEXT,

if that is null then DT_RESULT.REPORTING_DETECTION_LIMIT,

if that is null then REPORT_RESULT_LIMIT is null.

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 REPORTING_DETECTION_LIMIT

when Skip Missing Unit Conversions = true
unit conversion fails so skipped

 

original
DT_RESULT.REPORTING_DETECTION_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

DT_RESULT.RESULT_TEXT is not numeric

 

Original 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) * @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) * @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

REPORT_RESULT_LIMIT is null or not numeric

unit conversion succeeds

ND

symbol** + DT_RESULT.RESULT_NUMERIC

REPORT_RESULT_LIMIT is null or not numeric, @skip_missing_unit_conversions = true

unit conversion fails so skipped

 

symbol** + DT_RESULT.RESULT_NUMERIC

REPORT_RESULT_UNIT = RESULT_UNIT

REPORT_RESULT_LIMIT is null or not numeric, @skip_missing_unit_conversions = false

 

MISSING UNIT CONVERSION …

Use Non-Detect Multiplier for Report_Result_Value Only ='false'

D

converted DT_RESULT.RESULT_NUMERIC

Use Non-Detect Multiplier for Report_Result_Value Only ='false'

ND

symbol + converted DT_RESULT.RESULT_NUMERIC * @nd_multiplier

Use Non-Detect Multiplier for Report_Result_Value Only ='true'

Non-Detect Multiplier <> 0

ND

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

Use Non-Detect Multiplier for Report_Result_Value Only = 'false'

Non-Detect Multiplier = 0

ND

symbol + 0

Use Non-Detect Multiplier for Report_Result_Value Only='true'

Non-Detect 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 Multiplier 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 Multiplier 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 Multiplier 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 Multiplier for Report_Result_Value only='false'

ND

symbol + original REPORT_RESULT_LIMIT * @nd_multiplier

 

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.