Community Involvement Certificate Eligibility Report

This report lists of students who qualify for the Minister’s Community Involvement Certificates by showing their approved community involvement hours and assigning them to the Bronze (50-99 hours), Silver (100-199 hours), or Gold (200+ hours) tier for certificate ordering. The report can be run at both school and district levels. The report is unavailable for elementary and summer schools. The report output is in spreadsheet format.

Eligible students will be assigned only one tier: Bronze, Silver, or Gold.

Prerequisites

Community involvement hours must be recorded in PowerSchool before running this report. Hours are entered and managed on the student's Community Hours page.

Navigation: Start Page, Student Selection, Ontario Provincial Information, Community Hours

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.

Student Selection

Student must be in Grade 12.
Student must have 50 or more community involvement hours as of the selected effective date.
Student is active on the effective date, or
Student is inactive but meets the following conditions:
- Graduated this year from the reporting school:
  - Graduation school is blank, or set to the school running the report (If set to a different school, the student is excluded)
- Diploma Date:
  - Falls within the student’s enrollment period at the reporting school, and
  - Falls within the school start and end dates for the reporting year (year where the effective date falls)
- Exited the school, but the reporting school is the latest school
  - The most recent enrollment is at the school running the report, and
  - The Exit Code (using Ministry exit codes, not customer‑defined codes) is not one of the following:
    64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 18

Report Input

For help with navigation and running the report, refer to How to Find and Generate a Report.

Field	Description
Current Selection Students	Choose whether to run the report for the current selection of students or search students based on the school with the All students option. The Selected Students Only option is selected by default.
Schools to include*	When running from district, choose one of the following: Only schools where the grade level is higher than 8 and that are not closed or excluded from state reporting, and are not summer schools are included Select Multiple Schools – Select and hold the CTRL key and click to select the schools you want to be included in the report. If you select this option, at least one school must be selected from the list. All Schools - Files are created for all schools in the District. When run from a school level, the default selection is Current School Only.
As of the Effective Date	Select the effective date used for student selection. Defaults to the system date. If the system date is before the school year start date, it defaults to the school year start date If the system date is after the school year end date, it defaults to the school year end date.

Field

Description

Current Selection Students

Choose whether to run the report for the current selection of students or search students based on the school with the All students option. The Selected Students Only option is selected by default.

Schools to include*

When running from district, choose one of the following:

Only schools where the grade level is higher than 8 and that are not closed or excluded from state reporting, and are not summer schools are included

Select Multiple Schools – Select and hold the CTRL key and click to select the schools you want to be included in the report. If you select this option, at least one school must be selected from the list.
All Schools - Files are created for all schools in the District.

When run from a school level, the default selection is Current School Only.

As of the Effective Date

Select the effective date used for student selection. Defaults to the system date.

If the system date is before the school year start date, it defaults to the school year start date
If the system date is after the school year end date, it defaults to the school year end date.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Data Element	Additional Information	[Table] Field Name	Field Length
School Name	The name of the school in which the student is currently enrolled or was last enrolled.	If defined [S_ON_SCH_X]Alt_School_Name, otherwise [Schools]Name	200
Student Number	The student's student number.	[Students]Student_Number	32
OEN	The student’s unique Ontario Education Number.	[Students]State_StudentNumber	20
Student Name	The student’s name. Format: Last, First, Middle.	[S_ON_STU_X]Legal_Last_Name [S_ON_STU_X]Legal_First_Name S_ON_STU_X]Legal_Middle_Name [Students]Last_Name [Students]First_Name [Students]Middle_Name	200
Grade	Student grade level as of the effective date. This report is only for Grade 12.	[Students]Grade_Level	5
Homeroom	The student's homeroom assignment.	[Students]Home_Room	30
Diploma Type	The diploma the student is enrolled in.	[S_ON_STU_X]Diploma_Type [PSSR_ON_Student_Status]getDiplomaType	100
Diploma Requirements Met Date	The date on which the student met all the diploma requirements.	[S_ON_STU_X]Diploma_Date	N/A
Total Community Hours	The sum of all approved community involvement hours for the student.	[S_ON_STU_Community_Hours_C]Number_Of_Hours
Certificate	The certificate tier (Bronze, Silver, or Gold) assigned based on the student's total community involvement hours.	Calculated	10