| # | 
PeopleSoft Field Name | 
PeopleSoft Field Type | 
Database Column Type | 
Description | 
| 1 | 
 PUBNODE | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Application Messaging Publication Node.  This refers to the Node that the Application Message Instance was published from.
 | 
| 2 | 
 CHNLNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Channel Name (see PSCHNLDEFN).
 | 
| 3 | 
 PUBID | 
Signed Number(11,0) | 
DECIMAL(10) NOT NULL | 
Publication Identifier
 | 
| 4 | 
 MSGNAME | 
Character(30) | 
VARCHAR2(30) NOT NULL | 
Application Message Name.  Name of the Application Message Definition. (see PSMSGDEFN).
 | 
| 5 | 
 SEGMENTNO | 
Number(3,0) | 
SMALLINT NOT NULL | 
Segment Number
 | 
| 6 | 
 SUBSEGMENTNO | 
Number(3,0) | 
SMALLINT NOT NULL | 
Integration Broker Run-time Sub Segment
 | 
| 7 | 
 DATASEQNO | 
Signed Number(11,0) | 
DECIMAL(10) NOT NULL | 
Data Sequence Number
 | 
| 8 | 
UNCOMPMIMEDATALEN | 
Signed Number(11,0) | 
DECIMAL(10) NOT NULL | 
Uncompressed MIME Data Length
 | 
| 9 | 
COMPMIMEDATALEN | 
Signed Number(11,0) | 
DECIMAL(10) NOT NULL | 
Compressed MIME Data Length
 | 
| 10 | 
MIMEDATALONG | 
Image / Attachment | 
CLOB | 
MIME Data Long
 |