RB_TD_MSGCAT_V1

(SQL View)
 Index Back

Message Catalog

View used to prompt the Message Number for 360-Degree View Setup Components.

SELECT MESSAGE_SET_NBR , MESSAGE_NBR ,MESSAGE_TEXT , MSG_SEVERITY , LAST_UPDATE_DTTM ,DESCRLONG FROM PSMSGCATDEFN

  • Related Language Record: RB_TD_MSGCATLV1

  • Parent record: PSMSGSETDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MESSAGE_SET_NBR01 Number(5,0) INTEGER NOT NULL Message Catalog Number is used to store the message catalog number and dynamically retrieve a message.
    2 MESSAGE_NBR01 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    3 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    4 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
    C=Cancel
    E=Error
    M=Message
    W=Warning

    Default Value: M

    5 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP NOT NULL 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.

    Default Value: %date

    6 DESCRLONG Long Character CLOB Long Description