Task Instances

The Task Instances view object that extracts task instance details from the sales orders, such as start and completion dates, status, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.TaskInstanceExtractPVO

Primary Keys : TaskInstanceTaskInstanceId

Initial Extract Date : TaskInstanceCreationDate

Incremental Extract Date : TaskInstanceLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
TaskInstanceActualCompletionDate	Date when the task was completed.
TaskInstanceActualStartDate	Date when the work for the task commenced.
TaskInstanceCreatedBy	User who created the task instance row.
TaskInstanceCreationDate	Date when the task instance row was created.
TaskInstanceDooProcessInstanceId	Value that identifies the orchestration process instance associated to the task instance row. This is a foreign key to the Orchestration Process Instances view object.
TaskInstanceJeopardyReason	Reason that explains how the jeopardy score was set.
TaskInstanceJeopardyScore	Numeric value that specifies the severity of the delayed task.
TaskInstanceLastUpdateDate	Date when the task instance row was last updated.
TaskInstanceLastUpdateLogin	Session login associated to the user who most recently updated the task instance row.
TaskInstanceLastUpdatedBy	User who most recently updated the task instance row.
TaskInstanceObjectVersionNumber	Number of times the task instance row has been updated.
TaskInstancePlannedCompletionDate	Date when the task is planned to be completed.
TaskInstancePlannedStartDate	Date when the work for the task is planned to commence.
TaskInstanceRequiredCompletionDate	Date when the task is required to be completed.
TaskInstanceRequiredStartDate	Date when the work for the task is required to commence.
TaskInstanceRootParentGroupId	Value that identifies the root orchestration process group associated to the task instance row. This is a foreign key to the Orchestration Process Instances view object.
TaskInstanceScheduledCompletionDate	Date when the task is scheduled to be completed.
TaskInstanceScheduledStartDate	Date when the work for the task is scheduled to commence.
TaskInstanceStatusCode	Code that identifies the status of the task.
TaskInstanceStepActive	Indicates whether the orchestration process step is active. A list of accepted values is defined in the lookup type DOO_STEP_ACTIVE.
TaskInstanceTaskId	Value that identifies the task associated to the task instance row. This is a foreign key to the Tasks view object.
TaskInstanceTaskInstanceId	Value that uniquely identifies the task instance row. This is the primary key of the Task Instances view object.