PSIBPROFILESUB

(SQL Table)
Index Back

# 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 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
4 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
5 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
6 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
7 ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
8 SUBCON_PEOPLECODE Number(7,0) INTEGER NOT NULL OnNotify PeopleCode
9 SUBCON_TOTAL Number(7,0) INTEGER NOT NULL Subscription Contract Total
10 IBTUXEDOQUEUESIZE Number(7,0) INTEGER NOT NULL Tuxedo Queue Size
11 IBPROFILETIMESTAMP DateTime(26) TIMESTAMP IB Profile Timestamp