Geotechnical Results

Report Name: Geotechnical Results (example)

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

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Report Grid1

Description: The Geotechnical Results report returns information from the DT_SAMPLE, DT_GEO_TEST and DT_GEO_RESULT tables based on the report parameter selections. The report returns information from the DT_GEO_TEST and DT_GEO_RESULT tables. Location and sample related results in the DT_GEO_TEST and DT_GEO_RESULT tables are included in the output. Note that the DT_GEO_TEST records can be associated with their corresponding records in the DT_SAMPLE table by DT_GEO_TEST.OBJECT_EUID = DT_SAMPLE.SAMPLE_ID. The report supports filtering the output by the DT_GEO_TEST.TEST_TYPE field.

This report can be run in EQuIS Professional or published to EQuIS Enterprise. The report can return the output of newly submitted EDD data (filtered by DT_GEO_RESULT.EBATCH) after its EIA report is setup in Enterprise.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Results report (EarthSoft.Reports.Library.d30189.dll) is available for download in the Products\EQuIS Geotech folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Tables: DT_GEO_RESULT, DT_GEO_TEST, DT_LOCATION, DT_SAMPLE, DT_TASK

Report Parameters

EBATCH	Hidden. Monitors EIA setup in Enterprise, mapped to DT_GEO_RESULT.EBATCH.
FACILITY_ID	Hidden. Login facility or facility group.
Task(s)	Parameter for selecting task code(s), mapped to DT_TASK.TASK_CODE.
Location
Individual(s)	Parameter for selecting individual locations, mapped to DT_LOCATION.SYS_LOC_CODE.
Group(s)	Parameter for selecting location groups, mapped to RT_GROUP.GROUP_CODE.
Test Type(s)	Parameter for selecting test type(s), mapped to DT_GEO_TEST.TEST_TYPE.

Report Output: FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, SYS_SAMPLE_CODE, SAMPLE_DATE, START_DEPTH, END_DEPTH, DEPTH_UNIT, TASK_CODE, SAMPLE_ID, TEST_TYPE, GEO_TEST_ID, TEST_METHOD, GEO_RESULT_CODE, RESULT_VALUE, RESULT_VALUE_TEXT, RESULT_UNIT

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.