Deriving Dates for Requisition/Candidate in TCC
SummaryHow to derive the dates in TCC that are not available as a direct projection
I need help in deriving the following columns in TCC. I am assuming this is possible only using a complex projection. I see in TCC columns, there is no direct column projection for the below mentioned items, however they are available in OBI.
- Requisition Latest Fully Approved Date
- Time From Req. Fully Approved date to Offer Accepted (per candidate)
- Time On Hold Since First Approval
- # Openings Left To Fill (Based on offer Accepted) - Meaning an accepted offer is considered as Hired.