This workbook enables you to track applicants, monitor workers' assignment history, and analyze termination history.

For a person's assignment history, you can analyze the following:

• Workforce movement within the organization

• Time between recruitment stages

• Trends via termination reasons

Worksheets

This workbook has the following worksheets:

• Person Assignment

• Application

• Employee Separation

Person Assignment Worksheet

This worksheet enables you to analyze a person's assignment history between specific dates. For each person you can examine:

• The current assignment

• Details of previous assignments

Business Questions

What has an employee been assigned to?

Parameters

You need to specify values for the following parameters:

• Start Date

• End Date

Application Worksheet

This worksheet enables you to analyze an applicant's assignment record between the start and end of an application.

For each employee you can examine the following:

• Total number of applications

• Number of successful applications

• Length of time between different application stages

Business Questions

Has a person previously made an application?

Parameters

You need to specify values for the following parameters:

• Start Date

• End Date

Employee Separation Worksheet

This worksheet enables you track termination reasons by type, date, and length of service, allowing you to spot trends among leavers. For each termination, you can:

• Compare termination reasons to discover trends.

• Compare the length of time in an organization against time in a job.

Business Questions

Why are employees leaving the enterprise?

Parameters

This worksheet has no parameters.