eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_AW_AWD_DISB

Product:	IGF - Financial Aid (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ADISB.ROWID ROW_ID
, ADISB.AWARD_ID AWARD_ID
, ADISB.DISB_NUM DISB_NUM
, ADISB.TP_CAL_TYPE TP_CLA_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.HOLD_REL_IND HOLD_REL_IND
, ADISB.MANUAL_HOLD_IND MANUAL_HOLD_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.FEE_PAID_1 FEE_PAID_1
, ADISB.FEE_PAID_2 FEE_PAID_2
, ADISB.CHEQUE_NUMBER CHEQUE_NUMBER
, ADISB.LD_CAL_TYPE LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER
, ADISB.DISB_ACCEPTED_AMT DISB_ACCEPTED_AMT
, ADISB.DISB_PAID_AMT DISB_PAID_AMT
, ADISB.RVSN_ID RVSN_ID
, ADISB.INT_REBATE_AMT
, ADISB.FORCE_DISB
, ADISB.DISB_EXP_DT
, ADISB.MIN_CREDIT_PTS
, ADISB.VERF_ENFR_DT
, 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
, NULL
, NULL
, NULL
, NULL
, ADISB.FEE_CLASS FEE_CLASS
, ADISB.SHOW_ON_BILL
, ADISB.ATTENDANCE_TYPE_CODE
, ADISB.BASE_ATTENDANCE_TYPE_CODE
, ADISB.PAYMENT_PRD_ST_DATE
, ADISB.CHANGE_TYPE_CODE
, ADISB.FUND_RETURN_MTHD_CODE
, ADISB.DIRECT_TO_BORR_FLAG
FROM IGF_AW_AWD_DISB_ALL ADISB
WHERE NVL (ADISB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
AWARD_ID
DISB_NUM
TP_CAL_TYPE
TP_SEQUENCE_NUMBER
DISB_GROSS_AMT
FEE_1
FEE_2
DISB_NET_AMT
DISB_DATE
TRANS_TYPE
ELIG_STATUS
ELIG_STATUS_DATE
AFFIRM_FLAG
HOLD_REL_IND
MANUAL_HOLD_IND
DISB_STATUS
DISB_STATUS_DATE
LATE_DISB_IND
FUND_DIST_MTHD
PREV_REPORTED_IND
FUND_RELEASE_DATE
FUND_STATUS
FUND_STATUS_DATE
FEE_PAID_1
FEE_PAID_2
CHEQUE_NUMBER
LD_CAL_TYPE
LD_SEQUENCE_NUMBER
DISB_ACCEPTED_AMT
DISB_PAID_AMT
RVSN_ID
INT_REBATE_AMT
FORCE_DISB
DISB_EXP_DT
MIN_CREDIT_PTS
VERF_ENFR_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
NOTIFICATION_SENT
NOTIFICATION_DATE
AUTH_ID
AUTH_DATE
FEE_CLASS
SHOW_ON_BILL
ATTENDANCE_TYPE_CODE
BASE_ATTENDANCE_TYPE_CODE
PAYMENT_PRD_ST_DATE
CHANGE_TYPE_CODE
FUND_RETURN_MTHD_CODE
DIRECT_TO_BORR_FLAG