Help with getting details from HR profile on catalog item

[Brett Watson]

Kia ora,

I have a record producer and want to populate a variable (hire_date) with employment_start_date from the employee profile of the signed in user when the form loads.

I've tried a few methods but can't quite get it to work and would really appreciate any suggestions 😃

This is what I was hoping would work but didn't:

var profile = new GlideRecord("hr_profile");
profile.addQuery("user",g_form.getValue("opened_for"));
profile.query();
if(profile.next())
g_form.setValue('hire_date',profile.employment_start_date);

Thanks,

Brett

[Alok Das]

Yes, because in HR Profile and Cases we have very sensitive information and even admin can't access to complete details on HR table unless they have the HR role.

Users without an HR role cannot access HR Service Delivery.

There are specific HR roles that allow users access to specific areas of the system. For example, the HR profile reviewer [sn_hr_core.profile_reader] role can read profiles, but not edit them.

Please refer to the below link for more details.

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

However, If employee start date is required for submitting a request and it's mandatory then as a workaround you can create a custom read only field on user table and with the scripting sync it from user's start date from HR profile.

Kindly mark my answer as Correct and Helpful based on the Impact.

Regards,

Alok