SELECT AL4.ACADEMIC_YEAR, 
       AL5.AAUDE_INST_CODE, 
       AL5.INST_NAME, 
       AL2.CIP_4_DIGIT_CODE, 
       AL2.CIP_4_DIGIT_DESC, 
       AL1.FACULTY_TYPE, 
       AL3.BUDGETED_FTE_FACULTY, 
       AL3.INSTRUCTIONAL_FTE_FACULTY, 
       AL3.LOWER_DIV_ORG_CREDIT_HRS, 
       AL3.UPPER_DIV_ORG_CREDIT_HRS, 
       AL3.UG_INDV_CREDIT_HRS, 
       AL3.GRAD_ORG_CREDIT_HRS, 
       AL3.GRAD_INDV_CREDIT_HRS, 
       AL3.LAB_DISC_REC_SECTIONS, 
       AL3.LOWER_DIV_OTHER_SECTIONS, 
       AL3.UPPER_DIV_OTHER_SECTIONS, 
       AL3.GRAD_OTHER_SECTIONS 
FROM WAREUSER.DELW_FACULTY_TYPE AL1, 
     WAREUSER.DELW_CIP_4_DIGIT AL2, 
     WAREUSER.DELW_TEACHING_LOAD_DETAIL AL3, 
     WAREUSER.ACADEMIC_YEAR AL4, 
     WAREUSER.INSTITUTION AL5 
WHERE AL4.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY 
AND AL5.INSTITUTION_KEY=AL3.INSTITUTION_KEY 
AND AL3.DELW_CIP_4_DIGIT_KEY=AL2.DELW_CIP_4_DIGIT_KEY 
AND AL3.DELW_FACULTY_TYPE_KEY=AL1.DELW_FACULTY_TYPE_KEY 
AND AL4.ACADEMIC_YEAR='2000-2001' 
AND AL5.INST_NAME='Oregon'