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
| 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. |