RB_PERS_DISPNAM (SQL View)	Index Back
Person Name View CRM ERMS view used for displayingPerson Name

RB_PERS_DISPNAM

(SQL View)

Person Name View

CRM ERMS view used for displayingPerson Name

SELECT BO_NAME_DISPLAY , A.PERSON_ID ,BO_NAME X FROM PS_RD_PERSON A ,PS_BO_NAME B WHERE A.BO_ID=B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name