How to pull information from a referenced table into RITM

[Brent Cox]

I have a catalog item that has a reference variable to sys_user table. So within the RITM, it provides the user name. However, we have an API call needed that needs the unique User ID instead of the user name. Managers submitting these tickets don't know this, so it is not as easy as just adding the varable to ask the user ID. My question is whether it is possible to somehow call on the user_name field on the sys_user table for whatever the user is on variable employee_user_firstname that we have in the catalog item and have that user ID populated on the RITM? 

[Swapna Abburi]

Hi @Brent Cox 

You can create another string type of variable and auto populate with user ID using the existing user reference variable.