RD_PERS_NAME_VW (SQL View)	Index Back
Person ID to BO Name This view is intended to be used as part of a related display to determine the name of the Person or Supervisor.

RD_PERS_NAME_VW

(SQL View)

Person ID to BO Name

This view is intended to be used as part of a related display to determine the name of the Person or Supervisor.

SELECT BO_ID , NAME FROM %Table(BO_NAME) WHERE SEQ_NBR = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
Prompt Table: BO

2 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
Default Value: BO_NAME.NAME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID Prompt Table: BO
2	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object Default Value: BO_NAME.NAME