Report Name: Collect – Field EDD (example)
File Name: EarthSoft.Reports.Library.161941.dll
Dependencies: Licensed Collect Module and EDGE Schema
Software: EQuIS Collect, EQuIS Enterprise
Source: EQuIS Collect install
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.
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
Last Custom Data:
SPM_Samples worksheet in the Excel output file has custom field data of the latest sample in columns like last_custom_1, last_custom_2, last_custom_3, last_custom_4 and last_custom_5. These columns are mapped to the CUSTOM_FIELD_1, CUSTOM_FIELD_2, CUSTOM_FIELD_3, CUSTOM_FIELD_4 and CUSTOM_FIELD_5 fields of the DT_SAMPLE table, respectively. For each unique set of FACILITY_ID, SYS_LOC_CODE and MATRIX_CODE, latest sample is found among samples whose task code matches one of the selected SPM task code(s).
Most Recent Measurements:
The Most_Recent_Measurements worksheet in the Excel output file contains the latest values for flow, water level, field results, and equipment parameters.
•Flow – Latest value of DT_FLOW.INSTANT_FLOW and DT_FLOW.CUMULATIVE_FLOW for each unique pair of FACILITY_ID and SYS_LOC_CODE in the SPM_Samples worksheet.
•Water Level – Latest value of DT_WATER_LEVEL.WATER_LEVEL_DEPTH for each unique pair of FACILITY_ID and SYS_LOC_CODE in the SPM_Samples worksheet.
•Field Results – Most recent value of selected Historical/Field Parameter(s) from the DT_RESULT table for latest sample. Latest samples are found for each unique pair of FACILITY_ID, SYS_LOC_CODE and MATRIX_CODE in the SPM_Samples worksheet.
•Equipment Parameter(s) – Most recent value of selected Equipment Parameter Code(s) and Equipment Code(s) from the DT_EQUIPMENT_PARAMETER table for each unique pair of FACILITY_ID and SYS_LOC_CODE in the SPM_Samples worksheet. Equipment Code(s) are selected from the DT_EQUIPMENT table using selected equipment type(s) and whose STATUS_FLAG = ‘A’.
Note: If FACILITY_ID is empty in the DT_EQUIPMENT_PARAMETER table, then FACILITY_ID of facility to which the user is logged in will be displayed.
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2020 EarthSoft, Inc • Modified: 22 Oct 2020