select eo.NameOfInstitution,sdi.SchoolId,s.StudentUniqueId,s.LastSurname,s.FirstName
,sdi.IncidentIdentifier,di.IncidentDate,db.CodeValue as BehaviorCode,db.Description as Behavior,di.ReporterName,di.IncidentTime,di.IncidentDescription,dl.Description as Location
,act.DisciplineActionIdentifier,act.DisciplineDate,da.CodeValue as DisciplineCode, da.Description as DisplineDescription
from edfi.StudentDisciplineIncidentAssociation sdi
left join edfi.DisciplineActionStudentDisciplineIncidentAssociation act on act.IncidentIdentifier=sdi.IncidentIdentifier and act.StudentUSI=sdi.StudentUSI
left join edfi.StudentDisciplineIncidentAssociationBehavior sdb on sdb.IncidentIdentifier=sdi.IncidentIdentifier and sdb.StudentUSI=sdi.StudentUSI
left join edfi.Descriptor db on db.DescriptorId=sdb.BehaviorDescriptorId
left join edfi.DisciplineActionDiscipline sda on sda.DisciplineActionIdentifier=act.DisciplineActionIdentifier and sda.StudentUSI=act.StudentUSI
left join edfi.Descriptor da on da.DescriptorId=sda.DisciplineDescriptorId
left join edfi.DisciplineIncident di on di.IncidentIdentifier=sdi.IncidentIdentifier
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sdi.SchoolId
left join edfi.Student s on s.StudentUSI=sdi.StudentUSI
left join edfi.Descriptor dl on dl.DescriptorId=di.IncidentLocationDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName,di.IncidentDate,sdi.IncidentIdentifier,act.DisciplineDate