Collect – Field EDD

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Collect Module >

Collect – Field EDD

Report Name: Collect – Field EDD (example)

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

Dependencies: Licensed Collect Module

Software: EQuIS Collect, EQuIS Enterprise

Source: EQuIS Collect install

Language: English

Output Type: Excel1

 

Description: This report creates an EDD to be used in Collect to assist field crews in recording field data. The report creates an EDD with a list of locations to be used as a starting point and/or a task list.

 

Installation Instructions: This report requires a licensed EQuIS Collect module and the Collect Schema applied to the database. For use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. First download the EQuIS Collect xcopy zip from the community center, unblock the *.zip file and extract the EarthSoft.Reports.Library.161941.dll file to the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS. The report will be available for selection once it has been published.

 

Overview:

When used in conjunction with the EQuIS Sample Planning Module (SPM), data fields relating to water levels, activities (or inspections), sampling and chain of custody (COC) handling can also be pre-populated, reducing the amount of time spent in the field entering these data.

 

Pass information from the Collect Field EDD report to Collect Forms by using the Pre-Population feature.

 

Source Tables DT_ACTION_LEVEL_PARAMETER, DT_COORDINATE, DT_EQUIPMENT, DT_FACILITY, DT_FILE, DT_LOCATION_PARAMETER, DT_MEASURE_DATUM, DT_SPM_COMMITMENT, DT_SPM_CONTRACT, DT_SPM_PLAN, DT_SPM_PLANNED_ACTIVITY, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_PLANNED_SAMPLE, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_PLANNED_RESULT, DT_SPM_SCHEDULED_RESULT, DT_SPM_SCHEDULED_TASK, DT_SPM_SCHEDULED_TASK, DT_TASK

 

Report Parameters

Plan Code

Select a plan (only plans with applicable tasks are shown).

SPM Task Filter

Select one or more tasks.

Date Range


Start

Select a start date.

End

Select an end date.

Department(s)

Parameter for selecting department(s).

Monitoring Program(s)

Parameter for selecting monitoring program(s).

Monitoring Type(s)

Parameter for selecting monitoring type(s).

Authority(s)

Parameter for selecting authority(s).

Authority Type(s)

Parameter for selecting authority type(s).

Task Type(s)

Parameter for selecting task type(s).

Priority Ranking(s)

Parameter for selecting priority ranking(s).

Person Name(s)

Parameter for selecting person(s).

Company Code(s)

Parameter for selecting company code(s).

Project(s)

Parameter for selecting project(s).

SPM Task Code(s)

Parameter for selecting SPM task code(s).

Sampling Company Code(s)

Select one or more sampling company code.

Only Task Locations

Checkbox to only include locations from the selected tasks. Default: True.

Include SPM COCs for Selected Tasks

Checkbox to include SPM COCs for selected tasks. Default: False.

User(s)

Select one or more user. Users selected can be available as list in collect forms.

Include Subfacilities

Checkbox to include subfacilities related to the selected locations. Default: False.

Only Selected Locations

Checkbox to only include locations from the selected locations below. Default: False.

Reference Locations


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Coord_Type_Code

Parameter for selecting the COORD_TYPE_CODE.

Identifier

Parameter for selecting the coordinate identifier.

Status Flag

Selection parameter for STATUS_FLAG.

Task Code(s)

Option to prepopulate TASK_CODE from DT_TASK rather than use SPM.

Well Segments


First Well Segment


Select Segment Type for Top of Screen

Parameter for selecting the segment type for the top of the screen for the first well segment.

Select Top of Screen Material Type

Parameter for selecting the segment type for the top of the screen material type for the first well segment.

Second Well Segment


Select 2nd Well Segment Type

Parameter for selecting the segment type for the top of the screen for the second well segment.

Select 2nd Well Segment Material Type

Parameter for selecting the segment type for the top of the screen material typehis for the second well segment.

Reference Elevation

Parameter to select the reference elevation source: HISTORICAL_REFERENCE_ELEV, MEASURE_DATUM, or TOP_CASING_ELEV.

Historical


Water Levels


Years Back


Historical range outlier

The percent of outlier data that will be excluded from the minimum and maximum range used to check new detpth to water values.

Action Levels


Param Codes

Parameter selection for PARAM_CODES.

Action Level Codes

Action level code parameter selection.

Select list of ad-hoc analysis

Parameter selection for ad-hoc analysis.

Equipment Types

Parameter selection for equipment types.

Select remap code(s)

Parameter selection for remap codes.

Scribe


Starting CLP Number

Starting CLP Number (without chars: I O U V)

Location Blank Rows

Location Blank Rows

Output File Type

Parameter for report output type: XLS or XLSX.

 

 

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