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    
LAST_EXTENDED_DATE TIMESTAMP       Stores last extended date.    
LAST_WITHDRAWN_REJECTED_DATE TIMESTAMP       Stores last withdrawn date.    
APPROVED_DATE TIMESTAMP       Stores approved date.    
ACCEPTED_DATE TIMESTAMP       Stores last accepted date    
PROPOSED_ACTION NUMBER 38 0   Stores the action id of the Offer.    
OBJECT_STATUS VARCHAR2 32     Stores the status of the object.    
MOVE_TO_HR_DATE TIMESTAMP       Timestamp when the offer got moved to HR phase.    

Copyright © 2019, 2023, Oracle and/or its affiliates.