Skip to main content
Skip table of contents

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]EntryDate

[ReEnrollments]EntryDate

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.