Transaction Approvals and Person Number

Content

Hi,

I have created logical SQL to return 'Rejected' Document Records from the following subject areas:

• Human Capital Management - Approval Notification Archive Real Time
• Human Capital Management - Transaction Administration Real Time

The Transaction Administration subject area contains the Employees 'Submitted by User Name'; however, the Employees Person Number is not contained in either subject area (well not that I can see).  What would be the best way to pull in the Person Number since the subject area 'Workforce Management - Documents of Record Real Time' does not contain any information on Rejected documents?

Regards,

Karen Waddell

Version