The Employee Profile (sn_employee) plugin provides an Employee Profile (sn_employee_profile) table that makes the employment start date and employment end date fields available outside of HR Service Delivery. For example, the table can be used with Strategic Portfolio Management to update the resource capacity of users.

Overview

Use the Employee Profile (sn_employee_profile) table to make the employment_start_date and employment_end_date fields available outside of HR Service Delivery.

Learn more about the Employee profile.

Table 1. Employee Profile (sn_employee_profile) table
Field Description
user Reference to the User (sys_user) table.
employment_start date Represents the employment start date.
employment_end_date Represents the employment end date.

If you are using Employee Profile with HR Service Delivery

When you activate the Employee Profile plugin, the following fields are pulled from the HR Profile (sn_hr_core_profile) table to populate the Employee Profile (sn_employee_profile) table.

Table 2. HR Profile (sn_hr_core_profile) table
Field Description
employment_start_date Represents the employment start date.
employment_end_date Represents the employment end date.

Sync employee profile from HR profile is a one-time scheduled job that will pull all users with their corresponding employment_start_date and employment_end_date values from the HR Profile table upon plugin activation. Subsequent updates will be made by the Synchronize fields to HR profile and Synchronize fields to employee profile business rules.

Note: If you need to run the one-time scheduled job again, make sure to first activate the job and allow for the invalidated RCA before running it. Do not run the job on a scheduled basis.

Activation information

You must activate the Employee Profile (sn_employee) plugin to use the Employee Profile table with your application.

Note: If you are using the table with Strategic Portfolio Management, see Update the resource capacity for more information.