PSIBPUBSLAVE

(SQL Table)
Index Back

IB Publication Secondary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
2 IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
3 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
4 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
5 QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
6 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Channel
7 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
10 SLAVEPROCESSNAME Character(15) VARCHAR2(15) NOT NULL Secondary Process Name
11 APPSERVER_PATH Character(64) VARCHAR2(64) NOT NULL Application Server Path