Fetch Proposed Department and location details from transaction tables

Nalsoft Pvt Ltd

I was able to get employee's current department and his location directly from Worker assignment Real Time Subject Area but how do i get his future/proposed transaction details.

I have tried using Workforce Management - Transaction Administration Real Time Subject Area to get the transaction id, but i am unable to join that to the respective employee analysis to get his future details.

Is there any other subject area which holds information to fetch proposed details.