PSMSFPUBDATA

(SQL Table)
Index Back

MSF staging table for pub/sub

MSF staging table for PSAPMSGPUBDATA.

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