This workbook enables you to report on current employee tenure details based on the employee primary assignment in a non-legislative specific format.

In addition to the basic employee primary assignment details, you can report on:

• Most recent hire date

• Original date of hire

• Total years of service

• Recent years of service

Worksheets

This workbook has the following worksheets:

• Organization Hierarchy

• Supervisor Hierarchy

Organization Hierarchy Worksheet

This worksheet enables you to report on employee tenure details (based on the employee primary assignment in a non-legislative specific format) for a given organization and its subordinate organizations.

Business Questions

How long have my employees within a given organization hierarchy been working within my enterprise?

Parameters

You must specify values for the following parameters:

• Organization Hierarchy

• Top Organization

• Employment Category

The worksheet includes those employees currently employed within the selected organization hierarchy, and within the selected employment category.

Headings and Calculations

This report uses the following calculations:

• Recent Years Service

  Calculates the employee's length of service since their most recent hire date as a number of years.

• Total Years Service

  Calculates the employee's length of service since their first hire date as a number of years.

Supervisor Hierarchy Worksheet

This worksheet enables you to report on employee tenure details (based on the employee primary assignment in a non-legislative specific format) for a given supervisor and his/her subordinates.

Business Questions

How long have employees, reporting directly or indirectly to a given supervisor, been working within my enterprise?

Parameters

You must specify values for the following parameters:

• Supervisor

• Employment Category

The worksheet includes those employees currently employed by the selected supervisor, and within the selected employment category.

Headings and Calculations

This report uses the following calculations:

• Recent Years Service

  Calculates the employee's length of service since their most recent hire date as a number of years.

• Total Years Service

  Calculates the employee's length of service since their first hire date as a number of years.