RB_PERS_NAME_V3 (SQL View)	Index Back
Person Name View Operator full name of the multichannel Agent

RB_PERS_NAME_V3

(SQL View)

Person Name View

Operator full name of the multichannel Agent

SELECT BO_NAME , A.PERSON_ID FROM PS_RD_PERSON A ,PS_BO_NAME B ,PSOPRALIAS_VW C WHERE A.BO_ID=B.BO_ID AND A.PERSON_ID=C.OPRALIASVALUE AND OPRALIASTYPE='PER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NAME Character(50) VARCHAR2(50) NOT NULL Name

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID