Oracle Fusion · Data dictionary
CMP_PERSON_BUDGETS_V
CompensationUsed in 0 subject areas47 reporting columnsBICC incremental-ready
Compensation (CMP), denormalized view.
Primary key: not yet catalogued for CMP_PERSON_BUDGETS_V, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): POOL_ID → HRT_POOLS_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCESS_CD | ● | Access code. | |
| BUDGETING_STYLE | ● | Budgeting style. | |
| BUDGET_LAST_UPD_DATE | ● | Budget last upd date. | |
| BUDGET_POP_CD | ● | Budget pop code. | |
| BUDGET_VAL_AMOUNT | ● | Budget val amount. | |
| BUDGET_VAL_PERCENT | ● | Budget val percentage. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DFLT_DIST_BUDGET_VAL | ● | Dflt distribution budget val. | |
| DFLT_WS_BUDGET_VAL | ● | Dflt ws budget val. | |
| DIST_BUDGET_ISSUE_DATE | ● | Distribution budget issue date. | |
| DIST_BUDGET_ISSUE_VAL | ● | Distribution budget issue val. | |
| DIST_BUDGET_VAL | ● | Distribution budget val. | |
| DIST_BUDGET_VAL_LAST_UPD_BY | ● | Distribution budget val last upd by. | |
| DIST_BUDGET_VAL_LAST_UPD_DATE | ● | Distribution budget val last upd date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OVERALL_BUDGET_AMOUNT | ● | Overall budget amount. | |
| OVERRIDE_OVER_ALLOCATE_CODE | ● | Code identifying the override over allocate. | |
| OVERRIDE_OVER_BUDGET_CODE | ● | Code identifying the override over budget. | |
| PERIOD_ID | ● | Identifier for the period. | |
| PERSON_EVENT_ID | ● | Identifier for the person event. | |
| PLAN_ID | ● | Identifier for the plan. | |
| POOL_ID | ● | Identifier for the pool. | |
| PUBLISHED_DIST_BUDGET_AMOUNT | ● | Published distribution budget amount. | |
| PUBLISHED_DIST_BUDGET_PCT | ● | Published distribution budget percent. | |
| PUBLISHED_WS_BUDGET_AMOUNT | ● | Published ws budget amount. | |
| PUBLISHED_WS_BUDGET_PCT | ● | Published ws budget percent. | |
| REC_MN_VAL_ALL | ● | Rec mn val all. | |
| REC_MX_VAL_ALL | ● | Rec mx val all. | |
| REC_VAL_ALL | ● | Rec val all. | |
| TOTAL_DIRECT_WORKERS | ● | Total direct workers. | |
| TOTAL_ELIGIBLE_SALARY | ● | Total eligible salary. | |
| TOTAL_ELIGIBLE_WORKERS | ● | Total eligible workers. | |
| UNPUBLISHED_DIST_BUDGET_AMOUNT | ● | Unpublished distribution budget amount. | |
| UNPUBLISHED_DIST_BUDGET_PCT | ● | Unpublished distribution budget percent. | |
| UNPUBLISHED_WS_BUDGET_AMOUNT | ● | Unpublished ws budget amount. | |
| UNPUBLISHED_WS_BUDGET_PCT | ● | Unpublished ws budget percent. | |
| USED_BUDGET | ● | Used budget. | |
| USER_PREFERRED_EXCHANGE_RATE | ● | User preferred exchange rate. | |
| WS_BUDGET_ISSUE_DATE | ● | Ws budget issue date. | |
| WS_BUDGET_ISSUE_VAL | ● | Ws budget issue val. | |
| WS_BUDGET_VAL | ● | Ws budget val. | |
| WS_BUDGET_VAL_LAST_UPD_BY | ● | Ws budget val last upd by. | |
| WS_BUDGET_VAL_LAST_UPD_DATE | ● | Ws budget val last upd date. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for CMP_PERSON_BUDGETS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table