FND Design Data [Home] [Help]

Table: IRC_AGENCY_VACANCIES

Product: PER - Human Resources
Description:
Implementation/DBA Data: TableHR.IRC_AGENCY_VACANCIES
Primary Key: IRC_AGENCY_VACANCIES_PK
  1. ColumnAGENCY_VACANCY_ID
Primary Key: IRC_AGENCY_VACANCIES_U1
  1. ColumnAGENCY_ID
  2. ColumnVACANCY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IRC_AGENCY_VACANCIES FK Joins to TablePO_VENDORS IRC_AGENCY_VACANCIES.AGENCY_ID
IRC_AGENCY_VACANCIES FK Joins to TablePER_ALL_VACANCIES IRC_AGENCY_VACANCIES.VACANCY_ID