HRMS - Vacancy Detail: by Recruiter

Description
Categories: Discoverer
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
Job
IRCFG_VACANCIES.JOB_NAME = :job
LOV
Top Organization
 HRIBG_ORG_HRCHY.ORGANIZATION_NAME = :top_organization
LOV
Location
IRCFG_VACANCIES.LOCATION_NAME = :location
LOV
Grade
IRCFG_VACANCIES.GRADE_NAME = :grade
LOV
Position
IRCFG_VACANCIES.POSITION_NAME = :position
LOV
Organization Hierarchy
 HRIBG_ORG_HRCHY.HIERARCHY_NAME = :organization_hierarchy
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
Date From
 
Date
Date To
 
Date