Logical SQL join condition for Recruitment and Transaction Console
Hi,
I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber,
RecruiterFullName,DepartmentName,RecruitingType,HiringManagerFullName,PositionName,PositionCode
PositionFTE, AssignmentFTE, FTEVariance details.
"Recruiting - Recruiting Real Time"
"Workforce Management - Position Real Time"
"Workforce Management - Worker Assignment Real Time"
Now, I want to add Approvers field from FA_FUSION_SOAINFRA.WFTASK to this report. Could you please suggest how we can join
Please find the attached data model.