RD_CONT_FLTR_VW(SQL View) |
Index Back |
---|---|
My Contacts BO Search filterMy 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 |