RC_MGR_NAME_VW

(SQL View)
Index Back

Call Center Person Name View

Call Center Manager Name View. Used in BU setup.

SELECT p.PERSON_ID , n.BO_NAME_DISPLAY , n.LAST_NAME , n.FIRST_NAME FROM PS_BO_NAME n , PS_RD_PERSON p WHERE n.BO_ID = p.BO_ID

# 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