Routes

The Route Extract view object provides route-related information for change orders, change types, or new item requests. It also contains information on workflow statuses of type approval and interim approval for these objects.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.RouteExtractPVO

Primary Keys : RoutePEORouteId

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name	Description
RoutePEOAppliedTemplateId	Value that uniquely identifies the route of the object from which this route is created.
RoutePEOCreatedBy	User who created the row.
RoutePEOCreationDate	Date and time when the row was created.
RoutePEOLastUpdateDate	Date and time when the row was last updated.
RoutePEOLastUpdateLogin	Session login details associated to the user who last updated the row.
RoutePEOLastUpdatedBy	User who last updated the row.
RoutePEOObjectName	Name of the object represented by the route. EGO_CHANGE is the value for the new item request or change, and EGP_CATALOG_GROUP is the value for item class.
RoutePEOObjectPk1	Value that identifies whether it's a change, an item class, or a change type. This is the primary key of the Change Type view object or Changes view object based on the identifier.
RoutePEOObjectPk2	Value that identifies the change lifecycle status. This is the primary key of the Change Lifecycle Status view object.
RoutePEOObjectPk3	Value that uniquely identifies data from other tables.
RoutePEOObjectPk4	Value that uniquely identifies data from other tables.
RoutePEOObjectPk5	Value that uniquely identifies data from other tables.
RoutePEOObjectVersionNumber	Used to implement optimistic locking. This number is incremented every time that 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.
RoutePEOResponseRequiredFrom	Response required per status in the approval process. It can either be from one or from all. A list of accepted values is defined in the lookup type RESPONSE_REQUIRED_FROM. Values are EGO_ONE and EGO_ALL.
RoutePEORouteId	Value that uniquely identifies the route. This is the primary key of the Routes view object.
RoutePEORouteInternalName	Internal name of the route. If derived from a template, the name is system-generated. If not, it's RoutePEORouteId.
RoutePEORouteTypeCode	Code that indicates whether the route type is definition or approval. Contains one of the following values: DEFINITION or APPROVAL.
RoutePEOSeedDataSource	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.
RoutePEOStatusCode	Workflow status of a change that's in approval or interim approval lifecycle status. Contains one of the following values: EGO_NOT_STARTED or EGO_IN_PROGRESS. The default value is EGO_NOT_STARTED.
RoutePEOTemplateFlag	Value that determines whether the people assignment is done while approvals are already in progress, with different values being assigned to distinct actions. Contains one of the following values: N,Y,R or A. If N, the approver is added in the change type setup. If Y, the approver is added directly on the change object when it's in open status. If R, the approval task is reassigned to a different user. If A, the approver is added to the change object when the approval process is in progress, for example, when the change order is in interim approval status.