| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SYMBOLICID |
Character(8) |
VARCHAR2(8) NOT NULL |
The foreign key linking the PSOPRDEFN table to PSACCESSPRFL
|
| 2 |
STM_ACCESS_ID |
Character(254) |
VARCHAR2(254) NOT NULL |
Access ID (Encrypted)
|
| 3 |
STM_ACCESS_PSWD |
Character(254) |
VARCHAR2(254) NOT NULL |
Access Password (Encrypted)
|
| 4 |
STM_ACCESS_PART1 |
Character(128) |
VARCHAR2(128) NOT NULL |
Access ID IV
|
| 5 |
STM_ACCESS_PART2 |
Character(128) |
VARCHAR2(128) NOT NULL |
Access Pswd IV
|
| 6 |
ENCRYPTED |
Number(1,0) |
SMALLINT NOT NULL |
Encrypted Flag
|
| 7 |
STM_ENCRYPTION_VER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Encryption Version
|
| 8 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|