HRMS - Applicant Detail: by Grade

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
LOV
Business Group Name
HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME = :business_group_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
Job Name
HRFG_APPLICANT_DETAILS.JOB_NAME = :job_name
LOV
Vacancy Name
HRFG_APPLICANT_DETAILS.VACANCY_NAME = :vacancy_name
LOV
Source Type
HRFG_APPLICANT_DETAILS.SOURCE_TYPE = :source_type
LOV
Effective Date
 
Date