Deriving Dates for Requisition/Candidate in TCC

Summary

How to derive the dates in TCC that are not available as a direct projection

Content

Hi,

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.

1. Requisition Latest Fully Approved Date
2. Time From Req. Fully Approved date to Offer Accepted (per candidate)
3. Time On Hold Since First Approval
4. # Openings Left To Fill (Based on offer Accepted) - Meaning an accepted offer is considered as Hired.