PSSTATUS(SQL Table) |
Index Back |
|---|---|
PeopleTools System Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |