The Workforce Separation by Competence (Organization Hierarchy) Status Analytics workbook compares employee competencies to separations across organizations and geographical areas. It also enables you to view separations across different competence scales and ranks.

Business Questions

Does the level of employee competence bear any relation to separations from different organizations or geographical areas within my enterprise?

Is my enterprise losing people who have a particular competence at a specific level?

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 Scale Level

• By Rank Level

The by Organization worksheet displays one row for each organization. The by Geography Area worksheet displays one row for each geographical area. The by Scale Level and by Rank Level worksheets display one row for each competence.

By Organization Worksheet and by Geography Area Worksheet Headings and Calculations

The by Organization and by Geography Area worksheets each contain a matrix report with 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".

• Competence columns (one column per defined competence)

  The number of people in each group who have separated from the workforce during the selected time period, and hold the competence.

By Scale Level Worksheet Headings and Calculations

The by Scale Level worksheet enables you to see the number of people who have separated from the workforce who hold competencies at a specific scale level.

The matrix report contains the following columns:

• Competence

  The competencies associated with people who have separated from your workforce in the selected time period.

• Min Required

  The minimum proficiency level required for the competence.

• Max Required

  The maximum proficiency level required for the competence.

• Scale level columns (one column per defined scale level)

  The number of people who have separated from the workforce during the selected time period and have achieved the scale level for the competence.

• Blank

  The number of people who have separated from the workforce during the selected time period, with no associated scale level for the competence.

By Rank Level Worksheet Headings and Calculations

The by Rank Level worksheet enables you to see the number of people who have separated from the workforce who hold competencies at a specific rank level.

The matrix report contains the following columns:

• Competence

  The competencies associated with people who have separated from your workforce in the selected time period.

• Min Required

  The minimum proficiency level required for the competence.

• Max Required

  The maximum proficiency level required for the competence.

• Rank level columns (one column per defined rank level)

  The number of people who have separated from the workforce during the selected time period and have achieved the rank level for the competence.

• Blank

  The number of people who have separated from the workforce during the selected time period, with no associated rank level for the competence.