PSOPRDEFN

This table defines PeopleSoft Users. This is also a core table for User Profile Manager.

Parent record of ACL_WEBLIB_VW ACL_WEBLIB_VW2 AUTHPRCSGRP PRCSRUNCNTLDTL PRCSRUNCNTLEOPT PSACLMENU_VW2 PSACLMENU_VW2_T PSAUTHITEM PSAUTHITEM_VW2 PSAUTHPRCS PSAUTHSIGNON PSMENU_PRMTVW1 PSOPROBJ PSPRCSPRFL PSPRCSRUNCDEL PSPRCSRUNCNTL PSPRCSRUNCNTLS PSROLEUSR_DM_VW PSSIGNON_VW PSUSEREMAIL PSUSERPRSNLDEL PSUSERPRSNLOPTN PSWEBLIBCREFVW

PeopleSoft Field Name Description
OPRID A user's ID
VERSION Version Number (OBJECTTYPENAME = 'UPM', also on PSLOCK)
Internal PeopleTools version for controlling caching of object.
OPRDEFNDESC Description field for a user
EMPLID Employee ID
EMAILID A user's E-mail address
OPRCLASS Operator Class
Prompt Table: PSCLASSDEFN
ROWSECCLASS The class used to determine row level security
Prompt Table: PSCLASSDEFN
OPERPSWD An user's password
ENCRYPTED Encrypted Flag
0=No
1=Yes
SYMBOLICID The foreign key linking the PSOPRDEFN table to PSACCESSPRFL
Prompt Table: PSACCESSPRFL
LANGUAGE_CD Language Code translate values
Default: ENG
MULTILANG Used to determine if user is Multilingual
0=Not Multilingual
1=Multilingual
CURRENCY_CD Currency Code
Prompt Table: CURRENCY_CD_TBL
LASTPSWDCHANGE The date the user last changed their password
Default: %Date
ACCTLOCK To lock out PeopleSoft User Account
0=Unlocked
1=Locked
PRCSPRFLCLS A class that determines a user's process profile
Prompt Table: PSCLASSDEFN
DEFAULTNAVHP Default Navigator Home Page
Prompt Table: PSCLASSDEFN
FAILEDLOGINS Number of Failed Login Attempts
EXPENT Expert Entry Mode
0=No (default)
1=Yes
OPRTYPE Operator Type
Default: 0
USERIDALIAS User ID Alias
LASTSIGNONDTTM Date/Time of Last Sign-on
LASTUPDDTTM 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 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.
PTALLOWSWITCHUSER Allow Switch User
0=No (default)
1=Yes
Author: David Kurtz
Return to Index © Go-Faster Consultancy Ltd. Last updated 04 October 2010

PeopleSoft Field Name	Description
OPRID	A user's ID
VERSION	Version Number (OBJECTTYPENAME = 'UPM', also on PSLOCK) Internal PeopleTools version for controlling caching of object.
OPRDEFNDESC	Description field for a user
EMPLID	Employee ID
EMAILID	A user's E-mail address
OPRCLASS	Operator Class Prompt Table: PSCLASSDEFN
ROWSECCLASS	The class used to determine row level security Prompt Table: PSCLASSDEFN
OPERPSWD	An user's password
ENCRYPTED	Encrypted Flag 0=No 1=Yes
SYMBOLICID	The foreign key linking the PSOPRDEFN table to PSACCESSPRFL Prompt Table: PSACCESSPRFL
LANGUAGE_CD	Language Code translate values Default: ENG
MULTILANG	Used to determine if user is Multilingual 0=Not Multilingual 1=Multilingual
CURRENCY_CD	Currency Code Prompt Table: CURRENCY_CD_TBL
LASTPSWDCHANGE	The date the user last changed their password Default: %Date
ACCTLOCK	To lock out PeopleSoft User Account 0=Unlocked 1=Locked
PRCSPRFLCLS	A class that determines a user's process profile Prompt Table: PSCLASSDEFN
DEFAULTNAVHP	Default Navigator Home Page Prompt Table: PSCLASSDEFN
FAILEDLOGINS	Number of Failed Login Attempts
EXPENT	Expert Entry Mode 0=No (default) 1=Yes
OPRTYPE	Operator Type Default: 0
USERIDALIAS	User ID Alias
LASTSIGNONDTTM	Date/Time of Last Sign-on
LASTUPDDTTM	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	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.
PTALLOWSWITCHUSER	Allow Switch User 0=No (default) 1=Yes

Author: David Kurtz
Return to Index	© Go-Faster Consultancy Ltd. Last updated 04 October 2010