MB Student Demographics Report
Introduction
This report generates the fixed length xxxxdem.asc Student Demographics file for EIS submissions.
Selection Criteria
The report includes students whose current school ([Students]SchoolId) is the current 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.
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 demographics header record. | N/A. Will always be 'H' | Text | 1 |
2 | File Type | Student Demographics file | N/A. Will always be 'D' | 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 demographics 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’s gender. | Students.StudentCoreFields.PSCore_Legal_Gender, if unavailable [Students]Gender | Text | 1 |
94 | Enrolment Date | Student Enrolment Date Format: DDMMYYYY | [Students]EntryDate [ReEnrollments]EntryDate | 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’s grade level.
| [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 | Year End Status | Student school exit code Note: This is the status of the student as of June 30 for the current academic year (or earlier if they have left the school before the end of the school year). | [Students]ExitCode [ReEnrollments]ExitCode | Text | 3 |
164 | Leave Date | Student school exit date Format: DDMMYYYY | [Students]ExitDate [ReEnrollments]ExitDate | Date | 8 |
172 | Enrolment | Student Entry Code | [Students]EntryCode [ReEnrollments]EntryCode | Text | 3 |
175 | Aboriginal Identity 1 | Student Aboriginal Identity (1) | [S_MB_STU_X]AboriginalId1 | Text | 3 |
178 | Aboriginal Identity 2 | Student Aboriginal Identity (2) | [S_MB_STU_X]AboriginalId2 | Text | 3 |
181 | Aboriginal Identity 3 | Student Aboriginal Identity (3) | [S_MB_STU_X]AboriginalId3 | Text | 3 |
184 | 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 |
209 | Filler | Blank space. | N/A | Text | 42 |
