MSGNAMEAPMSGVERPSMSGVER3_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. |