DW_SUCCSSN_PLAN_EXT_CANDIDATE_D

Holds Succession Plan External Candidate details

Details

Module: Succession Management

Key Columns

ENTERPRISE_ID, EXTERNAL_CANDIDATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXTERNAL_CANDIDATE_ID NUMBER 38 0 True Primary Key for External Candidates in Fusion Source.    
ENTERPRISE_ID NUMBER 38 0 True Primary Key for External Candidates in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier    
FIRST_NAME VARCHAR2 256     Candidate First Name    
LAST_NAME VARCHAR2 256     Candidate Last Name    
DISPLAY_NAME VARCHAR2 512     Display Name    
ADDRESS_LINE1 VARCHAR2 256     Address line 1    
ADDRESS_LINE2 VARCHAR2 256     Address Line 2    
TOWN_OR_CITY VARCHAR2 64     Town or City    
STATE VARCHAR2 128     State    
POSTAL_CODE VARCHAR2 32     Postal code    
COUNTRY VARCHAR2 64     Country    
CURRENT_EMPLOYER_NAME VARCHAR2 128     Current Employer name    
CURRENT_JOB_TITLE VARCHAR2 128     Current Job title    
EMAIL_ADDRESS VARCHAR2 256     Email Address    
PHONE_NUMBER VARCHAR2 64     Phone Number    
CREATION_DATE TIMESTAMP       Creation date of External Candidate    
LAST_UPDATE_DATE TIMESTAMP       Last updated date of external Candidate