Aşağıdaki sorgu ile sorgulanabilir.
select e.RegistryNumber, per.DisplayName, p.Name, u.Name, u.Code, us.Disabled from VBFAMREPO.dbo.raysHROrganizationUnitPositionMembers upm
join VBFAMREPO.dbo.raysHROrganizationUnitPositions up on up.Id = upm.OrganizationUnitPosition
join VBFAMREPO.dbo.raysHRPositions p on up.Position = p.Id
join VBFAMREPO.dbo.raysHROrganizationUnits u on u.Id = up.Organization
join VBFAMREPO.dbo.raysHREmployee e on upm.Employee = e.Id
join VBFAMREPO.dbo.raysHRUsers us on us.Id = e.Id
join VBFAMREPO.dbo.raysHRPersons per on per.Id = e.Id
WHERE e.RegistryNumber in ('xxxx')