Geotechnical Lab Test Assignments Report

Function Report Name: Geotechnical Lab Test Assignments (example)

Database Object: EQUIS.GEOTECH_LAB_ASSIGN_SAMPLES

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional

Source: EQuIS Professional install + EQuIS Geotech

Language: English

Output Type: Report Grid1

Description: The Geotechnical Lab Test Assignments report outputs assigned lab test method information for samples in a facility. This includes lab test name, sample information, lab information, and cost information. This report can be run in EQuIS Professional or used in the Data Grid widget in EQuIS Enterprise.

Installation Instructions: The EQUIS.GEOTECH_LAB_ASSIGN_SAMPLES database function is installed when the Geotech Schema is applied to the database. The EQUIS.GEOTECH_LAB_ASSIGN_SAMPLES function creates the function report Geotechnical Lab Test Assignments.

Additional Information: See the Geotechnical Function – EQUIS.GEOTECH_LAB_ASSIGN_SAMPLES article for a detailed explanation of calculations and output parameters. When running the report, samples parameter excludes samples that do not have DT_SAMPLE.TASK_CODE populated.

Tables: DT_COST, DT_GEO_LAB_ASSIGN, DT_GEO_LAB_ASSIGN_TEST, DT_SAMPLE, RT_GEO_TEST_METHOD

Report Parameters

Tasks	Parameter for selecting task code. This report only supports one task code selection.
Sample	Parameter for selecting sample(s).

1The Report Grid provides additional export options to Excel, PDF, Text, Access, XML, etc.