SDK_PER_SRCHGBL

Platform

View Text

Default

SELECT A.SDK_EMPLID ,C.SDK_OPRID ,B.SDK_EMPL_RCD ,A.SDK_NAME ,A.SDK_LAST_NAME_SRCH ,C.SDK_ACCESS_CD ,A.SYNCID ,A.SDK_SYNCTIMESTAMP ,A.SDK_SSN ,A.SDK_SIN ,A.SDK_NAT_INS_CD ,A.SDK_SSN_FRA ,A.SDK_SIN_GER ,A.SDK_NATIONAL_ID FROM PS_SDK_PERS_DATA A ,PS_SDK_JOB B ,PS_SDK_SCRTY_DEPT C WHERE C.SDK_ACCESS_CD='Y' AND A.SDK_EMPLID=B.SDK_EMPLID AND (B.SDK_EFFDT>=%CurrentDateIn OR B.SDK_EFFDT= ( SELECT MAX(D.SDK_EFFDT) FROM PS_SDK_JOB D WHERE B.SDK_EMPLID=D.SDK_EMPLID AND B.SDK_EMPL_RCD=D.SDK_EMPL_RCD AND D.SDK_EFFDT<=%CurrentDateIn)) AND EXISTS ( SELECT 'X' FROM PS_SDK_PSTREENODE E WHERE E.SDK_SETID=' ' AND E.SDK_TREE_NAME='DEPT_SECURITY' AND E.SDK_EFFDT=C.SDK_TREE_EFFDT AND E.SDK_TREE_NODE=B.SDK_DEPTID AND E.SDK_TREE_NODE_NUM BETWEEN C.SDK_TREE_NODE_NUM AND C.SDK_TREE_NODE_END AND NOT EXISTS ( SELECT 'X' FROM PS_SDK_SCRTY_DEPT G WHERE C.SDK_OPRID=G.SDK_OPRID AND C.SDK_TREE_NODE_NUM<>G.SDK_TREE_NODE_NUM AND E.SDK_TREE_NODE_NUM BETWEEN G.SDK_TREE_NODE_NUM AND G.SDK_TREE_NODE_END AND G.SDK_TREE_NODE_NUM BETWEEN C.SDK_TREE_NODE_NUM AND C.SDK_TREE_NODE_END))

PeopleSoft Field Name	Description
SDK_EMPLID	SDK Employee ID
SDK_OPRCLASS	SDK Operator Class
SDK_EMPL_RCD	SDK Employment Record Number
SDK_NAME	SDK Name
SDK_LAST_NAME_SRCH	SDK Last Name Search
SDK_ACCESS_CD	SDK Access Code N=No Access Y=Read/Write Access
SYNCID	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
SDK_SYNCTIMESTAMP	SDK Synchronization Timestamp
SDK_SSN	SDK Social Security Number
SDK_SIN	SDK Social Insurance Number
SDK_NAT_INS_CD	SDK National Insurance Number
SDK_SSN_FRA	SDK Social Security Number (France)
SDK_SIN_GER	SDK Social Insurance Number (Germany)
SDK_NATIONAL_ID	SDK National ID

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010