RC_PGMGHHDBK_V

(SQL View)
 Index Back

Call Center Person Name View

Call Center Manager Name View. Used in BU setup.

SELECT DISTINCT ( A.RC_MANAGER ) , B.BO_NAME_DISPLAY , B.LAST_NAME , B.FIRST_NAME FROM PS_RF_PROVIDER_GRP A , PS_RC_MGR_NAME_VW B , PS_SP_RC_VR_HHDVW C WHERE A.RC_MANAGER = B.RC_MANAGER AND A.SETID=( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = C.BUSINESS_UNIT AND D.RECNAME = 'RF_PROVIDER_GRP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.
2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name