RC_PG_MGR_VW(SQL View) |
Index Back |
---|---|
Call Center Person Name ViewCall 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 |