SPM - Completeness Report - Detailed

<< Click to Display Table of Contents >>

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

SPM - Completeness Report - Detailed

Report Name: SPM - Completeness Report - Detailed (example)

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 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 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 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_FLOW, 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

 

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.

Department(s)

Parameter for selecting department(s).

Monitoring Program

Parameter for selecting monitoring program.

Monitoring Type

Parameter for selecting monitoring type.

Authority

Parameter for selecting authority.

Authority Type

Parameter for selecting authority type.

Permit Number

Parameter for selecting permit number.

Task Type

Parameter for selecting task type.

Priority Ranking

Parameter for selecting priority ranking.

Person Name(s)

Parameter for selecting person(s).

Company Code(s)

Parameter for selecting company code(s).

Project(s)

Parameter for selecting project(s).

SPM Task Code(s)

Parameter for selecting SPM task code(s).

Type(s)

Select one or more sample types.

QC Type(s)

See Plan QC Samples in SPM for additional information.

Matrix(es)

Select one or more sample matrix.

Delivery Group(s)

Parameter to select one or more sample delviery goups (field or lab).

Result Type(s)

Parameter to select result type(s).

Test Type(s)

Parameter to select test type(s).

Non-detect Symbol

Input parameter for non-detect symbol. Default: <.

Reporting Limit

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Check by Method

Checkbox for enabling check by method. Default: False.

Check by Lab

Checkbox for enabling check by lab. Default: False.

Check by Matrix

Checkbox for enabling check by matrix. Default: True.

Check by Fraction

Checkbox for enabling check by fraction. Default: True.

Check by Sample depth

Checkbox for enabling check by Sample depth. Default: True.

Check by SPM sys_sample_code

Checkbox for enabling check by SPM sys_sample_code. Default: False.

Add Task Client

Checkbox to add task client. Default: False.

A Simple results Summary Report

Checkbox to create a simple lab results summary report with C and I status. Default: False.

Included Unplanned Samples

Checkbox to include unplanned samples. Default: False.

 

* This report includes a hidden parameter, Match on sys_loc_code, that could affect the output of the report. The default for this parameter is True. See Plan QC Samples in SPM for additional information.

 

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report that allows saving of User Reports). These parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

 

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