RSF_RT_WF_MGR_V

(SQL View)
 Index Back

Lead Telemarktg Agent and Mgr

Returns the telemarketing agent and the Manager's person_id from RB_WORKER record.

SELECT DISTINCT A.PERSON_ID , B.PERSON_ID FROM PS_RB_WORKER A , PS_RB_WORKER B WHERE ((A.PERSON_ID = B.PERSON_ID) OR (A.PERSON_ID = B.SUPERVISOR_ID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 PERSON_ID_AGENT Character(15) VARCHAR2(15) NOT NULL Person ID Agent