IBTRANSACTIONIDDFW_IB_STCK_VW1(SQL View) |
Index Back |
|---|
| SELECT IBTRANSACTIONID , IB_OPERATIONNAME , PUBSTATUS , STATUSSTRING , QUEUENAME FROM PSAPMSGPUBHDR WHERE PUBSTATUS 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 | PUBSTATUS | Number(2,0) | SMALLINT NOT NULL | Publication Status |
| 4 | STATUSSTRING | Character(5) | VARCHAR2(5) NOT NULL | Status String |
| 5 | QUEUENAME | Character(30) | VARCHAR2(30) NOT NULL | Channel Name (see PSQUEUEDEFN). |