The Certified Employee Seniority Report (7103) was written for Browning School District. This report displays employee's name, number, degree, endorsements and continuous years of service.
Reporting data is derived as follows:
The degree comes from the employee's most recent assigned salary grid description.
The endorsements are the majors and minors taken from certificates of the type 'EDUC'.
Seniority is accumulated by reading through all assignments that end on or before the 'As Of Date' and that start on or after the employee's current hire date.
For each assignment the Number Of Days field is referenced and if it is 95 or greater, one year of seniority is credited.
The report is sorted by employee or seniority and degree. Also included is a merge option to export data to a file.
As Of Date
-
Enter a valid date in (YY)YYMMDD format. Assignments are excluded from the seniority calculation if they end after this date.
Seniority Years
-
This prompt lets you select employees based on seniority. Only employees with seniority within this range of years will be considered for reporting.
Employee Categories
-
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.
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.
Report/Merge
-
Enter R to prepare a report of selected employees/assignments.
-
Enter M to prepare a data file with report fields. This file can be used by other applications.
-
If you answer 'M', the following prompt must be answered.
Merge Profile
-
Enter a valid merge profile (data field separator for the report data file).
Report Sort
-
Enter 'E' to sort this report by employee.
-
Enter 'S' to sort this report by seniority.
Employee Sort
-
Enter A to sort employees alphabetically by Name.
-
Enter N to sort employees numerically by Employee Number.
Employee Selection
-
Enter A to consider all employees for selection.
-
Enter S to enter selected employees individually.
Report Title
-
Enter appropriate title for the report.