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

Product:	IGF - Financial Aid (Obsolete)
Description:	Base 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.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.REP_PELL_ID
, ESS.DUNS_ID
, 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
GAPS_AWARD_NUMBER
ACCTOUNT_SCHEDULE_NUMBER
ACCTOUNT_SCHEDULE_DATE
PREVOUS_OBLIGATION_AMOUNT
OBLIGATION_ADJUSTED_AMOUNT
CURRENT_OBLIGATION_AMOUNT
PREVOUS_OBLIG_PYMT_AMOUNT
OBLIG_PYMT_ADJUSTED_AMOUNT
CURRENT_OBLIG_PYMT_AMOUNT
YEAR_TD_TOTAL_RECP
YEAR_TD_ACCEPTED_DISB_AMOUNT
YEAR_TD_POSTED_DISB_AMOUNT
YEAR_TD_ADMIN_COST_ALLOWANCE
CAPS_DRWN_DN_PAYMENTS
GAPS_LAST_DATE
LAST_PAYMENT_NUMBER
REPORTING_PELL_ID
DUNS_ID
ESS_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE