[Home] [Help]
| Product: | IGF - Financial Aid (Obsolete) |
|---|---|
| Description: | Shows Direct Loan disbursement details for each of disbursements for loan |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DDTL.ROW_ID ROW_ID
, DDTL.AWARD_ID AWARD_ID
, DDTL.DISB_NUM DISB_NUM
, DDTL.DISB_SEQ_NUM DISB_SEQ_NUM
, DDTL.DISB_ACTIVITY DISB_ACTIVITY
, DDTL.DISB_GROSS_AMT DISB_GROSS_AMT
, DDTL.FEE_1 FEE_1
, DDTL.FEE_2 FEE_2
, DDTL.DISB_NET_AMT DISB_NET_AMT
, DDTL.DISB_ADJ_AMT DISB_ADJ_AMT
, DDTL.FEE_PAID_1 FEE_PAID_1
, DDTL.FEE_PAID_2 FEE_PAID_2
, DDTL.DISB_DATE DISB_DATE
, DDTL.DISB_BATCH_ID DISB_BATCH_ID
, DDTL.DISB_ACK_DATE DISB_ACK_DATE
, DDTL.BOOKING_BATCH_ID BOOKING_BATCH_ID
, DDTL.BOOKED_DATE BOOKED_DATE
, DDTL.DISB_STATUS DISB_STATUS
, DDTL.DISB_STATUS_DATE DISB_STATUS_DATE
, DDTL.SF_STATUS SF_STATUS
, DDTL.SF_STATUS_DATE SF_STATUS_DATE
, DDTL.SF_INVOICE_NUM SF_INVOICE_NUM
, LAR.LOAN_NUMBER LOAN_NUMBER
, ADISB.AFFIRM_FLAG AFFIRM_FLAG
, ADISB.CREATED_BY CREATED_BY
, ADISB.CREATION_DATE CREATION_DATE
, ADISB.LAST_UPDATED_BY LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ADISB.INT_REBATE_AMT
FROM IGF_DB_AWD_DISB_DTL DDTL
, IGF_AW_AWD_DISB ADISB
, IGF_AW_AWARD AWD
, IGF_SL_LOANS LAR
, IGF_LOOKUPS_VIEW LKPS
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
WHERE DDTL.AWARD_ID = ADISB.AWARD_ID
AND DDTL.DISB_NUM = ADISB.DISB_NUM
AND DDTL.AWARD_ID = AWD.AWARD_ID
AND DDTL.AWARD_ID = LAR.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND LKPS.LOOKUP_TYPE IN ('IGF_SL_DL_STAFFORD'
, 'IGF_SL_DL_PLUS')
AND FCAT.FED_FUND_CODE = LKPS.LOOKUP_CODE