RA_USER_ONLY_VW (SQL View)	Index Back
Business Objects with a User This view returns all persons that have been assigned at least one user ID.

RA_USER_ONLY_VW

(SQL View)

Business Objects with a User

This view returns all persons that have been assigned 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