PSOPRDEFNVW

index back

SELECT OPRID , VERSION , OPRDEFNDESC , EMPLID , EMAILID , OPRCLASS , ROWSECCLASS , ENCRYPTED , SYMBOLICID , LANGUAGE_CD , MULTILANG , CURRENCY_CD , LASTPSWDCHANGE , ACCTLOCK , PRCSPRFLCLS , DEFAULTNAVHP , FAILEDLOGINS , EXPENT , OPRTYPE , USERIDALIAS , LASTSIGNONDTTM , LASTUPDDTTM , LASTUPDOPRID , PTALLOWSWITCHUSER 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

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: ENG

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

FAILEDLOGINS Number(3,0) SMALLINT NOT NULL Failed Login Attempts
EXPENT Number(1,0) SMALLINT NOT NULL Expert Entry

Default: 0

OPRTYPE Number(1,0) SMALLINT NOT NULL Operator Type

Default: 0

USERIDALIAS Character(70) VARCHAR2(70) NOT NULL User ID Alias
LASTSIGNONDTTM DateTime(26) TIMESTAMP Last Signon Date
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.
PTALLOWSWITCHUSER Number(1,0) SMALLINT NOT NULL Allow Switch User

Default: 0

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19