Statuses

The Statuses view object that extracts the definition of statues.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.StatusExtractPVO

Primary Keys : StatusStatusId, StatusTranslationLanguage, StatusTranslationStatusId

Initial Extract Date : StatusCreationDate

Incremental Extract Date : StatusLastUpdateDate

Attributes

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

Name	Description
StatusCreatedBy	User who created the status row.
StatusCreationDate	Date when the status row was created.
StatusLastUpdateDate	Date when the status row was last updated.
StatusLastUpdateLogin	Session login associated to the user who most recently updated the status row.
StatusLastUpdatedBy	User who most recently updated the status row.
StatusObjectVersionNumber	Number of times the status row has been updated.
StatusOrchestrationApplicationId	Value that identifies the orchestration application associated to the status row. This is a foreign key to the DOO_ORCHESTRATION_APPLICATIONS table.
StatusSeededFlag	Indicates whether the status was predefined by the Oracle Fusion application. A list of accepted values is defined in the lookup type YES_NO.
StatusStatusCode	Code that uniquely identifies the status.
StatusStatusId	Value that uniquely identifies the status row. This is the primary key of the Statuses view object.
StatusTranslationCreatedBy	User who created the translated status row.
StatusTranslationCreationDate	Date when the translated status row was created.
StatusTranslationDisplayName	Name of the status.
StatusTranslationLanguage	Code that identifies the language into which the contents of the translatable columns are translated.
StatusTranslationLastUpdateDate	Date when the translated status row was last updated.
StatusTranslationLastUpdateLogin	Session login associated to the user who most recently updated the translated status row.
StatusTranslationLastUpdatedBy	User who most recently updated the translated status row.
StatusTranslationObjectVersionNumber	Number of times the translated status row has been updated.
StatusTranslationSourceLang	Code that identifies the language in which the contents of the translatable columns were originally created.
StatusTranslationStatusId	Value that uniquely identifies the status row.