Analytical Results II

<< Click to Display Table of Contents >>

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

Analytical Results II

Report Name: Analytical Results II

previously called (Beta) Analytical Results

 

Report Type: Standard Class Report

 

Description - Analytical Results II (ARII): 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.

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.

 

Report Parameters:

 

Location

 

30007-ARII_rp_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. Note that 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

 

30007-ARII_rp_sample1 30007-ARII_rp_sample2

 

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

 

30007-ARII_rp_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

 

30007-ARII_rp_result130007-ARII_rp_result2

 

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) to filter report output. Can be combined with the individual location selections.

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_VALUE and REPORT_RESULT_LIMIT. 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 1: format code = '0.00E+0': a RESULT_TEXT of 0.1235 is formatted in REPORT_RESULT_TEXT as 1.24E-1 and the RESULT_NUMERIC of 0.1235 is formatted in REPORT_RESULT_VALUE as 0.12.

oExample 2: 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.

 

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,

ii.quantitation_limit,

iii.method_detection_limit,

iv.mag_reporting_detect_limit (RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT) or

v.result_text

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.

 

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. For example, for PARAM_NAME=@extra_select, if ST_REPORT_PARAMETER.DEFAULT_VALUE of a SQL Database is populated with “start_depth + '-' + end_depth as [Depth_Range]”, a column of date_range with data like “15-20” is added to the report output grid. In a SQL Database, if “CONVERT(VARCHAR(8),sample_date,108) AS STime” is added to the DEFAULT_VALUE, a STime field with results like “18:58:00” will be included in the output.

 

The @extra_select parameter may be also used to generate 'permanent' output fields. For example, if Location Group(s) or Result>Analyte>Group(s) (aka MAGs) parameters is not selected in the Analytical Results II Report, MAGs or Location Group(s) related information such as MAG_REPORT_ORDER or LOC_REPORT_ORDER will not be in the output. After “NULL as LOC_REPORT_ORDER, NULL as MAG_REPORT_ORDER” is added to the DEFAULT_VALUE of the @extra_select, the fields of LOC_REPORT_ORDER and MAG_REPORT_ORDER will always occur in the output, regardless of whether there are any MAGs or Location Group(s) selected.

 

Note: Extra Selects can decrease report performance.

 

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.

 

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.

 

REPORT_RESULT_* 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

unit conversion succeeds

D

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


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 "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

D

DT_RESULT.RESULT_UNIT


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

ND

detection_limit_unit, result_unit

REPORT_RESULT_LIMIT

@reporting_limit = 'reporting_detection_limit'

 

converted* DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'quantitation_limit'

 

converted DT_RESULT.QUANTITATION_LIMIT, DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'method_detection_limit'

 

converted DT_RESULT.METHOD_DETECTION_LIMIT, DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'mag_reporting_detect_limit'

 

converted RT_MTH_ANL_GROUP_MEMBER.REPORTING_DETECT_LIMIT, DT_RESULT.REPORTING_DETECTION_LIMIT


@reporting_limit = 'result_text'

 

converted DT_RESULT.RESULT_TEXT, 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_RESULT_VALUE

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

REPORT_RESULT_LIMIT is null or not numeric

D

DT_RESULT.RESULT_NUMERIC


RESULT_TEXT is null

REPORT_RESULT_LIMIT is null or not numeric

ND

symbol** + DT_RESULT.RESULT_NUMERIC


@nd_apply_multiplier='false'

D

converted DT_RESULT.RESULT_NUMERIC


@nd_apply_multiplier='false'

ND

symbol + converted DT_RESULT.RESULT_NUMERIC * @nd_multiplier


@nd_apply_multiplier='true'

D

converted DT_RESULT.RESULT_NUMERIC


@nd_apply_multiplier='true'

@nd_multiplier<>0

ND

symbol + converted DT_RESULT.RESULT_NUMERIC


@nd_apply_multiplier='true'

@nd_multiplier=0

ND

symbol + 0


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

@nd_apply_multiplier='true'

D

DT_RESULT.RESULT_TEXT, DT_RESULT.RESULT_NUMERIC


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

@nd_apply_multiplier='true'

ND

symbol + original REPORT_RESULT_LIMIT


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

@nd_apply_multiplier='false'

D

DT_RESULT.RESULT_NUMERIC


when "Skip Missing Unit Conversions" = true

unit conversion fails so skipped

@nd_apply_multiplier='false'

ND

symbol + original REPORT_RESULT_LIMIT * @nd_multiplier

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

 

** - is DT_RESULT.DETECT_FLAG if detect_flag is '<', '>', '>=' or '<=', otherwise is @nd_symbol

 

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 Dependencies: There are no dependencies for this report.

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report. Note the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


*

Individual(s)-facilities


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

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



Use Non-Detect Multiplier to Report_Result_Value Only:



Non-Detect Symbol



Reportable



Reporting Limit


Additional Fields






                                               

30007-input.params

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

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

SAMPLEDATE

SAMPLETIME

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

 

Extra fields: Any fields chosen in this parameter.

Note: *refers to hidden parameters.

 

Tables: DT_SAMPLE, DT_TEST, DT_RESULT, DT_LOCATION

 

Database Type: SQL

 

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

 

Database Version: EQuIS 6.3+

 

Data Requirements: N/A

 

Output Type: Report Grid with options for Excel and CrossTab

 

Example Output:

 

30007-ARII_output_example