HRMS - Vacancy Detail: by Location

Description
Categories: Discoverer
Columns: Budget Measurement Type, Budget Measurement Value, Employment Category, Grade Name, Hierarchy Name, Hierarchy Version, Hierarchy Version Date From, Hierarchy Version Date To, Job Name, Location Name ...
This workbook reports on the detail of your Vacancies, for the Organization Hierarchy
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRVAD
SELECT IRCFG_VACANCIES.BUDGET_MEASUREMENT_TYPE, IRCFG_VACANCIES.BUDGET_MEASUREMENT_VALUE, IRCFG_VACANCIES.EMPLOYMENT_CATEGORY, IRCFG_VACANCIES.GRADE_NAME, HRIBG_ORG_HRCHY.HIERARCHY_NAME, HRIBG_ORG_HRCHY.HIERARCHY_VERSION, HRIBG_ORG_HRCHY.HIERARCHY_VERSION_DATE_FROM, HRIBG_ORG_HRCHY.HIERARCHY_VERSION_DATE_TO, IRCFG_VACANCIES.JOB_NAME, IRCFG_VACANCIES.LOCATION_NAME, IRCFG_VACANCIES.MANAGER_NAME, IRCFG_VACANCIES.MAXIMUM_QUALIFICATION_LEVEL, IRCFG_VACANCIES.MAX_SALARY, IRCFG_VACANCIES.MINIMU