Land Access by Task

<< Click to Display Table of Contents >>

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

Land Access by Task

Report Name: Land Access by Task

 

Report Type: Standard with SPM Module Purchase

 

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.

 

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.

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Plan Code



Task Filter




Date Range




Start Date



End Date


Department(s)



Monitoring Program



Monitoring Type



Authority



Authority Type



Task Type



Priority Ranking



Person Name(s)



Company Code(s)



Task Code(s)


Status



Facility ID*






spm_land_access_by_task

Note: * refers to hidden parameters

 

Tables: DT_SPM_ACCESS_REQUIRED, DT_SPM_ACCESS_STATUS, DT_SPM_SCHEDULED_TASK, RT_LOOKUP

 

Database Type: SQL

 

Database Schema: Sample Planning Module (SPM)

 

Data Requirements: Contact support@earthsoft.com for more information.

 

Report Requirements: Contact support@earthsoft.com for more information.

 

Output Type: Contact support@earthsoft.com for more information.

 

Example Output: Contact support@earthsoft.com for more information.