As of Friday October 16th, access to restricted content on this site now requires you to log in with your Genesys account. If you don't have an account, you can request one at these locations: Request MyPartner Portal Account or Request My Support Account.
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.
This page was last edited on December 19, 2017, at 10:26.

Feedback

Comment on this article:

blog comments powered by Disqus