# DW_SUCCSSN_PLAN_EXT_CANDIDATE_D

Holds Succession Plan External Candidate details

## Details

Module: Succession Management

## Key Columns

EXTERNAL_CANDIDATE_ID, ENTERPRISE_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 |  |

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