WF_MESSAGE_CAT

index back

WF Message Catalog View


SELECT message_set_nbr , message_nbr , MESSAGE_TEXT , msg_severity , last_update_dttm , %TextIn(descrlong) FROM PSMSGCATDEFN

  • Parent record: PSMSGSETDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
    MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.

    Default: 1

    MESSAGE_TEXTCharacter(100)VARCHAR2(100) NOT NULLMessage Text This field refers to the Text for a particular Message Number in the Message Catalog.
    MSG_SEVERITYCharacter(1)VARCHAR2(1) NOT NULLMessage Severity
    C=Cancel
    E=Error
    M=Message
    W=Warning

    Default: M

    LAST_UPDATE_DTTMDateTime(26)TIMESTAMP NOT NULLSpecifies 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: %date

    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19