SPM - Land Access by Task Report

Report Name: SPM - Land Access by Task

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type:

Description: Calculates a time window from (DT_SPM_SCHEDULED_TASK.START_DATE - DT_SPM_ACCESS_REQUIRED.LAND_ACCESS_DAYS) to DT_SPM_SCHEDULED_TASK.START_DATE and displays the Land Access information (required, approved, etc.) for locations that have a window that includes the Inquiry Date.

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 the Land Access requirement entry have a Status assigned in the SPM Land Access Status Form. Displays Land Access information for locations that have planned samples and/or activities.

Tables: DT_SPM_ACCESS_REQUIRED, DT_SPM_ACCESS_STATUS, DT_SPM_SCHEDULED_TASK, RT_LOOKUP

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).
Task Code(s)	Parameter for selecting task code(s).
Status	Parameter for selecting land access request status: a_ Accepted, c_ cancelled, m_ modified, or r_ rejected.