The system populates the model file with tables containing the following information, for each employee belonging to the selected population:

oColumn: one column per month, for each month in the selected period.

oLine:

▪Description of the row

▪The monthly totals for the account (or sum of totals for each month of all accounts selected for the row)

▪The row total (sum of totals for each month in the row)

•If the selected period begins during the month then, for the first month, the total is that of the start date selected on the last day of the month.

•If the selected period ends during the month then, for the last month, the total is that of the first day of the month on the date requested.

•For other months, the total is the total for the month.

•If the user has defined cut-offs, then at each cut-off, the system inserts a row with a description of the cut-off.

Back to list of dashboards