[Home] [Help]
View: IGFFV_PELL_YTD_DISBURSEMENTS
Product: | IGF - Financial Aid |
Description: | Full View for the Entity that holds the information about the year to date disbursement data |
Implementation/DBA Data: |
APPS.IGFFV_PELL_YTD_DISBURSEMENTS
|
View Text
SELECT YTDDS.INST_CROSS_REF_CODE
, '_LA:YTDDS.ACTION_CODE:IGF_LOOKUPS_VIEW:IGF_GR_ACTION_CODE:MEANING'
, YTDDS.DISB_REF_NUM
, YTDDS.DISB_ACCPT_AMT
, YTDDS.DB_CR_FLAG
, YTDDS.DISB_DT
, YTDDS.PYMT_PRD_START_DT
, YTDDS.DISB_BATCH_ID
, YTDDS.ORIGINATION_ID
, YTDDS.YTDDS_ID
, YTDDS.CREATED_BY
, YTDDS.CREATION_DATE
, YTDDS.LAST_UPDATED_BY
, YTDDS.LAST_UPDATE_DATE
FROM IGF_GR_YTD_DISB_ALL YTDDS WITH READ ONLY
Columns
Name |
INST_CROSS_REF_CODE |
"_LA:ACTION_CODE" |
DISBURSEMENT_REFERENCE_NUMBER |
DISBURSEMENT_ACCPTED_AMOUNT |
DEBIT_CREDIT_FLAG |
DISBURSEMENT_DATE |
PAYMENT_PERD_START_DATE |
DISBURSEMENT_BATCH_ID |
ORIGINATION_ID |
YTDDS_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |