Geotechnical Lab Test Status

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with Geotech > Geotech Sample Reports >

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.