The Workforce Separation (Organization Hierarchy) Template Analytics workbook provides two worksheets looking at separations from your workforce over time, for different reasons, and across different organizations.

These worksheets help you to create reports to analyze the trend of separations from your workplace for different organizations and different separation reasons.

Workbook Parameters

The template includes the following mandatory parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

The template includes the following optional parameters:

• Geography Area

• Geography Country

• Geography Region

• Geography Location

• Job Category

• Job

• Grade

• Position

Worksheets

This template workbook has the following worksheets:

• By Year, Organization and Separation Category

• Details

By Year, Organization and Separation Category Worksheet

The by Year, Organization and Separation Category worksheet investigates separations from the workforce for different organizations and different leaving reasons over yearly periods.

The worksheet displays one row for each year within the start and end dates you selected in the worksheet parameters.

Headings and Calculations

The worksheet contains the following columns:

• Year

• Start Date

  The start date of the year.

• End Date

  The end date of the year.

• Separation Category columns

  One set of columns for each separation category that you have defined. Each set includes a column for each relevant organization, as defined below.

• Organization columns (one column per organization that has had separations for the separation category)

  The number of people in the organization who have separated from the workforce within the specified separation category.

• Total

  The total number of separations within each year.

Details Worksheet

The Details worksheet tells you how separations from your workforce vary across different groups within your organization, such as organization, job, and location. For any date, you can see how many separations have occurred within each organization, location, job, grade, position, separation category, and separation reason.

A Total row displays the workforce separations for the period within the start and end dates selected in the parameters.

Headings and Calculations

The worksheet contains the following columns:

• Event date

  The date on which the separation occurred.

• Workforce Separations

  The number of separations for that date, for the same organization, location, job, grade, position, separation category, and separation reason.

• Organization

  The organization that had the separation.

• Location

  The location from which the separation took place.

• Job

  The job that had the separation.

• Grade

  The grade that had the separation.

• Position

  The position that had the separation.

• Separation Category

  The separation category that had the separation, for example involuntary or voluntary.

• Separation Reason

  The reason for the separation.