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: IGFFV_PEL_ELEC_SUM_STMNT_ACNTS

Product:	IGF - Financial Aid (Obsolete)
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:	Not implemented in this database

View Text

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

Columns

Name
REP_PELL_ID
DUNS_ID
GAPS_AWARD_NUMBER
ACCT_SCHEDULE_NUMBER
ACCT_SCHEDULE_DATE
PREVIOUS_OBLIGATION_AMOUNT
OBLIGATION_ADJUSTED_AMOUNT
CURRENT_OBLIGATION_AMOUNT
PREVIOUS_OBLIG_PYMT_AMOUNT
OBLIG_PYMT_ADJUSTED_AMOUNT
CURRENT_OBLIG_PYMT_AMOUNT
YTD_TOTAL_RECP
YTD_ACCEPTED_DISB_AMOUNT
YTD_POSTED_DISB_AMOUNT
YTD_ADMIN_COST_ALLOWANCE
CAPS_DRWN_DN_PAYMENTS
GAPS_LAST_DATE
LAST_PAYMENT_NUMBER
ESS_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE