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_FFELP_DISB_RESP_DETAILS

Product:	IGF - Financial Aid (Obsolete)
Description:	Full View for the Entity that holds FFELP Disbursement Response Details
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RESP8.DISB_DATE
, RESP8.DISB_GROSS_AMT
, RESP8.ORIG_FEE
, RESP8.GUARANTEE_FEE
, RESP8.ORIG_FEE_PAID
, RESP8.GUARNT_FEE_PAID
, RESP8.NET_DISB_AMT
, '_LA:RESP8.DISB_HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING'
, '_LA:RESP8.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DISB_STATUS:MEANING'
, RESP8.RESP_RECORD_STATUS
, RESP1.LOAN_NUMBER
, RESP1.B_FIRST_NAME
, RESP1.B_LAST_NAME
, RESP1.B_MIDDLE_NAME
, RESP1.B_SSN
, RESP8.CLRP1_ID
, RESP8.CLRP8_ID
, RESP8.CREATED_BY
, RESP8.CREATION_DATE
, RESP8.LAST_UPDATED_BY
, RESP8.LAST_UPDATE_DATE
FROM IGF_SL_CL_RESP_R8_ALL RESP8
, IGF_SL_CL_RESP_R1_ALL RESP1
WHERE RESP1.CLRP1_ID = RESP8.CLRP1_ID WITH READ ONLY

Columns

Name
RESP_DISBURSEMENT_DATE
RESP_DISBURSEMENT_GROSS_AMT
RESP_ORIGINATION_FEE
RESP_GUARANTEE_FEE
RESP_ORIGINATION_FEE_PAID
RESP_GUARANTEE_FEE_PAID
RESP_NET_DISBURSEMENT_AMT
"_LA:RESP_HOLD_RELEASE_IND"
"_LA:RESP_DISBURSEMNT_STATUS"
RESP_RECORD_INTERNAL_STATUS
LOAN_NUMBER
BORROWER_FIRST_NAME
BORROWER_LAST_NAME
BORROWER_MIDDLE_NAME
BORROWER_SSN
RESPONSE_PARENT_ID
RESP_DISBURSEMENT_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE