Aggregating Payroll and Point-of-Sale Actuals

Whenever payroll and point-of-sale data is loaded into the SO_RESULTS_DETAIL table in LFSO, the actuals data must be aggregated to daily values. Labor Budgeting requires this data as daily values to generate plans. This task has the following three parts:

1. The task finds the corresponding volume type associated with each record in the SO_RESULTS_DETAIL table, where it is stored in intervals of 15, 30, or 60 minutes, one day, or one week. By default, the aggregated actuals are AHR and revenue data.
2. The task aggregates all values for a day into a single daily value.
3. The task stores the daily value in the SO_RESULTS_SUMMARY table. This table has 371 columns: one for each day in a 53-week fiscal year.

To aggregate payroll and point-of-sale actuals, you create and schedule the Labor Budgeting - Actuals Summary Aggregation Task. You should schedule this task to run each time that Infor Consulting Services completes loading actuals data.