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 This column is for Oracle Internal use only. 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.