<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > SPM - Completeness Table - Equipment Activities Report |
Report Name: SPM - Completeness Table - Equipment Activities (example)
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: SPM - Completeness Table - Equipment Activities provides a comparison between the equipment activities that had been scheduled to occur and the data that have been received in the EQuIS data tables. The report grid has a Status column to show complete and incomplete tasks. The report can also be filtered by task status. This report is intended to generate a grid output to be used in EQuIS Enterprise and Microsoft Power BI Dashboards. This report can be run across multiple facilities by selecting the facility group.
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.
Overview: The comparison can use the following fields from DT_SPM_SCHEDULED_ACTIVITY and DT_EQUIPMENT_PARAMETER: FACILITY_ID, SYS_LOC_CODE, EQUIPMENT_CODE, PARAM_CODE, TASK_CODE. EQUIPMENT_CODE cannot be NULL and ACTIVITY_TYPE cannot be ‘water_level’, ‘purge’, or ‘flow’.
Tables: DT_EQUIPMENT_PARAMETER, DT_EQUIPMENT, DT_FACILITY, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_SCHEDULED_TASK, RT_EQUIPMENT_PARAM_TYPE, RT_SPM_ACTIVITY
Report Parameters |
||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021