CMP_PLANS_VL

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name

PLAN_ID STATUS_CODE ORDER_NUM HIERARCHY_TYPE ANNUALIZATION_FACTOR CORPORATE_CURRENCY BUSINESS_GROUP_ID APPROVAL_MODE SUBMIT_MODE START_DATE_CODE END_DATE_CODE START_DATE_RULE END_DATE_RULE MAX_ALLOWED COMP_TYPE PLAN_SECURITY_ENABLED_FLAG FREQUENCY START_DATE_TEXT END_DATE_TEXT START_DATE_EXTRA_INFO END_DATE_EXTRA_INFO ASSIGNMENTS_TO_USE HIERARCHY_GAP_HANDLING TRACK_INELIGIBLE_FLAG CURR_SWITCH_ENABLED_FLAG EXCHANGE_RATE_TYPE FEEDBACK_ENABLED_FLAG BUDGET_ENABLED_FLAG COMPENSATION_ENABLED_FLAG PERFORMANCE_SYSTEM PERF_LAYOUT_OPTION PERF_DIST_TARGET_THRESHOLD PERF_DOCUMENT_ID PERF_TEMPLATE_ID PERF_TEMPLATE_PERIOD_ID PERF_RATING_STATUS_CODE RATING_MODEL_ID INTERCEPT_GROUP_ID CLEAR_RANKING_FLAG EMP_STATEMENT_ENABLED_FLAG STATEMENT_GROUP_ID WHEN_GENERATE_STATEMENT MODEL_ENABLED_FLAG CREATE_MODEL_ENABLED_FLAG COMPARATIO_INCREMENT YEARS_INCREMENT RANGE_INCREMENT HIERARCHY_RULE_ID ACTION_ID ACTION_REASON_ID COMPETENCY_RATING_INCREMENT GOAL_RATING_INCREMENT OVERALL_RATING_INCREMENT PLAN_NAME DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN STMT_VIEW_STATUS STMT_TRANSLATION_PREF STMT_OUTPUT_FORMAT DEFAULT_CURR_TYPE_CODE LOG_PRIMARY_MISSING_RLTN PRIMARY_ACCESS_CODE PRIMARY_ACCESS_RULE_ID PRIMARY_MANAGER_TYPE SECONDARY_HIERARCHY_TYPE SECOND_HIERARCHY_GAP_HANDLING SECONDARY_HIERARCHY_RULE_ID LOG_SECONDARY_MISSING_RLTN SECONDARY_ACCESS_CODE SECONDARY_ACCESS_RULE_ID SECONDARY_MANAGER_TYPE REVIEWER_MANAGER_TYPE REVIEW_HIERARCHY_GAP_HANDLING REVIEWER_HIERARCHY_RULE_ID LOG_REVIEWER_MISSING_RLTN REVIEWER_ACCESS_CODE REVIEWER_ACCESS_RULE_ID REVIEWER_HIERARCHY_TYPE PRIMARY_POSITION_TREE_CODE SECONDARY_POSITION_TREE_CODE REVIEWER_POSITION_TREE_CODE PRIMARY_DEPARTMENT_TREE_CODE SECONDARY_DEPARTMENT_TREE_CODE REVIEWER_DEPARTMENT_TREE_CODE HIDE_INELIGIBLE_FLAG DISPLAY_ROWS FREEZE_COLS TABLE_VIEW FILTER_REPORTS STMT_DELIVERY_TYPE STMT_DAYS_UNTIL_EXPIRATION MULTIPLE_STMT_ENABLED_FLAG FILTERS_FLAG INSTRUCTIONS_FLAG SUMMARY_SECTION_FLAG TABLE_DENSITY PLAN_INFO_ENABLED_FLAG PLAN_INFO_TASK_NAME INDVDL_PG_ENABLED_FLAG INDVDL_PAGE_STYLE_CODE PRIMARY_ACCESS_REFRESH_FLAG SECONDARY_ACCESS_REFRESH_FLAG REVIEWER_ACCESS_REFRESH_FLAG MANAGE_MODEL_DI_ENABLED_FLAG MODEL_BATCH_LIMIT ASG_NAME_PROMOTE_FLAG ASG_NAME_POST_FLAG PERF_REVIEW_PERIOD_ID ALLOW_STAGGERED_STMT_RELEASE ENABLE_ASSIGNMENT_SEGMENTS ASG_SEG_RECORD_TYPE_CODE ASG_SEG_SHOW_INELIG_ROWS_FLAG ASG_SEG_SHOW_DETACH_FLAG PERF_RATING_ORDER STMT_GLOBAL_NAME ANALYTIC_REGION_COLLAPSE_FLAG WITHDRAW_MODE LD_PG_APPR_CHAIN_HIDE_FLAG WRKSHT_COLS_SORT_FLAG CURRENCY_DISP_TYPE PLAN_VALIDATION_DATE

Query

SQL_Statement

SELECT B.PLAN_ID, B.STATUS_CODE, B.ORDER_NUM, B.HIERARCHY_TYPE, B.ANNUALIZATION_FACTOR, B.CORPORATE_CURRENCY, B.BUSINESS_GROUP_ID, B.APPROVAL_MODE, B.SUBMIT_MODE, B.START_DATE_CODE, B.END_DATE_CODE, B.START_DATE_RULE, B.END_DATE_RULE, B.MAX_ALLOWED, B.COMP_TYPE, B.PLAN_SECURITY_ENABLED_FLAG, B.FREQUENCY, B.START_DATE_TEXT, B.END_DATE_TEXT, B.START_DATE_EXTRA_INFO, B.END_DATE_EXTRA_INFO, B.ASSIGNMENTS_TO_USE, B.HIERARCHY_GAP_HANDLING, B.TRACK_INELIGIBLE_FLAG, B.CURR_SWITCH_ENABLED_FLAG, B.EXCHANGE_RATE_TYPE, B.FEEDBACK_ENABLED_FLAG, B.BUDGET_ENABLED_FLAG, B.COMPENSATION_ENABLED_FLAG, B.PERFORMANCE_SYSTEM, B.PERF_LAYOUT_OPTION, B.PERF_DIST_TARGET_THRESHOLD, B.PERF_DOCUMENT_ID, B.PERF_TEMPLATE_ID, B.PERF_TEMPLATE_PERIOD_ID, B.PERF_RATING_STATUS_CODE, B.RATING_MODEL_ID, B.INTERCEPT_GROUP_ID, B.CLEAR_RANKING_FLAG, B.EMP_STATEMENT_ENABLED_FLAG, B.STATEMENT_GROUP_ID, B.WHEN_GENERATE_STATEMENT, B.MODEL_ENABLED_FLAG, B.CREATE_MODEL_ENABLED_FLAG, B.COMPARATIO_INCREMENT, B.YEARS_INCREMENT, B.RANGE_INCREMENT, B.HIERARCHY_RULE_ID, B.ACTION_ID, B.ACTION_REASON_ID, B.COMPETENCY_RATING_INCREMENT, B.GOAL_RATING_INCREMENT, B.OVERALL_RATING_INCREMENT, T.PLAN_NAME, T.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.STMT_VIEW_STATUS, B.STMT_TRANSLATION_PREF, B.STMT_OUTPUT_FORMAT, B.DEFAULT_CURR_TYPE_CODE, B.LOG_PRIMARY_MISSING_RLTN, B.PRIMARY_ACCESS_CODE, B.PRIMARY_ACCESS_RULE_ID, B.PRIMARY_MANAGER_TYPE, B.SECONDARY_HIERARCHY_TYPE, B.SECOND_HIERARCHY_GAP_HANDLING, B.SECONDARY_HIERARCHY_RULE_ID, B.LOG_SECONDARY_MISSING_RLTN, B.SECONDARY_ACCESS_CODE, B.SECONDARY_ACCESS_RULE_ID, B.SECONDARY_MANAGER_TYPE, B.REVIEWER_MANAGER_TYPE, B.REVIEW_HIERARCHY_GAP_HANDLING, B.REVIEWER_HIERARCHY_RULE_ID, B.LOG_REVIEWER_MISSING_RLTN, B.REVIEWER_ACCESS_CODE, B.REVIEWER_ACCESS_RULE_ID, B.REVIEWER_HIERARCHY_TYPE, B.PRIMARY_POSITION_TREE_CODE, B.SECONDARY_POSITION_TREE_CODE, B.REVIEWER_POSITION_TREE_CODE, B.PRIMARY_DEPARTMENT_TREE_CODE, B.SECONDARY_DEPARTMENT_TREE_CODE, B.REVIEWER_DEPARTMENT_TREE_CODE, B.HIDE_INELIGIBLE_FLAG, B.DISPLAY_ROWS, B.FREEZE_COLS, B.TABLE_VIEW, B.FILTER_REPORTS, B.STMT_DELIVERY_TYPE, B.STMT_DAYS_UNTIL_EXPIRATION, B.MULTIPLE_STMT_ENABLED_FLAG, B.FILTERS_FLAG, B.INSTRUCTIONS_FLAG, B.SUMMARY_SECTION_FLAG, B.TABLE_DENSITY, B.PLAN_INFO_ENABLED_FLAG, T.PLAN_INFO_TASK_NAME, B.INDVDL_PG_ENABLED_FLAG, B.INDVDL_PAGE_STYLE_CODE, B.PRIMARY_ACCESS_REFRESH_FLAG, B.SECONDARY_ACCESS_REFRESH_FLAG, B.REVIEWER_ACCESS_REFRESH_FLAG, B.MANAGE_MODEL_DI_ENABLED_FLAG, B.MODEL_BATCH_LIMIT, B.ASG_NAME_PROMOTE_FLAG, B.ASG_NAME_POST_FLAG, B.PERF_REVIEW_PERIOD_ID, B.ALLOW_STAGGERED_STMT_RELEASE, B.ENABLE_ASSIGNMENT_SEGMENTS, B.ASG_SEG_RECORD_TYPE_CODE, B.ASG_SEG_SHOW_INELIG_ROWS_FLAG, B.ASG_SEG_SHOW_DETACH_FLAG, B.PERF_RATING_ORDER, T.STMT_GLOBAL_NAME, B.ANALYTIC_REGION_COLLAPSE_FLAG, B.WITHDRAW_MODE, B.LD_PG_APPR_CHAIN_HIDE_FLAG, B.WRKSHT_COLS_SORT_FLAG, B.CURRENCY_DISP_TYPE, B.PLAN_VALIDATION_DATE FROM CMP_PLANS_B B, CMP_PLANS_TL T WHERE B.PLAN_ID = T.PLAN_ID AND B.BUSINESS_GROUP_ID = T.BUSINESS_GROUP_ID AND T.LANGUAGE = USERENV('LANG')