index back

PeopleSoft Field Name Field Type Column Type Description
DEVICEID Character(36) VARCHAR2(36) NOT NULL Device Identifier
SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number

Default: 1

DEVICEBOOKMARK Character(254) VARCHAR2(254) NOT NULL Mobile Device Bookmark
CHUNKCOUNT Number(9,0) DECIMAL(9) NOT NULL Chunk Count
SERVERBOOKMARK Character(36) VARCHAR2(36) NOT NULL Mobile Server Bookmark
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PLATFORMMOBILE Number(2,0) SMALLINT NOT NULL Mobile Device Platform
CREATIONDATE DateTime(26) TIMESTAMP Creation Date of Device ID
LASTSYNCDATE DateTime(26) TIMESTAMP Creation Date of Device ID
SYNC_RESPONSE Image / Attachment(30) VARCHAR2(30) Last Synchronizatino Response
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20