RB_USER_ONLY_VW (SQL View)	Index Back
User Business Objects View This view returns business objects that are persons associated with at least one User ID.

RB_USER_ONLY_VW

(SQL View)

User Business Objects View

This view returns business objects that are persons associated with at least one User ID.

SELECT A.BO_ID FROM %Table(BO_ROLE) A WHERE A.ROLE_TYPE_ID = 1 AND A.BO_ID IN ( SELECT B.BO_ID FROM %Table(RD_PERSON) B , %Table(PSOPRALIAS) C WHERE C.PERSON_ID = B.PERSON_ID AND C.OPRALIASTYPE = 'PER')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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