SPM - Planned Task Details Report

Report Name: SPM - Planned Task Details (example)

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type:

Description: The SPM - Planned Task Details report shows what items are involved with a planned task. The report includes information on the task itself, bottles assigned for the task, and a detailed list of which samples are to be collected and which activities (or inspections) are to be performed.

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: This report requires that at least one planned task exists in the SPM Plan.

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

Plan Code	Parameter to select the sample plan code. Only plans with applicable tasks are shown.
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.
Project(s)	Parameter for selecting project(s).
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 name(s).
Company Code(s)	Parameter for selecting company code(s).
Task Code(s)	Parameter for selecting task code(s).
Multiple tabs by start date	Check box for creating multiple tabs by start date. Default: True.
Company/Department	Parameter for selecting a sampling company/department.
Display Sample Type Code or Description	Parameter to display the sample type code or description. Default: code.