select eo.NameOfInstitution, spt.ShortDescription as Participation,s.LastSurname,s.FirstName,sdia.IncidentIdentifier
, di.IncidentDate, di.IncidentTime,di.IncidentDescription, ilt.ShortDescription as Location
, sdib.BehaviorDetailedDescription, d.ShortDescription as Behavior, d.CodeValue as DisciplineCode, bt.ShortDescription as BehaviorType
, di.ReporterName, dr.ShortDescription as ReporterType
, die.SeriousBodilyInjury, die.SexualAssault
, dpm.ShortDescription as PerceivedMotivation
, doi.ShortDescription as IncidentOthersInvolved
, dsr.ShortDescription as SeclusionRestraint
, st.LastSurname as StaffLast, st.FirstName as StaffFirst
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
left join edfi.Descriptor dr on dr.DescriptorId=di.ReporterDescriptionDescriptorId
left join extension.DisciplineIncidentExtension die on die.SchoolId=di.SchoolId and die.IncidentIdentifier=di.IncidentIdentifier
left join edfi.Descriptor dpm on dpm.DescriptorId=die.DisciplineIncidentPerceivedMotivationDescriptorId
left join edfi.Descriptor doi on doi.DescriptorId=die.DisciplineIncidentOthersInvolvedDescriptorId
left join edfi.Descriptor dsr on dsr.DescriptorId=die.DisciplineIncidentSeclusionRestraintDescriptorId
left join edfi.Staff st on st.StaffUSI=di.StaffUSI
order by eo.NameOfInstitution, s.LastSurname, s.FirstName