Jump to: navigation, search

PROCESS Dimension

All tasks are associated with a business process. Processes are associated with a department in iWD. Populated from iWD GAX Plug-in configurations, the PROCESS dimension contains information about iWD processes.

The PROCESS Dimension
Field Data Type Description
PROCESS_KEY int Primary key of this table.
PROCESS_CONFIG_ID int iWD GAX Plug-in ID for the process.
PROCESS_CONFIG_EVENT_ID bigint Event that created or updated the process record.
PROCESS_RUNTIME_ID nvarchar(255) iWD GAX Plug-in runtime ID for the process.
TENANT_KEY int Key to the TENANT dimension, identifying the tenant with whom the process is associated.
SOLUTION_KEY int Key to the SOLUTION dimension, identifying the solution with which the process is associated.
DEPARTMENT_KEY int Key to the DEPARTMENT dimension, identifying the department with which the process is associated.
PROCESS_NAME nvarchar(255) Descriptive name of the process.
CUSTOM_DIM_KEY int Key to the CUSTOM_DIM dimension, identifying custom attributes that apply to the process.
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.
VALID_FROM_DATE_KEY int Date key for the VALID_FROM process attribute.
VALID_FROM_TIME_KEY int Time key for the VALID_FROM process attribute.
VALID_TO_DATE_KEY int Date key for the VALID_TO process attribute.
VALID_TO_TIME_KEY int Time key for the VALID_TO process attribute.
VALID_FROM datetime The date, in YYYY-M-D HH:MM:SS F format, from which this process is valid.
VALID_TO datetime The date, in YYYY-M-D HH:MM:SS F format, until which this process is valid.
VERSION int Version of the record.

Feedback

Comment on this article:

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