Function Report Name: Geotechnical CPT Data (example)
Database Object: EQUIS.GEOTECH_CPT_DATA
Dependencies: Licensed EQuIS Geotech and Geotechnical Schema
Software: EQuIS Professional
Source: EQuIS Professional install + EQuIS Geotech
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 Geotechnical 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
Copyright © 2023 EarthSoft, Inc. • Modified: 19 Aug 2023