USERIDPrompt Table: PSOPRDEFN_VW
A=Role Added
D=Restricted Role Removed
L=User Locked
S=Role Swapped
U=User Unlocked
C=Change Reverted
F=Failed
O=Open
S=Success
EOSU_USRLOGVW(SQL View) |
Index Back |
|---|---|
User Maintenance log viewSample User Maintenance: User Maintenance log view |
| SELECT USERID ,EOSU_ROLE_ACTION ,EOSU_SUB_STS ,COMMENTS FROM PS_EOSU_USRMAINLOG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: PSOPRDEFN_VW |
| 2 | EOSU_ROLE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Sample User Maintenance- Field shows whether restricted roles where removed or swapped with sample role
A=Role Added D=Restricted Role Removed L=User Locked S=Role Swapped U=User Unlocked |
| 3 | EOSU_SUB_STS | Character(2) | VARCHAR2(2) NOT NULL |
Submission Status
C=Change Reverted F=Failed O=Open S=Success |
| 4 | COMMENTS | Long Character | CLOB | Comment |