EOSU_USRMAINLOG (SQL Table)	Index Back
User log Sample user maintenance: Roles log for swapping back when user is locked again

EOSU_USRMAINLOG

(SQL Table)

User log

Sample user maintenance: Roles log for swapping back when user is locked again

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TXN_NUM Number(6,0) INTEGER NOT NULL The Transaction Number is used by Absence Forecasting. Each forecast process has a unique transaction number.

2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
Prompt Table: PSOPRDEFN_VW

3 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

4 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

5 EOSU_SUB_STS Character(2) VARCHAR2(2) NOT NULL Submission Status
C=Change Reverted
F=Failed
O=Open
S=Success

6 COMMENTS Long Character CLOB Comment

7 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.

8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TXN_NUM	Number(6,0)	INTEGER NOT NULL	The Transaction Number is used by Absence Forecasting. Each forecast process has a unique transaction number.
2	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID Prompt Table: PSOPRDEFN_VW
3	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
4	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
5	EOSU_SUB_STS	Character(2)	VARCHAR2(2) NOT NULL	Submission Status C=Change Reverted F=Failed O=Open S=Success
6	COMMENTS	Long Character	CLOB	Comment
7	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.
8	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.