MB Student Course Registrations Report

Contents

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]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 Grade Level Kindergarten is represented as 'K'. 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

Back to Top