Message warehouse fields for Exceptions & Investigations messages
Information that is specific to Exceptions & Investigations messages is stored in the message warehouse view DNF_MWHENI_ou, where ou represents the name of the OU. This is a view of the main message warehouse table DNFMWHENI_ou. It contains one entry for each message.
| Field name | Data type | Mandatory | Description |
|---|---|---|---|
| MWH_WMQI_MSG_ID | CHAR(24) FOR BIT DATA | Yes | The message ID. This ID serves as the primary key in the message warehouse. This ID must be unique within an FTM SWIFT instance, and can be used to identify the information in this and other tables that corresponds to a particular message. Typically, this value is an IBM® MQ generated unique message ID. |
| MWH_CASE_CREATOR | CHAR(11) | No | Value of message field CaseCreator as defined by SWIFT. |
| MWH_CASE_ID | VARCHAR (35) | No | Value of message field CaseId as defined by SWIFT. |