PIM_LAST_SY3_VW (SQL View)	Index Back
Last sync datetime for a user This view is an outer join view which would show defined users even without a proper sync datetime

PIM_LAST_SY3_VW

(SQL View)

Last sync datetime for a user

This view is an outer join view which would show defined users even without a proper sync datetime

SELECT A.USERID , A.PIM_DEFAULT_ID , B.LASTSYNCDATE FROM PS_PIM_USERS_VW A LEFT OUTER JOIN PS_PIM_LAST_SY2_VW B ON A.USERID = B.USERID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PIM_PREF_ID Character(10) VARCHAR2(10) NOT NULL Used by PIM Preference

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_PREF_ID	Character(10)	VARCHAR2(10) NOT NULL	Used by PIM Preference
3	LASTSYNCDATE	DateTime(26)	TIMESTAMP	Creation Date of Device ID