Holds Succession Plan External Candidate details
Module: Succession Management
ENTERPRISE_ID, EXTERNAL_CANDIDATE_ID
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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.