<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > 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.
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)
and the following fields from DT_SPM_SCHEDULED_RESULTS and DT_TEST/DT_RESULT:
•CAS_RN
•FRACTION
•METHOD (optional based on check box in Parameters)
•LAB (optional based on check box in Parameters)
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 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2023 EarthSoft, Inc • Modified: 09 Mar 2022