EIA - Land Access
Copyright © 2019 EarthSoft, Inc • Modified: 03 Jul 2019
Report Name: EIA: Land Access
Report Type: Standard with EQuIS Sample Planning Module purchase
Description: The EIA: Land Access Report can be used to give advanced notice of Land Access requirements for upcoming scheduled tasks. The report output includes land access information for tasks where the Inquiry Date (set in report parameters) falls within a date range calculated for each task being considered. This date range is calculated using: the number of land access days required for the tasks; task start date; and a number of "early warning days" that can be set in the report parameters. This is the formula used:
Start date = (DT_SPM_SCHEDULED_TASK.START_DATE – (DT_SPM_ACCESS_REQUIRED.LAND_ACCESS_DAYS + EARLY WARNING DAYS))
End date = DT_SPM_SCHEDULED_TASK.START_DATE
This report is set up as a scheduled EQuIS Information Agent (EIA). For example, it could run daily to give notice of land access requirements falling due in the next two weeks. Instructions on how to set up EIAs is available here.
Report Dependencies: There are no dependencies for this report.
File Name: EarthSoft.Reports.Library.48827.dll
Contact email@example.com for a direct file link.
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
Note: * refers to hidden parameters
Tables: DT_PERSON, DT_SPM_ACCESS_REQUIRED, DT_SPM_ACCESS_STATUS, DT_SPM_SCHEDULED_TASK
Database Type: SQL Server
Database Schema: EQuIS Sample Planning Module (SPM)
Data Requirements: N/A
Report Requirements: N/A
Output Type: IGrid
Example Output: Contact firstname.lastname@example.org for more information.