PSUSEROPTNDEFN

 index back

User Personalization Admin

Administrator table for setting personalization defaults and determining which options a user may personalize.

  • Related language record: PSUSEROPTNLANG

  • Parent record: PSOPTNCATLVL_VW

    • PeopleSoft Field Name Field Type Column Type Description
    OPTN_CATEGORY_LVL Character(4) VARCHAR2(4) NOT NULL Option Category Level
    CRM=Customer Relationship Mgmt
    CSTM=Custom
    EPM=Enterprise Performance Mgmt
    FIN=Financials
    HRMS=Human Capital Management
    LS=Enterprise Learning Management
    PPTL=PeopleTools
    SCM=Supply Chain Management
    USEROPTN Character(12) VARCHAR2(12) NOT NULL User Option
    OPTN_CATEGORY_GRP Character(12) VARCHAR2(12) NOT NULL Option Category Group

    Prompt Table: PSOPTNCATGRPTBL

    OPTN_CATEGORY Character(12) VARCHAR2(12) NOT NULL Option Category

    Prompt Table: PSOPTNCATTBL

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    USEROPTN_TYPE Character(1) VARCHAR2(1) NOT NULL User Option Type
    1=Restricted
    2=User List
    3=Locale
    F=Functional
    S=System
    LOCALE_BASED Character(1) VARCHAR2(1) NOT NULL Locale Based

    Y/N Table Edit

    Default: N

    FORMAT_CNTL Character(2) VARCHAR2(2) NOT NULL Format control for personalization option values, e.g., Mixedcase, Upper, or Number Only..
    0=Uppercase
    6=Mixedcase
    8=Numbers Only
    FORMATLENGTH Number(4,0) SMALLINT NOT NULL Format Length in characters. Except that Images and Attachments in Kb.
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: %EDITTABLE

    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    USER_OPTION_VALUE Character(30) VARCHAR2(30) NOT NULL User personalization option override value.
    MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

    IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.

    Prompt Table: CONT_IMAGE_VW

    IMAGE_FIELD Image Reference(30) VARCHAR2(30) Image Reference Field to display images used in Personalizations explanations.
    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.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20