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 |