File Layouts for MMS
The following table describes the layouts of the MMS export files.
NOTE: All timestamps are presented in UTC with this format: DD-Mon-YYYY HH24:MI:SS
Sent
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
event_uuid |
VARCHAR(36) |
NO |
Internal ID of the event |
|
EVENT_TYPE_ID |
NUMBER |
NO |
Numerical value that denotes the event type for the given event transaction See Contact Event Type IDs for more information. |
|
ACCOUNT_ID |
NUMBER |
NO |
Account number |
|
LIST_ID |
NUMBER |
|
Numerical identifier of the List object used by the campaign |
|
RIID |
NUMBER |
NO |
Unique ID assigned for this specific List record |
|
CUSTOMER_ID |
VARCHAR2(255) |
|
A unique identifier of the recipient/record that matches a customer ID or unique identifier in your system of record |
|
EVENT_CAPTURED_DT |
TIMESTAMP |
NO |
Date and time the system was informed about the event |
|
EVENT_STORED_DT |
TIMESTAMP |
NO |
Date the event transaction was stored into the Event DB |
|
CAMPAIGN_ID |
NUMBER |
NO |
Numerical identifier of the specific campaign |
|
LAUNCH_ID |
NUMBER |
NO |
Numerical identifier of the launch instance |
|
program_id |
NUMBER |
|
Numerical identifier of the Program. -1 if unknown |
|
aggregator_id |
NUMBER |
NO |
Numerical identifier of the aggregator. 2 for Velti |
|
country_code |
VARCHAR2(2) |
|
Mobile country code |
|
VARCHAR2(50) |
NO |
Short or long mobile code |
|
|
mobile_number |
VARCHAR2(255) |
NO |
Mobile phone number |
|
mobile_channel |
VARCHAR2(50) |
NO |
The channel for the event |
|
OFFER_SIGNATURE_ID |
NUMBER |
|
Offers that were sent |
Skipped
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
event_uuid |
VARCHAR2(36) |
NO |
Internal ID of the event |
|
EVENT_TYPE_ID |
NUMBER |
NO |
Numerical value that denotes the event type for the given event transaction See Contact Event Type IDs for more information. |
|
ACCOUNT_ID |
NUMBER |
NO |
Account number (for example. 1234) |
|
LIST_ID |
NUMBER |
|
Numerical identifier for the List object used by the Campaign |
|
RIID |
NUMBER |
NO |
Unique ID assigned for this specific List record |
|
CUSTOMER_ID |
VARCHAR2(255) |
|
A unique identifier of the recipient/record that matches a customer ID or unique identifier in your system of record |
|
EVENT_CAPTURED_DT |
TIMESTAMP |
NO |
Date and time the system was informed about the event. |
|
EVENT_STORED_DT |
TIMESTAMP |
NO |
Date the event transaction was stored into the Event DB. |
|
CAMPAIGN_ID |
NUMBER |
NO |
Numerical identifier of the specific campaign |
|
LAUNCH_ID |
NUMBER |
NO |
Numerical identifier of the launch instance |
|
program_id |
NUMBER |
|
Numerical identifier of the Program. -1 if unknown |
|
aggregator_id |
NUMBER |
|
Numerical identifier of the aggregator. 2 for Velti |
|
COUNTRY_CODE |
VARCHAR2(2) |
|
Mobile country code |
|
MOBILE_CODE |
VARCHAR2(50) |
NO |
Short or long mobile code |
|
MOBILE_NUMBER |
VARCHAR2(255) |
NO |
Mobile phone number |
|
MOBILE_CHANNEL |
VARCHAR2(50) |
NO |
The channel for the event |
|
OFFER_SIGNATURE_ID |
NUMBER |
|
Offers that were sent |
|
REASON |
VARCHAR2(255) |
|
Reason for skipping the message |
Failed
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
event_uuid |
VARCHAR(36) |
NO |
Internal ID of the event |
|
EVENT_TYPE_ID |
NUMBER |
NO |
Numerical value that denotes the event type for the given event transaction See Contact Event Type IDs for more information. |
|
ACCOUNT_ID |
NUMBER |
NO |
Account number (for example. 1234) |
|
LIST_ID |
NUMBER |
|
Numerical identifier for the List object used by the Campaign |
|
RIID |
NUMBER |
NO |
Unique ID assigned for this specific List record |
|
CUSTOMER_ID |
VARCHAR2(255) |
|
A unique identifier of the recipient/record that matches a customer ID or unique identifier in your system of record |
|
EVENT_CAPTURED_DT |
TIMESTAMP |
NO |
Date and time the system was informed about the event. |
|
EVENT_STORED_DT |
TIMESTAMP |
NO |
Date the event transaction was stored into the Event DB. |
|
CAMPAIGN_ID |
NUMBER |
NO |
Numerical identifier of the specific campaign |
|
LAUNCH_ID |
NUMBER |
NO |
Numerical identifier of the launch instance |
|
program_id |
NUMBER |
|
Numerical identifier of the Program. -1 if unknown |
|
aggregator_id |
NUMBER |
|
Numerical identifier of the aggregator. 2 for Velti |
|
COUNTRY_CODE |
VARCHAR2(2) |
|
Mobile country code |
|
MOBILE_CODE |
VARCHAR2(50) |
NO |
Short or long mobile code |
|
MOBILE_NUMBER |
VARCHAR2(255) |
NO |
Mobile phone number |
|
MOBILE_CHANNEL |
VARCHAR2(50) |
NO |
The channel for the event |
|
OFFER_SIGNATURE_ID |
NUMBER |
|
Offers that were sent |
|
REASON |
VARCHAR2(255) |
|
Reason the message failed |