| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FO_USERID |
Character(70) |
VARCHAR2(70) NOT NULL |
Staffing Apply Online User ID (Email Address)
|
| 2 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 3 |
FO_PASSWORD |
Character(92) |
VARCHAR2(92) NOT NULL |
Password
|
| 4 |
OPERPSWDSALT |
Character(88) |
VARCHAR2(88) NOT NULL |
Operator Password for SALT
|
| 5 |
FO_PWD_ACT_ATTEMPT |
Number(3,0) |
SMALLINT NOT NULL |
Failed Attempts
|
| 6 |
FO_PWD_ACCT_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Locked
|
| 7 |
FO_PWD_SEC_ATTEMPT |
Number(3,0) |
SMALLINT NOT NULL |
Failed Attempts
|
| 8 |
FO_PWD_LASTRESET |
Date(10) |
DATE |
Last Pwd Reset
|
| 9 |
FO_PWD_HINT_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Secret Question ID
|
| 10 |
FO_PWD_HINT_ANS |
Character(50) |
VARCHAR2(50) NOT NULL |
Secret Answer
|
| 11 |
FO_PWD_HINT_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
Password Hint Locked
|
| 12 |
FO_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 13 |
FO_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 14 |
FO_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 15 |
FO_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|