I have a rule that awards in-lieu hours when an employee is short for a period. However, this rule awards ALL the hours on the last day of the period, and the client wants it spread out 8 hrs/day.
For example, if an EE is short 25 hours - the existing rule will award that 25 hours on the last day of the period. Client wants 8 hours on last day, 8 hours on 2nd last day, 8 hrs on 3rd last day, 1 hr on 4th last day.
My SQL is great, but I'm drawing a blank on this one. Any suggestions?