select eo.NameOfInstitution, spt.ShortDescription as Participation,s.LastSurname,s.FirstName,sdia.IncidentIdentifier
, di.IncidentDate, di.IncidentDescription, ilt.ShortDescription as Location
, sdib.BehaviorDetailedDescription, d.ShortDescription as Behavior, d.CodeValue as DisciplineCode, bt.ShortDescription as BehaviorType
from edfi.StudentDisciplineIncidentAssociation sdia
left join edfi.DisciplineIncident di on sdia.IncidentIdentifier=di.IncidentIdentifier and sdia.SchoolId=di.SchoolId
left join edfi.StudentDisciplineIncidentAssociationBehavior sdib on sdib.IncidentIdentifier=sdia.IncidentIdentifier and sdia.SchoolId=sdib.SchoolId
left join edfi.StudentParticipationCodeType spt on spt.StudentParticipationCodeTypeId=sdia.StudentParticipationCodeTypeId
left join edfi.Student s on s.StudentUSI=sdia.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sdia.SchoolId
left join edfi.IncidentLocationType ilt on ilt.IncidentLocationTypeId=di.IncidentLocationTypeId
left join edfi.Descriptor d on d.DescriptorId=sdib.BehaviorDescriptorId
left join edfi.BehaviorDescriptor bd on bd.BehaviorDescriptorId=d.DescriptorId
left join edfi.BehaviorType bt on bt.BehaviorTypeId=bd.BehaviorTypeId
order by eo.NameOfInstitution, s.LastSurname, s.FirstName