Mapping manager using USERKEY is not working rather with USERNAME its working

[Diptansu1]

Hello , 

We had one requirement to map users manager with email id field provided while doing flatfile import .

Using below preprocessor JSON it is working :

UPDATE NEWUSERDATA SET NEWUSERDATA.MANAGER=(select CURRENTUSERS.USERNAME from CURRENTUSERS where CURRENTUSERS.EMAIL=NEWUSERDATA.MANAGER)

Need to understand why it is so ?

e.g.

SET MANAGER=CURRENTUSERS.USERKEY ( not working )

SET MANAGER= CURRENTUSERS.USERNAME (working)

From the user table we can see manager field holds only integer (i.e. userkey value) then ideally first logic should have worked . But it is not working . Please suggest .

[rushikeshvartak]

Saviynt internally correlated manager key when user name is provided

[dgandhi]

Manager field of users table holds the userkey of the username.

Thanks