PSOPRDEFN

 index back

Operator Definition

This table defines PeopleSoft Users. This is also a core table for User Profile Manager.

  • Parent record of ACL_WEBLIB_VW ACL_WEBLIB_VW2 AUTHPRCSGRP PRCSRUNCNTLDTL PRCSRUNCNTLEOPT PSACLMENU_VW2 PSACLMENU_VW2_T PSAUTHITEM_VW2 PSAUTHPRCS PSAUTHSIGNON PSMENU_PRMTVW1 PSOPROBJ PSPRCSPRFL PSPRCSRUNCDEL PSPRCSRUNCNTL PSPRCSRUNCNTLS PSROLEUSR_DM_VW PSSIGNON_VW PSUSEREMAIL PSUSERPRSNLDEL PSUSERPRSNLOPTN PSWEBLIBCREFVW

    • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    USERIDALIAS Character(70) VARCHAR2(70) NOT NULL User ID Alias
    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
    PTOPERPSWDV2 Character(92) VARCHAR2(92) NOT NULL An user's password
    OPERPSWDSALT Character(88) VARCHAR2(88) NOT NULL Operator Password for SALT
    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: PSACCESSPROFILE

    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

    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 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20