Employment Periods

An Employment Period is defined as time between hire/rehire and termination. Effective-dated employment records are organized between those dates. Employment Periods group an employee's employment records together based on the date(s), enable Original Hire Date and Termination Dates to be revised, and define when historical employment records can be inserted.

Changes to effective-dated fields are recorded in a database table called Employee Employment Records; this allows for the insertion of information anywhere within an employee's timeline. Employment Periods are also stored within these tables. Employment Periods improve the ability to revise the three effective-dated date fields (Original Hire Date, Rehire Date and Termination Date).

When employees first join the organization an initial Employment Period will be created with a period start date based on their Original Hire Date, and any effective-dated changes will be part of that Employment Period. If the employee is terminated, their termination date becomes the period end date of that Employment Period. If they are rehired in the future, this will create a new Employment Period with a period start date based on their Rehire date. Based on this functionality, every active employee has a single active Employment Period with a period start date (which will be the Original Hire Date or, if rehired, their Rehire Date).

When an employee is hired, terminated, or rehired in Deltek Talent Management, or when existing values for these dates are edited, Deltek Talent Management performs the appropriate updates related to Employment Periods. The above rules for validating the original hire, rehire, and termination dates are enforced to ensure data integrity.

When a user can set or edit an employee's Original Hire Date, Rehire Date, and Termination date is based on the following rules:

Field	Description
Original Hire Date	This date can be set when an employee has no Employment Periods, meaning they are a new hire. The Original Hire Date can be edited when the Active Employment Period is the employee's first Employment Period, which means the employee has never been terminated and re-hired.
Rehire Date	The Rehire Date can be set when: When the employee has no Active Employment Periods, which indicates the employee is currently in a terminated state. (for example, they have one or more periods but all with a period end date, which indicates the employee is currently terminated.) When the employee has no Active Employment Periods, which indicates the employee is currently in a terminated state. (for example, they have one or more periods but all with a period end date, which indicates the employee is currently terminated.)
	The Rehire Date can be edited when: Only the Active Period is enabled for editing, which indicates the employee is not in a terminated state. The Active Period is not the first period, which indicates the employee has been rehired. The current Rehire Date occurs after the Period End Date.
Termination Date	The Termination Date can be set when: The employee has an Active Period, which indicates the employee is not currently in a terminated state. The Termination Date being added occurs after the Active Period Start Date.
	The Termination Date can be edited when: The employee has no Active Period set, which indicates the employee is currently in a terminated state. One or more periods with a Period End Date, which indicates the employee has at some point been terminated. An employee is in an active state where edits are allowed for only the most recent Employment Period. The current Termination Date occurs after the Period Start Date.
	Un-terminate Button: An Un-terminate button is also available if an employee was terminated in error and the termination needs to be removed (this removes the termination to continue the Employment Period; as such it should not be used for Rehires).

When performing Database migrations and Integrations, it is helpful to understand the following information about how Employment Periods work in Deltek Talent Management:

Field

Description

Database Migrations and Integrations

Database Migrations: The following database schema changes support Employment Periods: A hua_employee_employment_period table in the database. An Employment Period ID column can be found in the hua_employee_employment_record table. Employment Period rows are created for current and active employees. Existing employment rows are associated to the new Employment Period entries. Integrations: When an employee is hired, terminated, or rehired via integrations, or when existing values for these dates are edited, Deltek Talent Management performs the appropriate updates related to Employment Periods. The rules for validating the original hire, rehire, and termination dates are enforced to ensure data integrity. These updates are made for all users, whether Core HR is enabled or disabled. The current Rehire Date occurs after the Period End Date.

The User Status icon on an employee’s Total Talent Profile will be based on the Employment Period information:

Field

Description

User Status

The User Status icon on an employee’s Total Talent Profile will be based on the Employment Period information: Active (Green): If an employee is Active, their current Employment Period has a Period Start Date occurring before today's date, and no Period End Date or their Period End Date is in the future. Inactive (Grey): If an employee is Inactive, their current/last Employment Period has a Period Start Date and Period End Date in the past (terminated employee) OR it has an Employment Period with a future Period Start Date (future starting new hire).