SPM - Task Details

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Sample Planning Module >

SPM - Task Details

Report Name: SPM - 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: Excel1

 

Description: The Task Details report shows which items are involved with a scheduled 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 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.

 

Overview:

This report requires tasks scheduled in SPM.

 

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.

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).

Project(s)

Parameter for selecting project(s).

SPM Task Code(s)

Parameter for selecting task code(s).

Multiple tabs by start date

Checkbox for creating multiple tabs by start date. Default: True.

Display Sample Type Code or Description

Parameter to display the sample type code or description. Default: code.

 

 

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