Adding Hiring Manager worker number to ORC Reporting
Content
Is there a way to show the requisition Hiring Manager's (from Recruiting - Recruiting Real Time subject area, Job Requisition - Hiring Team) worker person number (from Workforce Management - Worker Assignment Real Time subject area) in an OTBI analysis? I've tried adding the Person Number and Person Name but it pulls up multiple numbers as well as multiple person names.
I've attached an image of the results as well as the SQL and XML examples.
Version
19D0