Orchestration Process Step Instances

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

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.ProcessStepInstanceExtractPVO

Primary Keys : ProcessStepInstanceStepInstanceId

Initial Extract Date : ProcessStepInstanceCreationDate

Incremental Extract Date : ProcessStepInstanceLastUpdateDate

Attributes

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

Name	Description
ProcessStepInstanceActualCompletionDate	Date when the orchestration process step was completed.
ProcessStepInstanceActualStartDate	Date when the work for the orchestration process step commenced.
ProcessStepInstanceCreatedBy	User who created the orchestration process step instance row.
ProcessStepInstanceCreationDate	Date when the orchestration process step instance row was created.
ProcessStepInstanceDooProcessInstanceId	Value that identifies the orchestration process instance associated to the orchestration process step instance row. This is a foreign key to the Orchestration Process Instances view object.
ProcessStepInstanceGroupId	Value that identifies the orchestration process group associated to the orchestration process step instance row. This is a foreign key to the Orchestration Process Groups view object.
ProcessStepInstanceLastUpdateDate	Date when the orchestration process step instance row was last updated.
ProcessStepInstanceLastUpdateLogin	Session login associated with the user who most recently updated the orchestration process step instance row.
ProcessStepInstanceLastUpdatedBy	User who most recently updated the orchestration process step instance row.
ProcessStepInstanceObjectVersionNumber	Number of times the orchestration process step instance row has been updated.
ProcessStepInstancePlannedCompletionDate	Date when the orchestration process step is planned to be completed.
ProcessStepInstancePlannedStartDate	Date when the work for the orchestration process step is planned to commence.
ProcessStepInstanceReferenceStepInstanceId	Value that identifies the previous orchestration process step instance row. Order Management uses this values when processing change order.
ProcessStepInstanceRequiredCompletionDate	Date when the orchestration process step is required to be completed.
ProcessStepInstanceRequiredStartDate	Date when the work for the orchestration process step is required to commence.
ProcessStepInstanceScheduledCompletionDate	Date when the orchestration process step is scheduled to be completed.
ProcessStepInstanceScheduledStartDate	Date when the work for the orchestration process step is scheduled to commence.
ProcessStepInstanceStepActive	Indicates whether the orchestration process step is active. A list of accepted values is defined in the lookup type DOO_STEP_ACTIVE.
ProcessStepInstanceStepId	Value that identifies the orchestration process step associated to the orchestration process step instance row. This is a foreign key to the Orchestration Process Steps view object.
ProcessStepInstanceStepInstanceId	Value that uniquely identifies the orchestration process step instance row. This is the primary key of the Orchestration Process Step Instances view object.
ProcessStepInstanceStepStatus	Code that identifies the status of the orchestration process step. A list of accepted values is defined in the lookup type DOO_STEP_STATUS.
ProcessStepInstanceTaskInstanceId	Value that identifies the task instance associated to the orchestration process step instance row. This is a foreign key to the Tasks Instances view object.