SQL Query to get Absence Entry Details which makes the plan balance negative — 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

SQL Query to get Absence Entry Details which makes the plan balance negative

edited May 6, 2020 10:35PM in Workforce Management 5 comments

Summary

SQL Query to get Absence Entry Details which makes the plan balance negative

Content

Hi Experts, Wondering if any of you have a SQL query handy which gives details of an absence entry which makes the balance go into negative. Say for example an employee has 10 days of balance on a given day. He books one absence for 8 days and second for 4 days. Now the second absence of 4 days is taking the balance to negative. is it possible to get the details of the second absence along with the amount value by which the balance has gone into negative. For this example the amount value is 2. Any help/pointer is

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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