EDGE Field EDD

<< Click to Display Table of Contents >>

EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with EDGE Module >

EDGE Field EDD

Report Name: EDGE Field EDD

 

Report Type: Standard with EDGE or Sample Planning Module (SPM) Purchases

 

Description: This report creates an EDD to be used in EDGE 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. The report also has options to include historical water level data to be used in the Historical Water Level tab of EDGE (aka "History: DTW"), historical field results, and well redevelopment data to be used in the Well Redevelopment Form.

 

When used in conjunction with the EQuIS Sample Planning Module (SPM), data fields relating to planned samples, field measurements and activities (or inspections) can be pre-populated in addition to the above, reducing the amount of time spent in the field entering these data.

 

Report Dependencies: This report depends on the following reports and must have these *.dlls available to work properly:

Analytical Results II Report – EarthSoft.Reports.Library.50943.dll

Water Levels II Report – EarthSoft.Reports.Library.64102.dll

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report. The input parameters vary depending on schemas applied to the database.

 

When opened in EQuIS Professional with a database that does not have the SPM Schema or the Live Schema, the input parameters only include the following:

 

Input Parameters

Input Parameter Screenshot

User(s)



Include Subfacilities



Only Selected Locations



Reference Locations




Individual(s)



Group(s)



Coord_Type_Code



Identifier



Status Flag


Flow




Include Flow Parameters



Include Last Measurement



Alarm Criteria


Export Latest Sample Date



Task Code(s)



Select Format



Select Segment Type for Top of Screen and Well Diameter



Reference Elevation



Historical




Well Redevelopment




Include Pre-Redevelopment



Include Redevelopment


Activities



Water Levels




Years back



Historical range outlier


LNAPL




Years back



Historical range outlier


Historical Chart




Select a field to plot on the historical chart



Select field(s) to show on the historical tab grid



Select custom field(s) to show on historical tab grid


Field Results


Scribe




Starting CPL Number


Output File Type



EDGE_Fld_EDD_input_params_no_SPM

 

When opened in EQuIS Professional or SPM with a database that does have the SPM Schema and the Live Schema, the input parameters include the following:

 

Input Parameters

Input Parameter Screenshot

Plan Code



SPM Task Filter




Date Range




Start Date



End Date


Department(s)



Monitoring Program(s)



Monitoring Type(s)



Authority(s)



Authority Type(s)



Task Type(s)



Priority Ranking(s)



Person Name(s)



Company Code(s)



Project(s)



SPM Task Code(s)


Sampling Company Code(s)



Only Task Locations



Include SPM COCs for Selected Tasks



User(s)



Include Subfacilities



Only Selected Locations



Reference Locations




Individual(s)



Group(s)



Coord_Type_Code



Identifier



Status Flag


Flow




Include Flow Parameters



Include Last Measurement



Alarm Criteria


Export Latest Sample Date



Task Code(s)



Select Format



Select Segment Type for Top of Screen and Well Diameter



Reference Elevation



Historical




Well Redevelopment




Include Pre-Redevelopment



Include Redevelopment


Activities



Water Levels




Years Back



Historical range outlier


LNAPL




Years Back



Historical range outlier


Historical Chart




Select a field to plot on the historical chart



Select field(s) to show on the historical tab grid



Select custom field(s) to show on the historical tab grid


Live




Baro Logger



     Logger_code



     Pressure Series Name



Weather Station



     Logger_code



     Baro Pressure Series
     Name



Transducer



    Logger_code



    Series to be flagged



    Tolerance value


Field Results


Scribe




Starting CPL Number


Output File Type



EDGE_Fld_EDD_input_params

 

Tables: DT_COORDINATE, DT_FACILITY, DT_FILE, DT_LOCATION_PARAMETER, DT_MEASURE_DATUM, DT_SPM_CONTRACT, DT_SPM_CONTRACT, DT_SPM_CONTRACT_CONTAINER, DT_SPM_CONTRACT_MAG, DT_SPM_CONTRACT_METHOD, DT_SPM_PLAN, DT_SPM_PLAN, DT_SPM_PLANNED_ACTIVITY, DT_SPM_PLANNED_SAMPLE, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_SCHEDULED_CONTAINER, DT_SPM_SCHEDULED_RESULT , DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_TASK, DT_SPM_SCHEDULED_TASK, DT_TASK, DT_WELL, DT_WELL_SEGMENT, RT_COORD_TYPE, RT_GROUP, RT_LOCATION_TYPE, ST_REPORT, ST_REPORT_PARAMETER

 

Database Type: SQL

 

Database Schema: Standard - EDGE Schema (SPM Schema recommended but not required)

 

Database Version: EQuIS Version 5.6+

 

Data Requirements: none

 

Output Type: Excel (*.xls or *.xlsx; decided in report parameters)

 

Example Output: View the following example.

 

EDGE_Field_EDD_ex_output