PSOPRDEFN

Return to Index

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 PSAUTHITEM_VW2 PSAUTHPRCS PSAUTHSIGNON PSMENU_PRMTVW1 PSOPROBJ PSPRCSPRFL PSPRCSRUNCDEL PSPRCSRUNCNTL PSPRCSRUNCNTLS PSROLEUSR_DM_VW PSSIGNON_VW PSUSEREMAIL PSUSERPRSNLDEL PSUSERPRSNLOPTN PSWEBLIBCREFVW
  • PeopleSoft Field NameDescription
    OPRIDA user's ID
    VERSIONVersion Number (OBJECTTYPENAME = 'UPM',  also on PSLOCK)

    Internal PeopleTools version for controlling caching of object. 

    OPRDEFNDESCDescription field for a user
    EMPLIDEmployee ID
    EMAILIDA user's E-mail address
    OPRCLASSOperator Class

    Prompt Table: PSCLASSDEFN

    ROWSECCLASSThe class used to determine row level security

    Prompt Table: PSCLASSDEFN

    OPERPSWDAn user's password
    ENCRYPTEDEncrypted Flag
    0=No
    1=Yes
    SYMBOLICIDThe foreign key linking the PSOPRDEFN table to PSACCESSPRFL

    Prompt Table: PSACCESSPRFL

    LANGUAGE_CDLanguage Code translate values

    Default: ENG

    MULTILANGUsed to determine if user is Multilingual
    0=Not Multilingual
    1=Multilingual
    CURRENCY_CDCurrency Code

    Prompt Table: CURRENCY_CD_TBL

    LASTPSWDCHANGEThe date the user last changed their password

    Default: %Date

    ACCTLOCKTo lock out PeopleSoft User Account
    0=Unlocked
    1=Locked
    PRCSPRFLCLSA class that determines a user's process profile

    Prompt Table: PSCLASSDEFN

    DEFAULTNAVHPDefault Navigator Home Page

    Prompt Table: PSCLASSDEFN

    FAILEDLOGINSNumber of Failed Login Attempts
    EXPENTExpert Entry Mode
    0=No (default)
    1=Yes
    OPRTYPEOperator Type

    Default: 0

    USERIDALIASUser ID Alias
    LASTSIGNONDTTMDate/Time of Last Sign-on
    LASTUPDDTTMSpecifies 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.
    LASTUPDOPRIDSpecifies 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.
    PTALLOWSWITCHUSERAllow Switch User
    0=No (default)
    1=Yes

    Author: David Kurtz

    Return to Index

    © David Kurtz  Last updated 01 August 2015