DW_TA_CANDIDATE_PROFILE_D

This dimension captures the Candidate Profile Details

Details

Module: Recruiting

Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, CAND_PROFILE_USAGE_ID

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