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 Name Field Type Column Type Description
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
IB_MSGTYPE Number(3,0) SMALLINT NOT NULL Message Type
IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
XMLALIAS Character(30) VARCHAR2(30) NOT NULL XML Alias name for a Field or Record in an Application Message.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19