VIEW: APPS.IGF_AP_NSLDS_DATA_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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