select s.StudentUSI 
, dd.CodeValue as DisabilityCode, dd.ShortDescription as Disability
, spe.PlanDate, dp.CodeValue as TypeOfPlanCode, dp.ShortDescription as TypeOfPlan, spe.AdditionalPlanDate
, de.CodeValue as PrimaryEdSettingCode, de.ShortDescription as PrimaryEducationSetting
, spe.PlacedByAnotherDistIEP
, spe.Section52FTE, spe.Section53FTE
, 'To be determined' as SpecEdExitReason
, 'To be determined' as EndDate
from edfi.StudentSpecialEducationProgramAssociation sea
left join edfi.StudentSpecialEducationProgramAssociationDisability dis on dis.StudentUSI=sea.StudentUSI and dis.BeginDate=sea.BeginDate
left join edfi.StudentProgramAssociation spa on spa.StudentUSI=sea.StudentUSI and sea.BeginDate=sea.BeginDate and spa.ProgramName=sea.ProgramName
left join edfi.Descriptor dd on dd.DescriptorId=dis.DisabilityDescriptorId
left join mi.StudentSpecialEducationProgramAssociationExtension spe on spe.StudentUSI=sea.StudentUSI and spe.BeginDate=sea.BeginDate and spe.ProgramName=sea.ProgramName
left join edfi.Descriptor dp on dp.DescriptorId=spe.TypeOfPlanDescriptorId
left join edfi.Descriptor de on de.DescriptorId=sea.SpecialEducationSettingDescriptorId
left join mi.StudentProgramAssociationExtension spae on spae.StudentUSI=sea.StudentUSI and spae.BeginDate=sea.BeginDate and spae.ProgramName=sea.ProgramName
left join edfi.Student s on s.StudentUSI=sea.StudentUSI
order by s.LastSurname, s.FirstName, sea.BeginDate