Holiday SQL / Report Micros 4.7

[Wildbar]

Wondering if anyone would be interested in writing a custom SQL / report for our Micros 4.7 Looking for an easy way to calculate some stat holiday pay. We use Premium Pay to define our stat holidays which pay at a rate of 1.5 times the hourly wage I have that working and reporting correctly. What I also need to do is to check if the employees receive the straight time stat holiday pay. To do this we need to check if the day is a premium pay day. If it is (and say it falls on a Monday) to qualify for the straight time stat pay the person must have worked 5 of the last 9 days of the week preceding the holiday (so 5 of the last 9 Mondays) If they qualify they then get the average of the hours worked over the previous 9 days of the week (so the previous 9 Mondays) including zero hours for days not worked. That average number then becomes their straight time hours of stat pay the employee is due. Confusing and time consuming...we do most of it by hand now.