ProUCL_data

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports >

ProUCL_data

Report Name: ProUCL_data (example)

File Name: EarthSoft.Interfaces.ProUCL.dll

Dependencies: Analytical Results

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: The EQuIS ProUCL Report export allows EQuIS users to export analytical data in a format that can be used in ProUCL (a third party statistical application developed by the USEPA).

 

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

 

Overview:

Documentation for the ProUCL application can be found here: https://www.epa.gov/land-research/proucl-software.

 

This report requires analytical data with detect_flag populated and an EQuIS Professional Plus Data license or higher. Please select the appropriate license using the License Selection pane prior to opening the report.

 

Note: Blank rows may be present in your output when two results for one analyte exist (e.g. Aluminum with two different fractions, T and D), but only one result exists for another analyte in the same sample (e.g. Lead).

 

Source Tables DT_LOCATION, DT_SAMPLE, DT_SDG, DT_STATIC_PROPS, DT_TEST, RT_ANALYTE, RT_FRACTION, RT_GROUP, RT_GROUP_MEMBER, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_RESULT_TYPE, RT_TEST_TYPE, RT_UNIT

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

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.

Delivery Group

Parameter for selecting the sample delivery group.

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.

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

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

Treat it as a large data set if the number of the rows of Analytical Results exceeds

Input parameter for indicating which count of rows treats the results as a large data set. Default: 200000.

Max rows per group if grouping data is needed for a large set of data due to outOfMemory issues

Input parameter for indicating maximum rows per group when grouping data. Default: 30000.

 

Report Output

Location ID

Sample ID

Sample Depth

additional columns for each Chemical Name

 

1Excel report output requires a valid license of Excel to view the output.