PSIBSUBSLAVE

(SQL Table)
Index Back

IB Subscription 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 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
4 QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
5 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Channel
6 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
7 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.
8 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
9 SLAVEPROCESSNAME Character(15) VARCHAR2(15) NOT NULL Secondary Process Name
10 APPSERVER_PATH Character(64) VARCHAR2(64) NOT NULL Application Server Path