Skip to main content
Skip table of contents

MB Student Course Registrations Report

Introduction

This report generates the fixed length xxxxreg.asc Student Course Registrations 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.
Only students in grade levels 9 to 12 are selected.

The report includes course registrations for students enrolled in classes at the school even if this school is not the student's primary enrolment.
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 student. Each information row will be followed by one or more detail rows 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 course registrations header record.

N/A. Will always be 'H'

Text

1

2

File Type

Student Course Registrations file

N/A. Will always be 'R'

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 course registrations 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.StudentCoreFields.PSCore_Legal_Gender, if unavailable

[Students]Gender

Text

1

94

Enrolment Date

Student Enrolment Date
Format: DDMMYYYY

[Students]EntryDate

[ReEnrollments]EntyDate

Date

8

102

Postal Code

Student Postal Code

[Students]Zip

Text

6

108

Grade

Student’s grade level.

  • K is printed if the grade level is 0.

  • SE is printed if grade level is -1.

  • SS is printed if grade level is 13.

  • All other grade levels are numeric 1 to 12.

[Students]Grade_Level

[ReEnrollments]Grade_Level

Text

2

110

School Student Number

Student School Student Number

[Students]Student_Number

Text

12

122

Resident Division

Student Resident Division

[S_MB_STU_X]ResidentDivision

Text

4

126

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

161

Filler

Blank space.

N/A

Text

40

Detail Row

1

Record Type

The course registrations 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

Credit

Class credit hours
One implied decimal place. E.g. 1.0 becomes 010 and 0.5 becomes 005

[Courses]Credit_Hours

Text

3

52

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

54

Semester

Semester code for class term

[Gen]Value where [Gen]SchoolId = [Sections]SchoolId and [Gen]YearId = [Sections]TermId

Text

1

55

Section

Class number

[Sections]Section_Number

Text

4

59

Delivery Mode

Class Delivery Mode Code

[S_MB_SEC_X]DeliveryMode if not blank, else [S_MB_CRS_Courses_X]DeliveryMode if not blank, else '01'

Text

4

63

Course PSP Number

Teacher PSP number

[S_MB_USR_X]TeacherPSPNumber

Text

6

69

Credit Flag

Indicates if the Credit field has one or two implied decimal places. Set to 'Y' for one implied decimal place.

N/A. Will always be 'Y'

Text

1

70

Filler

Blank space.

N/A

Text

131

JavaScript errors detected

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

If this problem persists, please contact our support.