The ASOF Program Assignment Report was written for the Nanaimo School District. It can however be used by others if the same assumptions hold true.
This report displays the program(s) and program FTE(s) for each employee selected along with the following fields: employee name and number, assigned position, assignment type, assignment start and end dates and location. The report can be sorted by employee, location then program then employee, OR program then employee. Employees can be selected by assignment ASOF date, employee category, assigned position, assignment type, location type, location, program and employee number. The selected information can also optionally be output to a merge file that can be used by other applications.
This report assumes the following:
-
That the employee's program information is stored in fields employee name and number, assigned position, assignment type, assignment start and end dates and location page 3 of the employee's assignment screen
-
That the corresponding program FTE information is stored in fields of the same screen. In order to enter the FTE amounts in the 'LEVEL' field, you must create a level database entry for every imaginable FTE amount.
As Of Date
-
Enter a valid date in (YY)YYMMDD format. Only employees with assignments that are current as of this date 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.
Assigned Positions
-
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.
Assignment Types
-
Enter up to 10 Assignment Types. Employees that have eligible assignments with matching types will be considered for reporting. If no assignment types are entered, all assignments will be considered for reporting.
Assigned Location Types
-
Enter up to 10 Location Types. Employees that have eligible assignments at locations with matching location types will be considered for reporting. If no location types are entered, all assignments will be considered for reporting.
Assigned Locations
-
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 Cost Centres
-
Enter up to 10 Cost Centres. Employees that have eligible assignments for matching cost centres will be considered for reporting. If no cost centres are entered, all assignments will be considered for reporting.
Assigned Programs
-
Enter up to 10 programs. Employees with matching programs will be considered for reporting. If no programs 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).
Include Comment
-
Enter Y to include assignment comment in the report or data file.
-
Enter N to exclude assignment comment from report or data file.
-
Employee Sort
-
Enter A to sort employees alphabetically by Name.
-
Enter N to sort employees numerically by Employee Number.
Report Sort
-
Enter 'E' to sort the report by Employee then assignment start date.
-
Enter 'L' to sort the report by location, then program, then employee, then assignment start date.
-
Enter 'P' to sort the report by program, then employee, then assignment start date.
-
Enter '1' to sort the report by location, then cost centre, then employee.
-
Enter '2' to sort the report by cost centre, then employee.
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.