Position Tenure
The number of calendar days that have elapsed that an employee has remained in a specific role.
Calculation:
ACTIVE EMPLOYEE: DATEDIFF([ATS.Candidate.Today_Date] – [ATS.Candidate.Start_Date] IF([ATS.Requisition.Requisition_ID]=[ATS.Requisition.Requisition_ID]))
TERMINATED EMPLOYEE: DATEDIFF([ATS.Candidate.Start_Date] – [ATS.Candidate.Termination_Date] IF([ATS.Requisition.Requisition_ID]=[ATS.Requisition.Requisition_ID]))
Leave a Reply
Want to join the discussion?Feel free to contribute!