The number that populates the 'Total Length of Service' field on an employee record in People Management is not a fixed number, but rather a calculation exists within it.
A Calculation is required to replicate the 'Total Length of Service' figure as seen on an employee record.
Copy and paste this exact calculation into your report to pull the correct length of service for each employee in years:
round((sysdate - PRCI_HR_PERSON_MASTER.ORIGINAL_DATE_JOINED)/365, 2)
'Total Length of Service' not pulling the correct figure on Insight Report
How can we pull the correct 'Total Length of Service' on an Insight report.
J
Written by Joshua Shooter
Updated over a month ago