PSSTATUS

index back

PeopleTools System Control


PeopleSoft Field NameField TypeColumn TypeDescription
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
OWNERIDCharacter(8)VARCHAR2(8) NOT NULLSQL Owner ID
TOOLSRELCharacter(20)VARCHAR2(20) NOT NULLTools Release Number
LASTREFRESHDTTMDateTime(26)TIMESTAMP NOT NULLLast Swap Refresh Stamp
LASTCHANGEDTTMDateTime(26)TIMESTAMPUsed to identify the last time the object was changed
OWNERACCTCharacter(8)VARCHAR2(8) NOT NULLSQL Owner Acct
UNICODE_ENABLEDNumber(1,0)SMALLINT NOT NULLUnicode Enabled
DBIDCharacter(32)VARCHAR2(32) NOT NULLDBID
DATABASE_OPTIONSNumber(10,0)DECIMAL(10) NOT NULLDatabase optional features
PTPATCHRELNumber(2,0)SMALLINT NOT NULLTools Patch Level

Default: 0

PTLASTPTCHDTTMDateTime(26)TIMESTAMPTools Patch Level Change Date

Default: %DATE

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19