# DW_TA_CANDIDATE_PROFILE_D

This dimension captures the Candidate Profile Details

## Details

Module: Recruiting

## Key Columns

CAND_PROFILE_USAGE_ID, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_START_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CAND_PROFILE_USAGE_ID | NUMBER | 38 | 0 | True | Candidate profile usage identifier |  |
EFFECTIVE_START_DATE | DATE |  |  | True | Candidate profile effective start date |  |
EFFECTIVE_END_DATE | DATE |  |  | True | Candidate profile effective end date |  |
EFFECTIVE_SEQUENCE | NUMBER | 38 | 0 | True | Candidate profile effective sequence |  |
EFFECTIVE_LATEST_CHANGE | VARCHAR2 | 32 |  | True | Candidate profile effective latest change |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Identifier |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Profile Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier | DW_PERSON_D | PERSON_ID

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