select eo.NameOfInstitution,s.LastSurname,s.FirstName,dg.CodeValue as GradeLevel
,spa.ProgramName, pt.ShortDescription as ProgramType, spa.BeginDate, spa.EndDate, de.ShortDescription as ReasonExited
,spa.ServedOutsideOfRegularSession, spa.EnrollmentStatus
from edfi.StudentProgramAssociation spa
left join edfi.ProgramType pt on pt.ProgramTypeId=spa.ProgramTypeId 
left join edfi.Program p on p.ProgramTypeId=spa.ProgramTypeId and p.EducationOrganizationId=spa.ProgramEducationOrganizationId and p.ProgramName=spa.ProgramName
left join edfi.Student s on s.StudentUSI=spa.StudentUSI
left join edfi.StudentSchoolAssociation ssa on ssa.StudentUSI=s.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId
left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId
left join edfi.Descriptor de on de.DescriptorId=spa.ReasonExitedDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName