AMM_FILTER(SQL Table) |
Index Back |
|---|---|
App Msg Monitor FilterThis record is used by the Application Message Monitor to filter messages. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PUB_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Message Instance Status
Prompt Table: APMSGSTATUS |
| 3 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: PSMSGNODEDEFN |
| 4 | ARCHIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
View Archived Messages
Y/N Table Edit Default Value: N |
| 5 | AMM_QUEUE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Queue Type
M=Oper Instance P=Pub Contract S=Sub Contract Default Value: M |
| 6 | AMM_GROUP_BY | Character(1) | VARCHAR2(1) NOT NULL |
Group By
Q=Queue S=Service Operation Default Value: Q |
| 7 | SYNCSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Synchronous Message Status
D=DONE E=ERROR |
| 8 | EXTOPERATIONNAME | Character(254) | VARCHAR2(254) NOT NULL | External Service Name |
| 9 | QUEUENAME | Character(30) | VARCHAR2(30) NOT NULL |
Channel Name (see PSQUEUEDEFN).
Prompt Table: PSQUEUEDEFN |
| 10 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
| 11 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table: PSOPERATION |
| 12 | IB_SEARCH_FROM_DT | Date(10) | DATE | Search From Date |
| 13 | IB_SEARCH_FRM_TIME | Time(15) | TIMESTAMP | Search From Time |
| 14 | IB_SEARCH_TO_DT | Date(10) | DATE | Search To Date |
| 15 | IB_SEARCH_TO_TIME | Time(15) | TIMESTAMP | Search To Time |
| 16 | IB_USERLEVEL | Character(1) | VARCHAR2(1) NOT NULL |
User Level View
Y/N Table Edit Default Value: N |
| 17 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL |
Subscribing Node
Prompt Table: PSMSGNODEDEFN |
| 18 | IB_NWREMOTENODE | Character(30) | VARCHAR2(30) NOT NULL | Ib Network Remote Node Name |
| 19 | IB_DIRECTION | Character(1) | VARCHAR2(1) NOT NULL |
Direction
F=Fault I=Inbound O=Outbound Default Value: O |
| 20 | IB_NWTRCKERNODE | Character(30) | VARCHAR2(30) NOT NULL | Ib Network Remote Node Name |
| 21 | IB_TRKTRANSID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
| 22 | IBCORRELATIONID | Character(36) | VARCHAR2(36) NOT NULL | Correlation ID |