EIA - Land Access

<< Click to Display Table of Contents >>

 >EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with Sample Planning Module > EIAs (EQuIS Information Agents) >

EIA - Land Access

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

Output Columns

Plan Code



Task Filter




Date Range




Start



End


Department(s)



Monitoring Program

Department(s)


Monitoring Type

Monitoring Program


Authority

Monitoring Type


Authority Type

Authority


Task Type

Authority Type


Priority Ranking

Task Type


Person Name(s)

Priority Ranking


Company Code(s)

Person Name(s)


Task Code(s)

Company Code(s)

Inquiry Date


Task Code(s)

Early Warning Days



Facility ID*



30174-eia_land_access

FACILITY_ID

CONTACT_1

PHONE_NUMBER

EMAIL_ADDRESS

CONTACT_2

PHONE_NUMBER_2

EMAIL_ADDRESS_2

SCHEDULED_TASK_CODE

SYS_LOC_CODE

START_DATE

LAND_ACCESS_DAYS

STATUS

STATUS_DATE

APPROVED_START_DATE

APPROVED_END_DATE

TASK_ACTION

ORG_SCHED_TASK_CODE

ORG_SCHED_TASK_START_DATE

CONTACT_REMARK

TITLE

ALT_PHONE_NUMBER

ADDRESS1

ADDRESS2

CITY

STATE

POSTAL_CODE

REMARK

TITLE_2

ALT_PHONE_NUMBER_2

ADDRESS1_2

ADDRESS2_2

CITY_2

STATE_2

POSTAL_CODE_2

PLANNED_TASK_CODE

SAMPLE_PLAN_CODE

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 support@earthsoft.com for more information.