PSSTATUS

index back

PeopleTools System Control


PeopleSoft Field Name Field Type Column Type Description
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
OWNERID Character(8) VARCHAR2(8) NOT NULL SQL Owner ID
TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
LASTREFRESHDTTM DateTime(26) TIMESTAMP NOT NULL Last Swap Refresh Stamp
LASTCHANGEDTTM DateTime(26) TIMESTAMP Used to identify the last time the object was changed
OWNERACCT Character(8) VARCHAR2(8) NOT NULL SQL Owner Acct
UNICODE_ENABLED Number(1,0) SMALLINT NOT NULL Unicode Enabled
DBID Character(32) VARCHAR2(32) NOT NULL DBID
DATABASE_OPTIONS Number(10,0) DECIMAL(10) NOT NULL Database optional features
PTPATCHREL Number(2,0) SMALLINT NOT NULL Tools Patch Level

Default: 0

PTLASTPTCHDTTM DateTime(26) TIMESTAMP Tools Patch Level Change Date

Default: %DATE

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20