RD_CTCT_NAME_V (SQL View)	Index Back
name for contact list This is the record for the view that shows the Name for the Business Object.

RD_CTCT_NAME_V

(SQL View)

name for contact list

This is the record for the view that shows the Name for the Business Object.

SELECT L.OPRID , L.BO_ID , N.BO_NAME_DISPLAY FROM PS_RD_CONTACT_LIST L , PS_BO_NAME N WHERE L.BO_ID = N.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object