Get employee ID from NMBRS API

Question

I have to query employee salaries information for statistical analysis. But using invantive-control and invantive query tool all EmployeeId fields are empty. And I need this field to add additional information. My question is how can I get EmployeeID in these tables. I am using the following query:

select top 10 PartitionID
,      EmployeeId
,      ID
,      Value 
from   EmployeeSalaries@nmbrs 

The result table:

I get similar results in tables:

• EmployeeFunctions
• EmployeeEmployments
• EmployeeSchedules

(and other tables miss EmployeeId as well)