PSIBPROFILEPUB

(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 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
4 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
5 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
6 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
7 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
8 IB_TCA_TIME Number(7,0) INTEGER NOT NULL Target Connector Adapter
9 ONSENDPC Number(7,0) INTEGER NOT NULL OnSend PeopleCode
10 PUBCON_TRANSFORM Number(7,0) INTEGER NOT NULL Outbound Transform
11 IBTUXEDOQUEUESIZE Number(7,0) INTEGER NOT NULL Tuxedo Queue Size
12 GWREQCONNECTOR Number(7,0) INTEGER NOT NULL Target Connector
13 GWREQTRANSFORM Number(7,0) INTEGER NOT NULL Gateway Request Transform
14 GWREQTOTAL Number(7,0) INTEGER NOT NULL Gateway Request Total
15 GWRESPTRANSFORM Number(7,0) INTEGER NOT NULL Gateway Response Transform
16 GWRESPTOTAL Number(7,0) INTEGER NOT NULL Gateway Response Total
17 APPSERVERDBTIME Number(7,0) INTEGER NOT NULL Application Server Database
18 ONREQUESTPC Number(7,0) INTEGER NOT NULL OnRequest PeopleCode
19 ONACKRECVPC Number(7,0) INTEGER NOT NULL OnReceive PeopleCode
20 APPSERVERRECVTIME Number(7,0) INTEGER NOT NULL Integration Service Total
21 PUBCON_TOTAL Number(7,0) INTEGER NOT NULL Publication Contract Total
22 IBPROFILETIMESTAMP DateTime(26) TIMESTAMP IB Profile Timestamp