EIA: Land Access Report

Report Name: EIA: Land Access

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 EIA: Land Access report can be used to give advanced notice of Land Access requirements for upcoming scheduled tasks.

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 use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview:

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 setup 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 setup EIAs is available here.

Source Tables DT_PERSON, DT_SPM_ACCESS_REQUIRED, DT_SPM_ACCESS_STATUS, DT_SPM_SCHEDULED_TASK

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(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).
Type(s)	Select one or more sample types.
Inquiry Date	Select the effective date of this inquiry.
Early Warning Days	Input for the number of days of early warning. Default: 5.

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

Report Output

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

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