Student Diploma Deficiency Report

Creates a report to identify students missing graduation requirements.

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 enrolled in the school on the effective date (defaults to the system date).
System date must fall within the selected term:
- If the system date is before the term start date (summer before school starts), the term start date is used.
- If the system date is after the term end date (summer after school ends), the term end date is used.
Students must be in one of the grades selected on the run page to be included in the report.
Student must be assigned a Diploma Type 1, 4, 5, or 6.
Student board residence status must not be 08 (shared), or 09 (online) for the student to be included in the report.
Student must bot have earned his diploma (diploma date not populated).
Studen must meet at least one of the following:
- Not enough credits earned to graduate.
- OSSLT is not completed.
- Missing community hours.
- If student enrolled in SHSM program (Diploma type is 4 or 6)
  - if Only Show Students Missing Requirements flag is selected, then the student is included only if “SHSM Credits - Earned” + “SHSM Credits - Potential” is less than “SHSM Credits - Required”
  - if Only Show Students Missing Requirements flag is not selected, the student will be included only if “SHSM Credits - Earned” is less than “SHSM Credits - Required”
  - Student is missing SHSM Required Certificate
  - Student is missing SHSM Optional Certificate
- Student is enrolled in OYAP-FAST and
  - “OYAP-FAST - Earned” is less than 8.
  - or Registered as an Apprentice is not selected.
  - or RTA is not Assigned.
OL credit earned is not NA or is less than 2.
If Ignore Student Exclusion is unchecked, a student must be excluded from processing if either of the following conditions is true:
- State Reporting Exclusion Flag
  The student has the Exclude From Provincial Reporting flag enabled ([Students]State_ExcludeFromReporting=1).
- OR
- Enrollment Type = 'EX' (Excluded)
  Any enrollment record (from Students or ReEnrollments) associated with the student has EnrollmentType = 'EX', and this enrollment overlaps with the run date. Overlap occurs when the enrollment’s start and end dates include the run date in whole or in part.

Students are included if neither conditions apply.

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.
Grade Level	Choose all applicable grade levels to include in the report. There is an All Grades option to select.
Effective Date	Select the enrollment date for students to include in the report. Students must be enrolled on this date to appear in the report. The default is the current date.
Include Current Courses	Select to include the courses the student is currently enrolled. This is unchecked by default.
Include Future Courses	Select to include the courses the students will be enrolled in the future. This is unchecked by default.
Only Show Students Missing Requirements	Select to include the students who have missing requirements. This is unchecked by default.
Ignore Student Exclusion	Select to disregard student exclusions. This is unchecked by default. Student selection is described in the Selection criteria.

Report Output

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

Data Element	Description	[Table]FieldName
School Name	The name of the school the report is run.	If defined [S_ON_SCH_X]Alt_School_Name, otherwise [Schools]Name
Student OEN	The student’s Ontario Education Number.	[Students]State_StudentNumber
Student Name	The student’s Preferred Name. Format: Last, First, Middle	[Students]Last_Name [Students]First_Name [Students]Middle_Name
Grade	Student grade level as of the effective date.
Grad Plan	The graduation plan selected for the student. Navigation: Student, PostSecondary Readiness, Graduation Plan Selection, Graduation Contracts	name ( start year - end year)
Diploma	The Diploma assigned to the student.	[PSSR_ON_Student_Status]getDiplomaType ([Students].id)
Compulsory Credits - Earned	Total compulsory credits earned to date.	Calculated
Optional Credits - Earned	Total optional credits earned to date.	Calculated
Compulsory Credits - Potential Earned	Displays the earned credits plus potential credits from current compulsory courses. This field is included only if the Include Current Courses flag is selected.	Calculated
Optional Credits - Potential Earned	Displays the earned credits plus optional credits from current optional courses. This field is included only if the Include Current Courses flag is selected.	Calculated
Categories Missing	Displays the missing categories, separated by commas. The categories displayed depend on whether "Include Current Courses" is selected.
Future Course Selection	Displays the courses selected for the future, separated by commas. The courses displayed depend on whether "Include Future Courses" is selected.
Community Hours Missing	The value displayed is based on whether “Community Involvement Hours Waived” flag is selected. If the “Community Involvement Hours Waived” flag is selected: If Adjusted Hours is zero, then this field is zero. If Adjusted Hours is greater than zero, then: Adjusted Hours − Earned Hours. If the result is negative, then this field is zero. If the “Community Involvement Hours Waived” flag is not selected If the student has completed at least 40 hours, the output is 0. If not, then the number of additional hours required to reach 40 is output.
OSSLT	Based on the student’s OSSLT status, the report outputs one of the following: Not Reported, Not Completed, Successfully Completed (for English, French, or Both), or Not Applicable.	[PSSR_ON_Common]LiteracyRequirement
Enrolled in OLC/CCL Course	Report output Yes if the Include current courses is selected, and the student is currently enrolled in a OLC/CCL course. Otherwise, this field is left blank.
OL Credit Earned	The Online Learning Credit Earned. Valid values: Blank, 0.00, 0.50, 1.00, 1.50, 2.00 or NA This value is capped at 2.00 Credits	PSSR_ON_common.GetStudentOnlineLearningRequirement
SHSM Credits - Required	The required SHSM credits displays based on the following criteria: If the student is not assigned a diploma type 4 or 6, this field is blank. If the student is assigned a diploma type 4 or 6 but is not enrolled in any SHSM program, this field displays “?”. If the student is assigned a diploma type 4 or 6 , and is enrolled in at least one SHSM program: a. If any SHSM program has an “All Requirements Met” date, the total number of required credits for the earliest program is displayed. b. If no program has an “All Requirements Met” date, the total number of required credits for the student’s primary SHSM program is printed.
SHSM Credits - Earned	The required SHSM credits displays based on the following criteria: Student not assigned a diploma (4 or 6), this field is blank Student assigned diploma (4 or 6) but not enrolled in SHSM program, this field displays “?”. Student has SHSM program with "All requirements met" date, the total earned credits from the earliest completed program displays. Student has multiple SHSM programs (none completed), then the total number of earned credits for the student’s primary SHSM program is printed. Student has no SHSM credits earned, 0.00 is displayed.
SHSM Credits - Potential	The potential SHSM credits displays based on the following criteria: Student assigned diploma (4 or 6) but not enrolled in SHSM program: displays "?" Is left blank if any of these apply: Student not assigned diploma (4 or 6) Student has at least one SHSM program with "All requirements met" date Earned SHSM credits equal or exceed required SHSM credits Otherwise, the total potential current SHSM credits is dispalyed if "Include Current Courses" is selected
SHSM Required Certificate Missing	The missing required SHSM certification displays based on the following criteria: If Student assigned diploma (4 or 6) but not enrolled in SHSM program, "?" is displayed. Is left blank if either applies: Student not assigned diploma (4 or 6) OR Student has at least one SHSM program with "All requirements met" date Otherwise, for the primary SHSM program: the total required mandatory certificates minus total earned certificates is displayed if result is greater than zero (0); otherwise, left blank,
OYAP-FAST - Earned	The OYAP-FAST value displays based on the following criteria: Is left blank, if the student is not assigned diploma (5 or 6) Student assigned diploma (5 or 6) but not enrolled in OYAP-FAST program, then 0.00 is displayed Otherwise, the total OYAP-FAST coop credits earned as of the effective date for the selected program are displayed
Registered as Apprentice	Indicates whether the student is a registered apprentice. Is left blank, if the student is not assigned a diploma ( 5 or 6) Otherwise, set to Yes, if the flag on the student record is selected, otherwise No
RTA Assigned	Indicates whether the student is assigned RTA. Is left blank if the student is not assigned a diploma ( 5 or 6), otherwise Yes if at least one RTA is assigned to the student; otherwise No.