MB Student Enrolment Report

Contents

Introduction

This report generates the fixed length xxxxenr.asc Student Enrolment file for EIS submissions.

Selection Criteria

The report includes students whose current school ([Students]SchoolId) is the currently selected school and whose Exclude From Provincial Reporting flag ([Students]State_ExcludeFromReporting) is false. When run at the district level, the report only includes schools whose Exclude From Provincial Reporting flag ([Schools]State_ExcludeFromReporting) is false.

Report Input

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

Parameter	Description	Choice Details
Enrolled As Of	Determines which students are selected for the report.	Only students enrolled on the specified date are included in the report. Default is September 30th of the current school year.

Report Output

The report output will contain one header row, followed by one information row per student. 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 enrolment header record.	N/A. Will always be 'H'	Text	1
2	File Type	Student Enrolment file	N/A. Will always be 'E'	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 enrolment information record.	N/A. Will always be 'I'	Text	1
2	School Attended	The number assigned to the school by the department, where the enrolment is being reported	[Schools]Alt_School_number if not 0 Otherwise [Students]/[ReEnrollments]SchoolId	Text	4
6	MET Student Number	Student MET Number	[Students]State_StudentNumber	Text	9
15	Surname	Student 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.	[Students]Last_Name [StudentCoreFields]PSCore_Legal_Last_Name	Text	35
50	Given Name(s)	Student 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.	[Students]First_Name [Students]Middle_Name [StudentCoreFields]PSCore_Legal_First_Name [StudentCoreFields]PSCore_Legal_Middle_Name	Text	35
85	Birth Date	Student Birth Date Format: DDMMYYYY	[Students]DoB	Date	8
93	Gender	Student Gender	[Students]Gender	Text	1
94	Enrolment Date	Student Enrolment Date Format: DDMMYYYY	[Students]EntryDate [ReEnrollments]EntyDate	Date	8
102	Previous Surname	Student Previous 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.	[S_MB_STU_X]PreviousSurname	Text	35
137	Postal Code	Student Postal Code	[Students]Zip	Text	6
143	Grade	Student Grade Level Kindergarten is represented as 'K'. All other grade levels are numeric – 1 to 12.	[Students]Grade_Level [ReEnrollments]Grade_Level	Text	2
145	School Student Number	Student School Student Number	[Students]Student_Number	Text	12
157	Resident Division	Student Resident Division	[S_MB_STU_X]ResidentDivision	Text	4
161	Student Program 1	Student Program (1)	[S_MB_STU_X]StudentProgram1	Text	3
164	Student Program 2	Student Program (2)	[S_MB_STU_X]StudentProgram2	Text	3
167	Student Program 3	Student Program (3)	[S_MB_STU_X]StudentProgram3	Text	3
170	Student Program 4	Student Program (4)	[S_MB_STU_X]StudentProgram4	Text	3
173	Enrolment	Student Entry Code	[Students]EntryCode [ReEnrollments]EntryCode	Text	3
176	Transportation	Student Transportation info	[S_MB_STU_X]Transportation	Text	3
179	Eligible %	Eligible %	[S_MB_STU_X]Eligible	Text	3
182	Special Needs	This field output is blank as it is no longer required by the ministry.	N/A	Text	3
185	Has Diploma	If the student has a diploma	[S_MB_STU_X]HasDiploma	Text	1
186	FE Sponsor	This field output is blank as it is no longer required by the ministry.	N/A	Text	3
189	Home Room	Student Home Room	[Students]Home_Room	Text	12
201	Aboriginal Identity 1	Student Aboriginal Identity (1)	[S_MB_STU_X]AboriginalId1	Text	3
204	Aboriginal Identity 2	Student Aboriginal Identity (2)	[S_MB_STU_X]AboriginalId2	Text	3
207	Aboriginal Identity 3	Student Aboriginal Identity (3)	[S_MB_STU_X]AboriginalId3	Text	3
210	Number of Courses 1	Number of Enhanced Courses (1)	[S_MB_STU_X]NumberOfEnhancedCourses1	Text	2
212	Care of CFS	If student has Care of Child and Family Services	[S_MB_STU_X]CareOfCFS	Text	1
213	Aboriginal Other Description	Aboriginal Other Description The description of Aboriginal Identity if Aboriginal Identity field = "400–Aboriginal Other".	[S_MB_STU_X]AboriginalOtherDesc	Text	25
238	Number of Courses 2	Number of Enhanced Courses (2)	[S_MB_STU_X]NumberOfEnhancedCourses2	Text	2
240	Newcomer	Assessment of newcomer EAL students	[S_MB_STU_X]NewcomerAssessment	Text	2
242	Needs Additional French Language Support	Indicate whether newcomer needs additional French language support Note: in addition to this indicator, the report will check to see if the student is enrolled in a Français or French Immersion Program such as 101 or 11x	[S_MB_STU_X]NewcomerAdditionalFrench	Text	1
243	Filler	Blank space.	N/A	Text	8

Back to Top