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 Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: PSCLASSDEFN

ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

Prompt Table: PSCLASSDEFN

OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password
ENCRYPTED Number(1,0) SMALLINT NOT NULL Encrypted Flag
SYMBOLICID Character(8) VARCHAR2(8) NOT NULL The foreign key linking the PSOPRDEFN table to PSACCESSPRFL

Prompt Table: PSACCESSPRFL

LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values

Default: LANGUAGE_CD

MULTILANG Number(1,0) SMALLINT NOT NULL Used to determine if user is Multi-Lingual
CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

LASTPSWDCHANGE Date(10) DATE NOT NULL The date the user last changed their password

Default: %Date

ACCTLOCK Number(1,0) SMALLINT NOT NULL To lock out PeopleSoft User Account
PRCSPRFLCLS Character(30) VARCHAR2(30) NOT NULL A class that determines a user's process profile

Prompt Table: PSCLASSDEFN

DEFAULTNAVHP Character(30) VARCHAR2(30) NOT NULL Default Navigator Home Page

Prompt Table: PSCLASSDEFN

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.
FAILEDLOGINS Number(3,0) SMALLINT NOT NULL Failed Login Attempts
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19