PSMSGDEFN

(SQL Table)
 Index Back

Application Message Definition

Table for PeopleTools Application Messaging Definition objects. A message is a group of records that is sent between systems. Messages are created and edited using the Application Designer.

  • Related Language Record: PSMSGDEFNLANG

  • Parent Record Of EOIU_SOPUBDEFN EOIU_SOPUB_LNG EOIU_UPGRD_RULE EO_MSGPUBDEFN EO_MSGPUB_LNG PSMSGDEFNLANG PSMSGDFN_LVW PSMSGVER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 XMLALIAS Character(30) VARCHAR2(30) NOT NULL XML Alias name for a Field or Record in an Application Message.
    4 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
    5 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    6 MSGSTATUS Number(1,0) SMALLINT NOT NULL Message Status
    7 NONREPUDIATION Number(1,0) SMALLINT NOT NULL Non-Repudiation Support
    8 VALIDATESTRUCT Number(1,0) SMALLINT NOT NULL Validate Structure
    9 ERRPROCMODE Number(1,0) SMALLINT NOT NULL Error Processing Mode
    10 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    11 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    12 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    13 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    14 ACTIONS Number(4,0) SMALLINT NOT NULL Actions
    15 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
    16 MSGDISPLAYNAME Character(30) VARCHAR2(30) NOT NULL Message Display Name
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    19 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.
    20 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.
    21 DESCRLONG Long Character CLOB Long Description