HRMS - Vacancy Detail: by Recruiter

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.MINIMUM_QUALIFICATION_LEVEL, IRCFG_VACANCIES.MIN_SALARY, IRCFG_VACANCIES.NUMBER_OF_OPENINGS, IRCFG_VACANCIES.ORGANIZATION_NAME, IRCFG_VACANCIES.PEOPLE_GROUP, IRCFG_VACANCIES.POSITION_NAME, IRCFG_VACANCIES.PROFESSIONAL_AREA, IRCFG_VACANCIES.RAISED_BY, IRCFG_VACANCIES.RECRUITER_NAME, IRCFG_VACANCIES.REQUISITION_NAME, IRCFG_VACANCIES.SALARY_CORRENCY, IRCFG_VACANCIES.SALARY_PERIOD, IRCFG_VACANCIES.SUITABLE_FOR_CONTRACTOR, IRCFG_VACANCIES.SUITABLE_FOR_EMPLOYEE, IRCFG_VACANCIES.TRAVEL_PERCENTAGE, IRCFG_VACANCIES.VACANCY_END_DATE, IRCFG_VACANCIES.VACANCY_NAME, IRCFG_VACANCIES.VACANCY_START_DATE, IRCFG_VACANCIES.VACANCY_STATUS, IRCFG_VACANCIES.WORK_AT_HOME
FROM IRCFG_VACANCIES, HRIBG_ORG_HRCHY WHERE 1=1 AND ((HRIBG_ORG_HRCHY.SUB_ORGANIZATION_ID = IRCFG_VACANCIES.ORGANIZATION_ID ) )               AND (:date_to BETWEEN HRIBG_ORG_HRCHY.HIERARCHY_VERSION_DATE_FROM AND HRIBG_ORG_HRCHY.HRCHY_VERSION_DATE_TO_NN ) AND (IRCFG_VACANCIES.VACANCY_START_DATE BETWEEN :date_from AND :date_to )  
ORDER BY IRCFG_VACANCIES.VACANCY_NAME ASC
Parameter Name SQL text Validation
Organization Hierarchy
 HRIBG_ORG_HRCHY.HIERARCHY_NAME = :organization_hierarchy
LOV
Top Organization
 HRIBG_ORG_HRCHY.ORGANIZATION_NAME = :top_organization
LOV
Recruiter Name
IRCFG_VACANCIES.RECRUITER_NAME = :recruiter_name
LOV
Hiring Manager
IRCFG_VACANCIES.MANAGER_NAME = :hiring_manager
LOV
Vacancy Status
IRCFG_VACANCIES.VACANCY_STATUS = :vacancy_status
LOV
Location
IRCFG_VACANCIES.LOCATION_NAME = :location
LOV
Grade
IRCFG_VACANCIES.GRADE_NAME = :grade
LOV
Position
IRCFG_VACANCIES.POSITION_NAME = :position
LOV
Job
IRCFG_VACANCIES.JOB_NAME = :job
LOV
Date From
 
Date
Date To
 
Date