select eo.NameOfInstitution, s.LastSurname, s.FirstName , ifsp.ReferralDate ,dra.CodeValue as ReferralAgencyCode, dra.ShortDescription as ReferralAgency ,dtime.CodeValue as IFSPTimelinessCode, dtime.ShortDescription as IFSPTimelinessDescriptor ,dres.CodeValue as ResultOfInitialIFSPCode, dres.ShortDescription as ResultOfInitialIFSP ,ifsp.InitialIFSPDate from mi.StudentEarlyLearningProgramAssociationIndividualizedFamilyServicePlan ifsp left join edfi.Descriptor dra on dra.DescriptorId=ifsp.ReferralAgencyDescriptorId left join edfi.Descriptor dtime on dtime.DescriptorId=ifsp.IFSPTimelinessDescriptorId left join edfi.Descriptor dres on dres.DescriptorId=ifsp.ResultOfInitialIFSPDescriptorId left join edfi.Student s on s.StudentUSI=ifsp.StudentUSI left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ifsp.EducationOrganizationId order by eo.NameOfInstitution,s.LastSurname,s.FirstName