Exceedances by Facility Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM >

Exceedances by Facility Report

Report Name: Exceedances by Facility

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1


Description: The Exceedances by Facility report contains two output sections:

1.Number of Samples With Exceedances

2.Number of Incidents


The Number of Samples With Exceedances section contains the numbers of samples within the specified date range that exceed and do not exceed the selected Action Level(s). The numbers represent counts of unique DT_SAMPLE.SAMPLE_ID values for those DT_SAMPLE records with child records in DT_TEST and DT_RESULT. The section also contains a pie chart comparing the two counts.


The Number of Incidents section represents the count of unique values in DT_RESULT.CUSTOM_FIELD_2 for any results with parent DT_SAMPLE.SAMPLE_DATE falling inside the specified date range. One application of this feature would be to store references to an external incident management system in DT_RESULT.CUSTOM_FIELD_2.


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.






Report Parameters


Parameter for selecting the facility

Date Range


Select a start date.


Select an end date.

Action Level(s)

Parameter for selecting action level(s).


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