select distinct eo.NameOfInstitution,s.LastSurname,s.FirstName,dg.CodeValue as GradeLevel,d.CodeValue as PhoneType,tel.TelephoneNumber,tel.OrderOfPriority,tel.DoNotPublishIndicator,tel.TextMessageCapabilityIndicator
from edfi.Student s 
left join edfi.StudentEducationOrganizationAssociationTelephone tel on s.StudentUSI=tel.StudentUSI
left join edfi.Descriptor d on d.DescriptorId=tel.TelephoneNumberTypeDescriptorId
left join edfi.StudentSchoolAssociation ssa on ssa.StudentUSI=s.StudentUSI
left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId
where (ssa.SchoolYear is null or ssa.SchoolYear=(select syt.SchoolYear from edfi.SchoolYearType syt where syt.CurrentSchoolYear=1)) and ssa.StudentUSI is not null
order by eo.NameOfInstitution,s.LastSurname,s.FirstName,tel.OrderOfPriority,d.CodeValue