Attributes for Job Offers
This table lists the main attributes of the Job Offers business object and exceptions for any attribute, if any.
Attribute |
Field Name |
Description |
Supported by LOV |
---|---|---|---|
ASSIGNMENT_OFFER_ID |
Assignment Offer ID |
Stores the ASSIGNMENT_ID of the Offer. Foreign key to PER_ALL_ASSIGNMENTS_M table. |
|
MANAGER_ASSIGNMENT_ID |
Hiring Manager Assignment ID |
Stores the ASSIGNMENT_ID of the hiring manager's assignment for this offer. Foreign key to PER_ALL_ASSIGNMENTS_M table. |
|
HIRING_MANAGER_ID |
Hiring Manager ID |
Stores the PERSON_ID of the hiring manager's assignment for this offer. Foreign key to PER_PERSONS table. |
|
EXPIRATION_DATE |
Expiration Date |
Stores offer expiration date of this offer. |
|
OFFER_LETTER_LAYOUT_ID |
Offer Letter |
Refers to BIP template used to generate the offer letter. |
Yes |
ADDITIONALTEXT1 |
Additional Text 1 |
Offer Letter additional text 1. |
|
ADDITIONALTEXT2 |
Additional Text 2 |
Offer Letter additional text 2. |
|
PRESELECTED_HR_ACTIONTYPE_CODE |
Action |
Stores the action type code that you can also get on the preselected hr action relation. |
|
PERSON_ID |
Person ID |
Stores the PERSON_ID of the candidate for this offer. Foreign key to PER_PERSONS table. |
|
RECRUITER_ASSIGNMENT_ID |
Recruiter Assignment ID |
Stores the ASSIGNMENT_ID of the recruiter's assignment for this offer. Foreign key to PER_ALL_ASSIGNMENTS table. |
|
SUBMISSION _ID |
Submission ID |
Refers to the job application. Foreign key to IRC_SUBMISSIONS table. |
For more information on the Job Offers attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.