SDK_PER_SRCHGBL

index back

SDK Personal Search - Global

SDK Personal Search - Global
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 NameField TypeColumn TypeDescription
SDK_EMPLIDCharacter(11)VARCHAR2(11) NOT NULLSDK Employee ID
SDK_OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLSDK Operator Class
SDK_EMPL_RCDNumber(3,0)SMALLINT NOT NULLSDK Employment Record Number
SDK_NAMECharacter(50)VARCHAR2(50) NOT NULLSDK Name
SDK_LAST_NAME_SRCHCharacter(30)VARCHAR2(30) NOT NULLSDK Last Name Search
SDK_ACCESS_CDCharacter(1)VARCHAR2(1) NOT NULLSDK Access Code
N=No Access
Y=Read/Write Access
SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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_SYNCTIMESTAMPDateTime(26)TIMESTAMPSDK Synchronization Timestamp
SDK_SSNCharacter(9)VARCHAR2(9) NOT NULLSDK Social Security Number
SDK_SINCharacter(9)VARCHAR2(9) NOT NULLSDK Social Insurance Number
SDK_NAT_INS_CDCharacter(9)VARCHAR2(9) NOT NULLSDK National Insurance Number
SDK_SSN_FRACharacter(13)VARCHAR2(13) NOT NULLSDK Social Security Number (France)
SDK_SIN_GERCharacter(12)VARCHAR2(12) NOT NULLSDK Social Insurance Number (Germany)
SDK_NATIONAL_IDCharacter(15)VARCHAR2(15) NOT NULLSDK National ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19