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