MB Student Marks Report
Contents
Introduction
This report generates the fixed length xxxxmrk.asc Student Marks file for EIS submissions.
Selection Criteria
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, includes schools whose 'Exclude From Provincial Reporting' flag ([Schools]State_ExcludeFromReporting) is false.
Students must be in grade level 9 to 12.
Includes marks associated with a term selected in the Include Term(s) parameter on the report input page (i.e. [StoredGrades]TermId matches the term id for a selected term). The term id for marks stored by the Permanently Store Grades process is the term id of the associated class. The term id for marks stored directly in Historical Grades is that of the term specified by the user at the time of entry.
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 marks to include. | Select one or more terms. Only marks with a term matching a selected term are included in the report. |
Final Mark Store Code(s): | Select the store codes used to identify the grades to report as the "Final" grade. | The store code values must be set up in TermBins to identify marks in the StoredGrades table. |
Get marks from Stored Grades | The source of student Stored Grade marks; grade or percent. | Select one of the follow options:
|
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 marks header record. | N/A. Will always be 'H' | Text | 1 |
2 | File Type | Student Marks file | N/A. Will always be 'M' | Text | 1 |
3 | Reporting Date | The current date the report is run on. | 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 marks 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]EntryDate | Date | 8 |
102 | Previous Surname | Student Previous Surname | [S_MB_STU_X]PreviousSurname | Text | 35 |
137 | Postal Code | Student Postal Code | [Students]Zip | Text | 6 |
143 | Grade | Student 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 | Aboriginal Identity 1 | Student Aboriginal Identity (1) | [S_MB_STU_X]AboriginalId1 | Text | 3 |
175 | Aboriginal Identity 2 | Student Aboriginal Identity (2) | [S_MB_STU_X]AboriginalId2 | Text | 3 |
178 | Aboriginal Identity 3 | Student Aboriginal Identity (3) | [S_MB_STU_X]AboriginalId3 | Text | 3 |
181 | 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 |
206 | Filler | Blank space. | N/A | Text | 42 |
Detail Row | |||||
1 | Record Type | The marks 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.5 becomes 15 and 0.25 becomes 2 | [StoredGrades]EarnedCrHrs | 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 | Final Mark | Student's class final mark associated to the store code EIS requires that valid final marks for PE11 and PE12 are "CO" and "IN". EIS requires that final marks for Non-Manitoba Optional ([S_MB_CRS_Courses_X/S_MB_SEC_X]ReportCardCrsType = "NOPT") and Compulsory Courses are "S" only. | [StoredGrades]Grade where [StoredGrades]StoreCode = Final Mark Store Code If blank, or doesn't exist, then '0' | Text | 3 |
57 | Semester | Semester code for the term associated with the mark. | [Gen]Value where [Gen]Cat = "semestercode", [Gen]SchoolId = [Terms]SchoolId for the associated term, and [Gen]YearId = [StoredGrades]TermId | Text | 1 |
58 | Exam Mark Included | Does Final Mark include the exam mark? | "Y" if [S_MB_SEC_X]ExamMarkIncl is defined and has the value 1 or "Y", otherwise "N" |
|
|
59 | 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 |
60 | 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 |
64 | Filler | Blank space. | N/A | Text | 137 |