SPM - Spatial Completeness Summary Report

Report Name: SPM - Spatial Completeness Summary (example)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Report Grid1

Description: The SPM - Spatial Completeness Summary report gives a comparison between the samples and analytical results that had been scheduled to occur, and the data that has been received in the EQuIS data tables. A report is produced that allocates a Completeness Status to each sample, and includes X and Y coordinates so the data may be mapped in GIS or in the EQuIS Enterprise Traffic Light Map Widget (shown here).

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 is made with the following fields from DT_SPM_SCHEDULED_SAMPLE and DT_SAMPLE:

•TASK_CODE

•SYS_LOC_CODE

•SAMPLE_TYPE

•MATRIX (if not null)

•DEPTH (if not null)

Source Tables DT_COORDINATE, 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

Plan Code	Parameter to select the sample plan code. Only plans with applicable tasks are shown.
Sample
Task Filter
Date Range
Start	Select a start date.
End	Select an end date.
SPM Task Code(s)	Parameter for selecting SPM task code(s).
QC Type(s)
Check by Matrix	Check box for enabling check by matrix. Default: True.
Check by Fraction	Check box for enabling check by fraction. Default: True.
Check by Sample depth	Check box for enabling check by Sample depth. Default: True.
Check by SPM sys_sample_code	Check box for enabling check by SPM sys_sample_code. Only applies when Output = '1- Field Samples'. Default: False.

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.