PRG_USR_PROFILE

index back

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 Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

Default: PSOPRDEFN.OPRDEFNDESC

EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default: PSOPRDEFN.EMPLID

DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
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: 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