Geotechnical CPT Data Report

Function Report Name: Geotechnical CPT Data (example)

Database Object: EQUIS.GEOTECH_CPT_DATA

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 CPT Data report uses raw Cone Penetration Test (CPT) data parameters stored in the DT_DOWNHOLE_POINT_DATA table to calculate and output correlated CPT parameters. This report filters the results based on the selected task and will only display locations that have CPT data in the DT_DOWNHOLE_POINT_DATA table. This report can be run in EQuIS Professional or used in the Data Grid widget in EQuIS Enterprise.

Note: To exclude a reading from being included in the Geotechnical CPT Data report, the user must set the DT_DOWNHOLE_POINT_DATA.REPORTABLE_YN value to ‘N’ for the reading.

Installation Instructions: The EQUIS.GEOTECH_CPT_DATA database function is installed when the Geotech Schema is applied to the database. The EQUIS.GEOTECH_CPT_DATA function creates the function report Geotechnical CPT Data.

Additional Information: See the Geotechnical Function – EQUIS.GEOTECH_CPT_DATA article for a detailed explanation of calculations and output parameters.

Tables: DT_DOWNHOLE_POINT_DATA, DT_EQUIPMENT, DT_EQUIPMENT_PARAMETER, DT_LOCATION, DT_LOCATION_PARAMETER, DT_TASK, DT_TASK_PARAMETER, DT_WATER_TABLE

Report Parameters

Tasks(s)	Parameter for selecting task code(s).
Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.

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