HRMS - Applicant Detail: Qualification

Description
Categories: Discoverer
Columns: Applicant Name, Awarded Date, Awarding Body, Business Group Name, Grade Attained, License Expiry Date, License Number, License Restrictions, Method Of Reimbursement, Projected Completion Date ...
This workbook reports on the detail of your applicants
Owner: SYSADMIN (System Administrator)
Identifier: HRIPRAPD
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_QUALIFICATIONS.AWARDED_DATE, HRFG_QUALIFICATIONS.AWARDING_BODY, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_QUALIFICATIONS.GRADE_ATTAINED, HRFG_QUALIFICATIONS.LICENSE_EXPIRY_DATE, HRFG_QUALIFICATIONS.LICENSE_NUMBER, HRFG_QUALIFICATIONS.LICENSE_RESTRICTIONS, HRFG_QUALIFICATIONS.METHOD_OF_REIMBURSEMENT, HRFG_QUALIFICATIONS.PROJECTED_COMPLETION_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_END_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_START_DATE, HRFG_QUALIFICATIONS.QUALIFICATION_STATUS, HRFG_QUALIFICATIONS.QUALIFICATION_TITLE, HRFG_QUALIFICATIONS.TRAINING_COMPLETED_UNITS
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS, HRFG_QUALIFICATIONS HRFG_QUALIFICATIONS WHERE 1=1 AND ((HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_QUALIFICATIONS.PERSON_ID ) ) 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 )    
ORDER BY HRFG_APPLICANT_DETAILS.APPLICANT_NAME ASC
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
Effective Date
 
Date