DW_SUCCSSN_PLAN_OWNER_D

Holds Succession Plan Owner details

Details

Module: Succession Management

Key Columns

ENTERPRISE_ID, PLAN_OWNER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_OWNER_ID NUMBER 38 0 True Plan Owner Identifier    
ENTERPRISE_ID NUMBER 38 0 True Enterprise identifier    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier    
PLAN_ID NUMBER 38 0   Plan Identifier    
PERSON_ID NUMBER 38 0   Person Identifer DW_PERSON_D PERSON_ID
OWNER_TYPE_CODE VARCHAR2 32     Owner Type code    
CREATION_DATE TIMESTAMP       Creation Date of plan owner    
LAST_UPDATE_DATE TIMESTAMP       Last updated date of plan owner