SDK_PER_SRCHGBL

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
1 SDK_EMPLID Character(11) VARCHAR2(11) NOT NULL SDK Employee ID
2 SDK_OPRCLASS Character(30) VARCHAR2(30) NOT NULL SDK Operator Class
3 SDK_EMPL_RCD Number(3,0) SMALLINT NOT NULL SDK Employment Record Number
4 SDK_NAME Character(50) VARCHAR2(50) NOT NULL SDK Name
5 SDK_LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL SDK Last Name Search
6 SDK_ACCESS_CD Character(1) VARCHAR2(1) NOT NULL SDK Access Code
N=No Access
Y=Read/Write Access
7 SYNCID Number(10,0) DECIMAL(10) NOT NULL 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.
8 SDK_SYNCTIMESTAMP DateTime(26) TIMESTAMP SDK Synchronization Timestamp
9 SDK_SSN Character(9) VARCHAR2(9) NOT NULL SDK Social Security Number
10 SDK_SIN Character(9) VARCHAR2(9) NOT NULL SDK Social Insurance Number
11 SDK_NAT_INS_CD Character(9) VARCHAR2(9) NOT NULL SDK National Insurance Number
12 SDK_SSN_FRA Character(13) VARCHAR2(13) NOT NULL SDK Social Security Number (France)
13 SDK_SIN_GER Character(12) VARCHAR2(12) NOT NULL SDK Social Insurance Number (Germany)
14 SDK_NATIONAL_ID Character(15) VARCHAR2(15) NOT NULL SDK National ID