SELECT 
AL1.ACADEMIC_YEAR, 
AL1.UNIT_ID, 
AL1.AAUDE_INST_CODE, 
AL1.INSTITUTION_NAME, 
AL1.DIVISION_CODE, 
AL1.DIVISION_NAME, 
AL1.DEPARTMENT, 
AL1.DEPARTMENT_NAME, 
AL1.INPUT_CIP_CODE, 
AL1.CIP_PROGRAM_CODE, 
AL1.CIP_PROGRAM_TITLE, 
AL1.CIP_FOUR_DIGIT_CODE, 
AL1.CIP_FOUR_DIGIT_TITLE, 
AL1.CIP_CATEGORY_CODE, 
AL1.CIP_CATEGORY_TITLE, 
AL1.IS_PRIMARY_FLAG 
FROM WAREUSER.CIP_CROSS_IPEDS_COMPLETION AL1 
WHERE 
(AL1.ACADEMIC_YEAR='1999-2000' 
 AND AL1.INSTITUTION_NAME='Missouri')