PSMSGVER3_VW

(SQL View)
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 PeopleSoft Field Type Database Column Type Description
1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
3 IB_MSGTYPE Number(3,0) SMALLINT NOT NULL Message Type
4 IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
5 IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
6 IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
7 XMLALIAS Character(30) VARCHAR2(30) NOT NULL XML Alias name for a Field or Record in an Application Message.