Hi,
I am tasked to create a report and in that I will need to get "Assigned to" person's last work day which is only visible on HR Profile. However this cannot be dotwalked. Can you please advise how I can do this? Thanks!
Screenshot show sys_user table and I need this to link to sn_hr_core_profile.
Hello,
What table is the HR integration source field referring to? is it the sn_hr_core_profile table then you can just click on it and a below icon will appear which you can us to get the end date
However if there is no field which is common between alm_asset and sn_hr_core_profile then you will have to create a custom field either on alm_asset table or sys_user table to be able to dot walk to the last date.
Please mark my answer as correct based on Impact.
Thanks for the reply.
The HR integration source does not link to the HR profile.
I have tried creating a custom field and managed to add HR profile as reference
However, the Last workday is still not showing.
Can I please get advise on how to link this to sys_user?
