EnvironInsite Boring Logs

Report Name: EnviroInsite Boring Logs

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

Dependencies: Licensed EnviroInsite Module and template in DT_FILE (see below)

Software: EnviroInsite

Source: EnviroInsite install

Language: English

Output Type: PDF

Description: The EnviroInsite Boring Logs Report relies on a log design template file to generate boring log files in PDF format.

Installation:

See the EnviroInsite Report Installation article for more detailed information.

For EQuIS Professional, a local installation of EQuIS EnviroInsite 7 is required to run the report.

For EQuIS Enterprise and ArcEQuIS, additional files must be added to the Enterprise bin folder. The required files are packaged (EnviroInsite_Enterprise_package_x64_{#}.zip) and available on the EarthSoft Community Center Downloads page (All Items\Products\EnviroInsite\v7).

ArcEQuIS also requires that the report be published to the database in EQuIS Professional.

Overview:

A template file, uploaded to the DT_FILE table, is required to run this export report. The data requirements depend on the content of the boring log template in use. See the Tables and Fields used to Generate Full-Page Boring Logs and Boring Logs help content for more information.

The template, created in EnviroInsite (see Log Design Window), defines the log content and format and must be imported into the EQuIS database using the Docs and Photos Form prior to running the report. The DT_FILE.FILE_TYPE field should be set to ".xml", and the file content is stored in the CONTENT field.

Notes:

•To share a template between multiple facilities of a database, clear the content of DT_FILE.FACILITY_ID.

•The anticipated time to generate the report export contents is on the order of 15 seconds per selected location.

Tables: DT_LOCATION and DT_WELL are accessed in all report executions. Other tables may also be accessed depending on the contents of the boring log template being used. These include: DT_WATER_TABLE, DT_DRILL_ACTIVITY, DT_LITHOLOGY, DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_DRILL_PARAMETER, DT_DOWNHOLE_POINT_DATA, and DT_WELL_SEGMENT.

Report Parameters

Template File	Select a log design template file from those stored in DT_FILE.
Location
EDD (ebatch)	Select an EBATCH value as a means of selecting locations based on filtering DT_LITHOLOGY.EBATCH with the ebatch input. Note that when a TASK_CODE is selected, EBATCH is filtered according to AT_LOCATION.ASSOCIATION for that TASK_CODE.
Locations	Parameter for selecting individual locations. Note that when a TASK_CODE is selected, locations are filtered according to AT_LOCATION.ASSOCIATION for that TASK_CODE.
Location Group(s)	Parameter for selecting location groups. Note that when a TASK_CODE is selected, location groups are filtered according to the location members pertaining to the AT_LOCATION.ASSOCIATION for that TASK_CODE.
Task Code	Select a task code from those listed in the AT_LOCATION.ASSOCIATION field.
Visibility parameters	Lists PARAM_CODEs from DT_TASK_PARAMETER and DT_FACILITY_PARAMETER for selection to temporarily adjust their visibility settings. See Boring Log Template Design Window article for details on assigning visibility parameters.
Visibility parameters to disable	PARAM_CODEs with PARAM_VALUEs of "Y" will be set to "N" for the duration of the report, hiding assigned columns from the boring log.
Visibility parameters to enable	PARAM_CODEs with PARAM_VALUEs of "N" will be set to "Y" for the duration of the report, enabling assigned columns to show on the boring log.
Output Type	Currently the only available output type is a PDF file format.