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_LOAN_LIMIT_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Sets the limits for Loans to be used during packaging
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ALLT.ROW_ID
, ALLT.ALLT_ID
, ALLT.CI_CAL_TYPE
, ALLT.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, ALLT.FFELP_GRADE_LEVEL
, ALLT.DL_GRADE_LEVEL
, ALLT.DEPEND_STAT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_DEP_STATUS'
, ALLT.DEPEND_STAT)
, ALLT.SUBS_ANNUAL_LT
, ALLT.TOT_ANNUAL_LT
, ALLT.SUBS_AGGR_LT
, ALLT.TOT_AGGR_LT
, ALLT.CREATED_BY
, ALLT.CREATION_DATE
, ALLT.LAST_UPDATED_BY
, ALLT.LAST_UPDATE_DATE
, ALLT.LAST_UPDATE_LOGIN
, ALLT.TOT_ANNUAL_LT - ALLT.SUBS_ANNUAL_LT
FROM IGF_AW_LOAN_LIMIT ALLT
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = ALLT.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = ALLT.CI_SEQUENCE_NUMBER

Columns

Name
ROW_ID
ALLT_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CI_ALTERNATE_CODE
CI_START_DT
CI_END_DT
FFELP_GRADE_LEVEL
DL_GRADE_LEVEL
DEPEND_STAT
DEPEND_STAT_MEAN
SUBS_ANNUAL_LT
TOT_ANNUAL_LT
SUBS_AGGR_LT
TOT_AGGR_LT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ADD_UNSUB_LOAN_AMT