HRMS - Applicant Detail: Detail (6)

Description
Categories: Discoverer
This workbook reports on the detail of your applicants
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRAPD
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.APPLICANT_NUMBER, HRFG_APPLICANT_DETAILS.APPLICANT_PERSON_TYPE, HRFG_APPLICANT_DETAILS.APPLICANT_TYPE, HRFG_APPLICANT_DETAILS.APPLICATION_COMMENTS, HRFG_APPLICANT_DETAILS.APPLICATION_END_DATE, HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE, HRFG_APPLICANT_DETAILS.APPLICATION_STATUS, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_APPLICANT_DETAILS.CURRENT_EMPLOYER, HRFG_APPLICANT_DETAILS.EMPLOYEE_PERSON_TYPE, HRFG_APPLICANT_DETAILS.GRADE_NAME, HRFG_APPLICANT_DETAILS.JOB_NAME, HRFG_APPLICANT_DETAILS.JOB_POST_SOURCE_NAME, HRFG_APPLICANT_DETAILS.LOCATION_NAME, HRFG_APPLICANT_DETAILS.ORGANIZATION_NAME, HRFG_APPLICANT_DETAILS.PEOPLE_GROUP, HRFG_APPLICANT_DETAILS.POSITION_NAME, HRFG_APPLICANT_DETAILS.PROJECTED_HIRE_DATE, HRFG_APPLICANT_DETAILS.RECRUITER_NAME, HRFG_APPLICANT_DETAILS.RECRUITMENT_ACTIVITY_NAME, HRFG_APPLICANT_DETAILS.REFERRING_EMPLOYEE_NAME, HRFG_APPLICANT_DETAILS.SOURCE_TYPE, HRFG_APPLICANT_DETAILS.USER_CONCAT_PERSON_TYPE, HRFG_APPLICANT_DETAILS.VACANCY_NAME
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS WHERE 1=1 AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND (:effective_date BETWEEN HRFG_APPLICANT_DETAILS.RECORD_START_DATE AND HRFG_APPLICANT_DETAILS.RECORD_END_DATE )
Parameter NameSQL textValidation
Applicant Name
HRFG_APPLICANT_DETAILS.APPLICANT_NAME = :applicant_name
LOV
Business Group Name
HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME = :business_group_name
LOV
Vacancy Name
HRFG_APPLICANT_DETAILS.VACANCY_NAME = :vacancy_name
LOV
Source Type
HRFG_APPLICANT_DETAILS.SOURCE_TYPE = :source_type
LOV
Job Name
HRFG_APPLICANT_DETAILS.JOB_NAME = :job_name
LOV
Organization Name
HRFG_APPLICANT_DETAILS.ORGANIZATION_NAME = :organization_name
LOV
Location Name
HRFG_APPLICANT_DETAILS.LOCATION_NAME = :location_name
LOV
Grade Name
HRFG_APPLICANT_DETAILS.GRADE_NAME = :grade_name
LOV
Position Name
HRFG_APPLICANT_DETAILS.POSITION_NAME = :position_name
LOV
Effective Date
 
Date