Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcm
Hello Team,
I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. Can you help me to go further on this.
For ex: If an employee Hire/Rehire date is:
12345 5-10 years = L1
67890 11-20 years = L2
09876 21+ years = L3
Thanks,
Janardhana
Tagged:
0