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

[kkswamy]

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.

[kkswamy]

i saw this but question is that, is this information will be available on User[sys_user] table to run a report on the "employee end date" field data?

[Susan Britt]

It will be on a new table, but you will be able to report on the user and these fields.  

https://docs.servicenow.com/bundle/paris-hr-service-delivery/page/product/human-resources/concept/em...

For now, you can modify the OOB scripts like @Ankur Bawiskar mentioned.  If you would rather not modify these, you can create a BR to do so, but you will probably need to create a restricted caller access record to allow the access to the other application scope.

[Ankur Bawiskar]

@kkswamy 

you can either modify that OOB script include and the proper function

Or create your custom BR to sync the fields across those table

Regards
Ankur

[kkswamy]

@sbritt @Ankur Bawiskar  I installed the "Employee Profile" plugin and it pulled the employee start and end date fields information in to sn_employee_profile table but, how to bring the employee end date information in a report running on the Asset[alm_asset] table and how we can dot walk in using "Assigned to" field?

[Susan Britt]

Sorry for the slow response.  I am not aware of an OOB relationship, so you could be a database view to join the tables (Asset > User > Employee Profile)