EIM SQL Employee Positions

I modified some existing script in order to find out the employee positions based on USER ID.

-----
SELECT
S_CONTACT.ROW_ID,S_CONTACT.FST_NAME, S_CONTACT.LAST_NAME,
S_USER.LOGIN,
NAME AS 'Position'
FROM S_CONTACT, S_PARTY_PER, S_PARTY, S_USER
WHERE (S_CONTACT.ROW_ID=S_PARTY_PER.PERSON_ID AND
S_PARTY_PER.PARTY_ID=S_PARTY.ROW_ID
AND S_CONTACT.ROW_ID = S_USER.PAR_ROW_ID
) AND
(S_CONTACT.EMP_FLG='Y' AND S_PARTY.PARTY_TYPE_CD='Position')
AND S_USER.LOGIN='ABCDE'
--
But in UI, I see less positions of this user than the query result. I want to know why? Maybe some positions are old positions that has been removed/deleted?

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.