RD_CONT_FLTR_VW

(SQL View)
Index Back

My Contacts BO Search filter

My Contacts BO Search filter record

SELECT BO_ID FROM %Table(RD_PERSON) WHERE BO_ID NOT IN ( SELECT BO_ID_CONTACT FROM %Table(RD_CNTCT_CMP_VW) ) AND BO_ID NOT IN ( SELECT BO_ID FROM PS_RB_WORKER WHERE EMPL_STATUS<>'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID