ProUCL_data

<< Click to Display Table of Contents >>

ProUCL_data

Report Name: ProUCL_data

 

Report Type: Standard Report

 

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). Documentation for the ProUCL application can be found here: https://www.epa.gov/land-research/proucl-software. It is a report in its first version, but categorized under the EQuIS Interface sometime later.

 

File Name: EarthSoft.Interfaces.ProUCL.dll

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start Date



End Date


Matrix(ces)



Task(s)



Delivery Group(s)



Depth




Minimum Start Depth



Maximum End Depth



Unit

Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(ces)



Prep Method(s)


Result




Analyte




Individual(s)



Group(s)


Unit



Type(s)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Reportable


30205-input.params.scrnsht3

Contact support@earthsoft.com
for more information.

Note: * refers to hidden parameters

 

Tables: RT_GROUP, RT_MTH_ANL_GROUP

 

Database Type: SQL

 

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

 

Database Version: EQuIS Version 5.4.3+

 

Data Requirements: N/A

 

Report Dependencies: Analytical Results

 

Report Requirements: Analytical data with detect flag populated. Similar requirements to Analytical Results Report.

 

Output Type: Excel

 

Example Output: View the following example.

 

30205-ex.output_zoom85

 

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