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   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    

Copyright © 2019, 2022, Oracle and/or its affiliates.