VIEW: APPS.IGFFV_NSLDS

Source

View Text - Preformatted

SELECT NSLDS.NSLDS_TRANSACTION_NUM , NSLDS.NSLDS_DATABASE_RESULTS_F , '_LA:NSLDS.NSLDS_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', NSLDS.NSLDS_PELL_OVERPAY_F , NSLDS.NSLDS_PELL_OVERPAY_CONTACT , NSLDS.NSLDS_SEOG_OVERPAY_F , NSLDS.NSLDS_SEOG_OVERPAY_CONTACT , NSLDS.NSLDS_PERKINS_OVERPAY_F , NSLDS.NSLDS_PERKINS_OVERPAY_CNTCT , '_LA:NSLDS.NSLDS_DEFAULTED_LOAN_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_DISCHARGED_LOAN_F , '_LA:NSLDS.NSLDS_SATIS_REPAY_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , '_LA:NSLDS.NSLDS_ACT_BANKRUPTCY_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_AGG_SUBSZ_OUT_PRIN_BAL , NSLDS.NSLDS_AGG_UNSBZ_OUT_PRIN_BAL , NSLDS.NSLDS_AGG_COMB_OUT_PRIN_BAL , NSLDS.NSLDS_AGG_CONS_OUT_PRIN_BAL , NSLDS.NSLDS_AGG_SUBSZ_PEND_DISMT , NSLDS.NSLDS_AGG_UNSBZ_PEND_DISMT , NSLDS.NSLDS_AGG_COMB_PEND_DISMT , NSLDS.NSLDS_AGG_SUBSZ_TOTAL , NSLDS.NSLDS_AGG_UNSBZ_TOTAL , NSLDS.NSLDS_AGG_COMB_TOTAL , NSLDS.NSLDS_AGG_CONSD_TOTAL , NSLDS.NSLDS_PERKINS_OUT_BAL , NSLDS.NSLDS_PERKINS_CUR_YR_DISMNT , NSLDS.NSLDS_DEFAULT_LOAN_CHNG_F , NSLDS.NSLDS_DISCHGED_LOAN_CHNG_F , NSLDS.NSLDS_SATIS_REPAY_CHNG_F , NSLDS.NSLDS_ACT_BNKRUPT_CHNG_F , NSLDS.NSLDS_OVERPAY_CHNG_F , NSLDS.NSLDS_AGG_LOAN_CHNG_F , NSLDS.NSLDS_PERKINS_LOAN_CHNG_F , NSLDS.NSLDS_PELL_PAYMNT_CHNG_F , '_LA:NSLDS.NSLDS_ADDTNL_PELL_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:NSLDS.NSLDS_ADDTNL_LOAN_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', NSLDS.DIRECT_LOAN_MAS_PROM_NT_F , NSLDS.NSLDS_PELL_SEQ_NUM_1 , NSLDS.NSLDS_PELL_VERIFY_F_1 , NSLDS.NSLDS_PELL_EFC_1 , NSLDS.NSLDS_PELL_SCHOOL_CODE_1 , NSLDS.NSLDS_PELL_TRANSCN_NUM_1 , NSLDS.NSLDS_PELL_LAST_UPDT_DT_1 , NSLDS.NSLDS_PELL_SCHEDULED_AMT_1 , NSLDS.NSLDS_PELL_AMT_PAID_TODT_1 , NSLDS.NSLDS_PELL_REMNG_AMT_1 , NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_1 , NSLDS.NSLDS_PELL_AWARD_AMT_1 , NSLDS.NSLDS_PELL_SEQ_NUM_2 , NSLDS.NSLDS_PELL_VERIFY_F_2 , NSLDS.NSLDS_PELL_EFC_2 , NSLDS.NSLDS_PELL_SCHOOL_CODE_2 , NSLDS.NSLDS_PELL_TRANSCN_NUM_2 , NSLDS.NSLDS_PELL_LAST_UPDT_DT_2 , NSLDS.NSLDS_PELL_SCHEDULED_AMT_2 , NSLDS.NSLDS_PELL_AMT_PAID_TODT_2 , NSLDS.NSLDS_PELL_REMNG_AMT_2 , NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_2 , NSLDS.NSLDS_PELL_AWARD_AMT_2 , NSLDS.NSLDS_PELL_SEQ_NUM_3 , NSLDS.NSLDS_PELL_VERIFY_F_3 , NSLDS.NSLDS_PELL_EFC_3 , NSLDS.NSLDS_PELL_SCHOOL_CODE_3 , NSLDS.NSLDS_PELL_TRANSCN_NUM_3 , NSLDS.NSLDS_PELL_LAST_UPDT_DT_3 , NSLDS.NSLDS_PELL_SCHEDULED_AMT_3 , NSLDS.NSLDS_PELL_AMT_PAID_TODT_3 , NSLDS.NSLDS_PELL_REMNG_AMT_3 , NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_3 , NSLDS.NSLDS_PELL_AWARD_AMT_3 , NSLDS.NSLDS_LOAN_SEQ_NUM_1 , NSLDS.NSLDS_LOAN_TYPE_CODE_1 , NSLDS.NSLDS_LOAN_CHNG_F_1 , NSLDS.NSLDS_LOAN_PROG_CODE_1 , NSLDS.NSLDS_LOAN_NET_AMNT_1 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_1 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_1 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_1 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_1 , NSLDS.NSLDS_LOAN_BEGIN_DT_1 , NSLDS.NSLDS_LOAN_END_DT_1 , NSLDS.NSLDS_LOAN_GA_CODE_1 , NSLDS.NSLDS_LOAN_CONT_TYPE_1 , NSLDS.NSLDS_LOAN_SCHOL_CODE_1 , NSLDS.NSLDS_LOAN_CONT_CODE_1 , NSLDS.NSLDS_LOAN_GRADE_LVL_1 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_1 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_1:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_SEQ_NUM_2 , NSLDS.NSLDS_LOAN_TYPE_CODE_2 , NSLDS.NSLDS_LOAN_CHNG_F_2 , NSLDS.NSLDS_LOAN_PROG_CODE_2 , NSLDS.NSLDS_LOAN_NET_AMNT_2 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_2 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_2 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_2 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_2 , NSLDS.NSLDS_LOAN_BEGIN_DT_2 , NSLDS.NSLDS_LOAN_END_DT_2 , NSLDS.NSLDS_LOAN_GA_CODE_2 , NSLDS.NSLDS_LOAN_CONT_TYPE_2 , NSLDS.NSLDS_LOAN_SCHOL_CODE_2 , NSLDS.NSLDS_LOAN_CONT_CODE_2 , NSLDS.NSLDS_LOAN_GRADE_LVL_2 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_2 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_2:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_SEQ_NUM_3 , NSLDS.NSLDS_LOAN_TYPE_CODE_3 , NSLDS.NSLDS_LOAN_CHNG_F_3 , NSLDS.NSLDS_LOAN_PROG_CODE_3 , NSLDS.NSLDS_LOAN_NET_AMNT_3 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_3 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_3 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_3 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_3 , NSLDS.NSLDS_LOAN_BEGIN_DT_3 , NSLDS.NSLDS_LOAN_END_DT_3 , NSLDS.NSLDS_LOAN_GA_CODE_3 , NSLDS.NSLDS_LOAN_CONT_TYPE_3 , NSLDS.NSLDS_LOAN_SCHOL_CODE_3 , NSLDS.NSLDS_LOAN_CONT_CODE_3 , NSLDS.NSLDS_LOAN_GRADE_LVL_3 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_3 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_3:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_SEQ_NUM_4 , NSLDS.NSLDS_LOAN_TYPE_CODE_4 , NSLDS.NSLDS_LOAN_CHNG_F_4 , NSLDS.NSLDS_LOAN_PROG_CODE_4 , NSLDS.NSLDS_LOAN_NET_AMNT_4 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_4 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_4 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_4 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_4 , NSLDS.NSLDS_LOAN_BEGIN_DT_4 , NSLDS.NSLDS_LOAN_END_DT_4 , NSLDS.NSLDS_LOAN_GA_CODE_4 , NSLDS.NSLDS_LOAN_CONT_TYPE_4 , NSLDS.NSLDS_LOAN_SCHOL_CODE_4 , NSLDS.NSLDS_LOAN_CONT_CODE_4 , NSLDS.NSLDS_LOAN_GRADE_LVL_4 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_4 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_4:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_SEQ_NUM_5 , NSLDS.NSLDS_LOAN_TYPE_CODE_5 , NSLDS.NSLDS_LOAN_CHNG_F_5 , NSLDS.NSLDS_LOAN_PROG_CODE_5 , NSLDS.NSLDS_LOAN_NET_AMNT_5 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_5 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_5 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_5 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_5 , NSLDS.NSLDS_LOAN_BEGIN_DT_5 , NSLDS.NSLDS_LOAN_END_DT_5 , NSLDS.NSLDS_LOAN_GA_CODE_5 , NSLDS.NSLDS_LOAN_CONT_TYPE_5 , NSLDS.NSLDS_LOAN_SCHOL_CODE_5 , NSLDS.NSLDS_LOAN_CONT_CODE_5 , NSLDS.NSLDS_LOAN_GRADE_LVL_5 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_5 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_5:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_SEQ_NUM_6 , NSLDS.NSLDS_LOAN_TYPE_CODE_6 , NSLDS.NSLDS_LOAN_CHNG_F_6 , NSLDS.NSLDS_LOAN_PROG_CODE_6 , NSLDS.NSLDS_LOAN_NET_AMNT_6 , NSLDS.NSLDS_LOAN_CUR_ST_CODE_6 , NSLDS.NSLDS_LOAN_CUR_ST_DATE_6 , NSLDS.NSLDS_LOAN_AGG_PR_BAL_6 , NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_6 , NSLDS.NSLDS_LOAN_BEGIN_DT_6 , NSLDS.NSLDS_LOAN_END_DT_6 , NSLDS.NSLDS_LOAN_GA_CODE_6 , NSLDS.NSLDS_LOAN_CONT_TYPE_6 , NSLDS.NSLDS_LOAN_SCHOL_CODE_6 , NSLDS.NSLDS_LOAN_CONT_CODE_6 , NSLDS.NSLDS_LOAN_GRADE_LVL_6 , NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_6 , '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_6:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING' , NSLDS.NSLDS_LOAN_LAST_D_AMT_1 , NSLDS.NSLDS_LOAN_LAST_D_DATE_1 , NSLDS.NSLDS_LOAN_LAST_D_AMT_2 , NSLDS.NSLDS_LOAN_LAST_D_DATE_2 , NSLDS.NSLDS_LOAN_LAST_D_AMT_3 , NSLDS.NSLDS_LOAN_LAST_D_DATE_3 , NSLDS.NSLDS_LOAN_LAST_D_AMT_4 , NSLDS.NSLDS_LOAN_LAST_D_DATE_4 , NSLDS.NSLDS_LOAN_LAST_D_AMT_5 , NSLDS.NSLDS_LOAN_LAST_D_DATE_5 , NSLDS.NSLDS_LOAN_LAST_D_AMT_6 , NSLDS.NSLDS_LOAN_LAST_D_DATE_6 , NSLDS.DLP_MASTER_PROM_NOTE_FLAG, '_LA:NSLDS.COMBINED_LOAN_LIMIT_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_LOAN_LIMIT_TYPE:MEANING', '_LA:NSLDS.SUBSIDIZED_LOAN_LIMIT_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_LOAN_LIMIT_TYPE:MEANING', PE.PARTY_NUMBER, PE.PARTY_NAME, CI.ALTERNATE_CODE, CI.DESCRIPTION, ISIR.APP_RECEIPT_DATE, NSLDS.TRANSACTION_NUM_TXT, NSLDS.BASE_ID , NSLDS.ISIR_ID , NSLDS.NSLDS_ID , NSLDS.CREATED_BY , NSLDS.CREATION_DATE , NSLDS.LAST_UPDATED_BY , NSLDS.LAST_UPDATE_DATE , BASE.PERSON_ID FROM IGF_AP_NSLDS_DATA_ALL NSLDS, IGF_AP_ISIR_MATCHED_ALL ISIR, IGF_AP_FA_BASE_REC_ALL BASE, IGS_CA_INST_ALL CI, HZ_PARTIES PE WHERE NSLDS.ISIR_ID = ISIR.ISIR_ID AND NSLDS.BASE_ID = BASE.BASE_ID AND BASE.CI_CAL_TYPE = CI.CAL_TYPE AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT NSLDS.NSLDS_TRANSACTION_NUM
, NSLDS.NSLDS_DATABASE_RESULTS_F
, '_LA:NSLDS.NSLDS_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_PELL_OVERPAY_F
, NSLDS.NSLDS_PELL_OVERPAY_CONTACT
, NSLDS.NSLDS_SEOG_OVERPAY_F
, NSLDS.NSLDS_SEOG_OVERPAY_CONTACT
, NSLDS.NSLDS_PERKINS_OVERPAY_F
, NSLDS.NSLDS_PERKINS_OVERPAY_CNTCT
, '_LA:NSLDS.NSLDS_DEFAULTED_LOAN_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_DISCHARGED_LOAN_F
, '_LA:NSLDS.NSLDS_SATIS_REPAY_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:NSLDS.NSLDS_ACT_BANKRUPTCY_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_AGG_SUBSZ_OUT_PRIN_BAL
, NSLDS.NSLDS_AGG_UNSBZ_OUT_PRIN_BAL
, NSLDS.NSLDS_AGG_COMB_OUT_PRIN_BAL
, NSLDS.NSLDS_AGG_CONS_OUT_PRIN_BAL
, NSLDS.NSLDS_AGG_SUBSZ_PEND_DISMT
, NSLDS.NSLDS_AGG_UNSBZ_PEND_DISMT
, NSLDS.NSLDS_AGG_COMB_PEND_DISMT
, NSLDS.NSLDS_AGG_SUBSZ_TOTAL
, NSLDS.NSLDS_AGG_UNSBZ_TOTAL
, NSLDS.NSLDS_AGG_COMB_TOTAL
, NSLDS.NSLDS_AGG_CONSD_TOTAL
, NSLDS.NSLDS_PERKINS_OUT_BAL
, NSLDS.NSLDS_PERKINS_CUR_YR_DISMNT
, NSLDS.NSLDS_DEFAULT_LOAN_CHNG_F
, NSLDS.NSLDS_DISCHGED_LOAN_CHNG_F
, NSLDS.NSLDS_SATIS_REPAY_CHNG_F
, NSLDS.NSLDS_ACT_BNKRUPT_CHNG_F
, NSLDS.NSLDS_OVERPAY_CHNG_F
, NSLDS.NSLDS_AGG_LOAN_CHNG_F
, NSLDS.NSLDS_PERKINS_LOAN_CHNG_F
, NSLDS.NSLDS_PELL_PAYMNT_CHNG_F
, '_LA:NSLDS.NSLDS_ADDTNL_PELL_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:NSLDS.NSLDS_ADDTNL_LOAN_F:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.DIRECT_LOAN_MAS_PROM_NT_F
, NSLDS.NSLDS_PELL_SEQ_NUM_1
, NSLDS.NSLDS_PELL_VERIFY_F_1
, NSLDS.NSLDS_PELL_EFC_1
, NSLDS.NSLDS_PELL_SCHOOL_CODE_1
, NSLDS.NSLDS_PELL_TRANSCN_NUM_1
, NSLDS.NSLDS_PELL_LAST_UPDT_DT_1
, NSLDS.NSLDS_PELL_SCHEDULED_AMT_1
, NSLDS.NSLDS_PELL_AMT_PAID_TODT_1
, NSLDS.NSLDS_PELL_REMNG_AMT_1
, NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_1
, NSLDS.NSLDS_PELL_AWARD_AMT_1
, NSLDS.NSLDS_PELL_SEQ_NUM_2
, NSLDS.NSLDS_PELL_VERIFY_F_2
, NSLDS.NSLDS_PELL_EFC_2
, NSLDS.NSLDS_PELL_SCHOOL_CODE_2
, NSLDS.NSLDS_PELL_TRANSCN_NUM_2
, NSLDS.NSLDS_PELL_LAST_UPDT_DT_2
, NSLDS.NSLDS_PELL_SCHEDULED_AMT_2
, NSLDS.NSLDS_PELL_AMT_PAID_TODT_2
, NSLDS.NSLDS_PELL_REMNG_AMT_2
, NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_2
, NSLDS.NSLDS_PELL_AWARD_AMT_2
, NSLDS.NSLDS_PELL_SEQ_NUM_3
, NSLDS.NSLDS_PELL_VERIFY_F_3
, NSLDS.NSLDS_PELL_EFC_3
, NSLDS.NSLDS_PELL_SCHOOL_CODE_3
, NSLDS.NSLDS_PELL_TRANSCN_NUM_3
, NSLDS.NSLDS_PELL_LAST_UPDT_DT_3
, NSLDS.NSLDS_PELL_SCHEDULED_AMT_3
, NSLDS.NSLDS_PELL_AMT_PAID_TODT_3
, NSLDS.NSLDS_PELL_REMNG_AMT_3
, NSLDS.NSLDS_PELL_PC_SCHD_AWD_US_3
, NSLDS.NSLDS_PELL_AWARD_AMT_3
, NSLDS.NSLDS_LOAN_SEQ_NUM_1
, NSLDS.NSLDS_LOAN_TYPE_CODE_1
, NSLDS.NSLDS_LOAN_CHNG_F_1
, NSLDS.NSLDS_LOAN_PROG_CODE_1
, NSLDS.NSLDS_LOAN_NET_AMNT_1
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_1
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_1
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_1
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_1
, NSLDS.NSLDS_LOAN_BEGIN_DT_1
, NSLDS.NSLDS_LOAN_END_DT_1
, NSLDS.NSLDS_LOAN_GA_CODE_1
, NSLDS.NSLDS_LOAN_CONT_TYPE_1
, NSLDS.NSLDS_LOAN_SCHOL_CODE_1
, NSLDS.NSLDS_LOAN_CONT_CODE_1
, NSLDS.NSLDS_LOAN_GRADE_LVL_1
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_1
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_1:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_SEQ_NUM_2
, NSLDS.NSLDS_LOAN_TYPE_CODE_2
, NSLDS.NSLDS_LOAN_CHNG_F_2
, NSLDS.NSLDS_LOAN_PROG_CODE_2
, NSLDS.NSLDS_LOAN_NET_AMNT_2
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_2
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_2
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_2
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_2
, NSLDS.NSLDS_LOAN_BEGIN_DT_2
, NSLDS.NSLDS_LOAN_END_DT_2
, NSLDS.NSLDS_LOAN_GA_CODE_2
, NSLDS.NSLDS_LOAN_CONT_TYPE_2
, NSLDS.NSLDS_LOAN_SCHOL_CODE_2
, NSLDS.NSLDS_LOAN_CONT_CODE_2
, NSLDS.NSLDS_LOAN_GRADE_LVL_2
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_2
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_2:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_SEQ_NUM_3
, NSLDS.NSLDS_LOAN_TYPE_CODE_3
, NSLDS.NSLDS_LOAN_CHNG_F_3
, NSLDS.NSLDS_LOAN_PROG_CODE_3
, NSLDS.NSLDS_LOAN_NET_AMNT_3
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_3
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_3
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_3
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_3
, NSLDS.NSLDS_LOAN_BEGIN_DT_3
, NSLDS.NSLDS_LOAN_END_DT_3
, NSLDS.NSLDS_LOAN_GA_CODE_3
, NSLDS.NSLDS_LOAN_CONT_TYPE_3
, NSLDS.NSLDS_LOAN_SCHOL_CODE_3
, NSLDS.NSLDS_LOAN_CONT_CODE_3
, NSLDS.NSLDS_LOAN_GRADE_LVL_3
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_3
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_3:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_SEQ_NUM_4
, NSLDS.NSLDS_LOAN_TYPE_CODE_4
, NSLDS.NSLDS_LOAN_CHNG_F_4
, NSLDS.NSLDS_LOAN_PROG_CODE_4
, NSLDS.NSLDS_LOAN_NET_AMNT_4
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_4
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_4
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_4
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_4
, NSLDS.NSLDS_LOAN_BEGIN_DT_4
, NSLDS.NSLDS_LOAN_END_DT_4
, NSLDS.NSLDS_LOAN_GA_CODE_4
, NSLDS.NSLDS_LOAN_CONT_TYPE_4
, NSLDS.NSLDS_LOAN_SCHOL_CODE_4
, NSLDS.NSLDS_LOAN_CONT_CODE_4
, NSLDS.NSLDS_LOAN_GRADE_LVL_4
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_4
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_4:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_SEQ_NUM_5
, NSLDS.NSLDS_LOAN_TYPE_CODE_5
, NSLDS.NSLDS_LOAN_CHNG_F_5
, NSLDS.NSLDS_LOAN_PROG_CODE_5
, NSLDS.NSLDS_LOAN_NET_AMNT_5
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_5
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_5
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_5
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_5
, NSLDS.NSLDS_LOAN_BEGIN_DT_5
, NSLDS.NSLDS_LOAN_END_DT_5
, NSLDS.NSLDS_LOAN_GA_CODE_5
, NSLDS.NSLDS_LOAN_CONT_TYPE_5
, NSLDS.NSLDS_LOAN_SCHOL_CODE_5
, NSLDS.NSLDS_LOAN_CONT_CODE_5
, NSLDS.NSLDS_LOAN_GRADE_LVL_5
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_5
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_5:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_SEQ_NUM_6
, NSLDS.NSLDS_LOAN_TYPE_CODE_6
, NSLDS.NSLDS_LOAN_CHNG_F_6
, NSLDS.NSLDS_LOAN_PROG_CODE_6
, NSLDS.NSLDS_LOAN_NET_AMNT_6
, NSLDS.NSLDS_LOAN_CUR_ST_CODE_6
, NSLDS.NSLDS_LOAN_CUR_ST_DATE_6
, NSLDS.NSLDS_LOAN_AGG_PR_BAL_6
, NSLDS.NSLDS_LOAN_OUT_PR_BAL_DT_6
, NSLDS.NSLDS_LOAN_BEGIN_DT_6
, NSLDS.NSLDS_LOAN_END_DT_6
, NSLDS.NSLDS_LOAN_GA_CODE_6
, NSLDS.NSLDS_LOAN_CONT_TYPE_6
, NSLDS.NSLDS_LOAN_SCHOL_CODE_6
, NSLDS.NSLDS_LOAN_CONT_CODE_6
, NSLDS.NSLDS_LOAN_GRADE_LVL_6
, NSLDS.NSLDS_LOAN_XTR_UNSBZ_LN_F_6
, '_LA:NSLDS.NSLDS_LOAN_CAPITAL_INT_F_6:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, NSLDS.NSLDS_LOAN_LAST_D_AMT_1
, NSLDS.NSLDS_LOAN_LAST_D_DATE_1
, NSLDS.NSLDS_LOAN_LAST_D_AMT_2
, NSLDS.NSLDS_LOAN_LAST_D_DATE_2
, NSLDS.NSLDS_LOAN_LAST_D_AMT_3
, NSLDS.NSLDS_LOAN_LAST_D_DATE_3
, NSLDS.NSLDS_LOAN_LAST_D_AMT_4
, NSLDS.NSLDS_LOAN_LAST_D_DATE_4
, NSLDS.NSLDS_LOAN_LAST_D_AMT_5
, NSLDS.NSLDS_LOAN_LAST_D_DATE_5
, NSLDS.NSLDS_LOAN_LAST_D_AMT_6
, NSLDS.NSLDS_LOAN_LAST_D_DATE_6
, NSLDS.DLP_MASTER_PROM_NOTE_FLAG
, '_LA:NSLDS.COMBINED_LOAN_LIMIT_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_LOAN_LIMIT_TYPE:MEANING'
, '_LA:NSLDS.SUBSIDIZED_LOAN_LIMIT_TYPE:IGF_LOOKUPS_VIEW:IGF_AP_LOAN_LIMIT_TYPE:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, ISIR.APP_RECEIPT_DATE
, NSLDS.TRANSACTION_NUM_TXT
, NSLDS.BASE_ID
, NSLDS.ISIR_ID
, NSLDS.NSLDS_ID
, NSLDS.CREATED_BY
, NSLDS.CREATION_DATE
, NSLDS.LAST_UPDATED_BY
, NSLDS.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AP_NSLDS_DATA_ALL NSLDS
, IGF_AP_ISIR_MATCHED_ALL ISIR
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE NSLDS.ISIR_ID = ISIR.ISIR_ID
AND NSLDS.BASE_ID = BASE.BASE_ID
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY