SPM - Completeness Table - Activities Report

Report Name: SPM - Completeness Table - Activities (example1) (example2) (example3)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Report Grid with options for Excel1 and CrossTab

Description: The SPM - Completeness Table - Activities report gives a comparison between the activities that had been scheduled to occur and the data that has been received in the EQuIS data tables. The report grid has a Status column to show complete and incomplete tasks. This report is intended to generate a grid output to be used in EQuIS Enterprise and Microsoft Power BI Dashboards.

Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database.

•For SPM usage, no additional steps are necessary.

•For Enterprise usage, this report should be published to the database. The report will be available for selection once it has been published.

•For Professional usage, this report should be published to the database or have the .dll added to the local '.../Earthsoft/EQuIS/' folder.

Overview:

Activity type Parameter has three options: Water Levels, Soil Gas Survey and Other Activities.

•If Activity Type is Water Levels, then comparison is made against the DT_WATER_LEVEL table.

•If Activity Type is Soil Gas Survey, then comparison is made against the DT_SOIL_GAS_SURVEY table.

•If Activity Type is Other Activities, then comparison is made against the DT_LOCATION_PARAMETER and DT_EQUIPMENT_PARAMETER tables.

Activities are matched between the two tables based on these fields match:

•SYS_LOC_CODE

•EQUIPMENT_CODE (if populated in DT_LOCATION_PARAMETER table)

•TASK_CODE, and

•ACTIVITY_CODE in DT_SPM_PLANNED_ACTIVITY matches PARAM_CODE in DT_EQUIPMENT_PARAMETER/DT_LOCATION_PARAMETER.

•The dates between DT_SPM_PLANNED_ACTIVITY and the _PARAMETER table do not need to match

Tables: DT_FACILITY, DT_SPM_SCHEDULED_ACTIVITY, DT_WATER_LEVEL, DT_SOIL_GAS_SURVEY, DT_LOCATION, DT_LOCATION_PARAMETER, DT_COORDINATE, DT_SPM_SCHEDULED_TASK, DT_SPM_PLANNED_TASK, DT_SPM_COMMITMENT, DT_EQUIPMENT, DT_EQUIPMENT_PARAMETER

Report Parameters

Activity Type	Parameter to select a single activity type. (Required)
Plan Code	Parameter to select the sample plan code. Only plans with applicable tasks are shown. (Required)
Task Filter
Date Range
Start	Select a start date.
End	Select an end date.
Department(s)	Parameter for selecting department(s).
Monitoring Program	Parameter for selecting monitoring program.
Monitoring Type	Parameter for selecting monitoring type.
Authority	Parameter for selecting authority.
Authority Type	Parameter for selecting authority type.
Permit Number	Parameter for selecting permit number.
Task Type	Parameter for selecting task type.
Priority Ranking	Parameter for selecting priority ranking.
Person Name(s)	Parameter for selecting person name(s).
Company Code(s)	Parameter for selecting company code(s).
Project(s)	Parameter for selecting project(s).
SPM Task Code(s)	Parameter for selecting task code(s).
Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Include Unplanned Other Activities	Boolean parameter to include unplanned activities. Default is false.

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