CR_USER_MAINT

(SQL Table)
Index Back

User Maintenance Table

Source record used for User ID Clone/Replace Process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BASE_OPRID Character(30) VARCHAR2(30) NOT NULL The base User ID used for creating new user IDs
2 NEW_OPRID Character(30) VARCHAR2(30) NOT NULL New UserID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
5 PROFILE_ACTION Character(1) VARCHAR2(1) NOT NULL User Profile Action
C=Clone User Profile
R=Replace User Profile
6 PROCESSED_FLAG Character(1) VARCHAR2(1) NOT NULL Used for Leave Donations Batch Process to indicate whether to process a request or not.
7 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.
8 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.
9 COMMENTS Long Character CLOB Comment