select s.LastSurname,s.FirstName,s.StaffUniqueId,s.LoginId,d.CodeValue as CodeType
,sic.IdentificationCode,sic.AssigningOrganizationIdentificationCode
from edfi.StaffIdentificationCode sic
left join edfi.Staff s on s.StaffUSI=sic.StaffUSI
left join edfi.Descriptor d on d.DescriptorId=sic.StaffIdentificationSystemDescriptorId
order by s.LastSurname,s.FirstName, d.CodeValue