Jump to: navigation, search

TENANT Dimension

The TENANT dimension describes the iWD tenant, and the values are populated from the values set up in iWD GAX Plug-in. The tenant forms part of the ownership chain for a task.

The TENANT Dimension
Field Data Type Description
TENANT_KEY int Primary key of this table.
TENANT_CONFIG_ID int iWD GAX Plug-in ID for the tenant
TENANT_CONFIG_EVENT_ID bigint Event that created or updated the tenant record.
TENANT_RUNTIME_ID nvarchar(255) iWD GAX Plug-in runtime ID for the tenant
TENANT_NAME nvarchar(255) Descriptive name of the tenant
CUSTOM_DIM_KEY int Key to the CUSTOM_DIM dimension, identifying custom attributes of the tenant.
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 updated this record.
VALID_FROM datetime The date, in YYYY-M-D HH:MM:SS F format, from which this tenant is valid.
VALID_TO datetime The date, in YYYY-M-D HH:MM:SS F format, until which this tenant is valid.
VERSION int Version of the record.

Feedback

Comment on this article:

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