select s.StudentUniqueId
, s.LastSurname,s.FirstName
,sea.DateOfParentalConsent
,sea.InitialIEPCompletionDate
,dt.CodeValue+'-'+dt.ShortDescription as TimelinessOfInitialIEPDescriptorId
,dr.CodeValue+'-'+dr.ShortDescription as ResultOfInitialIEPDescriptorId
,sea.DaysBeyondTimeline
,dc.CodeValue+'-'+dc.ShortDescription as PartCTransitionTimelinessDescriptorId
from mi.StudentSpecialEducationProgramAssociationExtension sea
left join edfi.Student s on s.StudentUSI=sea.StudentUSI
left join edfi.Descriptor dt on dt.DescriptorId=sea.TimelinessOfInitialIEPDescriptorId
left join edfi.Descriptor dr on dr.DescriptorId=sea.ResultOfInitialIEPDescriptorId
left join edfi.Descriptor dc on dc.DescriptorId=sea.PartCTransitionTimelinessDescriptorId
where sea.DateOfParentalConsent is not null or sea.InitialIEPCompletionDate is not null
                or sea.TimelinessOfInitialIEPDescriptorId is not null
                or sea.ResultOfInitialIEPDescriptorId is not null
                or sea.DaysBeyondTimeline is not null
                or sea.PartCTransitionTimelinessDescriptorId is not null
order by s.LastSurname,s.FirstName