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.