Change Statuses

The Change Statuses view object provides information about all the workflow statuses that are assigned to the change object or new item request.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.ChangeStatusesExtractPVO

Primary Keys : EgoChangeStatusesBasePEOStatusCode

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name	Description
EgoChangeStatusesBasePEOApplicationId	Value that identifies the application to which this change status belongs.
EgoChangeStatusesBasePEOCreatedBy	User who created the change status row.
EgoChangeStatusesBasePEOCreationDate	Date and time when the change status was created.
EgoChangeStatusesBasePEODisableDate	Date and time when the change status was disabled.
EgoChangeStatusesBasePEOLastUpdateDate	Date and time when the change status was last updated.
EgoChangeStatusesBasePEOLastUpdateLogin	Session login details associated with the user who last updated the change status.
EgoChangeStatusesBasePEOLastUpdatedBy	User who last updated the change status row.
EgoChangeStatusesBasePEOObjectName	Name of the object type to which the change status is associated. Contains one of the following values: EGO_CHANGE or ENG_CHANGE.
EgoChangeStatusesBasePEOObjectVersionNumber	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.
EgoChangeStatusesBasePEOSeedDataSource	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.
EgoChangeStatusesBasePEOSeededFlag	Value that identifies whether the status is predefined or not. Contains one of the following values: Y or N. If Y, the status is predefined. If N, the status is not predefined.
EgoChangeStatusesBasePEOStatusCode	Status code of the change status. This is the primary key of the Change Statuses view object.
EgoChangeStatusesBasePEOStatusInternalName	Internal name of the change status.
EgoChangeStatusesBasePEOStatusType	Status type of the change status. Contains one of the following values: 1, 4, 6, 8, 13, and 20. If 1, the status is Open. If 4, the status is Scheduled. If 6, the status is Completed. If 8, the status is Approval. If 13, the status is Interim_Approval. If 20, the status is Definition.
EgoChangeStatusesTLPEODescription	Description of the translatable change status.
EgoChangeStatusesTLPEOLanguage	Code of the language into which the contents of the translatable columns are translated.
EgoChangeStatusesTLPEOStatusCode	Status code of the change object or new item requests. The status code is the foreign key of the Change Status view object. This is the unique identifier for the Translatable Change Status view object, along with the language attribute.
EgoChangeStatusesTLPEOStatusName	Status name of the translatable change status row.