Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds the NSLDS data of a financial aid student |
Implementation/DBA Data: | APPS.IGFFV_NSLDS |
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