| # | 
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_MSGSCHEMA | 
Number(1,0) | 
SMALLINT NOT NULL | 
Int Broker Message Schema
 | 
| 5 | 
IB_PARTS | 
Number(1,0) | 
SMALLINT NOT NULL | 
Message Parts
 | 
| 6 | 
IB_NOTUPGRADE | 
Number(1,0) | 
SMALLINT NOT NULL | 
Int Broker Not Upgrade Flag
 | 
| 7 | 
IB_PARTDFLTIND | 
Number(1,0) | 
SMALLINT NOT NULL | 
Message Part Default Indicator
 | 
| 8 | 
IB_EXCLDESCSCHMA | 
Number(1,0) | 
SMALLINT NOT NULL | 
Exclude Description in Schema
 | 
| 9 | 
IB_OCCUROVRD | 
Number(1,0) | 
SMALLINT NOT NULL | 
Single Level 0 Row
 | 
| 10 | 
IB_MESSAGEUSE | 
Number(1,0) | 
SMALLINT NOT NULL | 
Message Use
 | 
| 11 | 
IB_INC_NAMESPACE | 
Number(1,0) | 
SMALLINT NOT NULL | 
Include Namespace
 | 
| 12 | 
IB_SUPPRESSTAGS | 
Number(1,0) | 
SMALLINT NOT NULL | 
Suppress Empty XML Tags
 | 
| 13 | 
IB_PACKAGEID | 
Character(100) | 
VARCHAR2(100) NOT NULL | 
Referenced Package
 | 
| 14 | 
IB_SCHEMANAME | 
Character(100) | 
VARCHAR2(100) NOT NULL | 
Document Name
 | 
| 15 | 
IB_VARIANTNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Version Name
 | 
| 16 | 
IB_ROOTELEMENT | 
Character(50) | 
VARCHAR2(50) NOT NULL | 
Root Element
 | 
| 17 | 
IB_ADS_NAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
ADS Name
 | 
| 18 | 
IB_LANGCODE | 
Number(1,0) | 
SMALLINT NOT NULL | 
Include Language Code
 |