As we moved from a software product catering solely for fine-dining towards a product also catering for fast food outlets, additional sub modules were required. Labor, Time and Attendance features became a necessity. In order to cater for as many clients as possible, features such as holiday pay, four types of overtime triggers and multiple breaks within multiple clock-in sessions were desired. The module was pretty complex since in addition, variable payroll day hours, different payroll periods and multiple jobs per employee were also catered for.

The solution was developed via a number of stored procedures headed by a few top level routines. This although perhaps not the easiest choice of language allowed the same routines to be used from both the VB6 maintenance screens and the labor related crystal reports.