Sourcing Program Header Details
The Sourcing Program Header view object consists of details about the sourcing program header
Data Store Key : FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.SourcingProgramHeaderPVO
Primary Keys : ProgramHeaderPEOProgramHeaderId
Initial Extract Date : ProgramHeaderPEOCreationDate
Incremental Extract Date : ProgramHeaderPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| 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. |
| ObjectiveAggToProgPEOObjBsCurrentSpendByProg | Sum of the current Amount of all award completed negotiations within the objective. |
| ObjectiveAggToProgPEOObjBsSavingsGoalByProg | Planned Savings Goal of all award completed negotiations within the objective. |
| ObjectiveAggToProgPEOObjBsTargetSpendByProg | Planned Target Spend of all award completed negotiation within the objective. |
| ObjectiveAggToProgPEOProgramHeaderId | System generated unique identifier for the program. |
| ProgBaseTargetSpendNotAllocatedToObj | Value that indicates that the target spend is not allocated to the objective. |
| ProgSavingsGoalDiffBaseVsPlanned | Value that indicates 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 browse category row. |
| ProgramBrowseCategoryPEOCreationDate | Date and time when the program browse category row was created. |
| ProgramBrowseCategoryPEOImageUrl | Uniform Resource Locator of the image used in the program browse category. |
| ProgramBrowseCategoryPEOLastUpdateDate | Date and time the program browse category row was last updated. |
| ProgramBrowseCategoryPEOLastUpdateLogin | Session login associated with the user who last updated the program browse category row. |
| ProgramBrowseCategoryPEOLastUpdatedBy | User who last updated the program browse 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 the 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 an 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 whether 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 daily sourcing program. |
| 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 daily sourcing program. |
| ProgramHeaderPEOCategoryId | Browsing category or item category from the procurement header hierarchy that the program is associated with. |
| ProgramHeaderPEOComments | Comments provided while creating program header. |
| ProgramHeaderPEOCreatedBy | User who created the program header row. |
| ProgramHeaderPEOCreationDate | Date and time the program header row was created. |
| ProgramHeaderPEOCreationDateOnly | Date the program header row was created. |
| ProgramHeaderPEOCurrencyCode | Base currency code in which the program is monitored. |
| ProgramHeaderPEOCurrentSpend | Current spend for which the program is created. |
| ProgramHeaderPEOEndDate | The date when the program header ends. |
| ProgramHeaderPEOGlobalProgramFlag | Value that indicates whether program is global or not. |
| 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 | Unique identifier of 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 phase of the program. |
| ProgramHeaderPEOProgramStatus | Determines status of the program. |
| ProgramHeaderPEOPurchasingCatFlag | Indicates whether 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 defined by the user. |
| 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 name of 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 whether the public entity object is enabled for the current program phase. |
| ProgramPhaseLookupPEOEndDateActive | Date when the program ends. |
| ProgramPhaseLookupPEOLastUpdateDate | Date and time the program phase row was last updated. |
| ProgramPhaseLookupPEOLastUpdateLogin | Session login associated with 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 the program status row was created. |
| ProgramStatusLookupPEODescription | Description of the program status. |
| ProgramStatusLookupPEODisplaySequence | Sequence in which the program status is displayed. |
| ProgramStatusLookupPEOEnabledFlag | Value that indicates if the public entity object is enabled for the current program status. |
| ProgramStatusLookupPEOEndDateActive | Date when the program 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 | Unique identifier for the program status application. |
| SysEffectiveDate | Date from which the program is effective from. |