Get Graduation School Number

Function Name: PSSR_ON_Common.GetGraduationSchoolNumber

Function Parameters

Student identifier

Function Return Value

School number for the student's school of graduation to be printed on the SHSM Record and Ontario Student Transcript.

Logic

Step 1

Uses [Students]Id to get the [Students]ON_Graduation_School
then
Selects [Schools]Alternate_School_Number, if null [Schools]School_Number
Where [Schools]School_Number = [Students]ON_Graduation_School
Returns the selected value.

If no records found

Step 2

Selects [Schools]Alternate_School_Number, if null [Schools]School_Number
Where [Schools]School_Number = [Students]Schoolid
Returns the selected value.