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 NameField TypeColumn TypeDescription
    OPTN_CATEGORY_LVLCharacter(4)VARCHAR2(4) NOT NULLOption 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
    USEROPTNCharacter(12)VARCHAR2(12) NOT NULLUser Option
    OPTN_CATEGORY_GRPCharacter(12)VARCHAR2(12) NOT NULLOption Category Group

    Prompt Table: PSOPTNCATGRPTBL

    OPTN_CATEGORYCharacter(12)VARCHAR2(12) NOT NULLOption Category

    Prompt Table: PSOPTNCATTBL

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    USEROPTN_TYPECharacter(1)VARCHAR2(1) NOT NULLUser Option Type
    1=Restricted
    2=User List
    3=Locale
    F=Functional
    S=System
    LOCALE_BASEDCharacter(1)VARCHAR2(1) NOT NULLLocale Based

    Y/N Table Edit

    Default: N

    FORMAT_CNTLCharacter(2)VARCHAR2(2) NOT NULLFormat control for personalization option values, e.g., Mixedcase, Upper, or Number Only..
    0=Uppercase
    6=Mixedcase
    8=Numbers Only
    FORMATLENGTHNumber(4,0)SMALLINT NOT NULLFormat Length in characters. Except that Images and Attachments in Kb.
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: %EDITTABLE

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    USER_OPTION_VALUECharacter(30)VARCHAR2(30) NOT NULLUser personalization option override value.
    MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

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

    Prompt Table: PSMSGCATDEFN

    IMAGE_NAMECharacter(30)VARCHAR2(30) NOT NULLThe name of images used in Personalizations explanations.

    Prompt Table: CONT_IMAGE_VW

    IMAGE_FIELDImage Reference(30)VARCHAR2(30)Image Reference Field to display images used in Personalizations explanations.
    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.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19