RC_WORKER_360_S

(SQL View)
Index Back

worker 360 view srh

search record for worker 360-degree view search

SELECT DISTINCT p.EMPLID , n.BO_NAME , n.BO_NAME_DISPLAY , p.BO_ID , p.SYNCID FROM PS_RD_PERSON p , PS_BO_NAME n , PS_BO_ROLE r WHERE p.BO_ID = n.BO_ID AND p.BO_ID = r.BO_ID AND r.ROLE_TYPE_ID = 4 AND n.PRIMARY_IND = 'Y' AND p.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
5 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.