PORTAL_USER_VW

index back

Operator Definition


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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLOperator Class

Prompt Table: PSCLASSDEFN

ROWSECCLASSCharacter(30)VARCHAR2(30) NOT NULLThe class used to determine row level security

Prompt Table: PSCLASSDEFN

OPERPSWDCharacter(32)VARCHAR2(32) NOT NULLAn user's password
ENCRYPTEDNumber(1,0)SMALLINT NOT NULLEncrypted Flag
SYMBOLICIDCharacter(8)VARCHAR2(8) NOT NULLThe foreign key linking the PSOPRDEFN table to PSACCESSPRFL

Prompt Table: PSACCESSPRFL

LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

Default: LANGUAGE_CD

MULTILANGNumber(1,0)SMALLINT NOT NULLUsed to determine if user is Multi-Lingual
CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code

Prompt Table: CURRENCY_CD_TBL

LASTPSWDCHANGEDate(10)DATE NOT NULLThe date the user last changed their password

Default: %Date

ACCTLOCKNumber(1,0)SMALLINT NOT NULLTo lock out PeopleSoft User Account
PRCSPRFLCLSCharacter(30)VARCHAR2(30) NOT NULLA class that determines a user's process profile

Prompt Table: PSCLASSDEFN

DEFAULTNAVHPCharacter(30)VARCHAR2(30) NOT NULLDefault Navigator Home Page

Prompt Table: PSCLASSDEFN

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.
FAILEDLOGINSNumber(3,0)SMALLINT NOT NULLFailed Login Attempts
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19