I am creating a custom SQL query to display the ownership / modified by history of a work item. (The JRS tool can not display this full history as shown in RTC). Using the JazzDW database, I am able to return the work item ID, Name, Owner_ID, Modified_ID, and Modified Date/ Time from the jazzdw.RICALM.Request_History table. At this point, I need to match the owner_id and modifier_id numbers with actual names. Does anyone know where the in the JazzDW database this information is stored? (This solution was recommended by IBM support, but the information I am requesting was not given)

SELECT REFERENCE_ID, NAME, OWNER_ID, MODIFIER_ID, REC_DATETIME FROM [jazzDW].[RICALM].[REQUEST_HISTORY] WHERE REFERENCE_ID = 'XXXX' AND NAME = 'TASK NAME'

ORDER BY REC_DATETIME DESC;