Analytical Results with Sample Parameter (Table)

<< Click to Display Table of Contents >>

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

Analytical Results with Sample Parameter (Table)

Report Name: Analytical Results with Sample Parameter (Table) (example)

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

Dependencies: v54.sample_parameter report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The Analytical Results with Sample Parameter (Table) Report combines the Analytical Results Report and the Sample Parameter Report using the mapping outlined below.

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary, but this report requires the Sample Parameters report (v54.sample_parameter) to have a STATUS_FLAG of A in ST_REPORT. For more information, see Change Report Status.

 

Overview:

This report uses the following data mapping to combine the Analytical Results report and Sample Parameters report:

DT_SAMPLE_PARAMETER.MEASUREMENT_DATE = "ANALYSIS_DATE"

DT_SAMPLE_PARAMETER.MEASUREMENT_METHOD = "ANALYTIC_METHOD"

DT_SAMPLE_PARAMETER.PARAM_CODE = "CAS_RN"

DT_SAMPLE_PARAMETER.PARAM_VALUE = "REPORT_RESULT_VALUE" (numeric values only)

DT_SAMPLE_PARAMETER.PARAM_VALUE = "REPORT_RESULT_TEXT"

DT_SAMPLE_PARAMETER.PARAM_UNIT = "REPORT_RESULT_UNIT"

 

To appear in the report, sample parameter group records (as listed in the Parameter > Group(s) report parameter) must meet the following conditions:

1.RT_GROUP.GROUP_TYPE = "param_code" for the group

2.RT_GROUP_MEMBER.MEMBER_TYPE = "param_code" for the group members

3.RT_GROUP_MEMBER.MEMBER_CODE entries for the group members exist in RT_SAMPLE_PARAM_TYPE.PARAM CODE.

 

Source Tables DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, RT_MTH_ANL_GROUP, RT_SAMPLE_PARAM_TYPE

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Use DT_GEOGRAPHY for coordinate data

Toggle to use DT_GEOGRAPHY for coordinate data.

Sample


Type(s)

Select one or more sample types.

Date Range

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

Matrix(es)

Select one or more sample matrix.

Task(s)

Select one or more tasks.

Task_Code_2(s)


Field SDG(s)

Select one or more Field SDGs.

Depth

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

DQM Status


Test


Method(s)

Select one or more test method.

Fraction(s)

Select one or more fraction.

Column Number(s)

Select one or more column number.

Type(s)

Select one or more test type.

Lab Matrix(es)

Select one or more lab matrixes.

Prep Method(s)

Select one or more prep methods.

Lab SDG(s)

Select one or more Lab SDGs.

Result


Analyte

Section for selecting analytes and/or analyte groups.

Unit

Selection for report result units.

Type(s)

Select one or more result type.

Detect Flag(s)

Select one or more options for detect flag.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Non-Detect Qualifier

Select one or more non-detect qualifiers.

Reportable

Select one or more options for reportable result.

Validated

Selection for whether the result is validated or not.

Reporting Limit

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Format Results\Format Code:

Select one format code (e.g. 0.########, 0.0E-00 etc.) predefined or defined in rt_lookup.lookup_desc with lookup_type='ARII_FORMAT'. It applies to REPORT_RESULT_TEXT, REPORT_RESULT_LIMIT, REPORT_METHOD_DETECTION_LIMIT, REPORT_REPORTING_LIMIT, REPORT_QUANTITATION_LIMIT and defaults to empty with no formats applied. It also applies to REPORT_RESULT_VALUE when it can be used to control rounding decimals of a value.

Additional Fields

Additional fields parameter.

Parameter

Section for selecting individual parameters and parameter groups.

 

 

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

SAMPLE_ID

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

TASK_CODE

PARENT_SAMPLE_CODE

ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD

ANALYSIS_DATE

COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_METHOD

LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

TEST_ID

CAS_RN

CHEMICAL_NAME

ORGANIC_YN

REPORT_RESULT_TEXT

REPORT_RESULT_VALUE

REPORT_RESULT_UNIT

REPORT_RESULT_LIMIT

REPORTABLE_RESULT

DETECT_FLAG

INTERPRETED_QUALIFIERES

VALIDATOR_QUALIFIERS

LAB_QUALIFIERS

QUANTITATION_LIMIT

METHOD_DETECTION_LIMIT

REPORTING_DETECTION_LIMIT

DETECTION_LIMIT_UNIT

APPROVAL_CODE

RESULT_TEXT

RESULT_NUMERIC

RESULT_UNIT

RESULT_TYPE_CODE

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

 

 

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