DW_TA_CANDIDATE_PROFILE_D

This dimension captures the Candidate Profile Details

Details

Module: Recruiting

Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, CAND_PROFILE_USAGE_ID, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE

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, 2024, Oracle and/or its affiliates.