Report Name: SPM - Completeness Report - Detailed (example)
File Name: EarthSoft.Reports.Library.48827.dll
Dependencies: Licensed SPM and SPM Schema
Source: SPM install
Output Type: Excel1
Description: The SPM - Completeness Report - Detailed report gives a comparison between the activities, samples and analytical results that had been scheduled to occur and the data that has been received in the EQuIS data tables. The report uses color coding to show complete and incomplete tasks at a glance.
Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database. For SPM usage, no additional steps neessary. 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.
The comparison no longer uses the SYS_SAMPLE_CODE, which is often not determined until the date and time the sample is actually collected. The comparison is made by comparing the following fields from DT_SPM_SCHEDULED_SAMPLE and DT_SAMPLE: TASK_CODE, SYS_LOC_CODE, SAMPLE_TYPE, MATRIX (if not null), and 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), and LAB (optional based on check box in Parameters).
Note that tasks which have been manually marked as Complete (i.e., through editing a scheduled task) will not show details in this report. Only Summary information will be exported.
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_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
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2020 EarthSoft, Inc • Modified: 14 May 2020