SPM - Activity Metrics Report

Report Name: SPM - Activity Metrics

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: EarthSoft Community Center Downloads Dashboard under Products > Data Governance

Language: English

Output Type: Report Grid with options for Excel1 and Crosstab

Description: The SPM - Activity Metrics report can be used as part of EQuIS data governance and returns metrics on scheduled water level, purge, and other activities for the Last X months from the End Date for all facilities.

Installation Instructions: This report requires a licensed EQuIS SPM and the SPM Schema applied to the database. The SPM - Activity Metrics report (EarthSoft.Reports.Library.d41308.dll) is available for download in the Products\Data Governance folder on the Downloads Dashboard on the EarthSoft Community Center. Copy the DLL file to the EQuIS Professional installation folder. For standard installations, this directory is C:\Program Files\EarthSoft\EQuIS; for per-user installations, this directory is %localappdata%\Programs\EarthSoft\EQuIS by default.

For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview: The report returns counts for each class of activity that are scheduled, the actual number of activities completed, and the number of activities completed punctually.

Source Tables: DT_FACILITY, DT_LOCATION_PARAMETER, DT_PURGE, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_SCHEDULED_TASK, DT_WATER_LEVEL, RT_GROUP, RT_SPM_ACTIVITY

Report Parameters

End Date	Select or enter an end date.
Last X Months	The previous number of months to search.

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