Oracle Fusion · Data dictionary
CMP_CWB_PERSON_RATES
CompensationUsed in 0 subject areas40 reporting columnsBICC incremental-ready
Compensation (CMP).
Primary key: not yet catalogued for CMP_CWB_PERSON_RATES — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| COMPONENT_ID | ● | Identifier for the component. | |
| COMP_POSTED_DATE | ● | Comp posted date. | |
| COMP_POSTING_DATE | ● | Comp posting date. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENCY | ● | Currency. | |
| ELIG_FLAG | ● | Indicator (Y/N) for the elig. | |
| ELIG_OVERRIDE_DATE | ● | Elig override date. | |
| ELIG_OVERRIDE_PERSON_ID | ● | Identifier for the elig override person. | |
| ELIG_SAL_VAL | ● | Elig sal val. | |
| EMP_BDGT_MAX_VAL | ● | Emp bdgt max val. | |
| EMP_BDGT_MIN_VAL | ● | Emp bdgt min val. | |
| EMP_BDGT_VAL | ● | Emp bdgt val. | |
| 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. | |
| MISC1_VAL | ● | Misc1 val. | |
| MISC2_VAL | ● | Misc2 val. | |
| MISC3_VAL | ● | Misc3 val. | |
| MISC4_VAL | ● | Misc4 val. | |
| MISC5_VAL | ● | Misc5 val. | |
| MISC6_VAL | ● | Misc6 val. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PERIOD_ID | ● | Identifier for the period. | |
| PERSON_EVENT_ID | ● | Identifier for the person event. | |
| PERSON_ID | ● | Identifier for the person. | |
| PLAN_ID | ● | Identifier for the plan. | |
| PRIOR_ELIG_SAL_VAL | ● | Prior elig sal val. | |
| PRIOR_WS_VAL | ● | Prior ws val. | |
| PRIOR_WS_VAL_DATE | ● | Prior ws val date. | |
| REC_MAX_VAL | ● | Rec max val. | |
| REC_MIN_VAL | ● | Rec min val. | |
| REC_VAL | ● | Rec val. | |
| WS_MAX_VAL | ● | Ws max val. | |
| WS_MIN_VAL | ● | Ws min val. | |
| WS_VAL | ● | Ws val. | |
| WS_VAL_LAST_UPD_BY | ● | Ws val last upd by. | |
| WS_VAL_LAST_UPD_DATE | ● | Ws val last upd date. | |
| WS_VAL_ORIG_UPD_BY | ● | Ws val orig upd by. |
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_CWB_PERSON_RATES?
We ship parameterized SQL, BICC config, and dbt models you own.