Human Capital Management - Transaction Administration Real Time - Assignee person is missing

Summary:

Hi, I am trying to create analysis to show all pending approval transactions using Human Capital Management - Transaction Administration Real Time, but I am unable to get assignee column (refer to the person responsible for approving or completing the transaction) .

How can I get this column?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

  0 s_0,

  "Human Capital Management - Transaction Administration Real Time"."Issue Details"."Assigned to User Name" s_1,

  "Human Capital Management - Transaction Administration Real Time"."Time"."Date" s_2,