PURGE_ROLEDEFN (SQL Table)	Index Back
User Profile Purge History Keeps track of the user Roles as they are removed from the system.

PURGE_ROLEDEFN

(SQL Table)

User Profile Purge History

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

4 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 Value: N

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

6 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	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	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 Value: N
5	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.
6	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.