Route Steps

The Route Steps view object provides information about each step in a route for a change order, a new item request, or a change type that's in approval or interim approval status. It includes details of when the route step starts and ends, and whether the approval is mandatory or optional.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.RouteStepsExtractPVO

Primary Keys : RouteStepsPEOStepId

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name	Description
RouteStepsPEOCreatedBy	User who created the row.
RouteStepsPEOCreationDate	Date and time when the row was created.
RouteStepsPEOLastUpdateDate	Date and time when the row was last updated.
RouteStepsPEOLastUpdateLogin	Session login details associated to the user who last updated the row.
RouteStepsPEOLastUpdatedBy	User who last updated the row.
RouteStepsPEOObjectName	Name of the object represented by the route. Contains one of the following values: EGO_CHANGE or EGP_CATALOG_GROUP. For change or change type, the value is EGO_CHANGE. For item class, the value is EGP_CATALOG_GROUP.
RouteStepsPEOObjectPk1	Value that identifies whether it's a change, or a new item request item class or a change type. Based on the identifier, this is the primary key of the Change Types view object or Changes view object or Items view object.
RouteStepsPEOObjectPk2	Value that identifies data from other tables.
RouteStepsPEOObjectPk3	Value that identifies data from other tables.
RouteStepsPEOObjectPk4	Value that identifies data from other tables.
RouteStepsPEOObjectPk5	Value that identifies data from other tables.
RouteStepsPEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
RouteStepsPEOResponseRequiredFrom	Indicates whether the mandatory or the optional approval that's required for the change type or the change order is from one or from all. A list of accepted values is defined in the lookup type EGO_ROUTE_STEP_RES_REQ.
RouteStepsPEORouteId	Value that uniquely identifies the route to which the route step belongs to. This is the foreign key to the Routes view object.
RouteStepsPEORulesSupported	Indicates if rule-based approval is supported for this Approval or Interim Approval route step. Contains one of the following values: Y or N.
RouteStepsPEOSeedDataSource	Specifies the name of the seed data source file. If the record was bulk loaded, this is indicated by the value BULK_SEED_DATA_SCRIPT.
RouteStepsPEOSkipFlag	Indicates whether the route step can be enabled or disabled. Contains one of the following values: Y or N. If Y, then the route step is to be skipped. If N, the route step isn't to be skipped.
RouteStepsPEOStepActivityType	Activity type of the route step. It can be Definition, Approval or Optional Approval.
RouteStepsPEOStepEndDate	End date and time of the route step.
RouteStepsPEOStepId	Value that uniquely identifies the route steps. This is the primary key of the Route Steps view object.
RouteStepsPEOStepSeqNumber	Sequence number of each unique step in the route.
RouteStepsPEOStepStartDate	Start date and time of the route step.
RouteStepsPEOStepStatusCode	Status code of the route step. A list of accepted values is defined in the lookup type EGO_ROUTE_STEP_STATUSES. Contains one of the following values: EGO_NOT_STARTED, EGO_IN_PROGRESS, or EGO_COMPLETED.
RouteStepsPEOTaskCompleteTime	End date and time of the route step. For example, if a change object is to be approved by two people, this value indicates the time taken by both the approvers to complete the process.
RouteStepsPEOTaskRoutingSlipListBuilder	Indicates whether the assignee list is rule-based or user-defined. Contains one of the following values: EGO_RULES_DRIVEN or EGO_USER_DEFINED.
RouteStepsPEOTaskStageType	Value that indicates whether it's a header stage or a line stage type. Contains one of the following values: EGO_LINE_STAGE or EGO_HEADER_STAGE.
RouteStepsPEOTaskStartTime	Start date and time of the task.
RouteStepsPEOUserDefinedSupported	Indicates if user-defined approval is supported for this approval or interim approval route step. Values are Y and N.
RouteStepsPEOWebServiceSupported	Indicates if web service based approval is supported for this approval or interim approval route step. Values are Y and N.
RouteStepsPEOWorkflowInstanceId	Value that identifies the workflow task for the step.