eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PER_ALL_VACANCIES

Product:	PER - Human Resources
Description:	Vacancies within a specific requisition.
Implementation/DBA Data:	HR.PER_ALL_VACANCIES

Primary Key: PER_VACANCIES_PK

VACANCY_ID

Primary Key: PER_VACANCIES_UK2

REQUISITION_ID
NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_ALL_VACANCIES	HR_ALL_ORGANIZATION_UNITS	PER_ALL_VACANCIES.BUSINESS_GROUP_ID
PER_ALL_VACANCIES	PER_ALL_POSITIONS	PER_ALL_VACANCIES.POSITION_ID
PER_ALL_VACANCIES	PER_JOBS	PER_ALL_VACANCIES.JOB_ID
PER_ALL_VACANCIES	PER_GRADES	PER_ALL_VACANCIES.GRADE_ID
PER_ALL_VACANCIES	HR_ALL_ORGANIZATION_UNITS	PER_ALL_VACANCIES.ORGANIZATION_ID
PER_ALL_VACANCIES	PER_REQUISITIONS	PER_ALL_VACANCIES.REQUISITION_ID
PER_ALL_VACANCIES	PAY_PEOPLE_GROUPS	PER_ALL_VACANCIES.PEOPLE_GROUP_ID
PER_ALL_VACANCIES	HR_LOCATIONS_ALL	PER_ALL_VACANCIES.LOCATION_ID
IRC_AGENCY_VACANCIES	PER_ALL_VACANCIES	IRC_AGENCY_VACANCIES.VACANCY_ID
IRC_OFFERS	PER_ALL_VACANCIES	IRC_OFFERS.VACANCY_ID
IRC_REC_TEAM_MEMBERS	PER_ALL_VACANCIES	IRC_REC_TEAM_MEMBERS.VACANCY_ID
IRC_VACANCY_CONSIDERATIONS	PER_ALL_VACANCIES	IRC_VACANCY_CONSIDERATIONS.VACANCY_ID
IRC_VACANCY_CONSIDERATIONS	PER_ALL_VACANCIES	IRC_VACANCY_CONSIDERATIONS.VACANCY_ID
PER_ALL_ASSIGNMENTS_F	PER_ALL_VACANCIES	PER_ALL_ASSIGNMENTS_F.VACANCY_ID
PER_RECRUITMENT_ACTIVITY_FOR	PER_ALL_VACANCIES	PER_RECRUITMENT_ACTIVITY_FOR.VACANCY_ID