How to copy the hr profile data on to user table both are in different application scopes

kkswamy
Tera Expert

Hi,

Is there anyway we can copy the "employee end date" field value from HR profile table on to custom field on User[sys_user] table.

Business rules written in one application scope will work in another application scope, if i want to query the HR profile table?

Any help much appreciated.

9 REPLIES 9

kkswamy
Tera Expert

@Pradeep Sharma @Chuck Tomasi could you please check this and let me know, is it possible between different application scopes?

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

There is OOB business rule which calls script include to sync User and HR Profile fields

You can refer that and enhance the Script Include to sync Employee End Date with Custom Field on User

BR On HR Profile Table

Name: Synchronize fields to sys_user

It calls script include "hr_Utils" and function "syncProfileFields"

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Ankur Bawiskar  Thanks for the response,

is this the place i should modify the script in the script include? and FYI.. we have an integration with Workday to bring all the employee information and feed to both HR profile and User table. So, are there any other places i should make the changes other than this script include?

find_real_file.png

Susan Britt
Mega Sage
Mega Sage

Once you upgrade to Paris, there is a new plugin "Employee Profile" that will make the employment start and end dates available.