PORTAL_USER_VW

Platform	View Text
Default	SELECT OPRID ,VERSION ,OPRDEFNDESC ,EMPLID ,EMAILID ,OPRCLASS ,ROWSECCLASS ,OPERPSWD ,ENCRYPTED ,SYMBOLICID ,LANGUAGE_CD ,MULTILANG ,CURRENCY_CD ,LASTPSWDCHANGE ,ACCTLOCK ,PRCSPRFLCLS ,DEFAULTNAVHP ,LASTUPDDTTM ,LASTUPDOPRID ,FAILEDLOGINS FROM PSOPRDEFN

PeopleSoft Field Name	Description
OPRID	A user's ID
VERSION	Internal PeopleTools version to control reloading of objects in cache.
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
SYMBOLICID	The foreign key linking the PSOPRDEFN table to PSACCESSPRFL Prompt Table: PSACCESSPRFL
LANGUAGE_CD	Language Code translate values Default: LANGUAGE_CD
MULTILANG	Used to determine if user is Multi-Lingual
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
PRCSPRFLCLS	A class that determines a user's process profile Prompt Table: PSCLASSDEFN
DEFAULTNAVHP	Default Navigator Home Page Prompt Table: PSCLASSDEFN
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.
FAILEDLOGINS	Failed Login Attempts

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010