F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)

DV = Default value

In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

MEDIA_TYPE_KEY

MEDIA_SERVER_ROOT_IXN_ID

If an interaction belongs to a thread but is not the root interaction of the thread, this field indicates the interaction ID of the root interaction in the thread; otherwise, this field is null. This value might not be unique.

Note: A configuration option, max-thread-duration-after-inactive-in-days, affects the definition of a thread in Genesys Info Mart, and, therefore, affects how this field is set. If a new interaction is a continuation of an old thread that has already expired (because of the configuration option), then Genesys Info Mart does not consider the interaction to be the continuation of a thread; instead, the interaction is considered to be the beginning (root) of a new thread. As such, this field will be null for the new interaction, and subsequent continuations of the new thread will refer to this interaction as the root interaction.

MEDIA_SERVER_IXN_ID

The interaction ID, as reported by the interaction media server for the first call in the interaction. This ID might not be unique. In the case of voice interactions, the ID is the numeric version of the hexadecimal T-Server Conn ID. This field is not populated for multimedia.

MEDIA_SERVER_ROOT_IXN_GUID

If an interaction belongs to a thread but is not the root interaction of the thread, this field indicates the root interaction GUID that represents the original interaction in the thread, as reported by the interaction media server and ICON; otherwise, this field is null. This value might not be unique.

Note: A configuration option, max-thread-duration-after-inactive-in-days, affects the definition of a thread in Genesys Info Mart, and, therefore, affects how this field is set. If a new interaction is a continuation of an old thread that has already expired (because of the configuration option), then Genesys Info Mart does not consider the interaction to be the continuation of a thread; instead, the interaction is considered to be the beginning (root) of a new thread. As such, this field will be null for the new interaction; however, subsequent continuations of the new thread will still refer to the original root interaction GUID, as reported by ICON.

MEDIA_SERVER_IXN_GUID

The interaction GUID, as reported by the interaction media server. This GUID might not be unique. In the case of T-Server voice interactions, the GUID is the Call UUID. In the case of multimedia, the GUID is the Interaction ID from Interaction Server.

TARGET_ADDRESS

The target media address that received the interaction, such as DNIS for voice media. This field is not populated for multimedia interactions because there can be multiple target addresses. This value may represent a network resource address.

11 — The record in the G_PARTY table refers to a nonexistent parent record.

12 — The call sequence cannot be established, because a party that is a source of the multi-site call cannot be found. (In other words, a party cannot be identified for this multi-site call that represents a called party in a source call, that either redirected or routed the call to an external site, or initiated a single-step transfer to an external site.)

13 — The record in the GO_CAMPAIGN table refers to a nonexistent group ID.

14 — The cycle was found in the results of the IRF transformation.

15 — Merge processing discarded a stuck G_CALL record.

16 — Merge processing discarded a stuck G_IR record.

17 — A negative duration was detected during IRF, MSF, or IRSF transformation.

18 — The value of the ServiceObjective KVP is not a number.

19 — The record in the G_CALL table refers to a nonexistent call.

20 — A history record with the change type of terminated is followed by another history record for the same party.

21 — The value of the VQID in the G_ROUTE_RESULT table is not unique.

22 — The value of the VQID in the G_VIRTUAL_QUEUE table is not unique.

23 — The value of the MEDIATION_SEGMENT_ID in transformation results is not unique.

24 — The value of the PARTYGUID in transformation results is not unique.

START_TS

END_TS

The UTC-equivalent value of the date and time at which the interaction ended, including any ACW time. If ACW occurs, the record is updated after ACW completes, which might happen in a subsequent ETL cycle.

START_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the interaction started. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.

END_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the interaction ended. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the END_TS timestamp to an appropriate time zone.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

UPDATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.

ANCHOR_ID

Introduced: Release 8.5.003
Identifies the fact (IRF or MSF) that can be considered the current anchor for this interaction in relevant reports. Since multimedia interactions are populated while they are still active, some reports might capture a multimedia interaction before it reaches a handling resource, and later reports might capture the interaction after it has reached a handling resource.

This field is populated as follows:

For voice interactions and for multimedia interactions that have been handled, the value of ANCHOR_ID is based on the INTERACTION_RESOURCE_ID of the INTERACTION_RESOURCE_FACT (IRF) record with IRF_ANCHOR = 1.

For active multimedia interactions that have not yet reached a handling resource (that is, are still in mediation), the value of ANCHOR_ID is based on the MEDIATION_SEGMENT_ID of the MEDIATION_SEGMENT_FACT (MSF) record for the most recent mediation DN.

ANCHOR_SDT_KEY

Introduced: Release 8.5.003
The START_DATE_TIME_KEY value of the fact (IRF or MSF) that is identified by ANCHOR_ID.

This field is populated as follows:

For voice interactions and for multimedia interactions that have been handled, the value of ANCHOR_SDT_KEY equals the START_DATE_TIME_KEY of the IRF identified by ANCHOR_ID.

For active multimedia interactions that have not yet reached a handling resource (that is, are still in mediation), the value of ANCHOR_SDT_KEY equals the START_DATE_TIME_KEY of the MSF identified by ANCHOR_ID.