PSOPRDEFN

(SQL Table)
 Index Back

Operator Definition

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

  • Parent Record Of EM_ROLEUSRDM_VW EOPM_MNU_DVW EOPM_MNU_DVW1 EORC_RCOPR_VW IN_WO_RNCTL_DFT PRCSRUNCNTL_VW PSAUTHITEM_VW2 PSAUTHPRCS PSAUTHSIGNON PSOPROBJ PSPRCSPRFL PSPRCSRUNCDEL PSPRCSRUNCNTL PSPRCSRUNCNTLS PSROLEUSR_DM_VW PSSIGNON_VW PSUSEREMAIL PSUSERPRSNLDEL PSUSERPRSNLOPTN PSWEBLIBCREFVW SF_RUNCNTL_DFLT SP_DB_USER_PREF SUP_FLUSR_RL_VW

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

    Prompt Table: PSCLASSDEFN

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

    Prompt Table: PSCLASSDEFN

    9 OPERPSWD Character(32) VARCHAR2(32) NOT NULL An user's password
    10 PTOPERPSWDV2 Character(92) VARCHAR2(92) NOT NULL An user's password
    11 OPERPSWDSALT Character(88) VARCHAR2(88) NOT NULL Operator Password for SALT
    12 ENCRYPTED Number(1,0) SMALLINT NOT NULL Encrypted Flag
    13 SYMBOLICID Character(8) VARCHAR2(8) NOT NULL The foreign key linking the PSOPRDEFN table to PSACCESSPRFL

    Prompt Table: PSACCESSPROFILE

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

    Default Value: ENG

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

    Prompt Table: CURRENCY_CD_TBL

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

    Default Value: %Date

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

    Prompt Table: PSCLASSDEFN

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

    Prompt Table: PSCLASSDEFN

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

    Default Value: 0

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

    Default Value: 0

    24 LASTSIGNONDTTM DateTime(26) TIMESTAMP Last Signon Date
    25 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.
    26 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.
    27 PTALLOWSWITCHUSER Number(1,0) SMALLINT NOT NULL Allow Switch User

    Default Value: 0

    28 PTACCTLOCKDATE Date(10) DATE The date the user account will be autmatically locked