IB_MSGNAMEIB_MSGVERSIONPSMSGPARTS_VW(SQL View) |
Index Back |
|---|---|
Message PartsParts View |
| SELECT V.MSGNAME , V.APMSGVER , V.IB_MSGSCHEMA , D.OBJECTOWNERID , ' ' FROM PSMSGVER V , PSMSGDEFN D WHERE V.MSGNAME = D.MSGNAME AND V.IB_PARTS = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_MSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Message Name |
| 2 | IB_MSGVERSION |
Character(30) | VARCHAR2(30) NOT NULL | Message Version |
| 3 | IB_MSGSCHEMA | Number(1,0) | SMALLINT NOT NULL | Int Broker Message Schema |
| 4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 5 | IB_ELEMENT_NAME | Character(254) | VARCHAR2(254) NOT NULL | Root Element Name |