APPS.IGFBV_FFELP_ORIG_RESPONSES
[Home] [Help]
| Product: | IGF - Financial Aid |
|---|---|
| Description: | Base view for the entity that holds FFELP Origination Response Details |
| Implementation/DBA Data: |
APPS.IGFBV_FFELP_ORIG_RESPONSES
|
SELECT RESP1.REC_CODE
, RESP1.REC_TYPE_IND
, RESP1.B_FIRST_NAME
, RESP1.B_LAST_NAME
, RESP1.B_MIDDLE_NAME
, RESP1.B_SSN
, RESP1.B_PERMT_ADDR1
, RESP1.B_PERMT_ADDR2
, RESP1.B_PERMT_CITY
, RESP1.B_PERMT_STATE
, RESP1.B_PERMT_ZIP
, RESP1.B_PERMT_ZIP_SUFFIX
, RESP1.B_PERMT_PHONE
, RESP1.B_DATE_OF_BIRTH
, RESP1.CL_LOAN_TYPE
, RESP1.REQ_LOAN_AMT
, RESP1.DEFER_REQ_CODE
, RESP1.BORW_INTEREST_IND
, RESP1.EFT_AUTH_CODE
, RESP1.B_SIGNATURE_CODE
, RESP1.B_SIGNATURE_DATE
, RESP1.LOAN_NUMBER
, RESP1.CL_SEQ_NUMBER
, '_LA:RESP1.B_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, RESP1.B_STATE_OF_LEGAL_RES
, RESP1.B_LEGAL_RES_DATE
, '_LA:RESP1.B_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_P_DEFAULT_STATUS:MEANING'
, RESP1.B_OUTSTD_LOAN_CODE
, RESP1.B_INDICATOR_CODE
, RESP1.S_FIRST_NAME
, RESP1.S_LAST_NAME
, RESP1.S_MIDDLE_NAME
, RESP1.S_SSN
, RESP1.S_DATE_OF_BIRTH
, '_LA:RESP1.S_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, '_LA:RESP1.S_DEFAULT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_S_DEFAULT_STATUS:MEANING'
, RESP1.S_SIGNATURE_CODE
, RESP1.LOAN_PER_BEGIN_DATE
, RESP1.LOAN_PER_END_DATE
, '_LA:RESP1.GRADE_LEVEL_CODE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING'
, '_LA:RESP1.ENROLLMENT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CL_ENROL_STATUS:MEANING'
, RESP1.ANTICIP_COMPL_DATE
, RESP1.COA_AMT
, RESP1.EFC_AMT
, RESP1.EST_FA_AMT
, RESP1.FLS_CERT_AMT
, RESP1.FLU_CERT_AMT
, RESP1.FLP_CERT_AMT
, RESP1.SCH_CERT_DATE
, RESP1.ALT_CERT_AMT
, RESP1.ALT_APPL_VER_CODE
, RESP1.LENDER_ID
, RESP1.FLS_APPROVED_AMT
, RESP1.FLU_APPROVED_AMT
, RESP1.FLP_APPROVED_AMT
, RESP1.ALT_APPROVED_AMT
, RESP1.GUARANTOR_ID
, RESP1.FED_APPL_FORM_CODE
, RESP1.LEND_BLKT_GUARNT_IND
, RESP1.LEND_BLKT_GUARNT_APPR_DATE
, RESP1.GUARNT_ADJ_IND
, RESP1.GUARANTEE_DATE
, RESP1.GUARANTEE_AMT
, '_LA:RESP1.REQ_SERIAL_LOAN_CODE:IGF_LOOKUPS_VIEW:IGF_SL_SERIAL_LOAN_CODE:MEANING'
, RESP1.BORW_CONFIRM_IND
, RESP1.B_LICENSE_STATE
, RESP1.B_LICENSE_NUMBER
, RESP1.B_REF_CODE
, '_LA:RESP1.PNOTE_DELIVERY_CODE:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_DELIVERY:MEANING'
, RESP1.B_FOREIGN_POSTAL_CODE
, RESP1.LEND_NON_ED_BRC_ID
, RESP1.LAST_RESORT_LENDER
, RESP1.RESP_TO_ORIG_CODE
, RESP1.ERR_MESG_1
, RESP1.ERR_MESG_2
, RESP1.ERR_MESG_3
, RESP1.ERR_MESG_4
, RESP1.ERR_MESG_5
, '_LA:RESP1.GUARNT_AMT_REDN_CODE:IGF_LOOKUPS_VIEW:IGF_SL_GUARNT_AMT_RED_CODE:MEANING'
, RESP1.TOT_OUTSTD_STAFFORD
, RESP1.TOT_OUTSTD_PLUS
, RESP1.ALT_PROG_TYPE_CODE
, RESP1.ALT_BORW_TOT_DEBT
, RESP1.ACT_INTEREST_RATE
, '_LA:RESP1.PRC_TYPE_CODE:IGF_LOOKUPS_VIEW:IGF_SL_PRC_TYPE_CODE:MEANING'
, '_LA:RESP1.SERVICE_TYPE_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CL_SERV_CD:MEANING'
, RESP1.REV_NOTICE_OF_GUARNT
, RESP1.SCH_REFUND_AMT
, RESP1.SCH_REFUND_DATE
, '_LA:RESP1.GUARNT_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_SL_GUARNT_STATUS:MEANING'
, '_LA:RESP1.LENDER_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_SL_LEND_STATUS:MEANING'
, '_LA:RESP1.PNOTE_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, '_LA:RESP1.CREDIT_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_SL_CREDIT_OVERRIDE:MEANING'
, RESP1.GUARNT_STATUS_DATE
, RESP1.LENDER_STATUS_DATE
, RESP1.PNOTE_STATUS_DATE
, RESP1.CREDIT_STATUS_DATE
, '_LA:RESP1.ACT_SERIAL_LOAN_CODE:IGF_LOOKUPS_VIEW:IGF_SL_ACT_SERIAL_LOAN_CODE:MEANING'
, RESP1.AMT_AVAIL_FOR_REINST
, RESP1.SCH_NON_ED_BRC_ID
, RESP1.UNIQ_LAYOUT_VEND_CODE
, RESP1.UNIQ_LAYOUT_IDENT_CODE
, RESP1.RESP_RECORD_STATUS
, RESP1.BORR_SIGN_IND
, RESP1.STUD_SIGN_IND
, RESP1.BORR_CREDIT_AUTH_CODE
, RESP1.SCHOOL_ID
, RESP1.CBTH_ID
, RESP1.CLRP1_ID
, RESP1.CREATED_BY
, RESP1.CREATION_DATE
, RESP1.LAST_UPDATED_BY
, RESP1.LAST_UPDATE_DATE
FROM IGF_SL_CL_RESP_R1_ALL RESP1 WITH READ ONLY