Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds the information about the summary details that get uploaded by the electronic statement of accounts that comes from the government |
Implementation/DBA Data: | APPS.IGFFV_PEL_ELEC_SUM_STMNT_ACNTS |
SELECT ESS.REP_PELL_ID
, ESS.DUNS_ID
, ESS.GAPS_AWARD_NUM
, ESS.ACCT_SCHEDULE_NUMBER
, ESS.ACCT_SCHEDULE_DATE
, ESS.PREV_OBLIGATION_AMT
, ESS.OBLIGATION_ADJ_AMT
, ESS.CURR_OBLIGATION_AMT
, ESS.PREV_OBLIGATION_PYMT_AMT
, ESS.OBLIGATION_PYMT_ADJ_AMT
, ESS.CURR_OBLIGATION_PYMT_AMT
, ESS.YTD_TOTAL_RECP
, ESS.YTD_ACCEPTED_DISB_AMT
, ESS.YTD_POSTED_DISB_AMT
, ESS.YTD_ADMIN_COST_ALLOWANCE
, ESS.CAPS_DRWN_DN_PYMTS
, ESS.GAPS_LAST_DATE
, ESS.LAST_PYMT_NUMBER
, ESS.ESS_ID
, ESS.CREATED_BY
, ESS.CREATION_DATE
, ESS.LAST_UPDATED_BY
, ESS.LAST_UPDATE_DATE
FROM IGF_GR_ELEC_STAT_SUM_ALL ESS WITH READ ONLY