ProcessInstanceExtractPVO

The Orchestration Process Instances view object that extracts orchestration process instance details from the sales orders, such as start and completion dates, status, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.ProcessInstanceExtractPVO

Primary Keys : ProcessInstanceDooProcessInstanceId

Initial Extract Date : ProcessInstanceCreationDate

Incremental Extract Date : ProcessInstanceLastUpdateDate

Attributes

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

Name	Description
ProcessInstanceActualCompletionDate	Date when the orchestration process was completed.
ProcessInstanceActualFulfillDate	Date when the orchestration process was fulfilled.
ProcessInstanceActualStartDate	Date when the work for the orchestration process commenced.
ProcessInstanceCreatedBy	User who created the orchestration process instance row.
ProcessInstanceCreationDate	Date when the orchestration process instance row was created.
ProcessInstanceDooProcessId	Value that identifies the orchestration process associated to the orchestration process instance row. This is a foreign key to the Orchestration Processes view object.
ProcessInstanceDooProcessInstanceId	Value that uniquely identifies the orchestration process instance row. This is the primary key of the Orchestration Process Instances view object.
ProcessInstanceDooProcessVersion	Version of the orchestration process.
ProcessInstanceJeopardyReason	Reason that explains how the jeopardy score was set.
ProcessInstanceJeopardyReasonTaskInstId	Value that identifies the task instance that caused the orchestration process to be in jeopardy. This is a foreign key to the Task Instances view object.
ProcessInstanceJeopardyScore	Highest jeopardy scores among all the tasks in the orchestration process.
ProcessInstanceLastUpdateDate	Date when the orchestration process instance row was last updated.
ProcessInstanceLastUpdateLogin	Session login associated with the user who most recently updated the orchestration process instance row.
ProcessInstanceLastUpdatedBy	User who most recently updated the orchestration process instance row.
ProcessInstanceObjectVersionNumber	Number of times the orchestration process instance row has been updated.
ProcessInstanceOrchestrationApplicationId	Value that identifies the orchestration application associated to the orchestration process instance row. This is a foreign key to the DOO_ORCHESTRATION_APPLICATIONS table.
ProcessInstancePlannedCompletionDate	Date when the orchestration process is planned to be completed.
ProcessInstancePlannedFulfillDate	Date when the orchestration process is planned to be fulfilled.
ProcessInstanceProcessActive	Indicates whether the orchestration process is active or not. A list of acceptable values is defined in the lookup type DOO_PROCESS_ACTIVE.
ProcessInstanceProcessNumber	Number of the orchestration process instance.
ProcessInstanceRequiredFulfillDate	Date when the orchestration process is required to be fulfilled.
ProcessInstanceStatusCode	Code that identifies the status of the orchestration process.