Route People

The Route People view object provides user, group, or role information assigned to the change order or change type approval workflows. It also includes people assignments made to the new item request and its definition.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.RoutePeopleExtractPVO

Primary Keys : RoutePeoplePEORoutePeopleId

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name	Description
RoutePeoplePEOAdhocPeopleFlag	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 from the change type setup page. If Y, the approver is added from the change object when it's in open status. If R, an 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, the change order is in interim approval status.
RoutePeoplePEOAssigneeId	Value that uniquely identifies the assignee of the route or the approver who's assigned to the change order, the change type, or the new item request. If the ASSIGNEE_TYPE_CODE is EGO_PERSON, the value is USER_GUID. If ASSIGNEE_TYPE_CODE is EGO_ROLE, the value is ROLES_GUID.
RoutePeoplePEOAssigneeTypeCode	Value that identifies whether the type of assignee is a role or a person. A list of accepted values is defined in the lookup type EGO_ROUTE_ASSIGNEE_TYPES. Contains one of the following values: EGO_ROLE or EGO_PERSON.
RoutePeoplePEOCreatedBy	User who created the row.
RoutePeoplePEOCreationDate	Date and time when the row was created.
RoutePeoplePEOLastUpdateDate	Date and time when the row was last updated.
RoutePeoplePEOLastUpdateLogin	Session login details associated to the user who last updated the row.
RoutePeoplePEOLastUpdatedBy	User who last updated the row.
RoutePeoplePEOObjectName	Name of the object to which the people assignments are added. Contains one of the following values: EGO_CHANGE or EGP_CATALOG_GROUP.
RoutePeoplePEOObjectPk1	Value that identifies whether the object is a change, a change type, or a new item request. This is the primary key of the Changes view object, or the Change Types view object.
RoutePeoplePEOObjectPk2	Value that represents the lifecycle status corresponding to the Route People row. This is the primary key of the Change Lifecycle Status view object.
RoutePeoplePEOObjectPk3	Value that refers to data from other tables.
RoutePeoplePEOObjectPk4	Value that refers to data from other tables.
RoutePeoplePEOObjectPk5	Value that refers to data from other tables.
RoutePeoplePEOObjectVersionNumber	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.
RoutePeoplePEOOriginalAssigneeId	Value that identifies the original assignee when an approval task is assigned to a role, or a user reassigns an approval task. If the value is ROLE_GUID, the original assignee was a role. If the value is USER _GUID, the original assignee was the user who reassigned the approval task.
RoutePeoplePEOOriginalAssigneeType	Value that uniquely identifies whether the original assignee type is based on a role or a person. A list of accepted values is defined in the lookup type EGO_ROUTE_ASSIGNEE_TYPES. Contains the following values: EGO_ROLE or EGO_PERSON.
RoutePeoplePEOReassignedTo	Users to whom the task has been reassigned or delegated.
RoutePeoplePEOResponseCode	Response code or action of the approvers who are part of the approval process. A list of accepted values is defined in the lookup type EGO_ROUTE_STEP_STATUSES.
RoutePeoplePEOResponseDate	Date when action is taken on the approval.
RoutePeoplePEOResponseRequiredFrom	Value that indicates whether a response is required from one approver or all approvers for the change type or the change order. This is applicable for both mandatory and optional approvals. A list of accepted values is defined in the lookup type EGO_ROUTE_STEP_RES_REQ.
RoutePeoplePEORoutePeopleId	Value that uniquely identifies the people who are part of the new item request, change, or change type workflow. This is the primary key of the Route People view object.
RoutePeoplePEOStepId	Value that identifies the step to which this Route People row belongs. This is the foreign key to the Route Steps view object.
RoutePeoplePEOTaskCompleteTime	End date and time of the task performed by the user.
RoutePeoplePEOTaskStartTime	Start date and time of the task performed by the user.
RoutePeoplePEOWfSubtaskInstanceId	Value that identifies the approval task of the individual approver.