PIM_LAST_SYN_VW (SQL View)	Index Back
Last Sync Datetime This view show the last sync datatime by each object type for users

PIM_LAST_SYN_VW

(SQL View)

Last Sync Datetime

This view show the last sync datatime by each object type for users

SELECT OPRID , PIM_SEC_TYPE , MAX(LAST_DTTM_UPDATE) FROM PS_PIM_SYNC_HIST GROUP BY OPRID , PIM_SEC_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

2 PIM_SEC_TYPE Character(50) VARCHAR2(50) NOT NULL Used by PIM History

3 LASTSYNCDATE DateTime(26) TIMESTAMP Creation Date of Device ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	PIM_SEC_TYPE	Character(50)	VARCHAR2(50) NOT NULL	Used by PIM History
3	LASTSYNCDATE	DateTime(26)	TIMESTAMP	Creation Date of Device ID