<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > 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.
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.
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 |
||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2023 EarthSoft, Inc • Modified: 25 Nov 2021