select da.DisciplineActionIdentifier,s.LastSurname,s.FirstName,eo.NameOfInstitution ,da.DisciplineDate,dae.OrderOfDiscipline,da.DisciplineActionLength,da.ActualDisciplineActionLength ,dt.Description as DisciplineType,d.Description as DisciplineDescription, d.ShortDescription as DisciplineShortDescription, d.CodeValue as DisciplineCodeValue ,da.LastModifiedDate,da.CreateDate,d.Namespace from edfi.DisciplineAction da left join edfi.Student s on s.StudentUSI=da.StudentUSI left join edfi.EducationOrganization eo on eo.EducationOrganizationId=da.ResponsibilitySchoolId left join edfi.DisciplineActionDiscipline dad on dad.StudentUSI=s.StudentUSI and dad.DisciplineActionIdentifier=da.DisciplineActionIdentifier left join edfi.DisciplineDescriptor dd on dd.DisciplineDescriptorId=dad.DisciplineDescriptorId left join edfi.Descriptor dt on dt.DescriptorId=dd.DisciplineDescriptorId left join edfi.Descriptor d on d.DescriptorId=dad.DisciplineDescriptorId left join mi.DisciplineActionExtension dae on dae.StudentUSI=da.StudentUSI and dae.DisciplineActionIdentifier=da.DisciplineActionIdentifier order by da.DisciplineDate, s.LastSurname,s.FirstName