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 This column is for Oracle Internal use only. 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