Oracle Fusion · Data dictionary
CMP_PLANS_B
CompensationUsed in 0 subject areas86 reporting columnsBICC incremental-ready
Compensation (CMP), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: PLAN_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_REASON_ID → PER_ACTION_REASONS_B · PLAN_ID → HRM_PLANS_V · RATING_MODEL_ID → HRT_RATING_MODELS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_ID | ● | Identifier for the action. | |
| ACTION_REASON_ID | ● | Identifier for the action reason. | |
| ANNUALIZATION_FACTOR | ● | Annualization factor. | |
| APPROVAL_MODE | ● | Approval mode. | |
| ASSIGNMENTS_TO_USE | ● | Assignments to use. | |
| BUDGET_ENABLED_FLAG | ● | Indicator (Y/N) for the budget enabled. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CLEAR_RANKING_FLAG | ● | Indicator (Y/N) for the clear ranking. | |
| COMPARATIO_INCREMENT | ● | Comparatio increment. | |
| COMPENSATION_ENABLED_FLAG | ● | Indicator (Y/N) for the compensation enabled. | |
| COMP_TYPE | ● | Type of comp. | |
| CORPORATE_CURRENCY | ● | Corporate currency. | |
| CREATED_BY | ● | User who created the row. | |
| CREATE_MODEL_ENABLED_FLAG | ● | Indicator (Y/N) for the create model enabled. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURR_SWITCH_ENABLED_FLAG | ● | Indicator (Y/N) for the currency switch enabled. | |
| EMP_STATEMENT_ENABLED_FLAG | ● | Indicator (Y/N) for the emp statement enabled. | |
| END_DATE_CODE | ● | Code identifying the end date. | |
| END_DATE_EXTRA_INFO | ● | End date extra info. | |
| END_DATE_RULE | ● | End date rule. | |
| END_DATE_TEXT | ● | End date text. | |
| EXCHANGE_RATE_TYPE | ● | Type of exchange rate. | |
| FEEDBACK_ENABLED_FLAG | ● | Indicator (Y/N) for the feedback enabled. | |
| FREQUENCY | ● | Frequency. | |
| HIERARCHY_GAP_HANDLING | ● | Hierarchy gap handling. | |
| HIERARCHY_RULE_ID | ● | Identifier for the hierarchy rule. | |
| HIERARCHY_TYPE | ● | Type of hierarchy. | |
| INTERCEPT_GROUP_ID | ● | Identifier for the intercept group. | |
| 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. | |
| LOG_PRIMARY_MISSING_RLTN | ● | Log primary missing rltn. | |
| LOG_REVIEWER_MISSING_RLTN | ● | Log reviewer missing rltn. | |
| LOG_SECONDARY_MISSING_RLTN | ● | Log secondary missing rltn. | |
| MAX_ALLOWED | ● | Max allowed. | |
| MODEL_ENABLED_FLAG | ● | Indicator (Y/N) for the model enabled. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORDER_NUM | ● | Order number. | |
| PERFORMANCE_SYSTEM | ● | Performance system. | |
| PERF_DIST_TARGET_THRESHOLD | ● | Perf distribution target threshold. | |
| PERF_DOCUMENT_ID | ● | Identifier for the perf document. | |
| PERF_LAYOUT_OPTION | ● | Perf layout option. | |
| PERF_RATING_STATUS_CODE | ● | Code identifying the perf rating status. | |
| PERF_TEMPLATE_ID | ● | Identifier for the perf template. | |
| PERF_TEMPLATE_PERIOD_ID | ● | Identifier for the perf template period. | |
| PLAN_ID | PK? | ● | Identifier for the plan. |
| PLAN_SECURITY_ENABLED_FLAG | ● | Indicator (Y/N) for the plan security enabled. | |
| PRIMARY_ACCESS_CODE | ● | Code identifying the primary access. | |
| PRIMARY_ACCESS_REFRESH_FLAG | ● | Indicator (Y/N) for the primary access refresh. | |
| PRIMARY_ACCESS_RULE_ID | ● | Identifier for the primary access rule. | |
| PRIMARY_DEPARTMENT_TREE_CODE | ● | Code identifying the primary department tree. | |
| PRIMARY_MANAGER_TYPE | ● | Type of primary manager. | |
| PRIMARY_POSITION_TREE_CODE | ● | Code identifying the primary position tree. | |
| RANGE_INCREMENT | ● | Range increment. | |
| RATING_MODEL_ID | ● | Identifier for the rating model. | |
| REVIEWER_ACCESS_CODE | ● | Code identifying the reviewer access. | |
| REVIEWER_ACCESS_REFRESH_FLAG | ● | Indicator (Y/N) for the reviewer access refresh. | |
| REVIEWER_ACCESS_RULE_ID | ● | Identifier for the reviewer access rule. | |
| REVIEWER_DEPARTMENT_TREE_CODE | ● | Code identifying the reviewer department tree. | |
| REVIEWER_HIERARCHY_RULE_ID | ● | Identifier for the reviewer hierarchy rule. | |
| REVIEWER_HIERARCHY_TYPE | ● | Type of reviewer hierarchy. | |
| REVIEWER_MANAGER_TYPE | ● | Type of reviewer manager. | |
| REVIEWER_POSITION_TREE_CODE | ● | Code identifying the reviewer position tree. | |
| REVIEW_HIERARCHY_GAP_HANDLING | ● | Review hierarchy gap handling. | |
| SECONDARY_ACCESS_CODE | ● | Code identifying the secondary access. | |
| SECONDARY_ACCESS_REFRESH_FLAG | ● | Indicator (Y/N) for the secondary access refresh. | |
| SECONDARY_ACCESS_RULE_ID | ● | Identifier for the secondary access rule. | |
| SECONDARY_DEPARTMENT_TREE_CODE | ● | Code identifying the secondary department tree. | |
| SECONDARY_HIERARCHY_RULE_ID | ● | Identifier for the secondary hierarchy rule. | |
| SECONDARY_HIERARCHY_TYPE | ● | Type of secondary hierarchy. | |
| SECONDARY_MANAGER_TYPE | ● | Type of secondary manager. | |
| SECONDARY_POSITION_TREE_CODE | ● | Code identifying the secondary position tree. | |
| SECOND_HIERARCHY_GAP_HANDLING | ● | Second hierarchy gap handling. | |
| START_DATE_CODE | ● | Code identifying the start date. | |
| START_DATE_EXTRA_INFO | ● | Start date extra info. | |
| START_DATE_RULE | ● | Start date rule. | |
| START_DATE_TEXT | ● | Start date text. | |
| STATEMENT_GROUP_ID | ● | Identifier for the statement group. | |
| STATUS_CODE | ● | Code identifying the status. | |
| STMT_OUTPUT_FORMAT | ● | Stmt output format. | |
| STMT_TRANSLATION_PREF | ● | Stmt translation pref. | |
| STMT_VIEW_STATUS | ● | Status of the stmt view. | |
| SUBMIT_MODE | ● | Submit mode. | |
| TRACK_INELIGIBLE_FLAG | ● | Indicator (Y/N) for the track ineligible. | |
| WHEN_GENERATE_STATEMENT | ● | When generate statement. | |
| YEARS_INCREMENT | ● | Years increment. |
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_PLANS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table