IBTRANSACTIONIDDFW_IB_STCK_VW2(SQL View) |
Index Back |
|---|
| SELECT IBTRANSACTIONID , IB_OPERATIONNAME , PUBCONSTATUS , STATUSSTRING , QUEUENAME ,IBPUBTRANSACTID FROM PSAPMSGPUBCON WHERE PUBCONSTATUS NOT IN (1,4,8) |
| # | 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 | PUBCONSTATUS | Number(2,0) | SMALLINT NOT NULL | Publication Contract Status |
| 4 | STATUSSTRING | Character(5) | VARCHAR2(5) NOT NULL | Status String |
| 5 | QUEUENAME | Character(30) | VARCHAR2(30) NOT NULL | Channel Name (see PSQUEUEDEFN). |
| 6 | IBPUBTRANSACTID | Character(36) | VARCHAR2(36) NOT NULL | Orig Transaction ID |