Table of Contents
School Enrolment Summary
This screen is accessed via the School Enrolments tab under the School Enrolments page. Its functionality allows the users to view summarized School Enrolments for students directly using the online PASIprep capabilities. The summarized data will provide details for:
- Authority Summary
- School Summary
- Programming Summary
In addition, there is an aggregation of enrolment data from the Current and Previous year.
Security
The School Enrolment Summary screen is available to both Ministry and Authority/School users with the following permission levels:
Search Criteria
The following selection criteria fields are presented on the context bar in the order of appearance (* denotes mandatory criteria):
| Field Name | Field Type | Description | Editable | Multiple Values Allowed |
|---|---|---|---|---|
| Authority | Drop Down | If O.1, then show all Authorities without a default value. If not O.1, then the user only has access to their authority. | Y | N |
| School | Drop Down | There will be a list of all Schools and they will filter based on the selected Authority. | Y | N |
| School Year | Drop Down | The current School Year will be listed as the default option. The dropdown should contain all Accepted School Years starting from 1990 to current as per UI guidelines. | Y | N |
Processing on Search Criteria
When searching based on the criteria from the context bar. The search will use the selected Authority, School, and School Year to provide data for the grid.The results of the search will be aggregated into the grid. All the rows for each of the views will be added into the grid and be ready to display based on any of the views the user might choose. In other words, all the needed rows to support the Authority Summary, School Summary and Programming Summary will all be in the grid at the same time. The grid’s Summary Type column will be used to filter which set of rows appear for each view. Note: The data is returned from the GetSubmissionStatusSummary_npr stored procedure. The main source of data for the report is the SSEAggregateStatus table. This table is populated via the _RecalculateSSEAggregateStatus_upr stored procedure when calling the GetSubmissionStatusSummary_npr as required (if the data appears out of date – based on the function CheckSchoolRequireSSEAggregateStatusRecal_sfn). This aggregate data is broken down by Programming Type and submission status (code classes: ProgrammingType, SubmissionStatusReportFilter).
Sept 30 counts: These fields are looking for school enrolments with a Registration Start Date of on or before Sept 30 of the selected school year and an Registration Exit Date on or after Sept 30. Deleted enrolments are excluded.
Data Fields
| Field Name | Description | A | S | P |
|---|---|---|---|---|
| Summary Type | A hidden column used for filtering the table when a view is selected. Will contain one of the following values: “Authority”, “School”, and “Programming Type”. | H | H | H |
| Authority | Shows the authority name and code. Formatted as “{Name} (Code)”. | V | V | V |
| Authority Name | Name of Authority. | H | H | H |
| Authority Code | Code of Authority. | H | H | H |
| Authority Classification | Classification or Type of Authority. | V | V | V |
| School Count | Count of Schools returned based on the Context Bar selection criteria. | V | N/A | N/A |
| School | Shows the school name and code. Formatted as “{Name} (Code)”. | N/A | V | V |
| School Name | Name of School associated to Authority. | N/A | H | H |
| School Code | School Code of the school enrolments. | N/A | H | H |
| Programming Type | Programming Type of the school enrolment. | N/A | N/A | V |
| Programming Timeframe | Programming Timeframe of the school enrolment. | N/A | N/A | V |
| Previous Year Enrolments | Number of enrolments from the previous year. | V | V | V |
| Current Year Enrolments | Number of enrolments of the current year. | V | V | V |
| Previous Year Sept 30 Enrolments | Number of enrolments of the previous year as of Sept 30. | V | V | V |
| Current Year Sept 30 Enrolments | Number of enrolments of the current year as of Sept 30. | V | V | V |
Note: The last three columns of the table show if a particular column in the grid is visible (“V”) or hidden (“H” or “N/A”) when that corresponding view is chosen (“A”-Authority Summary, “S”-School Summary, “P”-Programming Summary). Any “N/A” will show as “N/A”.
School Enrolment Summary Section
The section will start with a title of “School Enrolment Summary”. Followed by a grid of the summary data. The grid will support views (See the wiki for guideline information). The available views will be:
- Authority Summary
- School Summary
- Programming Summary
The default view is “Authority Summary”.
View Authority Summary
When Authority Summary view is selected, the data displayed in the data grid will be filtered to show the rows that have a Summary Type of “Authority” and the column visibility will be adjusted. Default sort is by the authority column.
View School Summary
When School Summary view is selected, the data displayed in the data grid will be filtered to show the rows that have a Summary Type of “School” and the column visibility will be adjusted. Default sort is by the authority and then by the school column.
View Programming Summary
When Programming Summary tab is selected, the data displayed in the data grid will be filtered to show the rows that have a Summary Type of “Programming” and the column visibility will be adjusted. Default sort is by the authority, by school, by Programming Type and then by Programming Timeframe column.