Holds Succession Plan External Candidate details
Module: Succession Management
EXTERNAL_CANDIDATE_ID, ENTERPRISE_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 | 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, 2024, Oracle and/or its affiliates.