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