This workbook enables you to report on employee anniversaries and birthdays by organization and supervisor hierarchy.
This workbook has the following worksheets
Organization Hierarchy
Supervisor Hierarchy
The worksheets use the following calculations:
Current Service Decimal
Calculates the employee's length of service in their latest assignment as a number of years.
Total Service Decimal
Calculates the employee's length of service since their first assignment as a number of years.
The Organization Hierarchy worksheet allows you to report on employee anniversaries (total service) and birth date (in the format DD-MON).
Employees are listed by organization. Total and current service calculations are in respect of the system date. The workbook uses the current version of the organization hierarchy.
When is the anniversary date of employment of my employees in a given organization hierarchy?
When are my employees' birthdays?
You must specify values for the following parameters:
Organization Hierarchy
Top Organization
The Supervisor Hierarchy worksheet allows you to report on employee anniversaries (total service) and birth date (in the format DD-MON).
Employees are listed by supervisor. Total and current service calculations are in respect of the system date. The workbook uses the current version of the supervisor hierarchy.
When is the anniversary date of employment of my employees in a given supervisor hierarchy?
When are my employees' birthdays?
You must specify values for the following parameters:
Supervisor