Change Lifecycle Statuses
The Change Lifecycle Status view object provides information about workflow statuses defined for a particular change type, change object, or new item request. The workflow definition and the progress of workflow statuses in the context of the change or new item request are also stored in this view object.
Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.ChangeLifecycleStatusExtractPVO
Primary Keys : ChangeLifeCycleStatusPEOChangeLifecycleStatusId
Initial Extract Date :
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ChangeLifeCycleStatusPEOActiveFlag | Contains one of the following values: Y or N. If Y, then the change lifecycle status is active. If N, then the status is inactive or completed. |
| ChangeLifeCycleStatusPEOAutoDemoteStatus | Status code of the previous lifecycle status, if the change lifecycle status is set to be automatically demoted. |
| ChangeLifeCycleStatusPEOAutoPromoteStatus | Status code of the next lifecycle status, if the change lifecycle status is set to be automatically promoted. |
| ChangeLifeCycleStatusPEOChangeEditableFlag | Indicates whether the change object is editable in this lifecycle status. When the change order is in approval or interim approval status, it indicates whether the change order can be edited or not. Contains one of the following values: Y, or N. The default value is null. |
| ChangeLifeCycleStatusPEOChangeLifecycleStatusId | Value that uniquely identifies the change lifecycle status. This is the primary key of the Change Lifecycle Status view object. |
| ChangeLifeCycleStatusPEOCompletionDate | Date and time when this lifecycle status was completed. |
| ChangeLifeCycleStatusPEOCreatedBy | User who created the change lifecycle status definition of a particular change type. |
| ChangeLifeCycleStatusPEOCreationDate | Date and time when the change lifecycle status definition was created. |
| ChangeLifeCycleStatusPEOEntityId1 | Value that uniquely identifies the change or change type based on the entity. If the entity is EGO_CHANGE, then the value is Change_ID. If the entity is EGO_CHANGE_TYPE, then the value is CHANGE_TYPE_ID. CHANGE_ID is the foreign key that refers to the primary key in the Changes view object, while CHANGE_TYPE_ID is the foreign key that refers to the primary key in the Change Type view object. |
| ChangeLifeCycleStatusPEOEntityId2 | Value that uniquely identifies data from other tables. |
| ChangeLifeCycleStatusPEOEntityId3 | Value that uniquely identifies data from other tables. |
| ChangeLifeCycleStatusPEOEntityId4 | Value that uniquely identifies data from other tables. |
| ChangeLifeCycleStatusPEOEntityId5 | Value that uniquely identifies data from other tables. |
| ChangeLifeCycleStatusPEOEntityName | Name of the entity associated with the lifecycle status. Contains one of the following values: EGO_CHANGE or EGO_CHANGE_TYPE. |
| ChangeLifeCycleStatusPEOEntryCriteriaRuleSetName | Criteria that must be met for a change to enter the status represented in the row. |
| ChangeLifeCycleStatusPEOExitCriteriaRuleSetName | Criteria that must be met for a change to move out or exit the status represented in this row. |
| ChangeLifeCycleStatusPEOIterationNumber | Number of times the lifecycle status of a particular change object is promoted or demoted. If the change order has been demoted to a previous status, then the iteration is bumped up for all the lifecycle statuses of this change order. |
| ChangeLifeCycleStatusPEOLastUpdateDate | Date and time of the lifecycle status of a particular change type or change was last updated. |
| ChangeLifeCycleStatusPEOLastUpdateLogin | Session login details associated with the user who last updated the row. |
| ChangeLifeCycleStatusPEOLastUpdatedBy | User who last updated the lifecycle status of a particular change or change type. |
| ChangeLifeCycleStatusPEOObjectVersionNumber | 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. |
| ChangeLifeCycleStatusPEOSeedDataSource | 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. |
| ChangeLifeCycleStatusPEOSequenceNumber | Sequence number of the lifecycle status of a change or change type, or new item request. The sequence number indicates the order in which the lifecycle statuses of a change order must proceed. |
| ChangeLifeCycleStatusPEOSkipRequestComment | Indicates whether the request for comment notification for this workflow status must be skipped or not. If Y, request for comment notification must be skipped. |
| ChangeLifeCycleStatusPEOStartDate | Date and time when this lifecycle status was started. |
| ChangeLifeCycleStatusPEOStatusCode | Status code to which this lifecycle status belongs. |
| ChangeLifeCycleStatusPEOWorkflowStatus | Status of the workflow. A list of accepted values is defined in the lookup type EGO_ROUTE_STEP_STATUSES. |