PORTAL_USER_VW

(SQL View)
 Index Back

Operator Definition


SELECT OPRID ,VERSION ,OPRDEFNDESC ,EMPLID ,EMAILID ,OPRCLASS ,ROWSECCLASS ,PTOPERPSWDV2 ,ENCRYPTED ,SYMBOLICID ,LANGUAGE_CD ,MULTILANG ,CURRENCY_CD ,LASTPSWDCHANGE ,ACCTLOCK ,PRCSPRFLCLS ,DEFAULTNAVHP ,LASTUPDDTTM ,LASTUPDOPRID ,FAILEDLOGINS FROM PSOPRDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
6 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: PSCLASSDEFN

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

Prompt Table: PSCLASSDEFN

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

Prompt Table: PSACCESSPROFILE

11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: LANGUAGE_CD

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

Prompt Table: CURRENCY_CD_TBL

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

Default Value: %Date

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

Prompt Table: PSCLASSDEFN

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

Prompt Table: PSCLASSDEFN

18 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.
19 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.
20 FAILEDLOGINS Number(3,0) SMALLINT NOT NULL Failed Login Attempts