Enrolment Reports
Introduction
This report is a PDF containing day school registers (both detail and summary) as described in the ministry's instructions for enrolment registers for elementary and secondary schools.
Attendance Type Override
If Attendance Type is entered on the Students Transfer Info > Current and Prior Enrollments or on the State/Province - ON page, this value is used in the report and overrides the calculated attendance type. The field is [Students]EnrollmentType or [ReEnrollments]EnrollmentType.
If the student is in an Intensive Behavioral Intervention program, Attendance Type must be manually overridden to full-time or part-time, whichever applies. For enrolment rules related to these students please refer to the Enrolment Register Instructions for Elementary and Secondary Schools on the Ministry website. When the attendance type is not manually overridden, it will be calculated. The following rules are used to calculate the attendance type.
Attendance Type Rules
The Attendance Type Rules determine if a Student is full-time or part-time.
Elementary School Rules
Full-Time Students
A student is considered full-time when course enrolment minutes are greater than or equal to 210.
Part-Time Students
A student is considered part-time when course enrolment minutes are less than 210.
Exception:
If no course enrolments (cc records) are found, minutes will be zero and the student will be considered part-time with an FTE of .04.
Secondary School Rules
Full-Time Students
A student is considered full-time when course enrolment minutes are greater than or equal to 210.
Exceptions:
If the student is age 14 to 17 and is enrolled in a special program designated as a Supervised Alternative Learning (SAL) program with SAL Program Type 002 (70 minutes or more of Day School instruction), in which case attendance type is full-time regardless of number of minutes enrolled.
Part-Time Students
A student is considered part-time when course enrolment minutes are less than 210.
Exceptions:
If the student is age 14 to 17 and is enrolled in a special program designated as a Supervised Alternative Learning (SAL) program with SAL Program Type 001 (less than 70 minutes of Day School instruction), the attendance type is part-time regardless of the number of minutes enrolled.
If no course enrolments (cc records) are found, minutes are zero and the student is considered part-time with an FTE of .04.
Independent Study Students
If all of the student's classes at the school of primary enrolment are flagged as independent study classes (that is, [S_ON_SEC_X]IsIndependentStudy_Class or [S_ON_CC_X]IsIndependentStudy_Class is true), the student does not appear on, or is transferred off, the FT or PT registers, as per Ministry guidelines.
Students who enrol as part-time or full-time and then switch to taking only Independent Study courses are noted as Internal Transfers, once the part-time or full-time courses end.
Students who change from taking only Independent Study courses to taking part-time or full-time courses, are noted as Internal Admissions on the date the regular courses begin.
FTE Rules
FTE is displayed on the reports for Part-Time students only. FTE is calculated at run time unless the student FTE has been manually overridden.
FTE Override
If FTE is manually entered on the Students Transfer Info > Current and Prior Enrollments or State/Province - ON pages, that FTE value will be used in the report. The FTE value entered on either of the above pages will override the calculated FTE. The field value is stored in [S_ON_STU_X]FTE or [S_ON_REN_X]FTE.
FTE for Full-Time
Calculated as minutes enrolled/300 when calculated attendance type is Full-Time, unless the student is age 14 to 17 and is enrolled in a special program designated as a Supervised Alternative Learning (SAL) program with SAL Program Type 002 (70 minutes or more of Day School instruction); in this case, the FTE is 1.0 regardless of the number of minutes enrolled. Independent Study students enrolled in an expulsion program have an FTE of 1.0 regardless of the number of minutes enrolled.
FTE for Part-Time
Calculated as minutes enrolled/300 when calculated attendance type is Part-Time, unless the student is age 14 to 17 and is enrolled in a special program designated as a Supervised Alternative Learning (SAL) program with SAL Program Type 001 (less than 70 minutes of Day School instruction); in this case, the FTE is 0.5 regardless of number of minutes enrolled. If the calculated value is less than 0.04 but greater than or equal to 0, the value is set to 0.04.
Enrolment Minutes Calculation
Enrolment minutes is calculated by GetStudentEnrolmentFieldBSID common function, described in the Enrolment Fields Report.
When the first day is not an in-session day, the report uses the first in-session day of the term to calculate attendance type and FTE.
If the student entry date is before the first in-session day in the semester then attendance type and FTE are calculated based on the first in-session day in the semester.
Student class enrolments that started before the first in-session date, attendance type, and FTE are calculated based on the first in-session day of the class term. Student class enrollments that started and ended before the first in-session day are ignored.
Selection Criteria
Selection criteria determine which student enrolments are included in the report. The report selects records from the [Students] and [ReEnrollments] tables based on the following:
Active or Inactive students enrolled in the school at any time between the start of the school year and the effective date entered in the effective date parameter on the report parameter page. If the effective date is the last day of school(latest last day of all schools with same BSID), then any student enrolled in the school at any time during the school year will be processed.
The student must not be excluded from provincial reporting.
The student must have a date of birth or Ontario Board Residence Status.
Minutes enrolled are based on current and past course enrolments for the current school year. Minutes for courses taken at night schools ([S_ON_SCH_X]IsNightSchool is true) are excluded for determining minutes enrolled and FTE. Attendance must be setup to "Count Meeting attendance recorded at another school for students enrolled at this school" if cross-enrolled minutes are to be included in enrolled minutes.
A student's enrolment(s) is excluded if their attendance type (i.e. EnrollmentType field) = 'EX' (excluded) for the enrolment (i.e. Students or ReEnrollments record) associated with, in whole or in part, the run date (i.e. if there is any overlap between the enrolment start and end dates and the run date). This allows the 'Exclude From Provincial Reporting' flag ([Students]State_ExcludeFromReporting) to be turned off for a student so that they are reported during a previous enrolment, but allows the student to be excluded from being reported during their current enrolment(s).
Independent Study students between the age of 14 and 17 participating in a SAL program are included.
Independent Study students participating in an Expulsion program are included.
Report Input
For help with navigation and running the report, refer to How to Find and Generate a Report.
Field | Description |
Effective Date | Select the end date for the report. Data will be calculated from the beginning of the school year to this date. |
Select Report Type | Choose whether you wish the Enrolment Reports to include detailed information, summary information, or both. |
Select Attendance Type | 9999Choose whether you wish the Enrolment Reports to include All (default), Full-Time or Part-Time students. |
Sort Data By | Choose whether you wish the Enrolment Reports to sort students by name only or by grade first and then by name. |
Group Data By | Choose whether you wish the Enrolment Reports to group students by grade or by homeroom. The groups will be displayed in an ascending order. |
Current Selection Students | Choose whether you wish to run the report for the current selection of students or have the report search for students based on school, entry date and exit date (All Students). |
Report Output
When the Group Data By run time parameter is set to Group by Grade, the report summaries will display for the following grade categories:
Junior Kindergarten (full-time and part-time)
Internal transfers are required when a student moves from grade JK to grade K during the school year.
Kindergarten (full-time and part-time)
Grades 1 - 3 (full-time and part-time)
Internal transfers are required when a student moves from Grade 3 to Grade 4 during the school year.
Grades 4 - 8 (full-time and part-time)
Grades 9 - 12, under age 21 (full-time and part-time)
Grades 9 - 12, age 21 or over (full-time and part-time)
The report details will display students sorted either alphabetically by name or by grade level first and then by name, depending on the value of the Sort Data By run time parameter.
When the Group Data By run time parameter is set to Group by Homeroom, the report details will display students grouped by Homeroom Teacher (sorted alphabetically by teacher legal last name if blank teacher last name ) and then sorted either alphabetically by name or by grade level first and then by name, depending on the value of the Sort Data By run time parameter.
There are different types of report summaries. Each report type has a Page Header with School Name, Year Name and Run Date. The report details and summaries include:
Enrolment Summary by Month for Full Time and Part-Time pupils (grades JK, K, 1-3, 4-8, SAL, secondary pupils under 21 and secondary pupils 21 and over). This summary page displays by Month the following fields: Previous Student Counts, Internal and External Admission counts, Internal and External Transfer Counts, Retired Count, Net Change, Net Last, Pupils of Board and Other Pupils. The page also displays a summary recap for October, March and the Effective Date with the following fields: Net Last Day, Pupils of the Board, Other Pupils.
Enrolment Summary for Full Time pupils Under 21. The page displays the following fields for each student: OP, Name, Student Number, October Regular Minutes, October Regular FTE, October High Credit Minutes, October High Credit FTE, March Regular Minutes, March Regular FTE, March High Credit Minutes, March High Credit FTE. In addition there is a section that recaps for October and March: Total Pupils of the Board, Total Other Pupils, Total Regular and High Credit FTEs for Pupils of the Board, Total Regular FTEs for Other Pupils. Note that if a student's board residence status is not "01" (pupil of the board) all high credit values are zero.
Enrolment Summary for Part-Time pupils (grades JK, K, 1-3, 4-8, secondary pupils under 21 and secondary pupils 21 and over). This page displays the following fields for each student: OP, Name, Student Number, October Regular Minutes, October Regular FTE, October High Credit Minutes, October High Credit FTE, March Regular Minutes, March Regular FTE, March High Credit Minutes, March High Credit FTE and Effective Date Total FTE. In addition there is a section that recaps for October, and March: Total Pupils of the Board, Total Other Pupils, Total Regular and High Credit FTEs for Pupils of the Board and Total Regular FTEs for Other Pupils. Note that if a student's board residence status is not "01" (pupil of the board) all high credit values are zero.
Enrolment Details for Full Time and Part-Time pupils (grades JK, K, 1-3, 4-8, SAL and 9-12). This page contains the following fields per student: OP, OEN, Name, Student Number, Grade, Internal Admission Date, External Admission Date, Internal Transfer Date, External Transfer Date, Retirement Date and Minutes On Effective Date.
Tuition Paid Details for Full Time and Part-Time pupils (grades JK, K, 1-3, 4-8, secondary pupils under 21 and secondary pupils 21 and over). This page displays additional details for students who are not Pupils of the Board. It contains the following fields: OP, Tuition Paid By, OEN, Name, Student Number, and Grade and is sorted by last name.
School Enrolment Summary. This summary displays at the end of the report and provides Full Time Equivalent totals broken down by grade (elementary schools) or by age (secondary schools).
Additional details are defined in the table below. Each of the fields displayed in the output of the report is described below. Refer to Understanding the Report Output Table for a definition of each column in the table.
Page Header
Data Element | Description | [Table]FieldName |
School Name | This is the name of the school the Enrolment Reports is printed for. | [S_ON_SCH_X]Alt_School_Name (if defined) ELSE [Schools]School_Name |
Report Page | The page number within the entire report as run. | Determined by SRP when the report is generated. |
Register Name | This is the name of the register the page is for. | Derived based on the sort group, type of school and attendance type of the students. |
Page Title | The title of the page within the register. | Derived based upon the detail data contained on the page |
Year Name | This is the name of the school year the Enrolment Reports is printed for. | [Terms]Name where [Terms]IsYearRec = 1 |
Run Date | The date the Enrolment Reports is run. | Current Date |
Effective Date | The date entered on the report input page. The report will reflect data from the beginning of the school year to this date. | Entered on the report input page. |
Monthly Enrolment Summary for Full Time students
Data Element | Description | [Table]FieldName |
Month | The name of the month that the student enrolment counts is for. | Derived from [Terms]FirstDay and [Terms]LastDay where [Terms]IsYearRec = 1 |
Previous | The number of students enrolled as of the last day of the previous month. Note: This column is NOT summed in the Totals line. | Count of Internal Admissions plus External Admissions from Prior Month minus Internal Transfers minus External Transfers minus Retirements from Prior Month Based on Attendance Type Rules - for Attendance Type FT Add Internal admissions and External admissions
Subtract Internal Transfers, External Transfers, Retirements
|
Internal Admissions | The number students who started an enrolment via an internal admission in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
External Admissions | The number of students who started an enrolment via an external admission in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Internal Transfers | The number of students who ended an enrolment via an internal transfer in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
External Transfers | The number of times a student ended an enrolment via an external transfer in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Retired | The number of times a student ended an enrolment via a retirement in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Net Change | The change in the number of students enrolled between the last day of the previous month and the last day of the current month. Note: This column is summed in the Totals line. | Calculated as the sum of the Internal Admissions, External Admissions, Internal Transfers, External Transfers, and Retired columns for the month. |
Net Last | The number of students enrolled as of the last day of the month. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Board Pupils | The number of students enrolled as of the last day of the month who are pupils of the board. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Other Pupils | The number of students enrolled as of the last day of the month who are not pupils of the board. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Net Last Day (October) | The number of students enrolled as of the last school day of October. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true:
|
Net Last Day (March) | The number of students enrolled as of the last school day of March. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 01, 02, 03, 05, 07 or 08. |
Net Last Day (Effective Date) | The number of students enrolled as of the effective date chosen at run time. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 01, 02, 03, 05, 07 or 08. |
Pupils of the Board (October) | The number of students enrolled as of the last school day of October who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of October, and [Students]/[ReEnrollments]ExitDate is after the last day of October, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Pupils of the Board (March) | The number of students enrolled as of the last school day of March who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Pupils of the Board (Effective Date) | The number of students enrolled as of the effective date chosen at run time who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Other Pupils (October) | The number of students enrolled as of the last school day of October who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of October, and [Students]/[ReEnrollments]ExitDate is after the last day of October, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Other Pupils (March) | The number of students enrolled as of the last school day of March who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Other Pupils (Effective Date) | The number of students enrolled as of the effective date chosen at run time who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Tuition Paid Details (Full-Time)
The Attendance Type is derived from [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type of FT.
Data Element | Description | [Table]FieldName |
OP (Other Pupil) | Prints the Board Residence Status Code if the student is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]StudentPaidBy where [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
OEN | The student's Ontario Education Number. | [Students]State_StudentNumber |
Paid By | The tuition "paid by" information for a student who is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]StudentPaidBy where [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Name | The student's name. Format: Last, First | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Student # | The student's locally assigned number. | [Students]Student_Number |
Grade | The student's grade level. | [Students]Grade_Level or [ReEnrollments]Grade_Level |
Enrolment Details (full-time)
The 'Group Data By (Grade or Home Room)', 'Sort Data By (Student Name or Grade and Student Name)' and 'Attendance Type' sort the report. The Attendance Type is derived from [Students]EnrollmentType, [ReEnrollments]EnrollmentType or calculated attendance type of FT.
Data Element | Description | [Table]FieldName |
OP (Other Pupil) | Prints OP and the name of the payor if the student is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]StudentPaidBy where [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
OEN | The student's Ontario Education Number. | [Students]State_StudentNumber |
Name | The student's name. Format: Last, First If Group by Homeroom - will contain homeroom ([S_ON_CRS_X]Course_Type = H) teacher last and first name, course name, Course number and section number. This information will be displayed in red and larger font to stand out from the student data. The lead teacher as of the report effective date is used. The lead teacher is identified by the SectionTeacher record where the role id is that of the lead teacher role (which is the RoleDef record where IsLocked = 1). | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name OR
[Users]Last_Name,[Users]First_Name - [Courses]Name - [CC]Course_Number.[CC]Section_Number |
Student # | The student's locally assigned number. | [Students]Student_Number |
Grade | The student's grade level. | [Students]Grade_Level or [ReEnrollments]Grade_Level |
Internal Admission | Date the student is internally admitted for this enrolment. Blank if the enrolment is not an internal admission. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT or PT and one of the following is true:
|
External Admission | Date the student is externally admitted for this enrolment. Blank if the enrolment is not an external admission. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT or PT and one of the following is true:
|
Internal Transfer | Date the student is internally transferred for this enrolment. Blank if the enrolment is still active, or the enrolment is not an internal transfer. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT or PT and one of the following is true:
|
External Transfer | Date the student is externally transferred for this enrolment. Blank if the enrolment is still active, or the enrolment is not an external transfer. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT or PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Retirement | Date the student is retired for this enrolment. Blank if the enrolment is still active, or the enrolment is not a retirement. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT or PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Minutes on Effective Date (Mins Eff Dt) | The number of minutes the student is enrolled for, either on the effective date or the last date in-session prior to the effective date if the effective date is not an in-session day for the student. | [PS_Membership_Defaults]Potential_Minutes_Present where [[PS_Membership_Defaults]CalendarDate = effective date or [PS_Membership_Defaults]Potential_Minutes_Present where [[PS_Membership_Defaults]CalendarDate = last in-session date prior to effective date. If [Students]Grade_Level = -1 or 0 and [Students]ON_TimeTableType = 3 then the minutes from [PS_Membership_Defaults]Potential_Minutes_Present are divided by 2. This field will be marked with a double asterisk (**) on the full-time register if the student is on the full-time register because of participation in a SAL Program that provides at least 70 minutes of classroom instruction. This field will be marked with a double asterisk (**) on the part-time register if the student is on the part-time register because of participation in a SAL Program that provides less than 70 minutes of classroom instruction. This field will be marked with "*e" on the full-time register if the student is on the full-time register because of participation in an expulsion program. Student moved from regular study to 'Independent Study, minutes on effective date are empty. |
Total Active Students as of (Effective Date) | A summary count at the end of the report details page showing the total number of students who are active on the register as of the effective date. | Count of students who have not transferred from or retired from the register as of the effective date (or last in-session date prior to the effective date if the effective date is not an in-session day) entered at report run time. |
** Key | If any student on the full-time register is placed on that register because they participate in a SAL program which provides at least 70 minutes of classroom instruction, the student's effective date minutes will be flagged and a footnote will appear at the end of the register explaining why the minutes are flagged. | Text string that states "** - Student is enrolled in a SAL Program" |
^ Key | If any student appearing on a register has had their FTE or Attendance Type overridden from its default value, the student's FTE will be flagged and a footnote will appear at the end of the register explaining why the FTE is flagged. | Text string that states "^ - Student's FTE and/or Attendance Type has been manually overridden" |
*e Key | If any student on the full-time register is placed on that register because they participate in an expulsion program, the student's effective date minutes will be flagged and a footnote will appear at the end of the register explaining why the minutes are flagged. | Text string that states "*e - Student is participating in an expulsion Program" |
Full Time Enrolment Summary (pupils under 21 only - Part One)
There are four columns for each of the Monthly Minutes of Instruction/FTEs:
October - calculated as of October 31st of the school year, unless October 31st falls on a non in-session day in which case the last school day before October 31st is used.
March - calculated as of March 31st of the school year, unless March 31st falls on a non in-session day in which case the last school day before March 31st is used.
Effective Date FTE - calculated as of the date entered in the "Effective Date" parameter on the report setup page.
The values needed for the report are obtained from the GetStudentEnrolmentField function.
Note:
If a student's board residence status is not "01" (pupil of the board) all high credit values are zero. Details on the field values the function returns can be found in the Enrolment Reports.
If the school the course is taken is an Online school ADE and High Credit ADE values are Zero.
Data Element | Description | [Table]FieldName or [Function]ReturnedValue |
OP (Other Pupil) | Prints OP if the student is not a pupil of the board. | OP if [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. OR [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Name | The student's name. Format: Last, First | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Student Number | The student's locally assigned number. | [Students]Student_Number |
October Regular Minutes | The number of regular minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October Regular FTE | The student's regular FTE as of the October count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
October High Credit Minutes | The number of high credit minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October High Credit FTE | The student's high credit FTE as of the October count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
March Regular Minutes | The number of regular minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March Regular FTE | The student's regular FTE as of the March count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
March High Credit Minutes | The number of high credit minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March High Credit FTE | The student's high credit FTE as of the March count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
Effective Date FTE | The student's regular FTE as of the report's effective date (as entered during the report setup). | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = date entered as the "Effective Date" field on report UI. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
^ Key | If any student appearing on a register has had their FTE or Attendance Type overridden from its default value, the student's FTE will be flagged and a footnote will appear at the end of the register explaining why the FTE is flagged. | Text string that states "^ - Student's FTE and/or Attendance Type has been manually overridden" |
Full Time Enrolment Summary (pupils under 21 only - Part Two)
There are three columns for each of the following categories:
October - calculated as of October 31st of the school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st.
March - calculated as of March 31st of the school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st.
Effective Date - calculated as of the date entered on the report setup page.
Data Element | Description | [Table]FieldName |
Total Minutes in Cycle | The number of minutes in an enrolment cycle. | Always prints 300. |
Total Number of Pupils - Pupils of the Board | The number of students enrolled full-time as of the count date who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Total Number of Pupils - Other Pupils | The number of students enrolled full-time as of the count date who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Pupil FTEs - Pupils of the Board Regular | The sum of the regular FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students Regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Pupils of the Board High Credit | The sum of the high credit FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students High Credit FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Other Pupils Regular | The sum of the regular FTEs of the students enrolled as of the count date who are not pupils of the board. | Sum of Students regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Monthly Enrolment Summary for part-time students
Data Element | Description | [Table]FieldName |
Month | The name of the month that the student enrolment counts is for. | Derived from [Terms]FirstDay and [Terms]LastDay where [Terms]IsYearRec = 1 |
Previous | The number of students enrolled as of the last day of the previous month. Note: This column is NOT summed in the Totals line. | Count of Internal Admissions plus External Admissions from Prior Month minus Internal Transfers minus External Transfers minus Retirements from Prior Month Based on Attendance Type Rules - for Attendance Type PT Add Internal admissions and External admissions
Subtract Internal Transfers, External Transfers, Retirements
|
Internal Admissions | The number students who started an enrolment via an internal admission in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
External Admissions | The number of students who started an enrolment via an external admission in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Internal Transfers | The number of students who ended an enrolment via an internal transfer in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
External Transfers | The number of times a student ended an enrolment via an external transfer in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Retired | The number of times a student ended an enrolment via a retirement in the month. Note: This column is summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Net Change | The change in the number of students enrolled between the last day of the previous month and the last day of the current month. Note: This column is summed in the Totals line. | Calculated as the sum of the Internal Admissions, External Admissions, Internal Transfers, External Transfers, and Retired columns for the month. |
Net Last | The number of students enrolled as of the last day of the month. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Board Pupils | The number of students enrolled as of the last day of the month who are pupils of the board. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Other Pupils | The number of students enrolled as of the last day of the month who is not pupils of the board. Note: This column is NOT summed in the Totals line. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Net Last Day (October) | The number of students enrolled as of the last school day of October. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true:
|
Net Last Day (March) | The number of students enrolled as of the last school day of March. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 01, 02, 03, 05, 07 or 08. |
Net Last Day (Effective Date) | The number of students enrolled as of the effective date chosen at run time. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 01, 02, 03, 05, 07 or 08. |
Pupils of the Board (October) | The number of students enrolled as of the last school day of October who is pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of October, and [Students]/[ReEnrollments]ExitDate is after the last day of October, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Pupils of the Board (March) | The number of students enrolled as of the last school day of March who is pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Pupils of the Board (Effective Date) | The number of students enrolled as of the effective date chosen at run time who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 01 or 08. |
Other Pupils (October) | The number of students enrolled as of the last school day of October who is not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of October, and [Students]/[ReEnrollments]ExitDate is after the last day of October, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Other Pupils (March) | The number of students enrolled as of the last school day of March who is not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the last school day of March, and [Students]/[ReEnrollments]ExitDate is after the last school day of March, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Other Pupils (Effective Date) | The number of students enrolled as of the effective date chosen at run time who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and the following is true: [Students]/[ReEnrollments]EntryDate is on or before the effective date, and [Students]/[ReEnrollments]ExitDate is after the effective date, and [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. |
Tuition Paid Details (Part-Time)
The Attendance Type is derived from [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type of PT.
Data Element | Description | [Table]FieldName |
OP (Other Pupil) | Prints the Board Residence Status Code if the student is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]StudentPaidBy where [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
OEN | The student's Ontario Education Number. | [Students]State_StudentNumber |
Paid By | The tuition "paid by" information for a student who is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]StudentPaidBy where [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Name | The student's name. Format: Last, First | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Student # | The student's locally assigned number. | [Students]Student_Number |
Grade | The student's grade level. | [Students]Grade_Level or [ReEnrollments]Grade_Level |
Enrolment Details (Part-Time)
The 'Group Data By (Grade or Home Room)', 'Sort Data By (Student Name or Grade and Student Name)' and 'Attendance Type' sort the report. The Attendance Type is derived from [Students]EnrollmentType, [ReEnrollments]EnrollmentType or calculated attendance type of PT.
Data Element | Description | [Table]FieldName |
OP (Other Pupil) | Prints OP and the name of the payor if the student is not a pupil of the board. | [S_ON_STU_X]StudentPaidBy where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [ReEnrollments]ON_StudentPaidBy where [ReEnrollments]ON_Brd_Res_Status = 02, 03, 05 or 07. |
OEN | The student's Ontario Education Number. | [Students]State_StudentNumber |
Name | The student's name. Format: Last, First If Group by Homeroom - will contain homeroom ([S_ON_CRS_X]Course_Type = H) teacher last and first name, course name, Course number and section number. This information will be displayed in red and larger font to stand out from the student data. The lead teacher as of the report effective date is used. The lead teacher is identified by the SectionTeacher record where the role id is that of the lead teacher role (which is the RoleDef record where IsLocked = 1). | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name OR
[Users]Last_Name,[Users]First_Name - [Courses]Name - [CC]Course_Number.[CC]Section_Number |
Student # | The student's locally assigned number. | [Students]Student_Number |
Grade | The student's grade level. | [Students]Grade_Level or [ReEnrollments]Grade_Level |
Internal Admission | Date the student is internally admitted for this enrolment. Blank if the enrolment is not an internal admission. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
External Admission | Date the student is externally admitted for this enrolment. Blank if the enrolment is not an external admission. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Internal Transfer | Date the student is internally transferred for this enrolment. Blank if the enrolment is still active, or the enrolment is not an internal transfer. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
External Transfer | Date the student is externally transferred for this enrolment. Blank if the enrolment is still active, or the enrolment is not an external transfer. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Retirement | Date the student is retired for this enrolment. Blank if the enrolment is still active, or the enrolment is not a retirement. | Date where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true: If school year is 2012/2013 or earlier
If school year is 2013/2014 or later
|
Minutes on Effective Date (Mins Eff Dt) | The number of minutes the student is enrolled for, either on the effective date or the last date in-session prior to the effective date if the effective date is not an in-session day for the student. | [PS_Membership_Defaults]Potential_Minutes_Present where [[PS_Membership_Defaults]CalendarDate = effective date or [PS_Membership_Defaults]Potential_Minutes_Present where [[PS_Membership_Defaults]CalendarDate = last in-session date prior to effective date. If [Students]Grade_Level = -1 or 0 and [Students]ON_TimeTableType = 3 then the minutes from [PS_Membership_Defaults]Potential_Minutes_Present are divided by 2. This field will be marked with a double asterisk (**) on the part-time register if the student is on the part-time register because of participation in a SAL Program that provides less than 70 minutes of classroom instruction. Student moved from regular study to 'Independent Study', minutes are empty. |
Total Active Students as of (Effective Date) | A summary count at the end of the report details page showing the total number of students who are active on the register as of the effective date. | Count of students who have not transferred from or retired from the register as of the effective date (or last in-session date prior to the effective date if the effective date is not an in-session day) entered at report run time. |
^ Key | If any student appearing on a register has had their FTE or Attendance Type overridden from its default value, the student's FTE will be flagged and a footnote will appear at the end of the register explaining why the FTE is flagged. | Text string that states "^ - Student's FTE and/or Attendance Type has been manually overridden" |
Part-Time Enrolment Summary (pupils under 21 only - Part One)
There are four columns for each of the Monthly Minutes of Instruction/FTEs:
October - calculated as of October 31st of the school year, unless October 31st falls on a non in-session day in which case the last school day before October 31st is used.
March - calculated as of March 31st of the school year, unless March 31st falls on a non in-session day in which case the last school day before March 31st is used.
Effective Date FTE - calculated as of the date entered in the "Effective Date" parameter on the report setup page.
The values needed for the report are obtained from the GetStudentEnrolmentField function.
Note: If a student's board residence status is not "01" (pupil of the board) all high credit values are zero. Details on the field values the function returns can be found in the Enrolment Reports.
Data Element | Description | [Table]FieldName or [Function]ReturnedValue |
OP (Other Pupil) | Prints OP if the student is not a pupil of the board. | OP if [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Name | The student's name. Format: Last, First | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Student Number | The student's locally assigned number. | [Students]Student_Number |
October Regular Minutes | The number of regular minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October Regular FTE | The student's regular FTE as of the October count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
October High Credit Minutes | The number of high credit minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October High Credit FTE | The student's high credit FTE as of the October count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
March Regular Minutes | The number of regular minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March Regular FTE | The student's regular FTE as of the March count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
March High Credit Minutes | The number of high credit minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March High Credit FTE | The student's high credit FTE as of the March count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
Effective Date Total FTE | The student's FTE as of the effective date or the last in-session date prior to the effective date if the effective date is not an in-session day for the student. | Students FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
Set to .04 if not enrolled in courses but enrolled in school. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
^ Key | If any student appearing on a register has had their FTE or Attendance Type overridden from its default value, the student's FTE will be flagged and a footnote will appear at the end of the register explaining why the FTE is flagged. | Text string that states "^ - Student's FTE and/or Attendance Type has been manually overridden" |
Part-time Enrolment Summary (pupils under 21 only - Part Two)
There are three columns for each of the following categories:
October - calculated as of October 31st of the school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st.
March - calculated as of March 31st of the school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st.
Effective Date - calculated as of the date entered on the report setup page.
Data Element | Description | [Table]FieldName |
Total Minutes in Cycle | The number of minutes in an enrolment cycle. | Always prints 300. |
Total Number of Pupils - Pupils of the Board | The number of students enrolled full-time as of the count date who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Pupils - Other Pupils | The number of students enrolled full-time as of the count date who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Pupil FTEs - Pupils of the Board Regular | The sum of the regular FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students Regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Pupils of the Board High Credit | The sum of the high credit FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students High Credit FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Other Pupils Regular | The sum of the regular FTEs of the students enrolled as of the count date who are not pupils of the board. | Sum of Students regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Part-Time Enrolment Summary (pupils 21 and over only - Part One)
There are four columns for each of the Monthly Minutes of Instruction/FTEs:
October - calculated as of October 31st of the school year, unless October 31st falls on a non in-session day in which case the last school day before October 31st is used.
March - calculated as of March 31st of the school year, unless March 31st falls on a non in-session day in which case the last school day before March 31st is used.
Effective Date FTE - calculated as of the date entered in the "Effective Date" parameter on the report setup page.
The values needed for the report are obtained from the GetStudentEnrolmentField function.
Note: If a student's board residence status is not "01" (pupil of the board) all high credit values are zero. Details on the field values the function returns can be found in the Enrolment Reports.
Data Element | Description | [Table]FieldName or [Function]ReturnedValue |
OP (Other Pupil) | Prints OP if the student is not a pupil of the board. | OP if [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
Name | The student's name. Format: Last, First | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Student Number | The student's locally assigned number. | [Students]Student_Number |
October Regular Minutes | The number of regular minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October Regular FTE | The student's regular FTE as of the October count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
October High Credit Minutes | The number of high credit minutes of instruction received by the student as of the October count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
October High Credit FTE | The student's high credit FTE as of the October count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = October 31 of the current school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st. |
March Regular Minutes | The number of regular minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]Regular_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March Regular FTE | The student's regular FTE as of the March count date. | [GetStudentEnrolmentField]Regular_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
March High Credit Minutes | The number of high credit minutes of instruction received by the student as of the March count date. | [GetStudentEnrolmentField]High_Credit_Minutes where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
March High Credit FTE | The student's high credit FTE as of the March count date. | [GetStudentEnrolmentField]High_Credit_FTE where [GetStudentEnrolmentField]Effective_Date = March 31 of the current school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st. |
Effective Date Total FTE | The student's FTE as of the effective date or the last in-session date prior to the effective date if the effective date is not an in-session day for the student. | Students FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
Set to .04 if not enrolled in courses but enrolled in school. This field will be marked with a caret (^) if the student's FTE or Attendance Type has been manually overridden from its default value. |
^ Key | If any student appearing on a register has had their FTE or Attendance Type overridden from its default value, the student's FTE will be flagged and a footnote will appear at the end of the register explaining why the FTE is flagged. | Text string that states "^ - Student's FTE and/or Attendance Type has been manually overridden" |
Part-Time Enrolment Summary (pupils 21 and over only - Part Two)
There are three columns for each of the following categories:
October - calculated as of October 31st of the school year or, if October 31st falls on a non in-session day, the last in-session school day before October 31st.
March - calculated as of March 31st of the school year or, if March 31st falls on a non in-session day, the last in-session school day before March 31st.
Effective Date - calculated as of the date entered on the report setup page.
Data Element | Description | [Table]FieldName |
Total Minutes in Cycle | The number of minutes in an enrolment cycle. | Always prints 300. |
Total Number of Pupils - Pupils of the Board | The number of students enrolled full-time as of the count date who are pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Pupils - Other Pupils | The number of students enrolled full-time as of the count date who are not pupils of the board. | Count of Students where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Pupil FTEs - Pupils of the Board Regular | The sum of the regular FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students Regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Pupils of the Board High Credit | The sum of the high credit FTEs of the students enrolled as of the count date who are pupils of the board. | Sum of Students High Credit FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 01 or 08 or [S_ON_REN_X]Brd_Res_Status = 01 or 08. |
Pupil FTEs - Other Pupils Regular | The sum of the regular FTEs of the students enrolled as of the count date who are not pupils of the board. | Sum of Students regular FTE from Part 1 where [S_ON_STU_X]Brd_Res_Status = 02, 03, 05 or 07. or [S_ON_REN_X]Brd_Res_Status = 02, 03, 05 or 07. |
School Enrolment Summary (Secondary School)
All counts are as of the Effective Date entered on the report input page or the last in-session date prior to the effective date if the effective date is not an in-session day. There are two columns broken down by age (under 21 and 21 or over) and a total column for each of the following categories:
Data Element | Description | [Table]FieldName |
Equivalent Full Time Enrolment for Part Time - Pupils of the Board | The sum of the FTEs of the part-time students enrolled as of the effective date who are pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Equivalent Full Time Enrolment for Part Time - Other Pupils | The sum of the FTEs of the part-time students enrolled as of the effective date who are not pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Part Time Students - Pupils of the Board | The number of part-time students enrolled as of the effective date who are pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Part Time Students - Other Pupils | The number of part-time students enrolled as of the effective date who are not pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Half Time Students - Pupils of the Board | The number of half time students enrolled as of the effective date who are pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = HT and one of the following is true:
|
Total Number of Half Time Students - Other Pupils | The number of half time students enrolled as of the effective date who are not pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = HT and one of the following is true:
|
Equivalent Full Time Enrolment for Half Time - Pupils of the Board | The sum of the FTEs of the half time students enrolled as of the effective date who are pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = HT and one of the following is true:
|
Equivalent Full Time Enrolment for Half Time - Other Pupils | The sum of the FTEs of the half time students enrolled as of the effective date who are not pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = HT and one of the following is true:
|
Total Number of Full Time Students - Pupils of the Board | The number of full-time students enrolled as of the effective date who are pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Total Number of Full Time Students - Other Pupils | The number of full-time students enrolled as of the effective date who are not pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Total Full Time Equivalent for all students - Pupils of the Board | The sum of the FTEs of all students enrolled as of the effective date who are pupils of the board. | Calculated as the sum of Equivalent Full-Time Enrolment for Part-Time, Half Time and Full-Time Pupils of the Board. |
Total Full Time Equivalent for all students - Other Pupils | The sum of the FTEs of all students enrolled as of the effective date who are not pupils of the board. | Calculated as the sum of Equivalent Full-Time Enrolment for Part-Time, Half Time and Full-Time Other Pupils |
School Enrolment Summary (Elementary School)
All counts are as of the Effective Date entered on the report input page or the last in-session date prior to the effective date if the effective date is not an in-session day. There are four columns broken down by grade (JK, K, 1-3, 4-8) and a total column for each of the following categories:
Data Element | Description | [Table]FieldName |
Equivalent Full Time Enrolment for Part Time - Pupils of the Board | The sum of the FTEs of the part-time students enrolled as of the effective date who are pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Equivalent Full Time Enrolment for Part Time - Other Pupils | The sum of the FTEs of the part-time students enrolled as of the effective date who are not pupils of the board. | Student's FTE where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Part Time Students - Pupils of the Board | The number of part-time students enrolled as of the effective date who are pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Part Time Students - Other Pupils | The number of part-time students enrolled as of the effective date who are not pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = PT and one of the following is true:
|
Total Number of Full Time Students - Pupils of the Board | The number of full-time students enrolled as of the effective date who are pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Total Number of Full Time Students - Other Pupils | The number of full-time students enrolled as of the effective date who are not pupils of the board. | Student Count where [Students]EnrollmentType, [ReEnrollments]EnrollmentType, or calculated attendance type = FT and one of the following is true:
|
Total Full Time Equivalent for all students - Pupils of the Board | The sum of the FTEs of all students enrolled as of the effective date who are pupils of the board. | Calculated as the sum of Equivalent Full-Time Enrolment for Part-Time, Half Time and Full-Time Pupils of the Board. |
Total Full Time Equivalent for all students - Other Pupils | The sum of the FTEs of all students enrolled as of the effective date who are not pupils of the board. | Calculated as the sum of Equivalent Full-Time Enrolment for Part-Time, Half Time and Full- Time Other Pupils |
Supplemental And Troubleshooting Information
Student Selection - What to check if a student is missing from the report
The report should contain all students in a school who are or have been enrolled ([Students]/[ReEnrollments] tables) at the school during the current school year for even one day at any time between the first day of school and the effective date entered at the report run time (inclusive) unless:
The school is designated as a night school - [S_ON_SCH_X]IsNightSchool = 1 (checked = True = 1, unchecked = False = 0)
The student is excluded from state reporting - [Students]State_ExcludeFromReporting = 1 (checked = True = 1, unchecked = False = 0)
The student's Exit Date is less than or equal to their Entry Date - [Students]/[ReEnrollments]ExitDate <= [Students]/[ReEnrollments]EntryDate
The student's Attendance Type has been overridden to "LH - Less Than Halftime" - [Students]/[ReEnrollments]EnrollmentType = LH
The student is an independent study student - [S_ON_STU_X]Brd_Res_Status = 6 and is not participating in a SAL or Expulsion program
Attendance Type - What to check if a student appears on the wrong register (FT, PT)
Under normal circumstances the student is placed on a specific register based on the number of minutes of classes the student is or was enrolled in ([CC] table), the student's age, and the student's grade level. However, the following things can affect this placement:
The student's Attendance Type is overridden - [Students]/[ReEnrollments]EnrollmentType = PT or FT.
The student is enrolled in a special program designated as a SAL Program - [SpEnrollments]ProgramId = [Gen]Id where [Gen]Cat = specprog and [S_ON_GEN_SPECPROG_X]SAL_Flag = 1
Enrolled minutes are different than the expected attendance type requires (See Enrolled Minutes below)
The student's grade level does not allow the expected attendance type - [Students]/[ReEnrolments]Grade_Level
The student's age does not allow the expected attendance type - [Students]DOB
Independent Study classes should not be counted in the minutes calculations unless the student is participating in a SAL or expulsion program, which may result in the student appearing on the PT register.
Enrolled Minutes - What to check if enrolled minutes appear wrong on the register
The student's enrolled minutes are based on the number of classes the student is or was enrolled in and is dependent on how attendance is set up for the school. The base enrolled minutes are taken from [PS_Membership_Defaults]Potential_Minutes_Present. The following things can affect this number:
Attendance setup - "Count Meeting attendance recorded at another school for students enrolled at this school". If this box is not checked, minutes for courses taken at another school (cross enrolled courses) will NOT be included in the student's enrolled minutes. These minutes will NOT be included in [PS_Membership_Defaults]Potential_Minutes_Present
School setup - if a school is marked as being a night school ([S_ON_SCH_X]IsNightSchool = 1), the enrolled minutes for any courses take in that school will not be included in the student's enrolled minutes. These minutes WILL be included in [PS_Membership_Defaults]Potential_Minutes_Present (unless the minutes are for a cross enrolled course and cross enrolled minutes are excluded based on attendance setup) but the minutes will be subtracted out by the enrolment reports.
Nightly attendance process - [PS_Membership_Defaults] Potential_Minutes_Present relies on the nightly attendance process. If this process does not run on a daily basis, the data in [PS_Membership_Defaults] will not be current or will be incorrect. This process can be run manually by going to Special Functions > Attendance Functions > Refresh Premier Attendance Views Data.
Date the student entered and left the register - verify the dates the student entered and/or left the register if the number of enrolled minutes seems incorrect in a column (October, March or Effective Date). The student may have been on the register at some time during the year but may NOT have been on that particular register on the actual count date.
Independent study classes are excluded from a student's enrolled minutes unless the student is participating in a SAL or expulsion program.
FTE - What to check if the FTE appears incorrect on the register
Under normal circumstances a student's FTE is calculated as Enrolled Minutes divided by 300 ([PS_Membership_Defaults] Potential_Minutes_Present/300). If the result is greater than 1.00, the FTE is limited to 1.00. The following things can affect the FTE shown on the report:
The student's Attendance Type and/or FTE are manually overridden (indicated by a caret ^)- [Students]EnrollmentType = FT or HT and/or [S_ON_STU_X]FTE is not null.
If the attendance type is overridden, the report will use the value contained in [S_ON_STU_X]FTE if present.
If the attendance type is overridden but [S_ON_STU_X]FTE is null, the report will compute the FTE based on enrolled minutes.
If the attendance type is not overridden, any value in [S_ON_STU_X]FTE is ignored and the report will calculate the FTE based on enrolled minutes.
If a student is enrolled in the school but not enrolled in any courses, the student's FTE will be set to .04 unless the override conditions above apply.
If a student moved to independent study and did not enroll in any other regular classes, then the student should be considered an internal transfer. FTE should be blank after the day the student moved to independent study, unless the student is participating in a SAL or Expulsion program.
Date the student entered and left the register - verify the dates the student entered and/or left the register if the FTE seems incorrect in a column (October, March or Effective Date). The student may have been on the register at some time during the year but may NOT have been on that particular register on the actual count date.
Counts - What to check if student counts are off or don't match between pages
Sometimes the report will reflect different counts at the end of a register or Monthly Summary than is shown on the Summary for School, or the counts will be different when the report is grouped by Homeroom than when the report is grouped by grade level. The most common reason this happens is because students enrolled in an elementary school have overlapping Homeroom enrolments. When this happens, the report is unable to correctly track the internal transfers and internal admissions for the Homeroom enrolments and the counts may be higher or lower than they actually should be.
The below script can be used to help identify the students with overlapping Homeroom enrolments (where XXXX is the school ID for the school you are searching):
SELECT cc.*, CRS.SCHOOLID
FROM
CC, Courses crs
WHERE
crs.course_number = cc.course_number and
ps_customfields.getCF('Courses', crs.Id, 'Course_Type') = 'H'
and cc.schoolid = XXXX
and exists (select 'y' from cc cc2, Courses crs2
where CC.SCHOOLID = cc2.schoolid
and CC2.COURSE_NUMBER = CRS2.COURSE_NUMBER
and CC.STUDENTID = CC2.STUDENTID
and ps_customfields.getCF('Courses', crs2.Id, 'Course_Type') = 'H'
and CC2.DATEENROLLED < CC.DATELEFT
and CC2.DATEENROLLED > CC.DATEENROLLED
and CC2.DCID <> CC.DCID )
Dates - What to check if dates seem wrong for admissions, transfers or retirements
The enrolment reports tracks five types of dates for a student: Internal Admissions, External Admissions, Internal Transfers, External Transfers and Retirements. The rules around what constitutes each type are beyond the scope of this document. However, the following things can affect the date that is shown on the report for any date column.
Enrolling or withdrawing from a school - derived from [Students]/[ReEnrollments]EntryDate and [Students]/[ReEnrollments]Exitdate.
If an entry date entered falls on a not in-session day ([CalendarDay]InSession is null) the enrolment reports will adjust the date to the next in-session day in the calendar.
If an entry or exit date entered falls on an in-session day, the report will use the date as is.
Adding or dropping courses - when a student adds or drops courses, the enrolled minutes for the student increase or decrease. This alerts the report to retest the student for FT, HT, or PT criteria and reviews if the report needs to reflect a transfer from one register to another such as move from part-time to full-time or full-time to part-time. If the attendance type does not change based on the add or drop, the change will not be reflected on the report except in a change to enrolled minutes or calculated FTE.
When adding a course(s), the report uses the date the student added the course ([CC]DateEnrolled) to determine the Internal Admission date on the new register if the enrolment causes the student to move to a different register. If the DateEnrolled is not an in-session day, the report will adjust the date to the next in-session date on the calendar.
When dropping a course(s), the report uses the date the student dropped the course ([CC]Dateleft) to determine the Internal Transfer date on the old register the student is leaving if the drop causes the student to move to a different register. If the DateLeft is not an in-session day, the report will adjust the date to the next in-session date on the calendar.
Homeroom changes - For elementary schools, the report can be grouped by Homeroom ([S_ON_CRS_X]Course_Type = H). When a student changes Homerooms during the year, if the report is grouped by Homeroom, the change must be reflected as an internal transfer from one homeroom and an internal admission into another homeroom. The dates reflected on the report for this circumstance follow the same rules as for adding and dropping a course as described above. If the report is NOT grouped by homeroom, the homeroom change event will NOT be reflected on the report in any way since the change would not alter a student's enrolled minutes or FTE.
Reports have all zero summaries with no detail pages
If the enrolment reports produces only the summary pages showing zeros in all fields and does not produce any detail pages, check the following:
Nightly process is not running or is failing. The report relies on the nightly process to calculate enrolled minutes and place data in the PS_Membership_Defaults table. If there is no data in this table, the report will only produce the summary pages showing zeros in all fields.
Entry and Exit codes - having duplicate entry or exit codes defined, can cause the enrolment reports to fail while rendering the detail pages. Only the summary pages will be produced showing zeros in all fields. Note: A fix has been implemented that should keep this from occurring.
Oracle Error ORA-01438
If the report produces the Oracle error ORA-01438, it is typically because the field size for a computed value was exceeded by the computation result. The most common reason this happens is because a student is erroneously scheduled for more minutes than the school day allows (student is overscheduled). To locate the student causing the this error, do the following:
Run the report for a current selection that contains a smaller number of students, such as all students with a last name starting with "A". If the report runs successfully for the smaller selection, continue to run other small selections until the report fails.
Once the report fails for one of the smaller selection groups, check the scheduled courses for all of the students in the selection. Correct any student schedules that need to be corrected in the selection.
Internal versus External versus Retirement
General information regarding Internal Admissions and Transfers, External Admissions and Transfers, and Retirements.
Student moves from one register to another at the same school, such as going from full-time to part-time will always be reflected as internal admissions and transfers.
Homeroom changes (elementary schools only) at the same school are always reflected as internal admissions and transfers when the report is grouped by Homeroom.
Transfers from one school to another are generally reflected as external admissions and transfers but the report ultimately uses the MINISTRY entry and exit codes to determine internal, external or retirement. If the type of transfer/admission/retirement does not look correct, verify that the association mapping of the school entry/exit codes to the ministry entry/exit codes is correct.
OP and Paid By Data
The OP (Other Pupil) designation is derived based on the student's Board Residence Status. The indicator is set to OP if [S_ON_STU_X]/[S_ON_REN_X]Brd_Res_Status is other than 4 (Pupil of the Board) or 6 (Independent Study).
The "Paid By" text on the Tuition Paid Details report is printed from [S_ON_STU_X]/[S_ON_REN_X]StudentPaidBy. The data on the report is truncated if it is longer than the space allocated on the report.
Changes that require a new enrolment record to display correctly on the report
The following changes require the student's current school enrolment to be ended and a new school enrolment to be created for the report to be able to display the data correctly:
Grade Level changes - grade level changes that cause a student to move from one register to another, such as from a junior kindergarten register to a kindergarten register or from a Grade 1-3 register to a Grade 4-8 register will ONLY be reflected on the Enrolment Reports if a new school enrolment is created for the student for the new grade level. Without the new enrolment, the report has no way of knowing what day the grade level changed.
Changes to Board Residence Status - changes to board residence status require a new enrolment record to be created so the date associated with the change can be captured in the [ReEnrollments] and [Students] table.
Student Name and Student Transfer Information
The student's name as displayed on the report comes from [S_ON_STU_X]Legal_First_Name (if not null) and [S_ON_STU_X]Legal_Last_Name (if not null). If one or both fields are null, the report will pull the corresponding first or last name from [Students]First_Name or [Students]Last_Name.
Transferred out students - when a student is transferred out of one school with the intention of transferring him/her to another school, if the transfer process is NOT completed, the student record becomes "orphaned" in the system (i.e. inactive at the last school attended but not enrolled at the new school). This situation occurs when the following is done in PowerSchool:
The student is transferred out of the current school - Enrollment > Functions > Transfer Out of School. This step sets the student's status ([Students]Enroll_Status) to 2 - Inactive, at the current school.
The student is transferred to another school - Enrollment > Functions >Transfer to Another School. This step sets the student's school ID ([Students]SchoolID) to the ID of the new school. However, the enrolment school ID ([Students]Enrollment_SchoolID) remains as the old school ID. If the process is stopped at this point, the old enrolment record is not moved to the ReEnrollments table.
To complete the process the student must be enrolled at the new school - Enrollment > Functions > Re-Enroll In School. This step will force the old student record to be moved to the ReEnrollments table, will reset the student's enrolment school ID ([Students]Enrollment_SchoolID) to be the ID of the new school and will set the student's status [Students]Enroll_Status to 0 - Currently enrolled. Completing this step ensures that [Students]SchoolID and [Students]Enrollment_SchoolID both contain the new school ID.
If step 3 of the process is not completed, the enrolment reports has logic built in that looks for [Students]Enroll_Status = 2 and [Students]SchoolID != [Students]Enrollment_SchoolID. When it finds this condition, it uses the value in [Students]Enrollment_SchoolID to determine which school's report the student belongs on. In all other cases, the report uses [Students]SchoolID to make this determination.