Geotechnical Widget Data Revisions

<< Click to Display Table of Contents >>

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

Geotechnical Widget Data Revisions

Report Name: Geotechnical Widget Data Revisions  (example)

File Name: EarthSoft.Reports.Library.d30147.dll

Dependencies: Licensed EQuIS Geotech and Geotechnical Schema

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Report Grid1

 

Description: The Geotechnical Widget Data Revisions report returns information from the DT_NOTE table for the login facility in Professional or the selected facility in Enterprise that pertains to actions taken in the EQuIS Geotech - CPT/DMT Data Review (BETA), EQuIS Geotech - Lithology Editor (BETA), or EQuIS Geotech - Sample Test Review (BETA) widgets. When using these widgets, users must enter a comment that saves to the DT_NOTE.NOTE_TEXT field to serve as an auditable record of the changes made to the database via the widget. Each widget has an associated NOTE_TYPE applied when comments are saved and is used as a parameter in the report. The applicable DT_NOTE.NOTE_TYPE options are:

Geo_CPT_DMT_Revision

Geo_Lithology_Revision

Geo_SampleTest_Revision

 

See the EQuIS Geotech - CPT/DMT Data Review (BETA), EQuIS Geotech - Lithology Editor (BETA), or EQuIS Geotech - Sample Test Review (BETA) widget articles for more details about operation of the widgets.

 

This report can be run in EQuIS Professional or published to EQuIS Enterprise.

 

Installation Instructions: This report requires an EQuIS Geotech license and the Geotechnical Schema applied to the database. The Geotechnical Widget Data Revisions report (EarthSoft.Reports.Library.d30147.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.

 

Tables: DT_NOTE, RT_NOTE_TYPE

 

Report Parameters

FACILITY_ID

Hidden. Login facility.

Note Type(s)

Parameter for selecting NOTE_TYPEs, mapped to DT_NOTE.NOTE_TYPE where DB_RECORD_ID is the login FACILITY_ID and NOTE_TYPE is 'Geo_CPT_DMT_Revision', 'Geo_Lithology_Revision', and/or

'Geo_SampleTest_Revision'.

 

Report Output:

 

Report Output

Data Mapping

FACILITY_CODE

DT_FACILITY.FACILITY_CODE

NOTE_TEXT

DT_NOTE.NOTE_TEXT

NOTE_TYPE

DT_NOTE.NOTE_TYPE

USER_NAME

DT_NOTE.CONTACT_1

CREATED_DATE

DT_NOTE.CREATED_DATE

VALUE_1

DT_NOTE.VALUE_1

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.