example query from Financial Aid Status

sample.sql

SELECT A.CPS_SCHOOL_CODE, A.DESCR, B.SUSPEND_REASON 
FROM PS_INST_SCHOOL_CDS A, PS_ISIR_00_1_EC B 
WHERE B.IWD_TRANS_NBR = (SELECT MAX( C.IWD_TRANS_NBR) 
FROM PS_ISIR_00_1_EC C 
WHERE C.ECTRANSID = B.ECTRANSID 
   AND C.EMPLID = B.EMPLID) 
   AND A.CPS_SCHOOL_CODE = B.CPS_SCHOOL_CODE 
   AND A.INSTITUTION = ? 
   AND A.AID_YEAR = ? 
   AND A.CPS_SCHOOL_CODE NOT LIKE 'G%' 
   AND B.ISIR_LOAD_STATUS = 'S' 
   AND B.EMPLID = ? 
   AND B.IWD_BATCH_YR = ? 
   AND B.SUSPEND_REASON IN ('4','5') 
   AND B.MAX_MATCH_LEVEL < 16