All tasks are associated with a department that is configured in iWD GAX Plug-in.
|DEPARTMENT_KEY||int||Primary key of this table.|
|DEPARTMENT_CONFIG_ID||int||iWD GAX Plug-in ID for the department.|
|DEPARTMENT_CONFIG_EVENT_ID||bigint||ID of the event that created or updated this department record.|
|DEPARTMENT_RUNTIME_ID||nvarchar(255)||iWD GAX Plug-in runtime ID for the department.|
|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_NAME||nvarchar(255)||Name of the department.|
|CUSTOM_DIM_KEY||int||Key to the CUSTOM_DIM dimension, identifying custom attributes that apply to the department.|
|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||For the version of the record, the date from which it is valid.|
|VALID_TO||datetime||For the version of the record, the date to which it is valid.|
|VERSION||int||Version of the record.|
This page was last edited on December 19, 2017, at 10:26.
Comments or questions about this documentation? Contact us for support!