The Support Staff Seniority Report (1234) calculates and lists selected support employees' seniority by reading through employee assignments that are current as of a specified date. If an employee has a continuous assignment from January to December and if the school year is for 10 months, then the seniority for such an assignment is calculated to be 12 months. In all cases, the system calculates the number of full months first (usually not including summer months - June & July) and then adds on the time for the part months at the beginning and end of the assignment.
For example, if an employee has an assignment from September 6th 1999 to December 9th 1999, the system would accumulate 2 months for the full months of October and November. The system would then calculate the number of days from September 6th to September 30th and add that to the number of days from December 1st to December 9th. From September 6th to September 30th there are 19 working days. This number is divided by the total number of working days for the month which is in this case 21. So, the employee is credited 19/21 (.905) of a month for September. From December 1st to December 9th there are 7 working days. Again, this number is divided by the total number of working days in the month which is 13. So, the time credited for December is 7/13 (.538) of a month. The total time is broken down as follows:
|
September 6th – September 30th |
19/21 |
0.905 |
|
October |
|
1.000 |
|
November |
|
1.000 |
|
December 1st – December 9th |
7/13 |
0.538 |
|
|
|
3.443 |
The portion of months (0.443) is then multiplied by 20 to get the number of days (20 * 0.48.86 days). So, depending on the format you select for the report, the seniority for the assignment Sept 6, 1999 to Dec 9, 1999 would be 0 years 3 months and 8.86 days OR 0.3443 years. The FTE of the assignment is also usually included in this calculation and would be multiplied by the time. If the above assignment had been 0.60 FTE then the resulting seniority would have been 2.066 months (3.443 * 0.60).
This report can also include seniority from the employee's user defined demographics screen and add it to the seniority from the assignments. You can choose to import the years, months and days from fields 13,14 and 15 or just the years from field 3.
This report will only include assignments that have an assignment type code defined in User Specific Parameter Profile or assignments with seniority code or '1' or '2'.
This report also utilizes the Experience Year Database to properly handle assignments that start or end during the summer. If this database is filled in, then assignments that start during the summer will have their start dates shifted to the school year start date. Assignments that end during the summer will have their end dates shifted to the school year end date. This database can apply to all schools
or all schools of a particular type.
Date Range To Accumulate
-
Enter valid FROM and TO dates in (YY)YYMMDD format. The system will accumulate time from assignments within and including this date range.
Months Of Seniority
-
Enter the range for months of seniority to select employees. This range will select employees based on the number of months of seniority they have. Entering a range of 13 - 24 would select employees that have between 13 and 24 months of seniority.
Assignment Info As Of Date
-
Enter a valid ASOF date in (YY)YYMMDD format. It will be used to consider assignments that are current as of this date.
Employee Status Codes To Exclude
-
Enter up to 10 employee Status codes. Employees with matching status codes will be excluded from the report. If no status codes are entered, all employees will be considered for reporting.
Employee Category
-
Enter up to 10 Employee Categories. Employees with matching Category codes will be considered for reporting. If no categories are entered, all employees 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.
Report Format
-
Enter '1' to prepare the report in Seniority List format.
-
Enter '2' to prepare the report in Bumping List format.
Assignment Code List Source
-
Enter 'P' to consider only those assignments where the assignment type code matches with one of the codes found in the HR User Specific Parameters Profile in the ASGN Type Codes To Include On Exper Report field.
-
Enter '1' to consider only those assignments where the assignment type code is marked with a '1' in either Seniority Code fields.
-
Enter '2' to consider only those assignments where the assignment type code is marked with a '2' in either Seniority Code fields.
REPORT SORT [E/S/L]
-
Enter 'E' to sort this report by employee.
-
Enter 'S' to sort by seniority (most to least)
-
Enter 'L' to sort by location then seniority (most to least)
EMPLOYEE SORT [A/N]
-
Enter A to sort employees alphabetically by Name.
-
Enter N to sort employees numerically by Employee Number.
EMPLOYEE SELECTION [A/S]
-
Enter A to consider all employees for selection.
-
Enter S to enter selected employees individually.
DETAIL/SUMMARY [D/S]
-
Enter 'D' to display seniority details (with listing of each assignment and its associated seniority)
-
Enter 'S' to display a seniority summary (will display the current years and total seniority for each employee).
REPORT TITLE
-
Enter appropriate title for the report.
THE MODULE WILL ASK THE UPDATE QUESTIONS REGARDLESS OF THE REPORT FORMAT CHOSEN.
UPDATE USER DEFINED FIELD
-
Enter 'Y' if you want to update a user-defined demographics field with the seniority amount.
USER DEFINED FIELD NUMBER
-
Enter a valid field number for one of the user-defined fields that you want to update with the seniority.
-
A sample page of the report is shown below: