This workbook enables you to report on employees who are on a leave of absence on a particular effective date. The workbook shows the following employee primary assignment details:

• Employee number

• Organization

• Supervisor

• Location

• Hire date

• Absence details, including date start and date end

Worksheets

This workbook has the following worksheets:

• Organization Hierarchy

• Supervisor Hierarchy

Organization Hierarchy Worksheet

This worksheet enables you to report on employees who are on leave on the effective date chosen. Employees are listed for a given organization and its subordinate organizations. The additional parameter, Absence Types to Exclude, enables you to exclude absence types that are not of interest, for example, Unpaid Leave.

Business Questions

When are my employees in an organization hierarchy on leave?

Parameters

You must specify values for the following parameters:

• Organization Hierarchy

• Top Organization

• Effective Date

Supervisor Hierarchy Worksheet

This worksheet enables you to report on employees who are on leave on the effective date chosen. Employees are listed for a given supervisor and his/her subordinates. The additional parameter, Absence Types to Exclude, enables you to exclude absence types that are not of interest, for example, Unpaid Leave.

Business Questions

When are employees, reporting directly or indirectly to a specific supervisor, on leave?

Parameters

You must specify values for the following parameters:

• Supervisor

• Effective Date