XCC_CONTROL_BUDGETS
This table stores the header information for a control budget.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XCC_CONTROL_BUDGETS_PK |
CONTROL_BUDGET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Unique identifier for this transaction | |
| CREATED_FROM_CODE | VARCHAR2 | 30 | Method used to create this control budget. Valid values are CB_UI and PPM_API. | ||
| NAME | VARCHAR2 | 100 | Yes | Control budget name user identifier | |
| DESCRIPTION | VARCHAR2 | 240 | Description of the control budget | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Budget calendar period set name | |
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Control budget calendar period type | |
| START_PERIOD_NAME | VARCHAR2 | 15 | Yes | Start period of the control budget | |
| END_PERIOD_NAME | VARCHAR2 | 15 | Yes | End period of the control budget | |
| START_EFF_PERIOD_NUM | NUMBER | 18 | Yes | Effective period number of the start period of the control budget | |
| END_EFF_PERIOD_NUM | NUMBER | 18 | Yes | Effective period number of the end period of the control budget | |
| START_DATE | DATE | Yes | 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 | Yes | 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 | 30 | Yes | The source budget type code where budgets were created | |
| SOURCE_BUDGET | VARCHAR2 | 100 | XCC lookup code or control budget name value. Dependant on the source budget type code value | ||
| CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Yes | Control level code that will be used when determining funds available for distributions that fall into this supplimental 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 | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency assigned to the control budget | |
| DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default rate type assigned to the control budget | ||
| BUDGET_MANAGER_ID | NUMBER | 18 | Yes | Budget manager responsible for this control budget | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status code of the control budget | |
| LEDGER_ID | NUMBER | 18 | Yes | Primary ledgers defined in GL and enabled for budgetary control. Default value is -98. | |
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure defining column for the associated ledger's chart of accounts | ||
| PROJECT_ID | NUMBER | 18 | Yes | Project accounting project unique identifier. Default value is -98. | |
| BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure defining column for the control budget accounts | ||
| ACCOUNT_CREATION_ALLOWED_FLAG | VARCHAR2 | 1 | Yes | Indicates that when control budget accounts do not exist, they will be created by the system | |
| BALANCE_INCREASES_ALLOWED_FLAG | VARCHAR2 | 1 | Yes | 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 | 1 | Yes | 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 | 1 | Yes | 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 | |
| BDG_AMT_NOT_FOUND_RESULT_CODE | VARCHAR2 | 30 | Yes | Result when budgeted amount not found. In V2, this column will be defaulted to PASS and won't be exposed in the UI. In future releases, it will have values as FAIL or PASS | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| UOM_CODE | VARCHAR2 | 3 | UOM assigned to the control budget | ||
| RULE_SQL | CLOB | Rule SQL statement generated by the compiler | |||
| PARENT_SOURCE_BUDGET | VARCHAR2 | 100 | Source budget type code of the master control budget | ||
| PARENT_SOURCE_SYSTEM | VARCHAR2 | 30 | Source budget name of the master control budget | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PREVIOUS_STATUS_CODE | VARCHAR2 | 30 | Contains the previous status of the control budget. This is used when the status needs to be reverted to the previous status. | ||
| ALLOW_OVERRIDES_FLAG | VARCHAR2 | 1 | Yes | Indicates if overrides are allowed for this control budget. | |
| NO_OVERRIDES_NOTIFY_FLAG | VARCHAR2 | 1 | Yes | Indicates if the budget owner must be notified when no overrides are available. | |
| OVERRIDES_TAKEN_NOTIFY_FLAG | VARCHAR2 | 1 | Yes | 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. | |||
| RECALC_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the recalculation program. | ||
| PCBD_ERROR_CODE | VARCHAR2 | 30 | Error code indicating the error that was first encountered by the Prepare Control Budget Definition program. | ||
| IN_USE_END_EFF_PERIOD_NUM | NUMBER | 18 | End period effective number of the control budget when it was In Use the last time. | ||
| RECALC_SUCCESS_FLAG | VARCHAR2 | 1 | Indicates whether the recalculation program has run successfully for this control budget. | ||
| PCBD_INCOMPATIBLE_DATA | VARCHAR2 | 30 | Stores the parameter value, such as a control budget identifier. This prevents the prepare control budget definition process from running in parallel with another process that has the same value in this column. | ||
| CUBE_ID | NUMBER | 18 | Foreign key to XCC_BALANCES_CUBES. A null value means that either the cube does not exist, or the cube exists but control budget is not part of it yet. | ||
| REFRESH_BALANCES_REQD_FLAG | VARCHAR2 | 1 | Indicates that balances for this control budget must be refreshed into the corresponding cube. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| FUNDS_RELEASE_TIMEFRAME | VARCHAR2 | 30 | Yes | Determines when the funds are made available for a particular period. Valid values are: RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN. | |
| PJC_CONTRACT_ID | NUMBER | 18 | Yes | Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98. | |
| INTERNAL_BUDGET_TYPE_CODE | VARCHAR2 | 30 | 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 | 30 | Indicates the budgetary control processing type of the control budget. | ||
| OFFLINE_REASON_CODE | VARCHAR2 | 30 | Reason for taking control budget offline. | ||
| ALLOW_REVENUE_FUNDING_FLAG | VARCHAR2 | 1 | Yes | Indicates if funding from revenue is allowed for this control budget. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| xcc_refresh_tree_history | xcc_control_budgets | CONTROL_BUDGET_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| XCC_CONTROL_BUDGETS_N1 | Non Unique | FUSION_TS_TX_DATA | SOURCE_BUDGET, SOURCE_BUDGET_SYSTEM_CODE, STATUS_CODE, START_DATE, END_DATE | |
| XCC_CONTROL_BUDGETS_N2 | Non Unique | FUSION_TS_TX_DATA | PROJECT_ID, START_DATE | Obsolete |
| XCC_CONTROL_BUDGETS_N3 | Non Unique | FUSION_TS_TX_DATA | LEDGER_ID, PROJECT_ID, PJC_CONTRACT_ID, START_DATE | |
| XCC_CONTROL_BUDGETS_N4 | Non Unique | Default | PARENT_SOURCE_SYSTEM, STATUS_CODE | |
| XCC_CONTROL_BUDGETS_N5 | Non Unique | Default | UPPER("NAME") | |
| XCC_CONTROL_BUDGETS_U1 | Unique | FUSION_TS_TX_DATA | CONTROL_BUDGET_ID |