SELECT 
AL3.ACAD_YEAR_BEGIN_TERM, 
AL3.ACADEMIC_YEAR, 
AL4.UNIT_ID, 
AL4.INST_NAME, 
AL2.POSITION_DESCRIPTION_CODE, 
AL2.POSITION_DESCRIPTION, 
AL2.PRIMARY_FUNCTION_CODE, 
AL2.PRIMARY_FUNCTION, 
AL2.TENURE_STATUS_CODE, 
AL2.TENURE_STATUS, 
AL1.NUMBER_OF_EMPLOYEES 
FROM WAREUSER.IPEDS_EMPLOYEE_POS_DETAIL AL1, 
     WAREUSER.IPEDS_EMPLOYEE_POSITION AL2, 
     WAREUSER.ACADEMIC_YEAR AL3, 
     WAREUSER.INSTITUTION AL4 
WHERE AL1.IPEDS_EMPLOYEE_POSITION_KEY=AL2.IPEDS_EMPLOYEE_POSITION_KEY 
AND AL3.ACADEMIC_YEAR_KEY=AL1.ACADEMIC_YEAR_KEY 
AND AL4.INSTITUTION_KEY=AL1.INSTITUTION_KEY  
AND AL3.ACAD_YEAR_BEGIN_TERM='Fall 2002'