# 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. |  |

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