MB Teacher Contract Report
Contents
Introduction
This report creates the teacher contract file "Contract.asc".
Selection Criteria
The report only includes teachers at the current school whose Status is set to "Current" and whose Exclude From Provincial Reporting is set to "No".
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Parameter | Description | Choice Details |
|---|---|---|
Include Header Row | Controls the inclusion of a header row in the report, enabling easier data verification. | No (can be imported to EIS) Yes (cannot be imported to EIS, Use for Data Verification) |
Report Output
The report output will contain one data row per teacher, ordered by last and first name. All data values will be quoted except for dates. Depending on the Include Header Row report input parameter; a header row may be output describing each column's data. When the header row is included, the file cannot be uploaded to the EIS program. Do not include the header row if you intend to import the file to the EIS program. The header row can be helpful when validating the report data using a spreadsheet.
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Column | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
1 | PSP Number | Teacher PSP Number | [S_MB_USR_X]TeacherPSPNumber | Num | 6 |
2 | Surname | Teacher last name | [Users]Last_Name | Text | 20 |
3 | Given Name | Teacher Given Name | [Users]First_Name | Text | 20 |
4 | Division Start Date | Division Start Date | [S_MB_USR_X]DivisionStartDate format = DD/MM/YYYY | Date | 10 |
5 | Division Leave Date | Division Leave Date | [S_MB_USR_X]DivisionLeaveDate format = DD/MM/YYYY | Date | 10 |
6 | School Employed | School Employed | [Schools]Alt_School_Number if not 0 otherwise [Users]School_Number | Num | 4 |
7 | Is School | This value is left blank | N/A | Text | 0 |
8 | School Percent | School Percent | [S_MB_SSF_X]SchoolPercent | Text | 3 |