FND Design Data [Home] [Help]

Table: IRC_OFFERS

Product: PER - Human Resources
Description: Table to maintain details of iRecruitment Offers
Implementation/DBA Data: TableHR.IRC_OFFERS
Primary Key: IRC_OFFERS_PK
  1. ColumnOFFER_ID
Primary Key: IRC_OFFERS_U1
  1. ColumnAPPLICANT_ASSIGNMENT_ID
  2. ColumnOFFER_VERSION
Foreign Keys
Table
Foreign Table Foreign Key Column
IRC_OFFERS FK Joins to TablePER_ADDRESSES IRC_OFFERS.ADDRESS_ID
IRC_OFFERS FK Joins to TableFND_USER IRC_OFFERS.RESPONDENT_ID
IRC_OFFERS FK Joins to TableXDO_TEMPLATES_B IRC_OFFERS.TEMPLATE_ID
IRC_OFFERS FK Joins to TablePER_ALL_VACANCIES IRC_OFFERS.VACANCY_ID
TableIRC_OFFER_STATUS_HISTORY FK Joins to IRC_OFFERS IRC_OFFER_STATUS_HISTORY.OFFER_ID