What is the purpose of the Status field on sys_user_has_role?

[Robert C]

We have been doing some role cleanup review and noticed that some of the entries on sys_user_has_role were in the state of "Pending Approval". I have been looking through documentation but don't see anything that discusses the purpose of this status for roles? Could anyone point me to to a doc that would clarify the intent of this status for roles? Is there an approval somewhere that needs to be processed? I checked for a rule or script, but didn't see anything that would perform such an action.

[Miguel Donayre · Accepted solution]

There is an assignment rule for that role OOTB - https://docs.servicenow.com/bundle/rome-employee-service-management/page/product/workplace-safety-mg...

You might not have the job running switch is probably the reason they are in the "pending approval" state.

[Robert C]

Thank you Miguel.

[Community Alums]

Hi Robert S,

This means there are few users for whom a requested role has not been processed.

This would be better handled by using a standard service request with a req_item for each role being requested. Manage the approval process there with workflow and script the creation of the sys_user_has_role record following successful approval. This is because you should see it that once that sys_user_has_role record is created, that the user has that role, don't think of that record as being applied conditionally; a user either has the role or doesn't, eg. has the record or doesn't.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep