The Manitoba Education Days Taught Report creates a report and extract file of all employees within a payroll, producing the information required by Manitoba Education and Training (MET) for Teacher reporting.
The extract file is a fixed length ascii file which you would then send to MET. This file is created at the location pointed to by the logical SRB$OPSWRK. This exact file can be downloaded using the Download option on the main screen. It can also be emailed from the Email process on the main menu.
Employees with Terminated, On Leave or On Leave with Benefits status will not be reported if they do not have any days to report in the selected pay periods.
The Days Taught are calculated the same way that the TRAF Pension Report calculates the Days Paid, so Days Taught reported are the actual teaching days per period times the employee's FTE. The actual teaching days are taken from the Working Days in the applicable payroll calendar or may be overridden based on the Alternate Days setting on the Payroll Calendar or the Manitoba Pension Profile. The Days Taught are as of the settings when this report is run.
MET File Format:
The extract file name is xxxxEXP.ASC where xxxx is the school/division number.
Record Type Description
|
H |
Experience Header Record |
1 record per file |
|
I |
Identifier Record |
1 record per teacher / school |
|
D |
Description Records |
1 record per school |
|
Field |
Type |
Length |
Position |
|---|---|---|---|
|
Record Type Value 'H' (Header) |
Char |
1 |
1 |
|
File Type Value 'F' (Full Days Taught) |
Char |
1 |
2 |
|
Reporting Date (DDMMYYYY) |
Char |
8 |
3-10 |
|
Division Number |
Char |
4 |
11-14 |
|
Academic Year (YYYY) |
Char |
4 |
15-18 |
|
Eis Version |
Char |
5 |
19-23 |
|
Local Division Number |
Char |
10 |
24-33 |
|
Filler |
Char |
167 |
34-200 |
|
|
|||
|
Record Type Value 'I' (Identifier) |
Char |
1 |
1 |
|
School Employed |
Char |
4 |
2-5 |
|
Local School Number |
Char |
10 |
6-15 |
|
PSP Number |
Char |
6 |
16-21 |
|
Surname |
Char |
25 |
22-46 |
|
Given Name(s) |
Char |
25 |
47-71 |
|
Filler |
Char |
129 |
72-200 |
|
|
|
|
|
|
Record Type Value 'D' (Description) |
Char |
1 |
1 |
|
Full Days Taught |
Char |
5 |
2-6 |
|
Adjustment Code |
Char |
2 |
7-8 |
|
Filler |
Char |
192 |
9-200 |
Note: The School Employed Number requirement by MET is not currently available within the district's payrolls. To facilitate the reporting of this information, you can utilize the Alternate Sort Code field found on the Location Code Database. Please ensure field 11=USE Alternate Sort Code is set to 'N'o under the User Specific Parameters Profile to prevent this information from triggering the alternate sorting feature.
Enter the Starting Pay Period
-
Enter the starting period for a range of history periods to be included on the report.
Enter the Ending Pay Period
-
Enter the ending period for a range of history periods to be included on the report.
Enter the ACADEMIC Year for Reporting
-
Enter the year for which this report is being produced.
Enter the Division Number
-
Enter the Division Number of the School
Enter the Adjustment Code
-
Enter 2 for Substitute or 99 for Annual System Increment.
Report by Name or Employee Number
-
Enter 'N' to produce the report in employee name sequence.
-
Enter 'E' to produce the report in employee number sequence.
The report lists the following:
-
Employee's number
-
Employee's Name
-
PSP Number – this is the employee's PSP certificate number from atrieveHR
-
School Employed - this is the School Location as defined by MET
-
Days Taught – Total Days Taught by the employee for the selected pay period range
-
Standard totalling