0 Replies Latest reply on Sep 19, 2013 6:54 PM by PaulSmith

    T&L rule SQL: Create multiple IPT1 days from one row


      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?