This dimension captures the Offer Details
Module: Recruiting
OFFER_ID
| 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, 2024, Oracle and/or its affiliates.