PIM_LAST_SY2_VW (SQL View)	Index Back
Last Sync Datetime for a user This view shows the last sync datetime for a user

PIM_LAST_SY2_VW

(SQL View)

Last Sync Datetime for a user

This view shows the last sync datetime for a user

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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	LASTSYNCDATE	DateTime(26)	TIMESTAMP	Creation Date of Device ID