What is one thing common between HR profile record and user table record

[Drishti]

Hi Community,

Can anyone help me in one thing that what is common between HR profile record and user table record.

The reason I am asking is that I have to update "Title" field in user table whenever "Position" field is being update in HR profile record. 

I had created BR on HR profile table which will run when Position field changes and taken the value of Position field ,now what next?

How should I proceed to update the "Title" field in user table because I am unable to find anything common between these two records from user table and HR profile table.

Please guide, Thanks in advance.

[SatyakiBose]

Hello @Drishti 

If you are referring to the HR profile record table as this one - sn_employee_profile then,

Employee Profile (sn_employee_profile) table has a field called user.

user	Reference to the User (sys_user) table.

You can read about it here: https://docs.servicenow.com/en-US/bundle/utah-employee-service-management/page/product/human-resourc...

You can do a dot walk and update the user record.

[manjusha_]

@Drishti 

User field on hr profile is a reference to user table so you can use it as it gives you sys_id of the record.

Refer below screenshot

Thanks,

Manjusha

[Community Alums]

Hi @Drishti ,

 You have good number of fields which is common:

1. Email

2. Manager

3. First name 

4. Last name

5. Department

6. Location

So on..

[Drishti]

@Community Alums 

I am in search of Primary field, the fields which you have highlighted can have repeated value.