|
SELECT AWP.EMPLID ,AWP.INSTITUTION ,AWP.AID_YEAR ,AWP.AWARD_PERIOD ,AWD.ITEM_TYPE ,AWD.ACAD_CAREER ,AWD.SETID ,ADS.DISBURSEMENT_ID ,DSB.DISBURSEMENT_PLAN ,CRT.STRM ,FAT.STDNT_CAR_NBR ,FAT.ACAD_PROG_PRIMARY ,ATR.AID_APP_STATUS ,ATR.PROCESSING_STATUS ,ATR.PACKAGING_METHOD ,AWD.AWARD_STATUS ,ITM.DESCR ,AWP.FANLTR_STATUS FROM PS_STDNT_AID_ATRBT ATR , PS_STDNT_AWD_PER AWP , PS_STDNT_AWARDS AWD , PS_ITEM_TYPE_FA ITM , PS_STDNT_AWRD_DISB ADS , PS_DISB_ID_TBL DSB , PS_STDNT_CR_TERM CRT , PS_STDNT_FA_TERM FAT WHERE ATR.TABLE_ID = '1' AND AWP.EMPLID = ATR.EMPLID AND AWP.INSTITUTION = ATR.INSTITUTION AND AWP.AID_YEAR = ATR.AID_YEAR AND AWD.EMPLID = AWP.EMPLID AND AWD.INSTITUTION = AWP.INSTITUTION AND AWD.AID_YEAR = AWP.AID_YEAR AND ITM.SETID = AWD.SETID AND ITM.ITEM_TYPE = AWD.ITEM_TYPE AND ITM.AID_YEAR = AWD.AID_YEAR AND ITM.EFFDT = ( SELECT MAX(ITM2.EFFDT) FROM PS_ITEM_TYPE_FA ITM2 WHERE ITM2.SETID = ITM.SETID AND ITM2.ITEM_TYPE = ITM.ITEM_TYPE AND ITM2.AID_YEAR = ITM.AID_YEAR AND ITM2.EFFDT <= %CurrentDateIn ) AND ADS.EMPLID = AWD.EMPLID AND ADS.INSTITUTION = AWD.INSTITUTION AND ADS.AID_YEAR = ITM.AID_YEAR AND ADS.ITEM_TYPE = ITM.ITEM_TYPE AND DSB.INSTITUTION = ADS.INSTITUTION AND DSB.AID_YEAR = ADS.AID_YEAR AND DSB.ACAD_CAREER = ADS.ACAD_CAREER AND DSB.DISBURSEMENT_ID = ADS.DISBURSEMENT_ID AND CRT.EMPLID = ADS.EMPLID AND CRT.INSTITUTION = DSB.INSTITUTION AND CRT.AID_YEAR = DSB.AID_YEAR AND CRT.ACAD_CAREER = DSB.ACAD_CAREER AND CRT.STRM = DSB.STRM AND CRT.AWARD_PERIOD = AWP.AWARD_PERIOD AND FAT.EMPLID = CRT.EMPLID AND FAT.INSTITUTION = CRT.INSTITUTION AND FAT.STRM = CRT.STRM AND FAT.EFFDT = ( SELECT MAX(FAT2.EFFDT) FROM PS_STDNT_FA_TERM FAT2 WHERE FAT2.EMPLID = FAT.EMPLID AND FAT2.INSTITUTION = FAT.INSTITUTION AND FAT2.STRM = FAT.STRM AND FAT2.EFFDT <= %CurrentDateIn ) AND FAT.EFFSEQ = ( SELECT MAX(FAT3.EFFSEQ) FROM PS_STDNT_FA_TERM FAT3 WHERE FAT3.EMPLID = FAT.EMPLID AND FAT3.INSTITUTION = FAT.INSTITUTION AND FAT3.STRM = FAT.STRM AND FAT3.EFFDT = FAT.EFFDT )
|
EMPLID