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