The Workforce Gain (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating workforce gains that occur within yearly periods and within different organizations, the other providing a detailed analysis of gains in the workforce.
These worksheets help you to create reports to analyze how your workforce is growing. The workbook identifies a gain when an employee is inactive one day and active the next. It attributes the gain to the first date on which the employee is active.
The workbook shows gains caused by transfers in 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 how workforce gains have occurred, and compares the gains 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 gains have occurred within each year.
Total Gains
The total of all workforce gains due to new starts, transfers in, secondary assignment starts, and long term absence returns.
New Starts
The total workforce gains attributable to new starters with the organization.
Transfers
The total workforce gains attributable to transfers into the organization.
Secondary Assignment Starts
The total workforce gains attributable to the start of new secondary assignments.
Long Term Absence Returns
The total workforce gains attributable to returns from long term absences.
The Detail worksheet tells you how the gains occurred and how the gains have been deployed within the workforce.
The worksheet displays one row for all gain 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 gain took place.
Total Gains
The total of all workforce gains occurring on the event date within the same organization, location, job, grade and position.
New Starts
The total workforce gains attributable to new starters with the organization.
Transfers
The total workforce gains attributable to transfers into the organization.
Secondary Assignment Starts
The total workforce gains attributable to the start of new secondary assignments.
Long Term Absence Returns
The total workforce gains attributable to returns from long term absences.
Organization
The organization that had the gain.
Location
The location where the gain took place.
Job
The job of the gain.
Grade
The grade of the gain.
Position
The position of the gain.
Workforce Measurement Value
The total workforce count for each of the above groups (the returned value depends on the workforce measurement value you selected in the worksheet parameters).