MB TTP Activities Report

Contents

Introduction

This report generates the fixed length xxxxact.asc TTP Activities file for EIS submissions.

Selection Criteria

The report includes all classes for the current school or district whose Exclude From Provincial Reporting is set to "No". Classes with no student enrolment are included.
For the purpose of grouping classes, the course's CIP Code (the first character in the Code column in the Courses table) is used too determine grade levels 9, 10, 11 and 12:
- 1 = Grade 9
- 2 = Grade 10
- 3 = Grade 11
- 4 = Grade 12

If the Code is not defined or contains a character other than one of the characters listed above, the report uses the grade level from the Sections table.

A record is created for each teacher whose Status is set to "Current" associated with the class (as indicated in the SectionTeacher table) for which the % allocation is greater than zero. This includes both the lead teacher and any co-teachers.
Courses for which the "Exclude Course From EIS Reporting" flag is on are excluded from the report. The flag is set on the Edit Course District Information data entry page.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Parameter	Description	Choice Details
Include Term(s):	Terms used to identify the classes to include.	Select the terms to be included in the report. Select one or more terms. Only classes whose scheduling term matching a selected term are included in the report.

Report Output

The report output will contain one header row, followed by one information row per teacher. Each information row will be followed by one or more detail rows per teacher. A .zip file will be generated containing two files, a .xls spreadsheet that can be opened in Excel, and a .asc submission file that is to be sent to EIS.

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.

Position	Column	Description	[Table]FieldName	Field Type	Field Length
Header Row
1	Record Type	The TTP activities header record.	N/A. Will always be 'H'	Text	1
2	File Type	Student Marks file	N/A. Will always be 'A'	Text	1
3	Reporting Date	The current date the report is run on. Format: DDMMYYYY	N/A	Date	8
11	Division Number	The Division Number the report is for.	[Prefs]Value where [Prefs]Name = 'DistrictNumber'	Text	4
15	Academic Year	The academic year the report is for.	N/A. Generated from the Current Year and Term dropdown in PowerSchool.	Text	4
19	EIS Version	The version of EIS that generated this report. Will always be blank for reports generated from PowerSchool.	N/A	Text	5
24	Filler	Blank space.	N/A	Text	177
Information Row
1	Record Type	The TTP activities information record.	N/A. Will always be 'I'	Text	1
2	School Employed	The number assigned to the school by the department, where the employment is being reported	[Schools].Alt_School_number if not 0 Otherwise [Sections]SchoolId	Text	4
6	PSP Number	Teacher PSP Number	[S_MB_USR_X]TeacherPSPNumber	Text	6
12	Surname	Teacher Surname Format: The only acceptable characters are [a-z, A-Z, 0-9, dash, period, comma and single-quote]. All other characters are stripped from the field value. Also only a single whitespace character is acceptable between multiple names. The report will automatically replace any multiple whitespace with a single whitespace.	[Users]Last_Name	Text	25
37	Given Name(s)	Teacher Given Name Format: The only acceptable characters are [a-z, A-Z, 0-9, dash, period, comma and single-quote]. All other characters are stripped from the field value. Also only a single whitespace character is acceptable between multiple names. The report will automatically replace any multiple whitespace with a single whitespace.	[Users]First_Name	Text	25
62	Filler	Blank space.	N/A	Text	139
Detail Row
1	Record Type	The TTP activities detail record.	N/A. Will always be 'D'	Text	1
2	Subject Code	Course number	[Courses]Alt_Course_Number if not blank, else [Courses]Course_Number	Text	4
6	Subject Description	Course name	[Courses]Course_Name	Text	40
46	Subject Level	Class code	[Courses]Code	Text	3
49	Program Track	Program Track	[S_MB_SEC_X]ProgramTrack if not blank, else [S_MB_CRS_Courses_X]ProgramTrack if not blank, else 'EN'	Text	3
52	Number of Classes	If the Subject Level is not 'NA', this is the number of class of this subject that the teacher is teaching: in the same school in the same term for the same grade in the same language on the same school track	N/A. Generated from a count of records in the Sections table. Classes with no students enrolled are not included in the Number of Classes count.	Text	2
54	Male Enrolment	The number of male students taught in the subject.	N/A. Generated from a count of records in the Students table.	Text	3
57	Female Enrolment	The number of female students taught in the subject.	N/A. Generated from a count of records in the Students table.	Text	3
60	Language of Instruction	Language of instruction code	[S_MB_SEC_X]LanguageOfInst if not blank, else [S_MB_CRS_Courses_X]LanguageOfInst if not blank, else '01'	Text	2
62	Semester	Semester code for class term	[Gen]Value where [Gen]SchoolId = [Sections]SchoolId and [Gen]YearId = [Sections]TermId	Text	1
63	Filler	Blank space.	N/A	Text	138

Back to Top