Jump to: navigation, search

ETL_CUSTOM_MAP System

The ETL_CUSTOM_MAP table is used to configure mapping of task custom attributes to attributes in the I_/H_TASK_FACT and I_/H_TASK_WORK_FACT tables, as well as the CUSTOM_DIM dimension.

The ETL_CUSTOM_MAP System Table
Field Data Type Description
ETL_CUSTOM_MAP_KEY int Unique mapping record key.
SOLUTION_KEY int Key to the SOLUTION dimension identifying the solution for which this mapping is valid. If NULL, the custom mapping applies to all solutions.
PROCESS_KEY int For which process this mapping is valid. If null applies to all processes.
DEPARTMENT_KEY int Key to the DEPARTMENT dimension.
TYPE varchar(30) Indicates where this custom attribute has been configured. One of the following:
  • taskattribute
  • taskdimension
  • tenant
  • department
  • process
KEY_NAME varchar(255) Custom attribute key name in the Interaction Server database.
IS_DIMENSION int Indicates whether this attribute should be mapped to the CUSTOM_DIM dimension instead of to a fact table.
  • 0 for taskattribute types
  • 1 for other than taskattribute types
CUSTOM_ATTRIBUTE_INDEX int Custom attribute index. If IS_DIMENSION is false (0), 1–10; otherwise 1–5.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.