DW_TA_OFFER_D

This dimension captures the Offer Details

Details

Module: Recruiting

Key Columns

OFFER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OFFER_ID NUMBER 38 0 True Offer Identifier    
SOURCE_RECORD_ID NUMBER 38 0   unique key    
OFFER_NAME VARCHAR2 256     Name of the offer    
EXPIRATION_DATE DATE       Offer Expiration Date    
JOB_APPLICATION_ID NUMBER 38 0   Job Application Identifier DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
PERSON_ID NUMBER 38 0   Person Identifier DW_PERSON_D PERSON_ID
RECRUITER_ID NUMBER 38 0   Recruiter Identifier DW_PERSON_D PERSON_ID
RECRUITER_ASSIGNMENT_ID NUMBER 38 0   Recruiter Assignment Identifier    
ASSIGNMENT_OFFER_ID NUMBER 38 0   Assignment Offer Identifier    
HIRING_MANAGER_ID NUMBER 38 0   Hiring Manager Identifier DW_PERSON_D PERSON_ID
MANAGER_ASSIGNMENT_ID NUMBER 38 0   Manager Assignment Identifier    
ACCEPTED_ON_BEHALF VARCHAR2 16     Flag whether the offer was accepted on behalf of someone else    
ACCEPTED_ON_BEHALF_BY_ID NUMBER 38 0   Identifier if the offer was accepted on behalf of someone else    
ACCEPTED_ON_BEHALF_DATE DATE       Date when offer was accepted on behalf of someone else