# 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 |  |

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