| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 IBTRANSACTIONID |
Character(36) |
VARCHAR2(36) NOT NULL |
Transaction ID
|
| 2 |
IB_TYPE |
Number(3,0) |
SMALLINT NOT NULL |
Type
|
| 3 |
BCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
|
| 4 |
DATASEQNO |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Data Sequence Number
|
| 5 |
IB_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 6 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|
| 7 |
UNCOMPDATALEN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Data Length
|
| 8 |
IB_SCHEMADATA |
Image / Attachment |
CLOB |
Int Broker Message Schema Data
|