PSSTATUS

(SQL Table)
Index Back

PeopleTools System Control

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

Default Value: 0

11 PTLASTPTCHDTTM DateTime(26) TIMESTAMP Tools Patch Level Change Date

Default Value: %DATE

12 PT_DATABASE_OWNER Character(128) VARCHAR2(128) NOT NULL PT Database Owner