Absence System - Employee Seniority Report (1204)
The Employee Seniority Report (1204) is written specifically for the Coquitlam School District. It displays employee's name, number, benefits status, hire date and seniority. Coquitlam has two different seniority amounts: accumulated seniority and benefit seniority.
The accumulated seniority amount is the total seniority amount taken from HR's seniority system and displayed in total hours format. The seniority code used by the system to calculate this seniority will be the first one found on the employee's hire record.
The benefit seniority, however, is a slight variation of the regular seniority. It is also taken from HR's seniority system, except that any one year's total can Not exceed 1820 hours. So, except where an employee has had more than 1820 hours in a year, the accumulated and benefit seniority amounts will be the same. The benefit seniority however, is reported in years, months and hours format as opposed to total hours. The seniority code used to calculate this seniority is found in field Vacation Seniority Code on page 2 of the Hr User Specific Parameters Profile.
The benefit seniority is loaded by running the Load Seniority With Adjustments Process and answering 'Y' to the Update Benefit Seniority prompt.
This function allows employee selection based on category, bargaining unit, seniority code, benefit status, school term status and assignment selection based on assigned department, position or location.
The report can be sorted by employee, position, location and seniority. An option to create an export file is also available so that reported data can be imported into another application(s).
As Of Date
Enter a valid AS OF date in (YY)YYMMDD format. Any assignments that are current as of this date will be considered for reporting.
Employee Category
Enter up to 10 Employee Categories. Eligible assignments for employees with matching Category codes will be considered for reporting. If no categories are entered, all assignments will be considered for reporting.
Assigned Department
Enter up to 10 Department Codes. Eligible assignments with matching Department Codes will be considered for reporting. If no department codes are entered, all assignments will be considered for reporting.
Employee Barg Unit
Enter up to 10 bargaining unit codes. Only assignments for employees with matching bargaining units specified will be considered for reporting. If no bargaining units are entered, all assignments will be considered for reporting.
Assigned Location
Enter up to 10 Location Codes. Employees that have eligible assignments at matching locations will be considered for reporting. If no locations are entered, all assignments will be considered for reporting.
Assigned Position
Enter up to 10 Positions. Employees that have eligible assignments with matching Positions will be considered for reporting. If no positions are entered, all assignments will be considered for reporting.
Seniority Code
Enter up to 10 seniority codes. Only employees with matching one of the specified seniority codes are will be considered for reporting. If no seniority codes are entered, all employees will be considered for reporting.
Emps With Benefits
Enter 'Y' to select only employees that have at least one assignment designated as having benefits.
Enter 'N' to select only employees that are not eligible for benefits.
Enter 'B' to select employees regardless of their benefit status.
School Term Emps
Enter 'Y' to select only employees that have the school term field set to 'Y' on at least on assignment.
Enter 'N' to select only employees that do not work according to the school term.
Enter 'B' to select both school term and non-school term employees.
Report/Merge
Enter R to prepare the seniority report.
Enter M to create a merge (export) file containing report fields.
Report Sort
Enter '1' to sort by employee.
Enter '2' to sort by position then employee.
Enter '3' to sort by position then accumulated seniority
Enter '4' to sort by position then benefit seniority
Enter '5' to sort by location then employee.
Enter '6' to sort by location then accumulated seniority.
Enter '7' to sort by location the benefit seniority.
Enter '8' to sort by accumulated seniority.
Enter '9' to sort by benefit seniority.
Employee Sort
Enter A to sort employees alphabetically by Name.
Enter N to sort employees numerically by Employee Number.
Report Format
Enter '1' to display just the accumulated seniority in total hours.
Enter '2' to display just the benefit seniority in years, months and hours format.
Enter '3' to display both the accumulated and benefit seniority amounts.
Employee Selection
Enter A to consider all employees for selection.
Enter S to enter selected employees individually.
Report Title
Enter an appropriate tile for the report.