PSIBPROFILESYNC

(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_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
3 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
4 IB_TCA_TIME Number(7,0) INTEGER NOT NULL Target Connector Adapter
5 GWREQCONNECTOR Number(7,0) INTEGER NOT NULL Gateway Request Connector
6 GWREQTRANSFORM Number(7,0) INTEGER NOT NULL Gateway Request Transform
7 GWREQTOTAL Number(7,0) INTEGER NOT NULL Gateway Request Total
8 TRANSFORMIB Number(7,0) INTEGER NOT NULL Reply Transform
9 ONROUTEPC Number(7,0) INTEGER NOT NULL OnRoute PeopleCode
10 ONREQUESTPC Number(7,0) INTEGER NOT NULL OnRequest PeopleCode
11 GWRESPTRANSFORM Number(7,0) INTEGER NOT NULL Gateway Response Transform
12 GWRESPTOTAL Number(7,0) INTEGER NOT NULL Gateway Response Total
13 ONSENDPC Number(7,0) INTEGER NOT NULL OnSend PeopleCode
14 TRANSFORMOB Number(7,0) INTEGER NOT NULL Request Transform
15 APPSERVERSENDTIME Number(7,0) INTEGER NOT NULL Synchronous Total
16 APPSERVERRECVTIME Number(7,0) INTEGER NOT NULL Integration Service Total
17 SYNCTYPE Character(4) VARCHAR2(4) NOT NULL Synchronous Type
18 IBPROFILETIMESTAMP DateTime(26) TIMESTAMP IB Profile Timestamp