Query to Retrieve 'Assigned To' Manager's Personal Data in Transaction Console

Summary:

I'm trying to fetch personal data (e.g., PERSON_NUMBER, EMAIL_ADDRESS) for the "Assigned To" field in the Transaction Console. However, the only relationship I found between the task and the user is through the USERNAME. My concern is that when the USERNAME is updated for an employee, the workflow screen does not reflect the change, which creates an issue in maintaining consistency.

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

SELECT PAPF.PERSON_ID,
PAPF.PERSON_NUMBER
AS ASSIGNEE_NUMBER,
WFT.ASSIGNEESDISPLAYNAME
ASSIGNEE_NAME,
EM.EMAIL_ADDRESS
AS EMAIL_ADDRESS,
ASSIGN_PG.NAME