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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
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.
MESSAGE_TEXTCharacter(100)VARCHAR2(100) NOT NULLMessage Text This field refers to the Text for a particular Message Number in the Message Catalog.
DESCRLONGLong CharacterCLOBLong Description
MSG_SEVERITYCharacter(1)VARCHAR2(1) NOT NULLMessage Severity
C=Cancel
E=Error
M=Message
W=Warning
LAST_UPDATE_DTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19