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