Report help RITM and User table

[Luiz Lucena]

HI everyone, 

We have a catalog item for new hire creation, which create users in Active Directory. Some of those users being created are contractors, for those we have two types, Contigent Worker and Service Provider. 
Those fields are not stored in the User table (sys_user) neither is passed to Active Directory as an attribute. 
I can report on RITM table (sc_req_item) to see how many contractors were hired in a given period, but that doesn't give an exact number of active contractors (which is something the user table would do).

The challenge is that they want to see a report containing all active contractors and they also want the contractor type, which is not stored in the user table.

I was thinking in a database view for this, but not sure how to achieve that, so checking with my community fellows to see if anyone has a better approach.

Thanks in advance,

[Brian Lancaster · Accepted solution]

I would suggest finding a way to store the data in the user table. Trying to do a view between sc_req_item and the sys_user table might not work since a person could get married which would then change there name. Then there name would not match what was in the original onboarding request. 

Another thought, shouldn't this info be in your HR system. I'm note sure why you want to try and store this in ServiceNow.

[Luiz Lucena]

Hi @Brian Lancaster 

Thanks for the input, indeed, earlier today I said the same to my director, to store the contractor type in the user table as well, but the problem is that this field was created recently and HR is trying to append the contractor type to all of them. 

Our HR system is for FTE only, for now, contractors are being stored in ServiceNow and AD only.