FO_PWD_CONFIG(SQL Table) |
Index Back |
|---|---|
Password Control ConfigThis is the main record to store Password Control Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_PWD_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Password Control
N=No Y=Yes |
| 2 | FO_PWD_EXPIRES | Character(1) | VARCHAR2(1) NOT NULL |
Password Expiry
N=No Y=Yes |
| 3 | FO_PWD_EXP_DAYS | Number(3,0) | SMALLINT NOT NULL | Password expires in Days |
| 4 | FO_PWD_DIGITS | Number(3,0) | SMALLINT NOT NULL | Digits |
| 5 | FO_PWD_LCASE | Number(3,0) | SMALLINT NOT NULL | Lowercase |
| 6 | FO_PWD_UCASE | Number(3,0) | SMALLINT NOT NULL | Uppercase |
| 7 | FO_PWD_LEN | Number(3,0) | SMALLINT NOT NULL | Minimum Length |
| 8 | FO_PWD_SPL | Number(3,0) | SMALLINT NOT NULL | Special Characters |
| 9 | FO_PWD_SECQ_ENABL | Character(1) | VARCHAR2(1) NOT NULL |
Secret Question
N=No Y=Yes Y/N Table Edit |
| 10 | FO_PWD_SEC_ATTEMPT | Number(3,0) | SMALLINT NOT NULL | Failed Attempts |
| 11 | FO_PWD_ACCT_LOCK_E | Character(1) | VARCHAR2(1) NOT NULL |
Account Lock
N=No Y=Yes |
| 12 | FO_PWD_ACT_ATTEMPT | Number(3,0) | SMALLINT NOT NULL | Failed Attempts |
| 13 | FO_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 14 | FO_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 15 | FO_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 16 | FO_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |