Basic Results II

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Basic Results II

Report Name: Basic Results II

previously called (Beta) Basic Results

 

Report Type: Standard Report

 

Description: In addition to reporting the content of DT_BASIC_RESULT, the Basic Results II Report also provides measured results with unit conversion, if users provide a unit over the user interface. The converted results are in REPORT_RESULT_TEXT, REPORT_RESULT_VALUE and REPORT_RESULT_UNIT. Chemical names, geological coordinates and elevations are also listed. It is a class version of the old stored procedure report, Basic Results, but improved in terms of working with multiple facilities. Column FACILITY_CODE is added onto lists of Location/Individuals or Groups and Analyte/Groups of the user interface.

 

Note 1:  Working with Multiple Facilities

 

1. Individual and group location selection and analyte group selection can work with multiple facilities. When loged in to Professional as a facility group, the locations and analyte groups of all the facilities in the facility group will be displayed on the user interface. RT_GROUP_MEMBER.FACILITY_ID defines the facility of a location group. RT_MTH_ANL_GROUP.FACILITY_ID defines the facility of an analyte group. RT_GROUP.FACILITY_ID is not used to define the facility of a location group, because it is used for other purposes e.g. negative facility id referring to a facility group.

 

2. When all RT_GROUP_MEMBER.FACILITY_ID of a location group are not populated, the location group belongs to all facilities, and therefore will be displayed on the user interface, regardless of the facility logged in to. Similarly, if RT_MTH_ANL_GROUP.FACILITY_ID of an analyte group is not populated, the analyte group belongs to all facilities.

 

Note 2: If Location/Groups is Selected

 

1. If Location/Groups is selected, the LOC_GROUP_CODE and LOC_REPORT_ORDER columns are in the report output. Otherwise, they are not included in the report output.

 

Report Dependencies: There are no dependencies for this report.

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

*ebatch


Location



Individual(s)


Group(s)

Date Range



Start Date


End Date

Depth Range



Start


End

Analyte



Individual(s)


Group(s)


Unit



                                               

30008-input.params.scrnsht

REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT

CHEMICAL_NAME

FACILITY_ID

SYS_LOC_CODE

CAS_RN, DEPTH

RESULT_DATE

RESULT_VALUE

RESULT_UNIT

LOC_NAME

LOC_GROUP_CODE

LOC_REPORT_ORDER

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

SOURCE

SOURCE_METHOD

CUSTOM_FIELD_4

SOURCE_EXTENT

CUSTOM_FIELD_5

EBATCH

DEPTH_UNIT

FACILITY_CODE

X_COORD

Y_COORD

ELEV

LATITUDE

LONGITUDE

 

Note: *refers to hidden parameters.

 

Tables:        RT_GROUP, RT_MTH_ANL_GROUP, DT_BASIC_RESULT, RT_ANALYTE, VW_LOCATION

 

Database Type: SQL

 

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

 

Database Version: EQuIS 6.0+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: IGrid

 

Example Output: View the example below.

 

30008-ex.output_zoom75