Sourcing Program Objective Details

The Sourcing Program Objective view object consists of details about the sourcing program objective.

Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.SourcingProgramObjectivePVO

Primary Keys : ProgramHeaderPEOProgramHeaderId, ProgramObjectivePEOObjectiveHeaderId

Initial Extract Date : ProgramObjectivePEOCreationDate

Incremental Extract Date : ProgramObjectivePEOLastUpdateDate

Attributes

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

Name	Description
NegotiationAggToObjPEOAwardAmountByObj	Award amount identified in the objective.
NegotiationAggToObjPEOObjectiveHeaderId	Value that uniquely identifies the objective.
NegotiationAggToObjPEOPlannedCurrentSpendByObj	Sum of the current Amount of all award completed negotiations within the objective.
NegotiationAggToObjPEOPlannedSavingGoalsByObj	Planned Savings Goal of all award completed negotiations within the objective.
NegotiationAggToObjPEOPlannedTargetSpendByObj	Planned Target Spend of all award completed negotiation within the objective.
NegotiationAggToObjPEOProgramHeaderId	Value that uniquely identifies the program.
NegotiationAggToProgPEOAwardAmountByProg	Award amount identified in the program.
NegotiationAggToProgPEOPlannedCurrentSpendByProg	Sum of all the negotiation current amounts of objectives.
NegotiationAggToProgPEOPlannedSavingGoalsByProg	Sum of negotiation Savings Goal for all objectives.
NegotiationAggToProgPEOPlannedTargetSpendByProg	Sum of Negotiation Target Spend for all the objectives.
NegotiationAggToProgPEOProgramHeaderId	Value that uniquely identifies the program.
ObjBaseTargetSpendNotAllocatedToNeg	Value that indicates that target spend amount has not been allocated to the negotiation
ObjectiveAggToProgPEOObjBsCurrentSpendByProg	Sum of all the negotiation current amounts of objectives.
ObjectiveAggToProgPEOObjBsSavingsGoalByProg	Sum of negotiation Savings Goal for all objectives.
ObjectiveAggToProgPEOObjBsTargetSpendByProg	Sum of Negotiation Target Spend for all the objectives.
ObjectiveAggToProgPEOProgramHeaderId	Value that uniquely identifies the program.
ObjectiveBrowseCategoryPEOCategoryDescription	Description of the category of the objective.
ObjectiveBrowseCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveBrowseCategoryPEOCategoryName	Name of the program category.
ObjectiveBrowseCategoryPEOCreatedBy	User who created the objective row.
ObjectiveBrowseCategoryPEOCreationDate	Date and time the objective row was created.
ObjectiveBrowseCategoryPEOImageUrl	Uniform Resource Locator of the image used in the program.
ObjectiveBrowseCategoryPEOLastUpdateDate	Date and time the objective row was last updated.
ObjectiveBrowseCategoryPEOLastUpdateLogin	Session login associated with the user who last updated the objective row.
ObjectiveBrowseCategoryPEOLastUpdatedBy	User who last updated the objective row.
ObjectiveBrowseCategoryPEOObjectVersionNumber	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.
ObjectiveBrowseCategoryPEOType	Type of browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryName	Name of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryCode	Code of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryContentCode	Content code of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEOCategoryName	Name of the browsing category or item category from the procurement category hierarchy that the program is associated with.
ObjectiveCategoryPEODescription	Description of the objective.
ObjectiveCategoryPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program objective category.
ObjectiveCategoryPEOEndDateActive	Date when the objective category ends.
ObjectiveCategoryPEOObjectVersionNumber	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.
ObjectiveCategoryPEOStartDateActive	Date when the objective category starts.
ObjectiveCategoryPEOSummaryFlag	Summary of the sourcing objective category.
ObjectiveCategoryPEOSupplierEnabledFlag	Value that indicates if the supplier has been enabled in the objective category.
ObjectiveCategoryPEOWebStatus	Web status of the objective category.
ObjectivePersonNamePEODisplayName	Display name of the person in the objective.
ObjectivePersonNamePEOEffectiveEndDate	Date when the objective ends.
ObjectivePersonNamePEOEffectiveStartDate	Date when the objective starts.
ObjectivePersonNamePEOFullName	Full name of the person in the objective.
ObjectivePersonNamePEOListName	List name of the person in the objective.
ObjectivePersonNamePEOObjectVersionNumber	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.
ObjectivePersonNamePEOPersonId	Value that uniquely identifies the person who created the program.
ObjectivePersonNamePEOPersonNameId	Value that uniquely identifies the name of the person who created the program.
ObjectiveStatusLookupPEOCreatedBy	User who created the objective status row.
ObjectiveStatusLookupPEOCreationDate	Date and time the objective status row was created.
ObjectiveStatusLookupPEODescription	Description of the objective status.
ObjectiveStatusLookupPEODisplaySequence	Display sequence of the objective status.
ObjectiveStatusLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program objective status.
ObjectiveStatusLookupPEOEndDateActive	Date when the objective ends.
ObjectiveStatusLookupPEOLastUpdateDate	Date and time the objective status row was last updated.
ObjectiveStatusLookupPEOLastUpdateLogin	Session login associated with the user who last updated the objective status row.
ObjectiveStatusLookupPEOLastUpdatedBy	User who last updated the objective status row.
ObjectiveStatusLookupPEOMeaning	Meaning of the objective status.
ObjectiveStatusLookupPEOSetId	Value that uniquely identifies the set of the objective status.
ObjectiveStatusLookupPEOStartDateActive	Date when the objective starts.
ObjectiveStatusLookupPEOViewApplicationId	Value that uniquely identifies the objective status application.
ObjectiveTypeLookupPEOCreatedBy	User who created the objective type row.
ObjectiveTypeLookupPEOCreationDate	Date and time the objective type row was created.
ObjectiveTypeLookupPEODescription	Description of the objective type.
ObjectiveTypeLookupPEODisplaySequence	Sequence in which the objective type is displayed.
ObjectiveTypeLookupPEOEnabledFlag	Value that indicates whether public entity object is enabled for the current program objective.
ObjectiveTypeLookupPEOEndDateActive	Date when the objective ends.
ObjectiveTypeLookupPEOLastUpdateDate	Date and time of the last update of the objective type row.
ObjectiveTypeLookupPEOLastUpdateLogin	Session login associated with the user who last updated the objective type row.
ObjectiveTypeLookupPEOLastUpdatedBy	User who last updated the objective type row.
ObjectiveTypeLookupPEOMeaning	Meaning of the objective type.
ObjectiveTypeLookupPEOSetId	Value that uniquely identifies the set of the objective type.
ObjectiveTypeLookupPEOStartDateActive	Date when the objective type starts.
ObjectiveTypeLookupPEOViewApplicationId	Value that uniquely identifies the objective type application.
ProgBaseTargetSpendNotAllocatedToObj	Value that indicates if the target spend is not allocated to objective.
ProgSavingsGoalDiffBaseVsPlanned	Value that indicates the difference between base savings goal and planned savings goal.
ProgramBrowseCategoryPEOCategoryDescription	Description of the program browse category.
ProgramBrowseCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramBrowseCategoryPEOCategoryName	Category name of the program browse category.
ProgramBrowseCategoryPEOCreatedBy	User who created the program category row.
ProgramBrowseCategoryPEOCreationDate	Date and time the program category row was created.
ProgramBrowseCategoryPEOImageUrl	Uniform Resource Locator of the image used in the program browse category.
ProgramBrowseCategoryPEOLastUpdateDate	Date and time the program category row was last updated.
ProgramBrowseCategoryPEOLastUpdateLogin	Session login associated with the user who last updated the program category row.
ProgramBrowseCategoryPEOLastUpdatedBy	User who last updated the program category row.
ProgramBrowseCategoryPEOObjectVersionNumber	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.
ProgramBrowseCategoryPEOType	Type of program browse category.
ProgramCategoryName	Name of the program category.
ProgramCategoryPEOCategoryCode	Category code of the program category.
ProgramCategoryPEOCategoryContentCode	Content code of the program category or an item category from the procurement category hierarchy that the program is associated with.
ProgramCategoryPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramCategoryPEOCategoryName	Category name of the program.
ProgramCategoryPEODescription	Description of the program category.
ProgramCategoryPEOEnabledFlag	Value that indicates if the public entity object is enabled for the current program category.
ProgramCategoryPEOEndDateActive	Date when the program category ends.
ProgramCategoryPEOObjectVersionNumber	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.
ProgramCategoryPEOStartDateActive	Date when the objective starts.
ProgramCategoryPEOSummaryFlag	Summary of the sourcing program category.
ProgramCategoryPEOSupplierEnabledFlag	Value that indicates if the supplier has been enabled in the program category.
ProgramCategoryPEOWebStatus	Web status of the program category.
ProgramDailyConversionTypePEOConversionType	Type of conversion in daily sourcing program.
ProgramDailyConversionTypePEODescription	Description of the program daily conversion.
ProgramDailyConversionTypePEOObjectVersionNumber	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.
ProgramDailyConversionTypePEOUserConversionType	Type of user conversion in the daily sourcing program.
ProgramHeaderPEOCategoryId	Browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramHeaderPEOComments	Comments provided while creating the program.
ProgramHeaderPEOCreatedBy	User who created the program header row.
ProgramHeaderPEOCreationDate	Date and time the program header row was created.
ProgramHeaderPEOCreationDateOnly	Date of the creation of the program row.
ProgramHeaderPEOCurrencyCode	Base currency code in which program is monitored.
ProgramHeaderPEOCurrentSpend	Current spend for which the program is created.
ProgramHeaderPEOEndDate	The date when the program ends.
ProgramHeaderPEOGlobalProgramFlag	Value that indicates if the program is global.
ProgramHeaderPEOLastUpdateDate	Date and time the program header row was last updated.
ProgramHeaderPEOLastUpdateLogin	Session login associated with the user who last updated the program header row.
ProgramHeaderPEOLastUpdatedBy	User who last updated the program header row.
ProgramHeaderPEOObjectVersionNumber	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.
ProgramHeaderPEOPersonId	Identifier of the person who created the program.
ProgramHeaderPEOPrcBuId	Value that uniquely identifies the procurement business unit for which the program was created. It is populated only when the program is not global.
ProgramHeaderPEOProgramHeaderId	Value that uniquely identifies the program.
ProgramHeaderPEOProgramPhase	Determines the phase of the program.
ProgramHeaderPEOProgramStatus	Determines the status of the program.
ProgramHeaderPEOPurchasingCatFlag	Value that indicates if the category associated with the program is purchasing category.
ProgramHeaderPEORateDate	Conversion date for the selected rate type.
ProgramHeaderPEORateType	Rate type selected for the program.
ProgramHeaderPEOSavings	Savings amount that the program is trying to achieve.
ProgramHeaderPEOSavingsPercent	Savings percentage that the program is trying to achieve.
ProgramHeaderPEOStartDate	Date when the program starts.
ProgramHeaderPEOSynopsis	Program synopsis as defined by the user.
ProgramHeaderPEOTargetSpend	Target spend that the program is trying to achieve.
ProgramHeaderPEOTitle	Program title as defined by the user.
ProgramObjectivePEOCategoryId	A browsing category or item category from the procurement category hierarchy that the program is associated with.
ProgramObjectivePEOComments	Comments provided while creating the program.
ProgramObjectivePEOCreatedBy	User who created the program objective row.
ProgramObjectivePEOCreationDate	Date and time the program objective row was created.
ProgramObjectivePEOCurrentSpend	Current spend for which the program is created.
ProgramObjectivePEODescription	Description of the objective.
ProgramObjectivePEOEndDate	Date when the program ends.
ProgramObjectivePEOLastUpdateDate	Date and time the program objective row was last updated.
ProgramObjectivePEOLastUpdateLogin	Session login associated with the user who last updated the program objective row.
ProgramObjectivePEOLastUpdatedBy	User who last updated the program objective row.
ProgramObjectivePEOName	Name of the objective.
ProgramObjectivePEOObjectVersionNumber	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.
ProgramObjectivePEOObjectiveHeaderId	Value that uniquely identifies the objective.
ProgramObjectivePEOObjectiveType	Value used to classify or categorize an objective for reporting purposes. Possible Values are Price reduction, Cost avoidance, Productivity improvement.
ProgramObjectivePEOPersonId	Identifier of the person who created the program.
ProgramObjectivePEOProgramHeaderId	Value that uniquely identifies the program.
ProgramObjectivePEOPurchasingCatFlag	Value that indicates whether the category associated with the program is purchasing category or not.
ProgramObjectivePEORollUpFlag	Value that indicates whether the savings and spend values of the objective's negotiations will be counted for program level spend and savings.
ProgramObjectivePEOSavings	Sum of negotiated savings from all objectives.
ProgramObjectivePEOSavingsPercent	Ratio of Negotiated Savings and Negotiation Current Spend.
ProgramObjectivePEOStartDate	The date when the program starts.
ProgramObjectivePEOStatus	Determines the status of the objective.
ProgramObjectivePEOTargetSpend	Sum of Negotiation Target Spend for all the objectives.
ProgramPersonNamePEODisplayName	Display name of the user in the program
ProgramPersonNamePEOEffectiveEndDate	Date when the program ends.
ProgramPersonNamePEOEffectiveStartDate	Date when the program starts.
ProgramPersonNamePEOFullName	Full name of the person in the program.
ProgramPersonNamePEOListName	List name of the person in the program.
ProgramPersonNamePEOObjectVersionNumber	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.
ProgramPersonNamePEOPersonId	Value that uniquely identifies the person who created the program.
ProgramPersonNamePEOPersonNameId	Value that uniquely identifies the person who created the program.
ProgramPhaseLookupPEOCreatedBy	User who created the program phase row.
ProgramPhaseLookupPEOCreationDate	Date and time of the creation of the program phase row.
ProgramPhaseLookupPEODescription	Description of the program phase.
ProgramPhaseLookupPEODisplaySequence	Sequence in which the program phase is displayed.
ProgramPhaseLookupPEOEnabledFlag	Value that indicates if the public entity object is enabled for the current program phase.
ProgramPhaseLookupPEOEndDateActive	Date when the program phase ends.
ProgramPhaseLookupPEOLastUpdateDate	Date and time of the program phase row was last updated.
ProgramPhaseLookupPEOLastUpdateLogin	Session login associated to the user who last updated the program phase row.
ProgramPhaseLookupPEOLastUpdatedBy	User who last updated the program phase row.
ProgramPhaseLookupPEOMeaning	Meaning of the program phase.
ProgramPhaseLookupPEOSetId	Value that uniquely identifies the program phase set.
ProgramPhaseLookupPEOStartDateActive	Date when the program starts.
ProgramPhaseLookupPEOViewApplicationId	Value that uniquely identifies the program phase application.
ProgramStatusLookupPEOCreatedBy	User who created the program status row.
ProgramStatusLookupPEOCreationDate	Date and time of the creation of the program status row.
ProgramStatusLookupPEODescription	Description of the program status.
ProgramStatusLookupPEODisplaySequence	Sequence in which the program status is displayed.
ProgramStatusLookupPEOEnabledFlag	Value that indicates whether the public entity object is enabled for the current program status.
ProgramStatusLookupPEOEndDateActive	Date when the program status ends.
ProgramStatusLookupPEOLastUpdateDate	Date and time the program status row was last updated.
ProgramStatusLookupPEOLastUpdateLogin	Session login associated with the user who last updated the program status row.
ProgramStatusLookupPEOLastUpdatedBy	User who last updated the program status row.
ProgramStatusLookupPEOMeaning	Meaning of the program status
ProgramStatusLookupPEOSetId	Value that uniquely identifies the program status set.
ProgramStatusLookupPEOStartDateActive	Date when the program starts.
ProgramStatusLookupPEOViewApplicationId	Value that uniquely identifies the program status application.
SysEffectiveDate	Date from which the program is effective.