DW_TA_CANDIDATE_D

DW_TA_CANDIDATE_D stores candidate details.

Details

Module: Recruiting

Key Columns

PERSON_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Primary key of the table and also foreign Key to PER_PERSONS.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
CANDIDATE_NUMBER VARCHAR2 32 Unique readable number generated for Candidate
ADDED_BY_FLOW_CODE VARCHAR2 32 This column gives details about which business flow created the candidate.
AVAILABILITY_DATE DATE Date the candidate is available
DELETION_DATE TIMESTAMP Indicates the date and time of the deletion of the row.
CONFIRMED_FLAG VARCHAR2 16 This Flag is used to determine whether candidate is a verified or unverified.
MERGED_FLAG VARCHAR2 16 Stores if the candidate has merged data or not. If Y then candidate is alpha and has merged data.
OBJECT_STATUS VARCHAR2 64 Indicates the status of the object.
PREFERRED_LANGUAGE_CODE VARCHAR2 16 Stores the code of the candidate's preferred language.
DISPLAY_CANDIDATE_DATA_FLAG VARCHAR2 16 This flag is used to determine whether candidate has access to his/her profile information or not.
CAND_PHONE_ID NUMBER 38 0 Phone identifier
CAND_EMAIL_ID NUMBER 38 0 Email identifier