MANTE Seniority Report
The MANTE Seniority Report will list the seniority accumulated in each of the configured seniority groups for each employee along with a total. The seniority is accumulated by adding any entered opening balances to the amounts calculated from the assignment system. Any assignments matching the selection criteria will be processed and the number of days worked within each assignment will be added to the total. Specifically, the assignment days are multiplied by the assigned FTE and then divided by the total number of days entered on the assigned position (total hours/fte field 11) which needs to contain the total number of days that position works in a year. The position code database has been expanded so that each position can have a specific calendar attached to it which determines what days employees in that position work. The position code database has also been expanded to include a MANTE group code where you enter what MANTE group code applies to each position.
With this information in place, the report processes each selected assignment in year chunks starting from the start date specified. The number of days in each year chunk is calculated by omitting weekends and any days stored in the position calendar (and optionally the statutory calendar if specified). Once the number of days is calculated, it is (optionally) multiplied by the assigned FTE and then divided by the total number of days in the year (as specified on each position in the total hours/fte field). This amount is then accumulated and placed in the correct column on the report based on the MANTE group code also specified on the position.
The report can be sorted by employee name or number or by seniority (most to least). There is also a merge option which will export the contents of the report to an export file.
As Of Date Range
- Enter a valid range of dates. All assignments within this date range that match the other selection criteria will be processed.
Employee Categories
Assignment Types
Cont/Temp/Both
Include Leaves
Include Opening Balances
- Enter 'Y' to add opening balances from the MANTE Seniority Maintenance screen.
- Enter 'N' to omit the opening balances from the report.
- Enter 'O' to display only opening balances without considering any assignments.
Use Position Calendars
- Enter 'Y' to omit the days that exist in the calendar specified on the position.
Use Statutory Holiday Calendar
- Enter 'Y' to omit the days that exist in the statutory holiday calendar.
Multiply Days By FTE
- Enter 'Y' to multiply the number of days by the assigned FTE.
Show Calculation Detail
- Enter 'Y' to display an additional report showing how it arrived at its calculated seniority amount.
Report Sort
- Enter 'S' to sort the report by seniority (most to least) or 'E' to sort the report by employee.
Report/Merge
Employee Selection
Title
- Enter the title of the report. Enter 'Test' to print an additional report showing how the seniority for each employee was calculated.