SPM - Analysis Request Report

<< Click to Display Table of Contents >>

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

SPM - Analysis Request Report

Report Name: SPM - Analysis Request

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 Analysis Request report summarizes analyses requested for tasks associated with SPM Scheduled Task(s).

 

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 Plan, Contract, and scheduled Task to be created in SPM. Container information must be included in Contract information.

 

Source Tables DT_FACILITY, DT_SPM_CONTRACT, RT_COMPANY, DT_SPM_SCHEDULED_SAMPLE, RT_GROUP, DT_SAMPLE, DT_TASK, DT_SPM_COMMITMENT, DT_SPM_SCHEDULED_TASK

 

Input Parameters

Plan Code

Select a plan (only plans with applicable tasks are shown).

Task Filter

Select one or more tasks.

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

Lab (required)

Required parameter for selecting the lab.

Exclude Sample Type(s)

Parameter for excluding specific sample types.

Date of Request

Parameter for the date of the analysis request.

Expected arrival date at lab

Parameter for the expected sample arrival date to lab.

Other Instructions

Parameter for lab instructions.

Note

Parameter for analysis request notes.

 

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