Manitoba Teacher Monthly Report

The Manitoba Teacher Monthly Report creates a report and extract file of all employees within a payroll, producing the information required by MTS for Teacher reporting. This process creates a comma delimited CSV file which is sent to MTS with the details of the extracted information. The CSV file is generated in the work directory of the payroll, pointed to by the logical SRB$OPSWRK. The CSV file can be opened directly in Excel or emailed from the Email process on the main menu.

The reporting information will be pulled from the employees' Master Function Line where required.

The CSV file content contains the following fields as defined by MTS:

FIELD Name	Explanation	WHERE DATA is COMING From
First Name		Interlink File
Middle Name		Interlink File
Last Name		Interlink File
Address	Street, city, postal code, etc.	Employee Group File
e-mail		OPS/atrieveHR Email Address File
Phone Number		Employee Group File
Birth Date		Employee Group File
Gender	As identified by your member	Employee Group File
Certificate Number		From atrieveHR
School		Location from Master File
Role		Occupation from Master Function Line, description from Database
Classification	Where on salary scale	Class/Education level from Grid positions 3 & 4 from Master Function Line
Employment Status	Permanent of Limited	User Defined, from Master Function Line or atrieveHR Assignment. Could also be untracked.
Gross Salary	For the month being reported	From YTD History File
Full Time Equivalent		From Function Lines
Membership Dues		From YTD History File
Long Term Disability Premiums		From YTD History File
Short Term Disability Premiums		From YTD History File
Leave Type	Parental, disability, secondment, etc.	On Leave, On Leave/Bens, Terminated, Blank if Active
Unique Identifier	Common to all files if multiple files sent	Employee Number

This process includes the option to maintain multiple sets of stored prompts.

Name the prompt sets by defining a title up to 10 characters, with a 30-character description.

On the first prompt click the Report Defaults icon to select an existing set of prompt values.

Enter Starting Period

Enter the starting period for a range of history periods to be included on the report.

Enter Ending Period

Enter the ending period for a range of history periods to be included on the report.

Enter UNION DUES Deduction Codes

Enter one or up to 25 Union Dues deductions to be reported.

Enter LTD Deduction Codes

Enter one or up to 25 LTD deduction codes to be reported.

Select the Clear icon to clear the selected deduction codes.

Enter STD Deduction Codes

Enter one or up to 25 STD deduction codes to be reported.

Select the Clear icon to clear the selected deduction codes

Enter Pay Code Include / Exclude

Enter 'E' to indicate the following list of pay codes will be excluded from the salary calculation.
Enter 'I' to indicate the following list of pay codes will be included in the salary calculation

Enter Pay Codes

Enter the list of Pay Codes one at a time to be included or excluded from the salary calculation.

Select Employment Status DEFINITION

Select the method with which you track the Permanent and Limited status of the employees in your system. If this is not tracked at all, then all employees are reported as Permanent.

Enter 'O' to indicate the Employee Status is to be defined by the Occupation Code
Enter 'C' to indicate the Employee Status is to be defined by the Cycle Code
Enter 'E' to indicate the Employee Status is to be defined by the Employee Type Code
Enter 'P' to indicate the Employee Status is to be defined by the atrieveHR Assignment Type
Enter 'N' to indicate that the Employee Status is Not being tracked – all employees will be reported as Permanent

Enter Codes to Define Limited Status

Enter the codes one at a time up to a maximum of 30 characters that define the Limited Status for Employees.

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
Employee's Role - OCC Code from Function Line, Description from Database
Employee's Certificate Number – from atrieveHR
Employee's School (Location) Location Code from Master File, description from Database
Employee's Classification – class/education level from the salary grid positions 3 & 4
Employee's Employment Status – Permanent or Limited – user defined, from Function Line values or atrieveHR Assignment Type
Employee's FTE - from Function Line
Employee's Gross Salary – for the Month being reported – from YTD History
Employee's Membership Dues – from YTD History
Employee's LTD Premiums -from YTD History
Employee's STD Premiums -from YTD History
Employee's Leave Type – On Leave, On Leave with Benefits, Terminated. Blank if Active.
Standard totalling (report only)