SPM - Completeness Report

Report Name: SPM - Completeness Report - Summary (example1) (example2)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

Description: Details completeness of field samples and analytical results (Completed, Incomplete, SRN issues) by task and facility.

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:

Source Tables DT_FACILITY, DT_FIELD_SAMPLE, DT_LOCATION, DT_LOCATION_PARAMETER, DT_PURGE, DT_RESULT, DT_SAMPLE, DT_SOIL_GAS_SURVEY, DT_SPM_CONTRACT, DT_SPM_CONTRACT_CONTAINER, DT_SPM_CONTRACT_MAG, DT_SPM_CONTRACT_MAG, DT_SPM_CONTRACT_MAG, DT_SPM_CONTRACT_METHOD, DT_SPM_PLAN, DT_SPM_SCHEDULED_ACTIVITY, DT_SPM_SCHEDULED_CONTAINER, DT_SPM_SCHEDULED_RESULT, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_TASK, DT_SPM_SCHEDULED_TASK, DT_TASK, DT_TEST, DT_WATER_LEVEL, RT_ANALYTE, RT_COMPANY, RT_GROUP, RT_GROUP_MEMBER, RT_LOOKUP, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP, RT_SPM_ACTIVITY

Report Parameters

Facility	Parameter for selecting the facility
Date Range
Start	Select a start date.
End	Select an end date.
Include Tasks Marked as Completed	Checkbox for including tasks marked as completed. Default: False.

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