PSPURGEPERMLIST (SQL Table)	Index Back
Permissions List Purge History

PSPURGEPERMLIST

(SQL Table)

Permissions List Purge History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description

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

4 PERMLST_PURGE_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	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	CLASSDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Permission List Description
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
4	PERMLST_PURGE_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.