Geotechnical Lab Test Status

Report Name: Geotechnical Lab Test Status (example 1. example 2)

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

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional and Enterprise

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

Language: English

Output Type: Report Grid1

Description: The Geotechnical Lab Test Status report summarizes the status of the geotechnical lab tests of the selected tasks and/or locations (see the Data Mapping of the report output). The output of the report is in a grid format and includes a ‘test_status’ field that reports if the lab test status is complete (‘COMP’) or in progress (‘INPR’). Only samples that have a lab test assigned to them in the DT_GEO_LAB_ASSIGN_TEST table are included in the report output.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Lab Test Status report (EarthSoft.Reports.Library.176839.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.

Additional Details:

The report outputs the lab test status information based on a defined relationship between DT_GEO_LAB_ASSIGN_TEST.TEST_METHOD_CODE and DT_GEO_TEST.TEST_METHOD. This relationship must be configured in the RT_REMAP and RT_REMAP_DETAIL tables where the RT_REMAP_DETAIL.REMAP_CODE = 'GEO_TEST_METHODS'. Information on how the relationships are defined is detailed below:

•RT_REMAP_DETAIL.INTERNAL_VALUE = DT_GEO_LAB_ASSIGN_TEST.TEST_METHOD_CODE

•RT_REMAP_DETAIL.EXTERNAL_VALUE = DT_GEO_TEST.TEST_METHOD

•RT_REMAP_DETAIL.EXTERNAL_FIELD = 'TEST_METHOD'

•RT_REMAP_DETAIL.REMAP_CODE = 'GEO_TEST_METHODS'

If data are present in the DT_GEO_RESULT table for DT_GEO_TEST.TEST_METHOD where DT_GEO_LAB_ASSIGN_TEST.TEST_METHOD_CODE = DT_GEO_TEST.TEST_METHOD (as defined by the RT_REMAP tables), then the lab test status is reported as ‘COMP’.

When data are not present in the DT_GEO_RESULT table where DT_GEO_LAB_ASSIGN_TEST.TEST_METHOD_CODE = DT_GEO_TEST.TEST_METHOD (as defined by the RT_REMAP tables), then the lab test status is reported as ‘INPR’.

This report output includes the following fields:

Report Output	Data Mapping
FACILITY_CODE	DT_FACILITY.FACILITY_ID
TASK_CODE	DT_GEO_LAB_ASSIGN.TASK_CODE, DT_SAMPLE.TASK_CODE
SYS_LOC_CODE	DT_SAMPLE.SYS_LOC_CODE associated to DT_GEO_LAB_ASSIGN_TEST.SAMPLE_ID
SYS_SAMPLE_CODE	DT_SAMPLE.SYS_SAMPLE_CODE
START_DEPTH	DT_SAMPLE.START_DEPTH
END_DEPTH	DT_SAMPLE.END_DEPTH
REMAPPED_TEST_METHOD	DT_GEO_LAB_ASSIGN_TEST.TEST_METHOD_CODE
TEST_METHOD	RT_REMAP_DETAIL.EXTERNAL_VALUE, DT_GEO_TEST.TEST_METHOD
TEST_METHOD_NAME	RT_GEO_TEST_METHOD.TEST_METHOD_NAME
TEST_STATUS	‘COMP' if DT_GEO_TEST with the checked TEST_METHOD has associated records in both DT_SAMPLE (DT_GEO_TEST.OBJECT_EUID = DT_SAMPLE.SAMPLE_ID) and DT_GEO_RESULT. Otherwise 'INPR'.

Tables: DT_GEO_LAB_ASSIGN, DT_GEO_LAB_ASSIGN_TEST, DT_GEO_RESULT, DT_GEO_TEST, DT_SAMPLE, RT_GEO_TEST_METHOD, RT_REMAP, RT_REMAP_DETAIL

Report Parameters

Facility_id	Hidden. Login facility.
Task(s)	Parameter for selecting DT_TASK.TASK_CODE fields that match DT_GEO_LAB_ASSIGN.TASK_CODE.
Location/Individual(s)	Parameter for selecting DT_LOCATION.SYS_LOC_CODE.
Location/Group(s)	Parameter for selecting RT_GROUP.GROUP_CODE.

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