CMP_PLANS_B
Stores compensation plan information.
Details
-
Schema: FUSION
-
Object owner: CMP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMP_PLANS_B_PK |
PLAN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | PLAN_ID | |
| SECONDARY_POSITION_TREE_CODE | VARCHAR2 | 30 | SECONDARY_POSITION_TREE_CODE | ||
| REVIEWER_POSITION_TREE_CODE | VARCHAR2 | 30 | REVIEWER_POSITION_TREE_CODE | ||
| PRIMARY_DEPARTMENT_TREE_CODE | VARCHAR2 | 30 | PRIMARY_DEPARTMENT_TREE_CODE | ||
| SECONDARY_DEPARTMENT_TREE_CODE | VARCHAR2 | 30 | SECONDARY_DEPARTMENT_TREE_CODE | ||
| REVIEWER_DEPARTMENT_TREE_CODE | VARCHAR2 | 30 | REVIEWER_DEPARTMENT_TREE_CODE | ||
| PRIMARY_POSITION_TREE_CODE | VARCHAR2 | 30 | PRIMARY_POSITION_TREE_CODE | ||
| LOG_PRIMARY_MISSING_RLTN | VARCHAR2 | 1 | LOG_PRIMARY_MISSING_RLTN | ||
| PRIMARY_ACCESS_CODE | VARCHAR2 | 30 | PRIMARY_ACCESS_CODE | ||
| PRIMARY_ACCESS_RULE_ID | NUMBER | 18 | PRIMARY_ACCESS_RULE_ID | ||
| PRIMARY_MANAGER_TYPE | VARCHAR2 | 30 | PRIMARY_MANAGER_TYPE | ||
| SECONDARY_HIERARCHY_TYPE | VARCHAR2 | 30 | SECONDARY_HIERARCHY_TYPE | ||
| SECOND_HIERARCHY_GAP_HANDLING | VARCHAR2 | 30 | SECOND_HIERARCHY_GAP_HANDLING | ||
| SECONDARY_HIERARCHY_RULE_ID | NUMBER | 18 | SECONDARY_HIERARCHY_RULE_ID | ||
| LOG_SECONDARY_MISSING_RLTN | VARCHAR2 | 1 | LOG_SECONDARY_MISSING_RLTN | ||
| SECONDARY_ACCESS_CODE | VARCHAR2 | 30 | SECONDARY_ACCESS_CODE | ||
| SECONDARY_ACCESS_RULE_ID | NUMBER | 18 | SECONDARY_ACCESS_RULE_ID | ||
| SECONDARY_MANAGER_TYPE | VARCHAR2 | 30 | SECONDARY_MANAGER_TYPE | ||
| REVIEWER_MANAGER_TYPE | VARCHAR2 | 30 | REVIEWER_MANAGER_TYPE | ||
| REVIEW_HIERARCHY_GAP_HANDLING | VARCHAR2 | 30 | REVIEW_HIERARCHY_GAP_HANDLING | ||
| REVIEWER_HIERARCHY_RULE_ID | NUMBER | 18 | REVIEWER_HIERARCHY_RULE_ID | ||
| LOG_REVIEWER_MISSING_RLTN | VARCHAR2 | 1 | LOG_REVIEWER_MISSING_RLTN | ||
| REVIEWER_ACCESS_CODE | VARCHAR2 | 30 | REVIEWER_ACCESS_CODE | ||
| REVIEWER_ACCESS_RULE_ID | NUMBER | 18 | REVIEWER_ACCESS_RULE_ID | ||
| REVIEWER_HIERARCHY_TYPE | VARCHAR2 | 30 | REVIEWER_HIERARCHY_TYPE | ||
| DEFAULT_CURR_TYPE_CODE | VARCHAR2 | 30 | DEFAULT_CURR_TYPE_CODE | ||
| RATING_MODEL_ID | NUMBER | 18 | RATING_MODEL_ID | ||
| STMT_VIEW_STATUS | VARCHAR2 | 30 | STMT_VIEW_STATUS | ||
| STMT_TRANSLATION_PREF | VARCHAR2 | 30 | STMT_TRANSLATION_PREF | ||
| STMT_OUTPUT_FORMAT | VARCHAR2 | 30 | STMT_OUTPUT_FORMAT | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | STATUS_CODE | |
| ORDER_NUM | NUMBER | ORDER_NUM | |||
| HIERARCHY_TYPE | VARCHAR2 | 30 | HIERARCHY_TYPE | ||
| ANNUALIZATION_FACTOR | NUMBER | ANNUALIZATION_FACTOR | |||
| CORPORATE_CURRENCY | VARCHAR2 | 5 | CORPORATE_CURRENCY | ||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | BUSINESS_GROUP_ID | |
| APPROVAL_MODE | VARCHAR2 | 30 | APPROVAL_MODE | ||
| SUBMIT_MODE | VARCHAR2 | 30 | SUBMIT_MODE | ||
| START_DATE_CODE | VARCHAR2 | 30 | START_DATE_CODE | ||
| END_DATE_CODE | VARCHAR2 | 30 | END_DATE_CODE | ||
| START_DATE_RULE | NUMBER | 18 | START_DATE_RULE | ||
| END_DATE_RULE | NUMBER | 18 | END_DATE_RULE | ||
| MAX_ALLOWED | NUMBER | 3 | MAX_ALLOWED | ||
| COMP_TYPE | VARCHAR2 | 30 | COMP_TYPE | ||
| PLAN_SECURITY_ENABLED_FLAG | VARCHAR2 | 1 | PLAN_SECURITY_ENABLED_FLAG | ||
| FREQUENCY | VARCHAR2 | 30 | FREQUENCY | ||
| START_DATE_TEXT | VARCHAR2 | 30 | START_DATE_TEXT | ||
| END_DATE_TEXT | VARCHAR2 | 30 | END_DATE_TEXT | ||
| START_DATE_EXTRA_INFO | DATE | START_DATE_EXTRA_INFO | |||
| END_DATE_EXTRA_INFO | DATE | END_DATE_EXTRA_INFO | |||
| ASSIGNMENTS_TO_USE | VARCHAR2 | 30 | ASSIGNMENTS_TO_USE | ||
| HIERARCHY_GAP_HANDLING | VARCHAR2 | 30 | HIERARCHY_GAP_HANDLING | ||
| TRACK_INELIGIBLE_FLAG | VARCHAR2 | 1 | TRACK_INELIGIBLE_FLAG | ||
| HIDE_INELIGIBLE_FLAG | VARCHAR2 | 1 | HIDE_INELIGIBLE_FLAG | ||
| CURR_SWITCH_ENABLED_FLAG | VARCHAR2 | 1 | CURR_SWITCH_ENABLED_FLAG | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | EXCHANGE_RATE_TYPE | ||
| FEEDBACK_ENABLED_FLAG | VARCHAR2 | 1 | FEEDBACK_ENABLED_FLAG | ||
| BUDGET_ENABLED_FLAG | VARCHAR2 | 1 | BUDGET_ENABLED_FLAG | ||
| COMPENSATION_ENABLED_FLAG | VARCHAR2 | 1 | COMPENSATION_ENABLED_FLAG | ||
| PERFORMANCE_SYSTEM | VARCHAR2 | 30 | PERFORMANCE_SYSTEM | ||
| PERF_LAYOUT_OPTION | VARCHAR2 | 30 | PERF_LAYOUT_OPTION | ||
| PERF_DIST_TARGET_THRESHOLD | NUMBER | 18 | PERF_DIST_TARGET_THRESHOLD | ||
| PERF_DOCUMENT_ID | NUMBER | 18 | PERF_DOCUMENT_ID | ||
| PERF_TEMPLATE_ID | NUMBER | 18 | PERF_TEMPLATE_ID | ||
| PERF_TEMPLATE_PERIOD_ID | NUMBER | 18 | PERF_TEMPLATE_PERIOD_ID | ||
| PERF_RATING_STATUS_CODE | VARCHAR2 | 30 | PERF_RATING_STATUS_CODE | ||
| INTERCEPT_GROUP_ID | NUMBER | 18 | INTERCEPT_GROUP_ID | ||
| CLEAR_RANKING_FLAG | VARCHAR2 | 1 | CLEAR_RANKING_FLAG | ||
| EMP_STATEMENT_ENABLED_FLAG | VARCHAR2 | 1 | EMP_STATEMENT_ENABLED_FLAG | ||
| STATEMENT_GROUP_ID | NUMBER | 18 | STATEMENT_GROUP_ID | ||
| WHEN_GENERATE_STATEMENT | VARCHAR2 | 30 | WHEN_GENERATE_STATEMENT | ||
| MODEL_ENABLED_FLAG | VARCHAR2 | 1 | MODEL_ENABLED_FLAG | ||
| CREATE_MODEL_ENABLED_FLAG | VARCHAR2 | 1 | CREATE_MODEL_ENABLED_FLAG | ||
| COMPARATIO_INCREMENT | NUMBER | COMPARATIO_INCREMENT | |||
| YEARS_INCREMENT | NUMBER | YEARS_INCREMENT | |||
| RANGE_INCREMENT | NUMBER | RANGE_INCREMENT | |||
| HIERARCHY_RULE_ID | NUMBER | 18 | HIERARCHY_RULE_ID | ||
| ACTION_ID | NUMBER | 18 | ACTION_ID | ||
| ACTION_REASON_ID | NUMBER | 18 | ACTION_REASON_ID | ||
| COMPETENCY_RATING_INCREMENT | NUMBER | COMPETENCY_RATING_INCREMENT | |||
| GOAL_RATING_INCREMENT | NUMBER | GOAL_RATING_INCREMENT | |||
| OVERALL_RATING_INCREMENT | NUMBER | OVERALL_RATING_INCREMENT | |||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| DISPLAY_ROWS | NUMBER | 3 | DISPLAY ROWS FOR WORKSHEET DEFAULT LAYOUT | ||
| FREEZE_COLS | NUMBER | 2 | FREEZE COLS FOR WORKSHEET DEFAULT LAYOUT | ||
| TABLE_VIEW | NUMBER | 1 | TABLE VIEW FOR WORKSHEET DEFAULT LAYOUT | ||
| FILTER_REPORTS | NUMBER | 18 | FILTER REPORTS FOR WORKSHEET DEFAULT LAYOUT | ||
| STMT_DELIVERY_TYPE | VARCHAR2 | 30 | STMT_DELIVERY_TYPE | ||
| MULTIPLE_STMT_ENABLED_FLAG | VARCHAR2 | 1 | MULTIPLE_STMT_ENABLED_FLAG | ||
| STMT_DAYS_UNTIL_EXPIRATION | NUMBER | 18 | STMT_DAYS_UNTIL_EXPIRATION | ||
| FILTERS_FLAG | VARCHAR2 | 30 | FILTERS_FLAG | ||
| INSTRUCTIONS_FLAG | VARCHAR2 | 30 | INSTRUCTIONS_FLAG | ||
| SUMMARY_SECTION_FLAG | VARCHAR2 | 30 | SUMMARY_SECTION_FLAG | ||
| TABLE_DENSITY | VARCHAR2 | 30 | TABLE_DENSITY | ||
| PLAN_INFO_ENABLED_FLAG | VARCHAR2 | 1 | PLAN_INFO_ENABLED_FLAG | ||
| INDVDL_PG_ENABLED_FLAG | VARCHAR2 | 1 | INDVDL_PG_ENABLED_FLAG | ||
| INDVDL_PAGE_STYLE_CODE | VARCHAR2 | 30 | INDVDL_PAGE_STYLE_CODE | ||
| PRIMARY_ACCESS_REFRESH_FLAG | VARCHAR2 | 1 | PRIMARY_ACCESS_REFRESH_FLAG | ||
| SECONDARY_ACCESS_REFRESH_FLAG | VARCHAR2 | 1 | SECONDARY_ACCESS_REFRESH_FLAG | ||
| REVIEWER_ACCESS_REFRESH_FLAG | VARCHAR2 | 1 | REVIEWER_ACCESS_REFRESH_FLAG | ||
| MANAGE_MODEL_DI_ENABLED_FLAG | VARCHAR2 | 1 | MANAGE_MODEL_DI_ENABLED_FLAG | ||
| MODEL_BATCH_LIMIT | NUMBER | 10 | MODEL_BATCH_LIMIT | ||
| ASG_NAME_PROMOTE_FLAG | VARCHAR2 | 1 | ASG_NAME_PROMOTE_FLAG | ||
| ASG_NAME_POST_FLAG | VARCHAR2 | 1 | ASG_NAME_POST_FLAG | ||
| PERF_REVIEW_PERIOD_ID | NUMBER | 18 | PERF_REVIEW_PERIOD_ID | ||
| ALLOW_STAGGERED_STMT_RELEASE | VARCHAR2 | 1 | ALLOW_STAGGERED_STMT_RELEASE | ||
| ENABLE_ASSIGNMENT_SEGMENTS | VARCHAR2 | 1 | ENABLE_ASSIGNMENT_SEGMENTS | ||
| ASG_SEG_RECORD_TYPE_CODE | VARCHAR2 | 30 | ASG_SEG_RECORD_TYPE_CODE | ||
| ASG_SEG_SHOW_INELIG_ROWS_FLAG | VARCHAR2 | 1 | ASG_SEG_SHOW_INELIG_ROWS_FLAG | ||
| ASG_SEG_SHOW_DETACH_FLAG | VARCHAR2 | 1 | ASG_SEG_SHOW_DETACH_FLAG | ||
| PERF_RATING_ORDER | VARCHAR2 | 30 | PERF_RATING_ORDER | ||
| ANALYTIC_REGION_COLLAPSE_FLAG | VARCHAR2 | 1 | ANALYTIC_REGION_COLLAPSE_FLAG | ||
| WITHDRAW_MODE | VARCHAR2 | 30 | WITHDRAW_MODE | ||
| LD_PG_APPR_CHAIN_HIDE_FLAG | VARCHAR2 | 1 | LD_PG_APPR_CHAIN_HIDE_FLAG | ||
| WRKSHT_COLS_SORT_FLAG | VARCHAR2 | 1 | WRKSHT_COLS_SORT_FLAG | ||
| CURRENCY_DISP_TYPE | VARCHAR2 | 30 | CURRENCY_DISP_TYPE | ||
| PLAN_VALIDATION_DATE | TIMESTAMP | PLAN_VALIDATION_DATE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMP_PLANS_B_N2 | Non Unique | FUSION_TS_TX_DATA | PLAN_ID, STATEMENT_GROUP_ID |
| CMP_PLANS_B_N3 | Non Unique | Default | COMP_TYPE |
| CMP_PLANS_B_UK1 | Unique | FUSION_TS_TX_DATA | PLAN_ID |