The Workforce Loss (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating workforce losses that occurred within yearly periods and within different organizations, the other providing a detailed analysis of losses in the workforce.
These worksheets help you to create reports to analyze how your workforce is decreasing. 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 inactive.
The workbook shows losses caused by transfers out depending on the portion of the organization hierarchy you are viewing.
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
This template workbook has the following worksheets:
By Year and Organization
Detail
The by Year and Organization worksheet analyses when and where workforce losses occur. It compares workforce losses over time and across organizations.
It displays one row for each organization within each year.
The worksheet contains the following columns:
Year
Year Start Date
Year End Date
Organization
The name of each organization in which losses have occurred within each year.
Total Losses
The total of all workforce losses due to separations, transfers out, secondary assignment ends, and long term absences.
Separations
The total workforce losses attributable to separations from the organization.
Transfers
The total workforce losses attributable to transfers out of the organization.
Secondary Assignment Ends
The total workforce losses attributable to the ending of secondary assignments.
Long Term Absences
The total workforce losses attributable to long term absences from the organization.
The Detail worksheet tells you how losses occurred and where losses occurred within the workforce.
The worksheet displays one row for all loss events occurring on a specific date within the worksheet parameter start and end dates, within each organization, location, job, grade, and position.
The worksheet contains the following columns:
Event Date
The date the loss took place.
Organization
The organization that had the loss.
Location
The location where the loss took place.
Job
The job of the loss.
Grade
The grade of the loss.
Position
The position of the loss.
Total Losses
The total of all workforce losses occurring on the event date within the same organization, location, job, grade and position.
Separations
The total workforce losses attributable to separations from the organization.
Transfers
The total workforce losses attributable to transfers out of the organization.
Secondary Assignment Ends
The total workforce losses attributable to the ending of secondary assignments.
Long Term Absences
The total workforce losses attributable to long term absences from the organization.