PSOPRDEFN

index back

Operator Definition

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

  • Related language record: PSOPRDEFN_LANG
  • 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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
    EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
    EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
    OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLOperator Class

    Prompt Table: PSCLASSDEFN

    ROWSECCLASSCharacter(30)VARCHAR2(30) NOT NULLThe class used to determine row level security

    Prompt Table: PSCLASSDEFN

    OPERPSWDCharacter(32)VARCHAR2(32) NOT NULLAn user's password
    OPERPSWDSALTCharacter(88)VARCHAR2(88) NOT NULLOperator Password for SALT
    ENCRYPTEDNumber(1,0)SMALLINT NOT NULLEncrypted Flag
    SYMBOLICIDCharacter(8)VARCHAR2(8) NOT NULLThe foreign key linking the PSOPRDEFN table to PSACCESSPRFL

    Prompt Table: PSACCESSPRFL

    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

    Default: ENG

    MULTILANGNumber(1,0)SMALLINT NOT NULLUsed to determine if user is Multi-Lingual
    CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code

    Prompt Table: CURRENCY_CD_TBL

    LASTPSWDCHANGEDate(10)DATE NOT NULLThe date the user last changed their password

    Default: %Date

    ACCTLOCKNumber(1,0)SMALLINT NOT NULLTo lock out PeopleSoft User Account
    PRCSPRFLCLSCharacter(30)VARCHAR2(30) NOT NULLA class that determines a user's process profile

    Prompt Table: PSCLASSDEFN

    DEFAULTNAVHPCharacter(30)VARCHAR2(30) NOT NULLDefault Navigator Home Page

    Prompt Table: PSCLASSDEFN

    FAILEDLOGINSNumber(3,0)SMALLINT NOT NULLFailed Login Attempts
    EXPENTNumber(1,0)SMALLINT NOT NULLExpert Entry

    Default: 0

    OPRTYPENumber(1,0)SMALLINT NOT NULLOperator Type

    Default: 0

    USERIDALIASCharacter(70)VARCHAR2(70) NOT NULLUser ID Alias
    LASTSIGNONDTTMDateTime(26)TIMESTAMPLast Signon Date
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    PTALLOWSWITCHUSERNumber(1,0)SMALLINT NOT NULLAllow Switch User

    Default: 0

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