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.