DW_CMP_PLAN_DEFINITION_D

This dimension captures the Plan Definition Details

Details

Module: Compensation

Key Columns

PLAN_DEFINITION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_DEFINITION_ID NUMBER 38 0 True Plan Definition Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source Record Identifier
PLAN_ID NUMBER 38 0 Plan Identifier DW_CMP_PLAN_D PLAN_ID
PERIOD_ID NUMBER 38 0 Period Identifier DW_CMP_PLAN_PERIOD_D PERIOD_ID
DEFINITION_TYPE VARCHAR2 32 Definition Type
BUSINESS_GROUP_ID NUMBER 38 0 Business_Group Identifier
STATUS_CODE VARCHAR2 32 Status Code DW_CMP_PLAN_PERIOD_STATUS_D_TL PLAN_PERIOD_STATUS_CODE
CORPORATE_CURRENCY VARCHAR2 32 Corporate Currency
PLAN_COMPONENT_COUNT NUMBER Plan_Component Count
APPROVAL_MODE VARCHAR2 32 Approval Mode
SUBMIT_MODE VARCHAR2 32 Submit Mode
BUDGETING_STYLE VARCHAR2 32 Budgeting Style
POST_AS_SALARY_FLAG VARCHAR2 16 Post_As_Salary Flag