PSAPMSGARCHST

(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 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