TS_MSG_VW

index back

Search Result-Msg Catalog Text

Search Result - Message Catalog Text
SELECT R.OPRID , R.TS_SRCH_ID , R.LANGUAGE_CD , R.MESSAGE_SET_NBR , R.MESSAGE_NBR , M.MESSAGE_TEXT ,%TextIn(M.DESCRLONG) , M.MSG_SEVERITY , M.LAST_UPDATE_DTTM FROM PS_TS_RESULT_MSG R ,PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR = R.MESSAGE_SET_NBR AND M.MESSAGE_NBR = R.MESSAGE_NBR

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
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.
DESCRLONG Long Character CLOB Long Description
MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
LAST_UPDATE_DTTM 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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19