DW_PERSON_TYPE_USAGE_D

This dimension captures the Person Type Usage Details

Details

Module: Recruiting

Key Columns

EFFECTIVE_LATEST_CHANGE, EFFECTIVE_END_DATE, EFFECTIVE_SEQUENCE, PERSON_TYPE_USAGE_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_TYPE_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     Unique Identifier    
PERSON_ID NUMBER 38 0   Profile Identifier DW_PERSON_D PERSON_ID
SYSTEM_PERSON_TYPE VARCHAR2 32     Person Identifier