PSMENUDEFN

(SQL Table)
Index Back

Menu Definition

  • Related Language Record: PSMENUDEFNLANG
  • Parent Record Of PSMENUITEM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 MENUGROUP Character(30) VARCHAR2(30) NOT NULL Menu Group
    4 INSTALLED Number(1,0) SMALLINT NOT NULL Installed
    5 GROUPORDER Number(5,0) INTEGER NOT NULL Menu Group Order
    6 MENUORDER Number(5,0) INTEGER NOT NULL Menu Order
    7 GROUPSEP Number(5,0) INTEGER NOT NULL Menu Group Separator
    8 MENUSEP Number(5,0) INTEGER NOT NULL Menu Separator
    9 MENULABEL Character(30) VARCHAR2(30) NOT NULL Menu Label
    10 MENUTYPE Number(1,0) SMALLINT NOT NULL Menu Type
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    13 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.
    14 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.
    15 DESCRLONG Long Character CLOB Long Description