PRG_USR_PROFILE (SQL Table)	Index Back
User Profile Purge History Used in component: PURGE_USR_PROFILE to delete PS User Profiles, the table stores User Profile purge log.

PRG_USR_PROFILE

(SQL Table)

User Profile Purge History

Used in component: PURGE_USR_PROFILE to delete PS User Profiles, the table stores User Profile purge log.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
Default Value: PSOPRDEFN.OPRDEFNDESC

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PSOPRDEFN.EMPLID

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

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

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

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user Default Value: PSOPRDEFN.OPRDEFNDESC
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PSOPRDEFN.EMPLID
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
5	USRPROF_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
6	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.
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.