Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcm — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcm

edited Feb 28, 2025 9:02AM in Reporting and Analytics for HCM 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!