DW_PERSON_TYPE_USAGE_D

This dimension captures the Person Type Usage Details

Details

Module: Recruiting

Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_SEQUENCE, EFFECTIVE_END_DATE, PERSON_TYPE_USAGE_ID, EFFECTIVE_LATEST_CHANGE

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 This column is for Oracle Internal use only. Unique Identifier
PERSON_ID NUMBER 38 0 Profile Identifier DW_PERSON_D PERSON_ID
SYSTEM_PERSON_TYPE VARCHAR2 32 Person Identifier