MSGNAMEAPMSGVERPSIBSCHEMAS_VW(SQL View) |
Index Back |
|---|---|
IB Schemas. |
| SELECT V.MSGNAME , V.APMSGVER , V.IB_MSGSCHEMA , V.IB_INC_NAMESPACE , D.OBJECTOWNERID FROM PSMSGVER V , PSMSGDEFN D WHERE V.MSGNAME = D.MSGNAME |
| # | 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_MSGSCHEMA | Number(1,0) | SMALLINT NOT NULL | Int Broker Message Schema |
| 4 | IB_INC_NAMESPACE | Number(1,0) | SMALLINT NOT NULL | Include Namespace |
| 5 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |