VIEW: APPS.IGFFV_FFELP_ORIG_RESPONSES

Source

View Text - Preformatted

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_LAST_NAME, RESP1.S_FIRST_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, BATCH.BATCH_ID, BATCH.FILE_CREATION_DATE, BATCH.FILE_TRANS_DATE, BATCH.FILE_IDENT_CODE, BATCH.RECIPIENT_ID, BATCH.RECIP_NON_ED_BRC_ID, BATCH.SOURCE_ID, BATCH.SOURCE_NON_ED_BRC_ID, RESP1.SCHOOL_ID, RESP1.CBTH_ID, RESP1.CLRP1_ID, RESP1.CREATED_BY, RESP1.CREATION_DATE, RESP1.LAST_UPDATED_BY, RESP1.LAST_UPDATE_DATE, RESP1.B_ALIEN_REG_NUM_TXT, RESP1.ESIGN_SRC_TYP_CD FROM IGF_SL_CL_RESP_R1_ALL RESP1, IGF_SL_CL_BATCH_ALL BATCH WHERE BATCH.CBTH_ID = RESP1.CBTH_ID WITH READ ONLY

View Text - HTML Formatted

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_LAST_NAME
, RESP1.S_FIRST_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
, BATCH.BATCH_ID
, BATCH.FILE_CREATION_DATE
, BATCH.FILE_TRANS_DATE
, BATCH.FILE_IDENT_CODE
, BATCH.RECIPIENT_ID
, BATCH.RECIP_NON_ED_BRC_ID
, BATCH.SOURCE_ID
, BATCH.SOURCE_NON_ED_BRC_ID
, RESP1.SCHOOL_ID
, RESP1.CBTH_ID
, RESP1.CLRP1_ID
, RESP1.CREATED_BY
, RESP1.CREATION_DATE
, RESP1.LAST_UPDATED_BY
, RESP1.LAST_UPDATE_DATE
, RESP1.B_ALIEN_REG_NUM_TXT
, RESP1.ESIGN_SRC_TYP_CD
FROM IGF_SL_CL_RESP_R1_ALL RESP1
, IGF_SL_CL_BATCH_ALL BATCH
WHERE BATCH.CBTH_ID = RESP1.CBTH_ID WITH READ ONLY