PSAPMSGARCHTMP2

(SQL Table)
Index Back

IB Feed Archive Temp

This is a table used by IB Feed Archive process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
2 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
4 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
5 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
6 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=NO
Y=YES

Y/N Table Edit

Default Value: N