RB_ROLEUSER_VW (SQL View)	Index Back
Role User View Added " AND C.OPRALIASTYPE = 'PER' " to the WHERE clause

RB_ROLEUSER_VW

(SQL View)

Role User View

Added " AND C.OPRALIASTYPE = 'PER' " to the WHERE clause

SELECT D.BO_ID , B.ROLENAME , D.PERSON_ID FROM PS_ROLEXLATOPR A , PSROLEUSER B , PSOPRALIAS C , PS_RD_PERSON D WHERE A.ROLEUSER = B.ROLEUSER AND A.OPRID = C.OPRID AND C.PERSON_ID = D.PERSON_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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person 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	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID