Control Budgets
The control budgets view object contains setup information of each control budget in the budgetary control.
Data Store Key : FscmTopModelAM.FinExtractAM.XccBiccExtractAM.ControlBudgetExtractPVO
Primary Keys : ControlBudgetId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AllowOverridesFlag | Indicates whether the override is allowed for the control budget. |
| AttributeCategory | |
| AttributeChar1 | |
| AttributeChar10 | |
| AttributeChar2 | |
| AttributeChar3 | |
| AttributeChar4 | |
| AttributeChar5 | |
| AttributeChar6 | |
| AttributeChar7 | |
| AttributeChar8 | |
| AttributeChar9 | |
| AttributeDate1 | |
| AttributeDate2 | |
| AttributeDate3 | |
| AttributeDate4 | |
| AttributeDate5 | |
| AttributeNumber1 | |
| AttributeNumber2 | |
| AttributeNumber3 | |
| AttributeNumber4 | |
| AttributeNumber5 | |
| AttributeTimestamp1 | |
| AttributeTimestamp2 | |
| AttributeTimestamp3 | |
| AttributeTimestamp4 | |
| AttributeTimestamp5 | |
| BalanceDecreasesAllowedFlag | Indicates whether the budget balance can be decreased by a budget adjustment. |
| BalanceIncreasesAllowedFlag | Indicates whether the budget balance can be increased by a budget adjustment. |
| BudgetChartOfAccountsId | The identifier of the key flexfield structure for the budget chart of accounts. |
| BudgetManagerId | The budget manager who manages the control budget. |
| ChartOfAccountsId | The key flexfield structure for the associated ledger's chart of accounts. |
| ControlBudgetId | The unique identifier of the control budget. |
| ControlLevelCode | Code that identifies the degree of enforcement in controlling consumption against budget, such as ABSOLUTE, ADVISORY, TRACK, and NONE. TRACK indicates that no enforcement in place to control the consumption. NONE indicates that no enforcement is in place and no tracking of the consumption. |
| CreatedBy | The user who created the control budget. |
| CreationDate | The date and time when the control budget was created. |
| CurrencyCode | The currency of the control budget. |
| DefaultRateType | The default currency conversion rate type for the control budget. |
| Description | The description of the control budget. |
| EndDate | Date on which the last period of the control budget ends. |
| EndEffPeriodNum | The ending budget period of a control budget expressed as a numeric value for ease of comparison. |
| EndPeriodName | Ending budget period of a control budget. |
| FundsReleaseTimeframe | Determines the timing at which funds are made available for consumption in a particular period. Valid values are: RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN. |
| FvTypeCode | The code that indicates the type of transactions that impact the control budget, such as ORA_CONSUMPTION for procure-to-pay transactions and ORA_CASH for transactions impacting the cash balance. |
| InternalBudgetTypeCode | The code that indicates the type of spending control for a project control budget. For example, P_TT indicates Project and Top Task for a nonsponsored project or Award Project and Top Task for a sponsored project. |
| LastUpdateDate | The date and time when the control budget was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the control budget. |
| LastUpdatedBy | The user who last updated the control budget. |
| LedgerId | The unique identifier of the ledger. |
| MaximumOverrideAmount | The maximum override amount allowed for the control budget. |
| Name | The name of the control budget. |
| NegativeBalancesAllowedFlag | Indicates whether the budget adjustment is allowed to cause negative funds available balance. |
| NoOverridesNotifyFlag | Indicates whether the budget manager must be notified when no overrides are identified. |
| ObjectVersionNumber | The number of times the control budget has been updated. |
| OfflineReasonCode | The code that indicates the type of definition updates that causes the control budget to be not ready for use. A list of accepted values is defined in the lookup type ORA_XCC_CB_OFFLINE_REASONS. |
| OverridesTakenNotifyFlag | Indicates whether the budget manager must be notified when an override is taken. |
| ParentSourceBudget | The source budget name of another control budget from which the control budget derives its budget amount. If the control budget isn't sourced from another control budget, it captures the name of its own source budget. |
| ParentSourceSystem | The source budget type of another control budget from which the control budget derives its budget amount. If the control budget isn't sourced from another control budget, it captures the type of its own source budget. |
| PeriodSetName | The name of the budget calendar. |
| PeriodType | The period type of the budget calendar. |
| PjcContractId | The project accounting contract's unique identifier for the award associated with the budget amount. Default value is -98. |
| ProjectId | The unique identifier of the project. |
| SourceBudget | The name of the source budget. |
| SourceBudgetSystemCode | Code that identifies the source of budget data, such as EPM_CLOUD for EPM Financials module, budget, HYPERION for Hyperion Planning, ORA_FEDERAL for U.S. Federal Financials, PPM for Project Management, and OTHER for any other data source. It also includes XCC for budget data derived from another control budget, and NOBUDGET when no budget data is expected. |
| StartDate | Date from when the first period of the controls budget starts. |
| StartEffPeriodNum | The beginning budget period of a control budget expressed as a numeric value for ease of comparison. |
| StartPeriodName | Beginning budget period of a control budget. |
| StatusCode | The code that indicates the business cycle of a control budget. It includes various statuses that make the control budget not ready for use, such as NOT_READY_FOR_USE, DEFINITION_INCOMPLETE, PREPARING_DEFINITION, REDEFINING, REDEFINITION_INCOMPLETE, PREPARING_REDEFINITION, REFRESHING_TREE, AUTO_UPDATE, and other statuses, such as IN_USE, CLOSED and PERMANENTLY_CLOSED. |
| ToleranceAmount | The tolerance amount of budget overage permitted by a control budget. |
| TolerancePercent | The tolerance percentage of budget overage permitted by a control budget. |
| UomCode | The code that identifies the unit of measure of a control budget that tracks nonmonetary values. |