Geotechnical Project Details Report

Report Name: Geotechnical Project Details

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: Excel1 or PDF

Description: The Geotechnical Project Details report filters data by DT_TASK.TASK_CODE and outputs the project information related to the task. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Project Details 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 Shared Attributes detailed in the Shared Report Attributes article do not apply to this report. The following Excel Name Manager fields are specific to the Geotechnical Project Details report.

Excel Name Manager Field	EQuIS Source	Description
task_code	DT_TASK.TASK_CODE	Project Task Code
task_desc	DT_TASK.TASK_DESC	Project Task Name
project_info	Concatenation of the DT_TASK.TASK_DESC, ‘-’, RT_COMPANY.CITY, ’,’ RT_COMPANY.STATE	Concatenation of Project name with city and state (e.g., 405Bridge – Seattle, Washington)
office_address	Address in RT_COMPANY associated with AT_FACILITY.COMPANY_CODE. This includes RT_COMPANY.ADDRESS_1, RT_COMPANY.CITY, and RT_COMPANY.STATE.	Office in charge of project
logo	Queries the image in DT_FILE based on if DT_TASK_PARAMETER.PARAM_CODE = ‘logo’ or ‘alternative_logo’. If ‘alternative_logo’ is null, then the ‘Default’ logo is displayed.	Logo associated with office
site_address	DT_FACILITY.ADDRESS, DT_FACILITY.CITY, DT_FACILITY.STATE	Project site address
address_1	DT_FACILITY.ADDRESS	Project site street address
city_state	DT_FACILITY.CITY, DT_FACILITY.STATE	Project site city and state separated by a comma
client	DT_TASK.CLIENT	Project client name
client_location	DT_TASK_PARAMETER.PARAM_CODE = ‘client_location'	The location of the client (city and state)
exhibit_nb	User entered report parameter	Exhibit number that the user defines as a report parameter

Tables: DT_FACILITY, DT_FILE, DT_TASK, DT_TASK_PARAMETER, RT_COMPANY

Report Parameters

Task(s)	Parameter for selecting task code(s).
Excel Template	Parameter for selecting Excel template. The report searches the DT_FILE table where DT_FILE.PLACE_TYPE = ‘geo_general_notes'.
Override Template (EQuIS Professional Only)	Parameter to enter the full file path to use a local override template. This parameter is only available in EQuIS Professional.
Output File Type	Parameter for selecting the output file type. The options are PDF or Excel.
Exhibit Number	Parameter to enter an exhibit number to display on the output.

1Excel report output requires a valid license of Microsoft Excel to view the output.