| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSWD_CNTRL_ON |
Character(1) |
VARCHAR2(1) NOT NULL |
Are Password controls on
|
| 2 |
PSWDEXPIRESDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before password expires
|
| 3 |
PSWDWARNDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Warn of Password Expiration
|
| 4 |
MINPSWDLENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Minimum Password Length
|
| 5 |
PSWDREQSPECIAL |
Number(2,0) |
SMALLINT NOT NULL |
Require Special Digits in Password
|
| 6 |
PSWDREQLOWER |
Number(2,0) |
SMALLINT NOT NULL |
Required Number of Lower Case Alphabets in Password
|
| 7 |
PSWDREQUPPER |
Number(2,0) |
SMALLINT NOT NULL |
Required Number of Upper Case Alphabets in Password
|
| 8 |
PSWDREQDIGITS |
Number(2,0) |
SMALLINT NOT NULL |
Require Digits in Password
|
| 9 |
ALLOWOPRID |
Number(1,0) |
SMALLINT NOT NULL |
Allow Operator ID as password
|
| 10 |
ALLOWPRIEMAIL |
Number(1,0) |
SMALLINT NOT NULL |
Allow primary email as password
|
| 11 |
LOGINATTEMPTS |
Number(4,0) |
SMALLINT NOT NULL |
Maximum Login Attempts
|
| 12 |
PT_HINTDELAY |
Number(4,0) |
SMALLINT NOT NULL |
Maximum Login Attempts
|
| 13 |
LOCKOUTDURATION |
Number(3,0) |
SMALLINT NOT NULL |
Lockout Duration
|
| 14 |
PURGE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Purge User Profiles after
|
| 15 |
PASSWORD_HISTORY |
Number(3,0) |
SMALLINT NOT NULL |
Passwords to Retain
|
| 16 |
PT_PSWD_EXCLUDE_CH |
Character(100) |
VARCHAR2(100) NOT NULL |
Excluded Chars
|