PSMSGVER3_VW

index back

IB view of PSMSGVER.

Filters out messages not meant to be seen in the regular message builder.
SELECT V.MSGNAME , V.APMSGVER , V.IB_MSGTYPE , V.IB_PACKAGEID , V.IB_SCHEMANAME , V.IB_VARIANTNAME , M.XMLALIAS FROM PSMSGVER V , PSMSGDEFN M WHERE V.MSGNAME = M.MSGNAME AND V.IB_MESSAGEUSE = 0

PeopleSoft Field NameField TypeColumn TypeDescription
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVERCharacter(30)VARCHAR2(30) NOT NULLMessage Version
IB_MSGTYPENumber(3,0)SMALLINT NOT NULLMessage Type
IB_PACKAGEIDCharacter(100)VARCHAR2(100) NOT NULLReferenced Package
IB_SCHEMANAMECharacter(100)VARCHAR2(100) NOT NULLDocument Name
IB_VARIANTNAMECharacter(30)VARCHAR2(30) NOT NULLVersion Name
XMLALIASCharacter(30)VARCHAR2(30) NOT NULLXML Alias name for a Field or Record in an Application Message.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19