The Workforce Loss (Organization Hierarchy) Status Analytics workbook lists the total losses that occurred within a given time period for various groups such as organization, location, gender, and ethnic origin. Each worksheet represents the total losses for one specific grouping. You can also select which area of your enterprise you want to investigate.

The workbook identifies a loss when an employee is active one day and inactive the next. It attributes the loss to the first date on which the employee is not active.

For terminations, the loss occurs one day after the termination separation date (as the termination date coincides with the employees' last day at work).

The workbook includes long-term absences or suspensions only once. If you permanently terminate or transfer an employee who is on long-term absence or suspension, the report does not count the termination or transfer because the employee wasn't active when terminated or transferred.

The report shows losses caused by transfers out depending on the portion of the organization hierarchy you are viewing.

Business Questions

How does the number of losses from my enterprise, broken down into separations, long term absences, transfers and secondary assignment ends, compare for different groupings in my organization?

Workbook Parameters

All worksheets in this workbook have the following mandatory parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

Use the following parameters to further restrict the values in the workbook:

• Geography Area

• Geography Country

• Geography Region

• Geography Location

• Job Category

• Job

• Grade

• Position

Worksheets

This workbook has the following worksheets, each representing a grouping within your organization:

• By Organization

• By Geography Area

• Job

• Grade

• Position

The worksheets display one row for each grouping. For example, the by Position worksheet displays one row per position.

Headings and Calculations

The worksheets contain the following columns:

• A grouping column

  The heading depends on the selected worksheet, for example, in the by Job worksheet, this column is named "Job".

• Separations

  The total number of separations from your organization for each grouping.

• Transfers

  The total number of transfers out of your organization for each grouping.

• Secondary Assignment Ends

  The total number of secondary assignment ends for each grouping.

• Long Term Absences

  The total number of long term absences for each grouping.