Jump to: navigation, search

EMAIL_FACT Tables

These internal tables are reserved for future use:

  • I_EMAIL_FACT—Intraday data table
  • H_EMAIL_FACT—Historical data table
  • EMAIL_FACT—Blended view of historical and intraday data
Field Data Type Description
INTERACTION_ID nvarchar(64) The Interaction ID, unique within a single Interaction Server database. In the I_EMAIL_FACT table, this field serves as the primary key of the table. In the H_EMAIL_FACT table, this field serves as the primary key together with the LAST_TASK_EVENT_ID field.
LAST_TASK_EVENT_ID bigint Unique identifier for the last event that is associated with the task. Together with INTERACTION_ID, this field serves as the primary key of the H_EMAIL_FACT table.
SOLUTION_KEY int Key to the SOLUTION dimension, describing the solution instance of the task (as configured in iWD GAX Plug-in)—for example, Production versus Test. A solution is assigned as soon as a task is created in the Interaction Server database. A tenant can have more than one solution instance.
TENANT_KEY int Key to the TENANT dimension, describing the tenant of the task (as configured in iWD GAX Plug-in). A tenant is assigned as soon as a task is created in the Interaction Server database.
DEPARTMENT_KEY int Key to the DEPARTMENT dimension, identifying the department that is associated with the task.
PROCESS_KEY int Key to the PROCESS dimension, identifying the parent iWD business process of the task.
MEDIA_TYPE_KEY int Key to the MEDIA_TYPE dimension, identifying a media type, such as work item, or email.
INTERACTION_TYPE_KEY int Key to the INTERACTION_TYPE dimension, identifying an interaction type and subtype.
QA_REVIEW_DISP_CODE_KEY int Key to the QA_REVIEW_DISP_CODE dimension, identifying a disposition code set during QA review.
CUSTOM_DIM_KEY int Key to the CUSTOM_DIM dimension containing five additional attributes (beyond those that are listed below) that can be used to dimension a task.
IS_QA_REVIEW int Indicates whether the email had a QA review: 0 = No, 1 = Yes.
IS_STANDARD_RESPONSE int Indicates whether the email answered with standard response: 0 = No, 1 = Yes.
FROM_ADDRESS nvarchar(255) From email address.
TO_ADDRESSES nvarchar(1024) To email addresses.
CC_ADDRESSES nvarchar(1024) Email addresses in CC.
CURRENT_STATUS_KEY int Key to the STATUS dimension, describing the current status of the task.
LAST_QA_REVIEW_EMPLOYEE_KEY int Key to the AGENT dimension, identifying the last agent who reviewed the task.
PARENT_INTERACTION_ID nvarchar(64) ID to the parent email interaction, If there was one.
COMPLETED_DATE_KEY int Key to the EVENT_DATE dimension, describing the task completion date.
COMPLETED_TIME_KEY int Key to the EVENT_TIME dimension, describing the task completion time.
COMPLETED_INTERVAL int Time interval that is derived from the COMPLETED_DATE_KEY and COMPLETED_TIME_KEY fields. Used for ETL scripts.
COMPLETED_TS int Timestamp for the iWD task’s completed date and time. Used for ETL scripts.
CREATED_INTERVAL int Time interval that is derived from the CREATED_DATE_KEY and CREATED_TIME_KEY fields. Used for ETL scripts.
STOPPED_DATE_KEY int Key to the EVENT_DATE dimension, describing the date on which the task was stopped.
CREATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that created this task fact.
UPDATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this task fact.
This page was last edited on July 6, 2021, at 16:16.
Comments or questions about this documentation? Contact us for support!