For account import Entitlement hierarchy is making as null.

[Gopi]

Hi experts,

The query for Account Import:

select 'PeopleSoft HR' as Endpoint,  'PeopleSoft HR' as Securitysystem,acc.EMPLID as name,
case when EMPL_STATUS='A' THEN '1' ELSE '2' END AS status,ent.CN as entitlementvale,'memberOf' as enttype
FROM SYSADM.PS_EAP_USER acc FULL OUTER JOIN PS_EAP_SUB useracc ON acc.EMPLID=useracc.EPKIDUSER 
LEFT OUTER JOIN PS_EAP_CAT ent ON useracc.EPKIDENTITLEMENT= ent.PK_EPKID where emplid in ('706081','702676');

Query result:

The problem is that when I do account recon for user 702676 from DB using the above query few accounts without entitlement in DB it's marking as null in the Entitlement hierarchy. Even while querying also I see the same marked as null. How I can overcome this problem? Is it something Saviynt behavior?

I can confirm that there is no null entitlement in Saviynt.

Regards,

Gopi.

[naveenss]

Can you please share the screenshot from the "Associated Entitlement" tab?

[Gopi]

Hi @naveenss 

Apologize that I can see a null entitlement created.

Regards,

Gopi.

[naveenss]

Yes. Looks like the SQL query you have designed has 'null' as a string value for entitlements.  Please tweak your query using CASE statements to handle this.  

[Gopi]

Is it possible to display empty in Entitlement Hierarchy for accounts without entitlement?

Regards,

Gopi.

[rushikeshvartak]

Use left join