SPM - Result Metrics Report

Report Name: SPM - Result 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 - Result Metrics report can be used as part of EQuIS data governance and returns basic result information and counts on sampling results 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 results scheduled, the actual number of samples completed, and the number of results completed within the contract method turn around days.

Source Tables: DT_FACILITY, DT_FIELD_SAMPLE, DT_SPM_CONTRACT, DT_SPM_CONTRACT_METHOD, DT_RESULT, DT_SAMPLE, DT_SPM_SCHEDULED_RESULT, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_TASK, DT_TEST, RT_ANALTYE

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.