RBD_PARTNER_VW (SQL View)	Index Back
Dashboard Partner This is the record for the Dashboard Partner view.

RBD_PARTNER_VW

(SQL View)

Dashboard Partner

This is the record for the Dashboard Partner view.

SELECT A.BO_ID , C.SETID , B.BO_NAME_DISPLAY FROM %Table(RD_PARTNER) A , %Table(BO_NAME) B , %Table(BC) C WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND B.PRIMARY_IND = 'Y' AND EXISTS ( SELECT 'X' FROM %Table(BO_ROLE) D WHERE D.ROLE_TYPE_ID = 11 AND A.BO_ID = D.BO_ID)

# 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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object