BO_ROLE_VW3 (SQL View)	Index Back
Business Object Role Business Object Role defines Business Contact -- this is used on the Adhoc Roles page to limit the roles showing up on that page.

BO_ROLE_VW3

(SQL View)

Business Object Role

Business Object Role defines Business Contact -- this is used on the Adhoc Roles page to limit the roles showing up on that page.

SELECT BO_ID , ROLE_TYPE_ID FROM PS_BO_ROLE WHERE ROLE_TYPE_ID IN (86, 87)

# 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 ROLE_TYPE_ID3 Number(3,0) SMALLINT NOT NULL Role Type 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 Prompt Table: BO
2	ROLE_TYPE_ID3	Number(3,0)	SMALLINT NOT NULL	Role Type ID