DW_BC_CONTROL_BUDGET_D (Preview)

This table requires activation of Budgetary Control functional area. This table stores the header information for a control budget.

Details

Module: Budgetary Control

Key Columns

CONTROL_BUDGET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTROL_BUDGET_ID NUMBER 38 0 True Control Budget Unique Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source record identifier.
CONTROL_BUDGET_ID_CHAR VARCHAR2 128 Control Budget Unique Identifier
NAME VARCHAR2 128 Control budget name user identifier
DESCRIPTION VARCHAR2 256 Description of the control budget
PERIOD_SET_NAME VARCHAR2 32 Budget calendar period set name
PERIOD_TYPE VARCHAR2 32 Control budget calendar period type
START_PERIOD_NAME VARCHAR2 32 Start period of the control budget
END_PERIOD_NAME VARCHAR2 32 End period of the control budget
START_EFF_PERIOD_NUM NUMBER 38 0 Effective period number of the start period of the control budget
END_EFF_PERIOD_NUM NUMBER 38 0 Effective period number of the end period of the control budget
START_DATE DATE Start date of the start period of the control budget. Together with the end date, they indicate the entire date ranges of the control budget
END_DATE DATE End date of the end period of the control budget. Together with the start date, they indicate the entire date ranges of the control budget
SOURCE_BUDGET_SYSTEM_CODE VARCHAR2 32 The source budget type code where budgets were created
SOURCE_BUDGET VARCHAR2 128 XCC lookup code or control budget name value. Dependant on the source budget type code value
CONTROL_LEVEL_CODE VARCHAR2 32 Control level code that will be used when determining funds available for distributions that fall into this supplemental budgetary control or default rule
TOLERANCE_PERCENT NUMBER The % of the budget amount that will be used as tolerance
TOLERANCE_AMOUNT NUMBER The fixed amount that will be used as tolerance
BUDGET_CURRENCY_CODE VARCHAR2 32 Currency assigned to the control budget
DEFAULT_RATE_TYPE VARCHAR2 32 Default rate type assigned to the control budget
BUDGET_MANAGER_ID NUMBER 38 0 Budget manager responsible for this control budget
STATUS_CODE VARCHAR2 32 Status code of the control budget
LEDGER_ID NUMBER 38 0 Primary ledgers defined in GL and enabled for budgetary control. Default value is -98.
CHART_OF_ACCOUNTS_ID NUMBER 38 0 Key flexfield structure defining column for the associated ledger's chart of accounts
PROJECT_ID NUMBER 38 0 Project accounting project unique identifier. Default value is -98.
BUDGET_CHART_OF_ACCOUNTS_ID NUMBER 38 0 Key flexfield structure defining column for the control budget accounts
BALANCE_INCREASES_ALLOWED_FLAG VARCHAR2 16 Indicates whether increases are allowed as adjustments to the initial loaded amounts for control budget combination for this control budget or not
BALANCE_DECREASES_ALLOWED_FLAG VARCHAR2 16 Indicates whether decreases are allowed as adjustments to the initial loaded amounts for control budget combination for this control budget or not
NEGATIVE_BALANCES_ALLOWED_FLAG VARCHAR2 16 Indicates whether funds available balance is allowed to go negative from the adjustment to the initial loaded amounts for control budget combination for this control budget or not
UOM_CODE VARCHAR2 16 UOM assigned to the control budget
PARENT_SOURCE_BUDGET VARCHAR2 128 Source budget type code of the master control budget
PARENT_SOURCE_SYSTEM VARCHAR2 32 Source budget name of the master control budget
ALLOW_OVERRIDES_FLAG VARCHAR2 16 Indicates if overrides are allowed for this control budget.
NO_OVERRIDES_NOTIFY_FLAG VARCHAR2 16 Indicates if the budget owner must be notified when no overrides are available.
OVERRIDES_TAKEN_NOTIFY_FLAG VARCHAR2 16 Indicates if the budget owner must be notified when a override is taken.
MAXIMUM_OVERRIDE_AMOUNT NUMBER Maximum override amount allowed for this control budget. Amount is in the budget currency.
FUNDS_RELEASE_TIMEFRAME VARCHAR2 32 Determines when the funds are made available for a particular period. Valid values are: RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN.
PJC_CONTRACT_ID NUMBER 38 0 Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98.
INTERNAL_BUDGET_TYPE_CODE VARCHAR2 32 Order of segments in the budget chart of accounts structure. For example, PARF indicates a segment order of Project, Award, Top Resource, Funding Source.
FV_TYPE_CODE VARCHAR2 32 Indicates the budgetary control processing type of the control budget.
OFFLINE_REASON_CODE VARCHAR2 32 Reason for taking control budget offline.
CREATED_BY_USER_ID VARCHAR2 64 Who column: indicates the user who created the row.
UPDATED_BY_USER_ID VARCHAR2 64 Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.