RC_NONWRK_VW (SQL View)	Index Back
Non worker view A view of all person types that is not worker. It's used as filter record for BO search, search role RC POI.

RC_NONWRK_VW

(SQL View)

Non worker view

A view of all person types that is not worker. It's used as filter record for BO search, search role RC POI.

SELECT A.BO_ID FROM %Table(BO_ROLE) A WHERE A.ROLE_TYPE_ID = 88 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