MB BEF K-8 Classroom Report
Introduction
This report generates the fixed length xxxxbca.asc BEF K-8 Classroom file for EIS submissions.
Selection Criteria
Only classes for the current school or district where the grade level is less than or equal to 8 and where Exclude From Provincial Reporting is set to "No", are reported. The grade level that determines inclusion is set on the Sections page.
Only classes underway on September 30 of the current school year are reported.
Each teacher associated with the class on September 30 (as indicated in the SectionTeacher tab) for which the % allocation is greater than zero is reported. This includes both the lead teacher and any co-teachers.
When a class is reported for multiple teachers, the Minutes per Cycle reported is divided by the number of reported teachers, and rounded to a whole number. This ensures that the total minutes per cycle reported for the class from all teachers does not exceed 100% of the class's minutes per cycle.
If [Sections]Grade_Level is 9 or greater, a class is excluded. If undefined, the class is included.
A record is created for each teacher associated with the class (as indicated in the SectionTeacher table) for which the % allocation is greater than zero. This includes both the lead teacher and any co-teachers.
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 |
|---|---|---|
Classes | Identifies whether only French classrooms will be reported or French and/or English. | Select an option:
|
Report Output
The report output will contain one header row, followed by one information row per teacher. Each information row will be followed by one or more detail rows per teacher. A .zip file will be generated containing two files, a .xls spreadsheet that can be opened in Excel, and an .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 BEF K-8 header record. | N/A. Will always be 'H' | Text | 1 |
2 | File Type | Student Marks file | N/A. Will always be 'K' | 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 BEF K-8 information record. | N/A. Will always be 'I' | Text | 1 |
2 | School Employed | The number assigned to the school by the department, where the employment is being reported | [Schools].Alt_School_number if not 0 Otherwise [Sections]SchoolId | Text | 4 |
6 | PSP Number | Teacher PSP Number | [S_MB_USR_X]TeacherPSPNumber | Text | 6 |
12 | Surname | Teacher 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. | [Users]Last_Name | Text | 25 |
37 | Given Name(s) | Teacher 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. | [Users]First_Name | Text | 25 |
62 | Filler | Blank space. | N/A | Text | 139 |
Detail Row | |||||
1 | Record Type | The BEF K-8 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 | Subject Level as stored in the CIP Code field | [Courses]Code | Text | 3 |
49 | Homeroom | The classroom number BEF Homeroom field (used when French classes are taught to students from more than one homeroom). The BEF Homeroom value is extracted if defined; otherwise, the Sections. room value is extracted. | [S_MB_SEC_X]BEFHomeroomif defined, else [Sections]room | Text | 12 |
61 | School Track | School Track | [PS_Common_Code]Alt_Report_Code where [PS_Common_Code]PS_Group = 'MB_Courses' and [PS_Common_Code]Category = 'SchoolTrack' and [PS_Common_Code] = [S_MB_SEC_X]SchoolTrack if not blank, else [S_MB_CRS_Courses_X]SchoolTrack if not blank, else '14' | Text | 2 |
63 | Number of Classes | If the Subject Level is not 'NA', this is the number of class of this subject that the teacher is teaching:
| N/A. Generated from a count of records in the Sections table | Text | 2 |
65 | Male Enrolment
| The number of male students taught in the subject. | Generated from a count of records from the Legal Gender field in the StudentCoreFields table. If unavailable then from the Gender field in the Students table. | Text | 3 |
68 | Female Enrolment
| The number of female students taught in the subject. | Generated from a count of records from Legal Gender field in the StudentCoreFields table. If unavailable then from the Gender field in the Students table. | Text | 3 |
71 | 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 |
73 | Semester | Semester code for class term | [Gen]Value where [Gen]SchoolId = [Sections]SchoolId and [Gen]YearId = [Sections]TermId | Text | 1 |
74 | Minutes per Cycle | Minutes per cycle. | [S_MB_SEC_X]MinutesPerCycle if not blank, else '0' | Text | 4 |
78 | Filler | Blank space. | N/A | Text | 121 |