RB_WRK_DUMMY_VW

(SQL View)
 Index Back

Worker Primary Name

This view returns no values. It is used as a prompt table for the direct report drop down list box on My Worklist component. This list box is populated via PeopleCode, thus it is not necessary to load values from a prompt table using Tools.

SELECT A.PERSON_ID , B.BO_NAME_DISPLAY FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.BO_NAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object