EOEW_MSGCAT_VW

(SQL View)
 Index Back

Message Catalog

Contains text for all error messages and warnings. Messages can be maintained in multiple languages.

SELECT A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_TEXT , A.MSG_SEVERITY FROM PSMSGCATDEFN A WHERE A.MSG_SEVERITY = 'M' AND A.MESSAGE_SET_NBR > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
2 MESSAGE_NBR 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