RC_PG_MGR_VW

(SQL View)
Index Back

Call Center Person Name View

Call Center Manager Name View. Used in BU setup.

SELECT DISTINCT C.BUSINESS_UNIT , 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_SUPVW 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 BUSINESS_UNIT_BKLG Character(5) VARCHAR2(5) NOT NULL Business Unit field for Case Backlog operational dashboard chart.
2 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.
3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name