RC_CNSM_ONLY_VW (SQL View)	Index Back
Consumer Business Objects View This view returns business objects that have consumer role but not worker role.

RC_CNSM_ONLY_VW

(SQL View)

Consumer Business Objects View

This view returns business objects that have consumer role but not worker role.

SELECT A.BO_ID FROM %Table(BO_ROLE) A WHERE A.ROLE_TYPE_ID = 9 AND A.BO_ID NOT IN ( SELECT B.BO_ID FROM %Table(BO_ROLE) B WHERE B.ROLE_TYPE_ID = 4 AND B.BO_ID = A.BO_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