Facility Results II

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Facility Results II

Report Name: Facility Results II*

*previously called (Beta) Facility Results

 

Report Type: Standard Report

 

Description: Facility Results II provides a broad overview of the analytical result information for the selected locations, along with the sample depth and screened interval. It is a class version of the legacy Facility Results function report, though there are some differences. Facility Results II uses Analytical Results II to retrieve source data, while Facility Results uses the legacy Analytical Results function report.

 

Notes:

Facility Results II has the two new user input parameters of "Reportables:" and "Segment Type(s):" which Facility Results does not have.

loc_group_code and loc_report_order are not listed in the output of Facility Results II if Location/Groups are not selected, which is inherited from Analytical Results II.

The loc_group in the output of the legacy Facility Results is renamed as loc_group_code in Facility Results II.

Facility Results II has < in front of report_result_text which is inherited from Analytical Results II.

Facility Results II treats a location as the same one when it Is selected as individual location and also included in a selected location group. As compared, the legacy Facility Results treats the location as different ones.

Facility Results has loc_name, loc_group and loc_report_order, and no fraction under SQL while no loc_name, loc_group and loc_report_order but has fraction under Oracle. Therefore, Facility Results II generates all of the loc_name, loc_group_code, loc_report_order and fraction if Location/Groups are selected or loc_name/fraction if Location/Groups are not selected.

 

 

Click here for the latest version.

 

Report Dependencies: Analytical Results II (EarthSoft.Reports.Library.50943.dll)

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

*ebatch



Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start Date



End Date


Matrix(es)


Result




Analyte




Individual(s)



Group(s)


Unit






Reportable


Segment Type



                                               

30009-input.params

SYS_LOC_CODE,

LOC_NAME,

LOC_GROUP_CODE,

LOC_REPORT_ORDER,

CHEMICAL_NAME,

SAMPLE_DATE,

REPORT_RESULT_VALUE, REPORT_RESULT_TEXT,

REPORT_RESULT_UNIT,

DETECT_FLAG,

FRACTION,

REPORTING_DETECTION_LIMIT,

SAMPLE_DEPTH,

SCREEN_DEPTH

 

Note: * refers to hidden parameters.

 

Tables: All the tables used by Analytical Results II and DT_WELL_SEGMENT

 

Database Type: SQL

 

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

 

Database Version: EQuIS v5.6+

 

Data Requirements: N/A

 

Report Requirements: Grid

 

Output Type: Grid

 

Example Output: View the example below or download the attachment.

 

30009-ex.output_zoom48