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]))