View: IGF_DB_AWD_DISB_V

Product:	IGF - Financial Aid
Description:	Award disbursement details
Implementation/DBA Data:	APPS.IGF_DB_AWD_DISB_V

View Text

SELECT ADISB.ROW_ID ROW_ID
, AWDV.AWARD_ID AWARD_ID
, ADISB.DISB_NUM DISB_NUM
, AWDV.BASE_ID BASE_ID
, AWDV.CI_CAL_TYPE CI_CAL_TYPE
, AWDV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, AWDV.CI_ALTERNATE_CODE CI_ALTERNATE_CODE
, AWDV.CI_START_DT CI_START_DT
, AWDV.CI_END_DT CI_END_DT
, AWDV.STUDENT_ID STUDENT_ID
, AWDV.PERSON_NUMBER PERSON_NUMBER
, AWDV.SSN SSN
, AWDV.FULL_NAME FULL_NAME
, AWDV.FUND_ID FUND_ID
, AWDV.DESCRIPTION FUND_DESCRIPTION
, AWDV.FUND_CODE FUND_CODE
, AWDV.FUND_TYPE FUND_TYPE
, AWDV.FED_FUND_CODE FED_FUND_CODE
, AWDV.SYS_FUND_TYPE SYS_FUND_TYPE
, AWDV.OFFERED_AMT OFFERED_AMT
, AWDV.ACCEPTED_AMT ACCEPTED_AMT
, AWDV.RULES_OVERRIDE RULES_OVERRIDE
, ADISB.TP_CAL_TYPE TP_CAL_TYPE
, ADISB.TP_SEQUENCE_NUMBER TP_SEQUENCE_NUMBER
, ADISB.DISB_GROSS_AMT DISB_GROSS_AMT
, ADISB.FEE_1 FEE_1
, ADISB.FEE_2 FEE_2
, ADISB.DISB_NET_AMT DISB_NET_AMT
, ADISB.DISB_DATE DISB_DATE
, ADISB.TRANS_TYPE TRANS_TYPE
, ADISB.ELIG_STATUS ELIG_STATUS
, ADISB.ELIG_STATUS_DATE ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG AFFIRM_FLAG
, ADISB.MANUAL_HOLD_IND MANUAL_HOLD_IND
, ADISB.HOLD_REL_IND HOLD_REL_IND
, ADISB.DISB_STATUS DISB_STATUS
, ADISB.DISB_STATUS_DATE DISB_STATUS_DATE
, ADISB.LATE_DISB_IND LATE_DISB_IND
, ADISB.FUND_DIST_MTHD FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE FUND_RELEASE_DATE
, ADISB.FUND_STATUS FUND_STATUS
, ADISB.FUND_STATUS_DATE FUND_STATUS_DATE
, ADISB.CHEQUE_NUMBER CHEQUE_NUMBER
, ADISB.FEE_PAID_1 FEE_PAID_1
, ADISB.FEE_PAID_2 FEE_PAID_2
, 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
, AWDV.AWARD_STATUS
, ADISB.DISB_EXP_DT
, ADISB.VERF_ENFR_DT
, ADISB.FORCE_DISB
, ADISB.MIN_CREDIT_PTS
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, ADISB.PAID_AMT
, ADISB.LD_START_DT
, ADISB.LD_END_DT
, ADISB.TP_START_DT
, ADISB.TP_END_DT
, ADISB.LD_ALTERNATE_CODE
, ADISB.TP_ALTERNATE_CODE
FROM IGF_AW_AWARD_V AWDV
, IGF_AW_AWD_DISB_V ADISB
WHERE AWDV.AWARD_ID = ADISB.AWARD_ID

Columns