RB_VALID_ROLTYP (SQL View)	Index Back
Valid Role Type View Available Role Types for a Business Object.

RB_VALID_ROLTYP

(SQL View)

Valid Role Type View

Available Role Types for a Business Object.

SELECT A.BO_ID , B.ROLE_TYPE_ID , B.DESCR FROM PS_BO A , PS_BO_ROLE_TYPE B WHERE A.BO_TYPE_ID = B.BO_TYPE_ID

Related Language Record: RB_VLDRLTYP_LNG

# 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description