PSARCH_IDPSARCH_BATCHNUMHRS_PERSON_IDHRS_OPRNAME10=Active
20=Inactive
30=Duplicate
HRS_APPLOG_HST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 4 | HRS_OPRNAME |
Character(70) | VARCHAR2(70) NOT NULL | User Name |
| 5 | HRS_OPRPSWD | Character(92) | VARCHAR2(92) NOT NULL | User Password |
| 6 | HRS_OPRPSWDSALT | Character(88) | VARCHAR2(88) NOT NULL | Operator Password for SALT |
| 7 | HRS_OPRSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Login Status
10=Active 20=Inactive 30=Duplicate |
| 8 | HRS_LOGINCOUNT | Number(15,0) | DECIMAL(15) NOT NULL | Login Count |
| 9 | HRS_ACCTLOCK | Number(1,0) | SMALLINT NOT NULL | To lock out PeopleSoft User Account |
| 10 | HRS_FAILEDLOGINS | Number(3,0) | SMALLINT NOT NULL | Failed Login Attempts |
| 11 | HRS_PERM_ACCTLOCK | Number(1,0) | SMALLINT NOT NULL | To lock out PeopleSoft User Account |
| 12 | HRS_SECRET_ATTEMPT | Number(4,0) | SMALLINT NOT NULL | Maximum Login Attempts to answer secret question |
| 13 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 14 | HRS_LASTPSWDRESET | DateTime(26) | TIMESTAMP | Specifies the date and time of the last password reset |