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_AP_EFC_FRML_B_V

Product:	IGF - Financial Aid (Obsolete)
Description:	OBSOLETE
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT EFCB.ROWID
, EFCB.CI_CAL_TYPE
, EFCB.CI_SEQUENCE_NUMBER
, EFCB.METHOD_CODE
, NMT.METHOD_DESC
, EFCB.IPA_UNMRD_AMT
, EFCB.IPA_MRD_LESS_HALF_TM_AMT
, EFCB.IPA_MRD_AMT
, EFCB.EEA_UNMRD_AMT
, EFCB.EEA_MRD_1_WRK_AMT
, EFCB.EEA_MRD_2_WRK_RATE
, EFCB.EEA_MRD_2_WRK_AMT
, EFCB.ASS_STUD_AVAIL_INC
, EFCB.STUD_ASSET_CONV_RATE
, EFCB.CREATED_BY
, EFCB.CREATION_DATE
, EFCB.LAST_UPDATED_BY
, EFCB.LAST_UPDATE_DATE
, EFCB.LAST_UPDATE_LOGIN
FROM IGF_AP_EFC_FRML_B EFCB
, IGF_AP_NEED_MTH_TYP NMT
WHERE NMT.METHOD_CODE = EFCB.METHOD_CODE

Columns

Name
ROW_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
METHOD_CODE
METHOD_DESC
IPA_UNMRD_AMT
IPA_MRD_LESS_HALF_TM_AMT
IPA_MRD_AMT
EEA_UNMRD_AMT
EEA_MRD_1_WRK_AMT
EEA_MRD_2_WRK_RATE
EEA_MRD_2_WRK_AMT
ASS_STUD_AVAIL_INC
STUD_ASSET_CONV_RATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN