Specialist High Skills Major (SHSM) Record

Introduction

In addition to earning an Ontario Secondary School Diploma (OSSD) or other diploma, students may also qualify for a Specialist High Skills Major (SHSM) based on their course work in certain sector-specific courses and upon acquiring certain certifications. A separate SHSM record is produced for such students. The content and format of this report is set by the ministry.

Selection Criteria

Subject to the “Current Selection Students” parameter below, a student is included in the report if:

The student is enrolled in an SHSM program before the Effective Date.
The student is not excluded from state reporting ([Students]State_ExcludeFromReporting = F)
The student is enrolled in the selected school and is active as of the effective date.

If "Ignore Student Exclusion" is not selected, a student is excluded if either the student's Exclude From Provincial Reporting flag ([Students]State_ExcludeFromReporting) is selected, or if his/her 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 specified effective date (i.e. if there is any overlap between the enrolment start and end dates and the effective date).

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 (this is the default) or have the report search for students based on school, entry date and exit date (All Students). When the current selection is selected, the Grade Level is still considered for inclusion in the report run.
Effective Date	Enter the date that the information on the SHSM Record Report will be effective. Student must be active on the effective date to be included in the report. This date defaults to the system date
SHSM Programs	Choose the SHSM Program to be printed on the report. At least one SHSM Program must be selected.
SHSM Requirements	Choose whether the SHSM Record Report should include students who have completed requirements, students who have not completed requirements, or both. At least one SHSM Requirement must be selected.
Print Watermark	Enabled only if SHSM Requirements is set to ‘Students who have not completed requirements’. Select Yes or No to print a watermark. If Yes is selected, the watermark ‘Partially Completed’ will appear on the report.
Ignore Student Exclusion	Indicate whether the Exclude From Provincial Reporting flag or an attendance type of "EX" (excluded) should exclude a student from the report. If not selected (the default value), a student's flag and attendance type are examined. If selected, a student's flag and attendance type are not considered for student selection.
Print Course Code	To display the course code in the course title under Credits earned, select Yes.

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
For all Students where [Gen]Cat = specprog and [S_ON_GEN_SPECPROG_X]SHSM_Flag = 1 and [PS_Common_Code]Category = SHSM_Program_Type and [SPEnrollments]Enter_Date <= Effective Date and selected ‘SHSM Programs’ parameter = [SpEnrollments]ProgramID and selected ‘SHSM Requirements’ parameter.
Header
Surname	The student’s Legal Last Name.	[S_ON_STU_X]Legal_Last_Name, if blank then [Students]Last_Name
Given Names	The student’s Legal First Name followed by Legal Middle Name/s	[S_ON_STU_X]Legal_First_Name, if blank then [Students]First_Name [S_ON_STU_X]Legal_Middle_Name, if blank then [Students]Middle_Name
School board/School authority	The name of School District.	[Prefs]Value where [Prefs]Name = DISTRICTNAME
School	The name of School.	[PSSR_ON_COMMON] GETGRADUATIONSCHOOLNAME ([Students]ID)
OEN	The student’s Ontario Education Number.	[Students]State_StudentNumber, if blank then [S_ON_STU_X]MIN_Number
Specialist High Skills Major in	The SHSM program in which the student is enrolled.	[PS_Common_Code]Description where [Gen]Cat = specprog and [S_ON_GEN_SPECPROG_X]SHSM_Flag = 1 and [PS_Common_Code]Category = ‘SHSM_Program_Type’
Date of Issue	The date the SHSM was awarded.	[S_ON_SEN_X]SHSM_Program_Date
Credits earned for the Specialist High Skills Major A course appears in this section only if the course is returned by the GetStudentSHSMCourses common function for the student. The logic used by the function is described in Appendix H.
Course	The name of the SHSM course. Note: If you selected the report parameter Print Course Code, the course code displays in the course title.	[StoredGrades]Course_Name
Course Grade/Level	The Grade Level of the SHSM course.	Set to blank if [StoredGrades]Alternate_Course_Number is one of PLE99, QEV1W, QEE99, QMA99, QAP99, QSE99, Otherwise value is based on 4th character of [Courses]Alt_Course_Number: '1' if 4th character is A '2' if 4th character is B '3' if 4th character is C '4' if 4th character is D '5' if 4th character is E '9' if 4th character is 1 '10' if 4th character is 2 '11' if 4th character is 3 '12' if 4th character is 4 '13' if 4th character is 5 'OAC' if 4th character is 0
Credits	The Total Credits awarded for the SHSM Course.	Count of [StoredGrades]EarnedCrHrs
Date completed Year / Month	The date the SHSM course was completed. If a SHSM course is repeated, the completion date for the instance with the highest mark is printed.	If [S_ON_SGR_X]Credit_Date is defined use that value. If [S_ON_SGR_X]Credit_Date is undefined and there is an associated CC record, use the calendar day immediately prior to [CC]DateLeft. If [S_ON_SGR_X]Credit_Date is undefined and there is no associated CC record and [StoredGrades]TermId is defined (i.e. non-zero), use [Terms]LastDay for the associated term. If [S_ON_SGR_X]Credit_Date is undefined and there is no associated CC record and [StoredGrades]TermId is undefined, use [StoredGrades]DateStored (TermID should never be undefined).
Certifications/Training completed for Specialist High Skills Major This section is only populated if the student has completed Certifications/Training for SHSM where [PS_Common_Code]PS_Group = ON_DropDown_SHSM and [PS_Common_Code]Category = Certification_Type
Certifications/Training (# Hours)	SHSM Certifications/Training completed (Number of hours completed).	[S_ON_STU_SHSM_Cert_C]certType ([S_ON_STU_SHSM_Cert_C] Certification_Hours)
Date completed Year / Month	Date the SHSM Certifications/Training was completed.	[S_ON_STU_SHSM_Cert_C]Date_Completed
Footer
The following boxes will only be checked if the student has completed the following SHSM requirements.
Experiential learning and career exploration activities	Marked if the student has completed the experiential learning and career exploration activities.	Will set an X if [S_ON_SEN_X]SHSM_Experiential_Date <= Effective Date
“Reach ahead” experiences	Marked if the student has completed the reach ahead experiences.	Will set an X if [S_ON_SEN_X]SHSM_ReachAhead_Date <= Effective Date
Development of Essential Skills and work habits, and use of the Ontario Skills Passport for the purposes of documentation. OR Sector-partnered contextualized experience in	The student can complete either OSP or SPC but not both. Ontario Skills Passport (OSP) is displayed and marked if the student has completed the development of Essential Skills and work habits, and use of the Ontario Skills Passport for the purposes of documentation Sector-partnered contextualized experience (SPC) is displayed and marked if the student has completed the Sector-Partner Contextualized (SPC) Experience requirement. One or more of the following checkboxes is also selected to indicate which area the student uses to meet the requirement: coding innovation, creativity and entrepreneurship mathematical Note: As of Sept 1 2017, the SPC component replaces the Ontario Skills Passport component as a requirement. However, students can still choose to complete the OSP component requirement instead.	OSP checkbox will set an X if [S_ON_SEN_X]SHSM_SkillDev_Date <= Effective Date. SPC Checkbox is set when at least one of the three requirement areas are completed
This student has met the requirements of the Ontario Secondary School Diploma	Marked if the student meets the requirements of the Ontario Secondary School Diploma.	Will set an X if [S_ON_STU_X]Diploma_Date <= Effective Date
Principal of Secondary School	The signature line only – nothing printed.	N/A
Watermark	“Partially Completed”	Will appear on the record if Print Watermark is set to ‘Yes’ when SHSM Requirements is set to ‘Students who have not completed requirements’ on the report run page.