PSAPMSGARCHPT

(SQL Table)
Index Back

# 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 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
5 IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
6 SEGMENTNO Number(3,0) SMALLINT NOT NULL Segment Number
7 SUBSEGMENTNO Number(3,0) SMALLINT NOT NULL Integration Broker Run-time Sub Segment
8 DATASEQNO Signed Number(11,0) DECIMAL(10) NOT NULL Data Sequence Number
9 UNCOMPMIMEDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Uncompressed MIME Data Length
10 COMPMIMEDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Compressed MIME Data Length
11 MIMEDATALONG Image / Attachment CLOB MIME Data Long