The Workforce Separation by Length of Work (Organization Hierarchy) Status Analytics workbook compares employees' length of service across various groups such as organization, geographical area and separation category.

Business Questions

To what extent does employee length of service vary across different groups in my enterprise?

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

• By Separation Category & Reason

The worksheets display one row for each group. For example, the by Organization worksheet displays one row for each organization. The by Separation Category & Reason worksheet displays one row for each Separation Reason within each Separation Category.

Headings and Calculations

The matrix reports contain the following columns:

• A grouping column

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

  If you select the by Separation Category & Reason worksheet, two columns appear in the matrix - one for Separation Category and one for Separation Reason. Each row represents a Separation Reason within each Separation Category.

• Length of work band columns (one column per defined length of work band)

  The number of people who have separated from the workforce during the selected time period whose length of service matches the length of work band.

• Total

  The total number of separations during the selected time period for each group.