PSSYNCSERVERVAL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCSESSIONID Number(6,0) INTEGER NOT NULL SYNC_SESSION_ID

2 SYNCTYPEID Number(10,0) DECIMAL(10) NOT NULL SYNC_TYPE_ID

3 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

4 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

5 SYNCROWCOUNT Number(6,0) INTEGER NOT NULL SYNC_ROWCOUNT

6 SYNCSTATUS Character(1) VARCHAR2(1) NOT NULL Synchronous Message Status
D=DONE
E=ERROR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCSESSIONID	Number(6,0)	INTEGER NOT NULL	SYNC_SESSION_ID
2	SYNCTYPEID	Number(10,0)	DECIMAL(10) NOT NULL	SYNC_TYPE_ID
3	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
4	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
5	SYNCROWCOUNT	Number(6,0)	INTEGER NOT NULL	SYNC_ROWCOUNT
6	SYNCSTATUS	Character(1)	VARCHAR2(1) NOT NULL	Synchronous Message Status D=DONE E=ERROR