PIM_DELETED_CNT

(SQL View)
Index Back

PIM Deleted Contact view

This view shows all the existing contacts which has been marked as deleted by PIM

SELECT PIM_KEY , USERID , PIM_CATEGORY , PIM_DELETED FROM PS_PIM_CNTS_INFO WHERE PIM_DELETED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIM_KEY Character(50) VARCHAR2(50) NOT NULL This field is used to store key values from PIM interface
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
3 PIM_CATEGORY Character(254) VARCHAR2(254) NOT NULL Used by PIM History
4 PIM_DELETED Character(1) VARCHAR2(1) NOT NULL Used by PIM_CNTS_INFO for keeping track of deleted objects

Y/N Table Edit