MEDIA_CHANNEL Dimension

The MEDIA_CHANNEL dimension describes the type of media or media channel—for example, webform, fax— through which a task is received. This table is populated from task information and is a core iWD attribute.

The MEDIA_CHANNEL Dimension

Field	Data Type	Description
MEDIA_CHANNEL_KEY	int	Primary key of this table.
MEDIA_CHANNEL_NAME	nvarchar(255)	Name of the media channel.
CREATED_ETL_AUDIT_KEY	int	Key to the ETL_AUDIT dimension, identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY	int	Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.