IBTRANSACTIONIDIB_OPERATIONNAMEDFW_IB_STCK_VW3(SQL View) |
Index Back |
|---|
| SELECT IBTRANSACTIONID , IB_OPERATIONNAME , SUBCONSTATUS , STATUSSTRING , QUEUENAME ,IBPUBTRANSACTID FROM PSAPMSGSUBCON WHERE SUBCONSTATUS 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 | SUBCONSTATUS | Number(2,0) | SMALLINT NOT NULL | Subscription Contract Status for Application Messaging |
| 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 |