select s.LastSurname,s.FirstName,s.StudentUniqueId, d.CodeValue as CodeType
,sic.AssigningOrganizationIdentificationCode,sic.IdentificationCode,sic.EducationOrganizationId
from edfi.StudentEducationOrganizationAssociationStudentIdentificationCode sic
left join edfi.Student s on s.StudentUSI=sic.StudentUSI
left join edfi.Descriptor d on d.DescriptorId=sic.StudentIdentificationSystemDescriptorId
order by s.LastSurname,s.FirstName, d.CodeValue