PURGE_ROLEDEFN

index back

User Profile Purge History

Keeps track of the user Roles as they are removed from the system.

PeopleSoft Field Name Field Type Column Type Description
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
ROLEDEFN_PURG_STAT Character(1) VARCHAR2(1) NOT NULL This field will indicate whether or not an Operator's USER PROFILE has been deleted. It is a simple Y/N flag. (see XLAT)
N=Not Purged
Y=Purged

Default: N

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.
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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19