PIM_SYNC_HIST

(SQL Table)
Index Back

PIM Object History

This record contains statistics for the users being synched in PIM.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PIM_SEC_TYPE Character(50) VARCHAR2(50) NOT NULL Used by PIM History
3 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
4 PIM_SUBSEC_TYPE Character(50) VARCHAR2(50) NOT NULL Used by PIM History
5 PIM_SYNC_STATUS Character(1) VARCHAR2(1) NOT NULL Used by PIM History
C=Confirmed
D=Deleted
E=Error during processing
N=New data from PIM
P=Pending
S=Skip this object