How Can I Retrieve the Primary Recruiter Name From Workday Job Requisition Data?

Question

How can I retrieve the primary recruiter name from Workday job requisition data when the job requisition role assignment doesn't match the organization role assignment?

Environment

Connector: Workday HCM

Answer

To get the primary recruiter name:

1. In the JOB_REQUISITION_ROLE_ASSIGNMENT table, filter for requisition_role_code = 'Primary_Recruiter'.
2. Join the assignment to the corresponding record in the JOB_REQUISITION_ROLE_ASSIGNEE table.
3. Use the assignee record's worker_id value to join to the WORKER table and retrieve the recruiter's name.

For example:

SELECT 
  rlas.*,
  rlaa.*,
  w.*
FROM workday_hcm.job_requisition_role_assignment AS rlas
INNER JOIN workday_hcm.job_requisition_role_assignee AS rlaa
  ON rlas.jobRequisitionId = rlaa.jobRequisitionId
INNER JOIN workday_hcm.worker AS w
  ON rlaa.worker_id = w.worker_id
WHERE rlas.requisition_role_code = 'Primary_Recruiter'
LIMIT 1000;

Don't use role_assignee_id to identify the recruiter. This value represents a position and may not reliably identify the worker assigned to that position over time.