Route Associations

The Route Associations view object stores information about route associations like business entities, associated entities, and assignments defined for the new item request.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.RouteAssocsExtractPVO

Primary Keys : RouteAssociationsPEORouteAssocId

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name	Description
RouteAssociationsPEOAdhocFlag	Value that indicates that the new item request definition workflow task is associated through a reassignment action. Contains one of the following two values: Y and N. If set to Y, then new item request definition association is done through a reassignment action.
RouteAssociationsPEOCreatedBy	User who created the row.
RouteAssociationsPEOCreationDate	Date and time when the row was created.
RouteAssociationsPEODefinitionEntityName	Name of the business entity associated with the new item request definition setup. For example, when defining the new item request definition step, you can associate it with a business entity like an operational attribute, user-defined attribute or structure. A list of accepted values are defined in the lookup type EGO_ITEM_DEFINITION_ENTITIES.
RouteAssociationsPEODefinitionEntityPk1	Attribute group of the business entity associated with the new item request definition setup and workflow. It maps to different values based on the business entities.
RouteAssociationsPEODefinitionEntityPk2	Value that uniquely identifies the task pertaining to the association. For a new item request, this attribute is populated when you associate a task with the definition workflow. Else -1 is the value for new item request definition setup.
RouteAssociationsPEODefinitionEntityPk3	Sequence number of the user defined attribute group.
RouteAssociationsPEODefinitionEntityPk4	Value that indicates that the data is from an external source and is used for new item request definition.
RouteAssociationsPEODefinitionEntityPk5	Value that indicates that the data is from an external source and is used for new item request definition.
RouteAssociationsPEODefinitionStatus	Status of the definition for that particular associated entity. A list of values are defined in the lookup type EGO_ROUTE_STEP_STATUSES.
RouteAssociationsPEOInheritedFlag	Value that indicates that the definition association is inherited from the parent item class. Contains one of the following values: Y or N.
RouteAssociationsPEOLastUpdateDate	Date and time when the row was last updated.
RouteAssociationsPEOLastUpdateLogin	Session login details associated to the user who last updated the row.
RouteAssociationsPEOLastUpdatedBy	User who last updated the row.
RouteAssociationsPEOMandatoryFlag	Value that indicates whether the association definition is mandatory for the task to be completed. Contains one of the following values: Y or N.
RouteAssociationsPEOObjectName	Object name related to the association. If the object is associated with a new item request workflow, then the value is EGO_NEW_ITEM. If the object is associated to new item request definition setup, then the value is EGP_CATALOG_GROUP.
RouteAssociationsPEOObjectPk1	Value that identifies whether the item or the item class is defined based on workflow or setup. This is the primary key of the Items view object or the Item Class view object.
RouteAssociationsPEOObjectPk2	Value that identifies the revision of the item being defined in the workflow. This is the primary key of the Item Revision view object.
RouteAssociationsPEOObjectPk3	Value that identifies whether the item class is associated with the new item request definition workflow or the definition setup.
RouteAssociationsPEOObjectPk4	Value that identifies data from other tables.
RouteAssociationsPEOObjectPk5	Value that identifies data from other tables.
RouteAssociationsPEOObjectVersionNumber	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.
RouteAssociationsPEORouteAssocId	Value that uniquely identifies the route associations. This is the primary key of the Route Associations view object.
RouteAssociationsPEORoutePeopleId	Value that identifies the people corresponding to this route association. This is the primary key of the Route People view object.