select distinct eo.NameOfInstitution, s.LastSurname as StudentLastName, s.FirstName as StudentFirstName , ssa.SchoolYear , ssa.EntryDate , dg.CodeValue as GradeLevel, dg.ShortDescription as GradeLevelDesc , ssa.ExitWithdrawDate, de.CodeValue as ExitWithdrawCode, de.ShortDescription as ExitWithdrawDesc, ssa.PrimarySchool , dr.CodeValue as ResidencyCode, de.ShortDescription as ResidencyDesc, ssa.ClassOfSchoolYear , dp.CodeValue as GradPlanCode, dp.ShortDescription as GradPlanDesc,ssa.GraduationSchoolYear,ssa.RepeatGradeIndicator from edfi.StudentSchoolAssociation ssa left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId left join edfi.Student s on s.StudentUSI=ssa.StudentUSI left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId left join edfi.Descriptor de on de.DescriptorId=ssa.ExitWithdrawTypeDescriptorId left join edfi.Descriptor dr on dr.DescriptorId=ssa.ResidencyStatusDescriptorId left join edfi.Descriptor dp on dp.DescriptorId=ssa.GraduationPlanTypeDescriptorId order by eo.NameOfInstitution,s.LastSurname,s.FirstName