RBD_CONTACT_VW (SQL View)	Index Back
Dashboard Contact This is the record for the Dashboard Contact view.

RBD_CONTACT_VW

(SQL View)

Dashboard Contact

This is the record for the Dashboard Contact view.

SELECT A.BO_ID , B.BO_NAME_DISPLAY , ' ' FROM %Table(RD_PERSON) A , %Table(BO_NAME) B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND EXISTS ( SELECT 'X' FROM %Table(BO_ROLE) D WHERE A.BO_ID = D.BO_ID AND D.ROLE_TYPE_ID = 8 )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
3	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.