DW_TA_CANDIDATE_D
DW_TA_CANDIDATE_D stores candidate details.
Details
Module: Recruiting
Key Columns
PERSON_ID
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 |