HRMS - Applicant Detail: Detail (6)

Description
Categories: Discoverer
Columns: Applicant Name, Applicant Number, Applicant Person Type, Applicant Type, Application Comments, Application End Date, Application Start Date, Application Status, Business Group Name, Current Employer ...
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 Name SQL text Validation
Applicant Name
HRFG_APPLICANT_DETAILS.APPLICANT_NAME = :applicant_name