EIA: Upcoming Scheduled Tasks Report

Report Name: EIA: Upcoming Scheduled Tasks (example)

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

Dependencies: licensed SPM module and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

Description: The EIA: Upcoming Scheduled Tasks report can be used to notify users of schedule changes to upcoming tasks. If scheduled as an EIA with a particular Task Type of concern selected, the report will indicate what tasks of that particular task type have been recently scheduled. Scheduling the report as an EIA with "Cancelled?" checked will show which upcoming tasks have been cancelled.

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:

This report is setup as an EQuIS Information Agent (EIA) on a time-based schedule. Instructions on how to setup EIAs is available here. The report will only include changes (scheduling or cancellation) that have occurred since the last time the report is run.

Tables: DT_SPM_SCHEDULED_TASK

Report Parameters *

Plan Code	Parameter to select plan code.
Select Task Type(s)	Parameter to select task type(s).
Cancelled?	Parameter to select cancellation status.

* This report contains the following hidden parameter(s) that could affect the outcome of the report:

•Facility_ID

•Scheduled Tasks

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Report Output
FACILITY_ID PLANNED_TASK_CODE SCHEDULED_TASK_CODE TASK_TYPE START_DATE END_DATE SAMPLE_PLAN_CODE REMARK	PERCENT_COMPLETED COMPLETED_YN FULFILLED_BY SKIP_TASK_YN CUSTOM_FIELD_1 CUSTOM_FIELD_2 CUSTOM_FIELD_3 CUSTOM_FIELD_4	CUSTOM_FIELD_5 EBATCH EUID PRIORITY_RANKING CANCELLED_YN COMPANY_CODE PERSON_NAME

Report Output

FACILITY_ID

PLANNED_TASK_CODE

SCHEDULED_TASK_CODE

TASK_TYPE

START_DATE

END_DATE

SAMPLE_PLAN_CODE

REMARK

PERCENT_COMPLETED

COMPLETED_YN

FULFILLED_BY

SKIP_TASK_YN

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

EBATCH

EUID

PRIORITY_RANKING

CANCELLED_YN

COMPANY_CODE

PERSON_NAME

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