SPM - Completeness Table - Equipment Activities Report

<< 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: The 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.

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

 

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

Date Range

Used to filter records in both DT_SPM_SCHEDULED_ACTIVITY and DT_EQUIPMEMT_PARAMETER tables.

Start

Select a start date.

End

Select an end date.

Equipment Type

Select one or more equipment type(s).

Equipment(s)

Select one or more equipment code(s).

Parameter(s)

Select one or more equipment parameter code(s).

Adhoc Task Code(s)

Select one or adhoc task code(s)

Status

Select one or record status options: C (Complete), I (Incomplete), and U (Unplanned).

 

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

 

 



Copyright © 2024 EarthSoft, Inc. • Modified: 22 Feb 2023