SELECT AL5.ACADEMIC_YEAR, 
       AL5.AAUDE_INST_CODE, 
       AL5.INSTITUTION_NAME, 
       AL5.CUPA_INST_AFFILIATION, 
       AL5.CUPA_INST_STRUCTURE, 
       AL1.CUPA_POSITION_NUMBER, 
       AL1.CUPA_POSITION_DESC, 
       AL3.CUPA_REPORTING_POSITION_NUMBER, 
       AL3.CUPA_REPORTING_POSITION_DESC, 
       AL2.CUPA_HIRING_STATUS, 
       AL2.CUPA_GENDER, 
       AL2.CUPA_MINORITY_STATUS, 
       AL2.IS_VACANT, 
       AL2.CUPA_VACANCY_INDICATOR, 
       AL4.YEARS_OF_SERVICE, 
       AL4.SALARY, 
       AL4.NUMBER_OF_INCUMBENTS 
FROM WAREUSER.CUPA_POSITION AL1, 
     WAREUSER.CUPA_HIRING_DEMOGRAPHIC AL2, 
     WAREUSER.CUPA_REPORTING_RELATIONSHIP AL3, 
     WAREUSER.CUPA_ADMIN_SALARY_DETAIL AL4, 
     WAREUSER.CUPA_INSTITUTION AL5 
WHERE 
(AL4.CUPA_POSITION_KEY=AL1.CUPA_POSITION_KEY AND 
 AL4.CUPA_HIRING_DEMOGRAPHIC_KEY=AL2.CUPA_HIRING_DEMOGRAPHIC_KEY AND 
 AL4.CUPA_REPORTING_RELATION_KEY=AL3.CUPA_REPORTING_RELATION_KEY AND 
 AL5.CUPA_INSTITUTION_KEY=AL4.CUPA_INSTITUTION_KEY)  
AND 
(AL5.ACADEMIC_YEAR='2002' AND 
 AL1.CUPA_POSITION_NUMBER IN ('101.00', '101.10', '102.00', '102.10', '103.00') AND 
 (NOT AL4.SALARY IS NULL)
)