View: IGF_AP_NSLDS_DATA

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AP_NSLDS_DATA

View Text

SELECT NSLDS.ROWID
, NSLDS.NSLDS_ID
, NSLDS.ISIR_ID
, NSLDS.BASE_ID
, NSLDS.TRANSACTION_NUM_TXT
, NSLDS.NSLDS_TRANSACTION_NUM
, NSLDS.NSLDS_DATABASE_RESULTS_F
, NSLDS.NSLDS_F
, 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
, NSLDS.NSLDS_DEFAULTED_LOAN_F
, NSLDS.NSLDS_DISCHARGED_LOAN_F
, NSLDS.NSLDS_SATIS_REPAY_F
, NSLDS.NSLDS_ACT_BANKRUPTCY_F
, 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
, NSLDS.NSLDS_ADDTNL_PELL_F
, NSLDS.NSLDS_ADDTNL_LOAN_F
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_1
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_2
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_3
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_4
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_5
, 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
, NSLDS.NSLDS_LOAN_CAPITAL_INT_F_6
, NSLDS.CREATED_BY
, NSLDS.CREATION_DATE
, NSLDS.LAST_UPDATED_BY
, NSLDS.LAST_UPDATE_DATE
, NSLDS.LAST_UPDATE_LOGIN
, NSLDS.PROGRAM_APPLICATION_ID
, NSLDS.PROGRAM_ID
, NSLDS.PROGRAM_UPDATE_DATE
, NSLDS.REQUEST_ID
, NSLDS.ORG_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_ALL NSLDS
WHERE NVL (NSLDS.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns