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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user

Default: PSOPRDEFN.OPRDEFNDESC

EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID

Default: PSOPRDEFN.EMPLID

DESCR100Character(100)VARCHAR2(100) NOT NULLLength 100 Description
USRPROF_PURGE_STATCharacter(1)VARCHAR2(1) NOT NULLThis 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

LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19