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

 

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *