eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGFFV_NSLDS

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

View Text

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

Columns

Name
NSLDS_TRANSACTION_NUMBER
NSLDS_DATABASE_RESULTS_FLAG
"_LA:NSLDS_FLAG"
NSLDS_PELL_OVERPAYMENT_FLAG
NSLDS_PELL_OVERPAY_CONTACT
NSLDS_SEOG_OVERPAYMENT_FLAG
NSLDS_SEOG_OVERPAY_CONTACT
NSLDS_PERKINS_OVERPAY_FLAG
NSLDS_PERKINS_OVERPAY_CNTCT
"_LA:NSLDS_DEFAULTE_LOAN_FLAG"
NSLDS_DISCHARGED_LOAN_FLAG
"_LA:NSLDS_SATISFACT_REP_FLAG"
"_LA:NSLDS_ACT_BANKRUPT_FLAG"
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_SUBSIDIZED_TOTAL
NSLDS_AGG_UNSUBSIDIZED_TOTAL
NSLDS_AGG_COMBINED_TOTAL
NSLDS_AGG_CONSOLIDATED_TOTAL
NSLDS_PERKINS_PRINICIPAL_BAL
NSLDS_PERKINS_CUR_YR_AMOUNT
NSLDS_DEFAULT_LOAN_CHNG_FLAG
NSLDS_DISCHGED_LOAN_CHNG_FLAG
NSLDS_SATIS_REPAY_CHNG_FLAG
NSLDS_ACT_BNKRUPT_CHNG_FLAG
NSLDS_OVERPAYMENTS_CHANGE_FLAG
NSLDS_AGG_LOAN_CHANGE_FLAG
NSLDS_PERKINS_LOAN_CHANGE_FLAG
NSLDS_PELL_PAYMNT_CHANGE_FLAG
"_LA:NSLDS_ADTIONAL_PELL_FLAG"
"_LA:NSLDS_ADTIONAL_LOAN_FLAG"
DIRECT_LOAN_MAS_PROM_NOTE_FLAG
NSLDS_PELL_1_SEQUENCE_NUMBER
NSLDS_PELL_1_VERIFICATION
NSLDS_PELL_1_EFC
NSLDS_PELL_1_SCHOOL_CODE
NSLDS_PELL_1_TRANSACTON_NUMBER
NSLDS_PELL_1_LAST_UPDATE_DATE
NSLDS_PELL_1_SCHEDULED_AMOUNT
NSLDS_PELL_1_AMT_PAID_TO_DATE
NSLDS_PELL_1_REMAING_AMOUNT
NSLDS_PELL_1_PC_SCHD_AWARD_US
NSLDS_PELL_1_AWARD_AMOUNT
NSLDS_PELL_2_SEQUENCE_NUMBER
NSLDS_PELL_2_VERIFICATION
NSLDS_PELL_2_EFC
NSLDS_PELL_2_SCHOOL_CODE
NSLDS_PELL_2_TRANSACTON_NUMBER
NSLDS_PELL_2_LAST_UPDATE_DATE
NSLDS_PELL_2_SCHEDULED_AMOUNT
NSLDS_PELL_2_AMT_PAID_TO_DATE
NSLDS_PELL_2_REMAING_AMOUNT
NSLDS_PELL_2_PC_SCHD_AWARD_US
NSLDS_PELL_2_AWARD_AMOUNT
NSLDS_PELL_3_SEQUENCE_NUMBER
NSLDS_PELL_3_VERIFICATION
NSLDS_PELL_3_EFC
NSLDS_PELL_3_SCHOOL_CODE
NSLDS_PELL_3_TRANSACTON_NUMBER
NSLDS_PELL_3_LAST_UPDATE_DATE
NSLDS_PELL_3_SCHEDULED_AMOUNT
NSLDS_PELL_3_AMT_PAID_TO_DATE
NSLDS_PELL_3_REMAING_AMOUNT
NSLDS_PELL_3_PC_SCHD_AWARD_US
NSLDS_PELL_3_AWARD_AMOUNT
NSLDS_LOAN_1_SEQUENCE_NUMBER
NSLDS_LOAN_1_TYPE_CODE
NSLDS_LOAN_1_CHANGE_FLAG
NSLDS_LOAN_1_PROGRAM_CODE
NSLDS_LOAN_1_NET_AMOUNT
NSLDS_LOAN_1_CUR_STATUS_CODE
NSLDS_LOAN_1_CUR_STATUS_DATE
NSLDS_LOAN_1_AGG_PRINCI_BAL
NSLDS_LOAN_1_OUT_PR_BAL_DT
NSLDS_LOAN_1_BEGIN_DATE
NSLDS_LOAN_1_END_DATE
NSLDS_LOAN_1_GRADE_CODE
NSLDS_LOAN_1_CONTACT_TYPE
NSLDS_LOAN_1_SCHOOL_CODE
NSLDS_LOAN_1_CONTACT_CODE
NSLDS_LOAN_1_GRADE_LEVEL
NSLDS_LOAN_1_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_1_CAP_IN_FLAG"
NSLDS_LOAN_2_SEQUENCE_NUMBER
NSLDS_LOAN_2_TYPE_CODE
NSLDS_LOAN_2_CHANGE_FLAG
NSLDS_LOAN_2_PROGRAM_CODE
NSLDS_LOAN_2_NET_AMOUNT
NSLDS_LOAN_2_CUR_STATUS_CODE
NSLDS_LOAN_2_CUR_STATUS_DATE
NSLDS_LOAN_2_AGG_PRINCI_BAL
NSLDS_LOAN_2_OUT_PR_BAL_DT
NSLDS_LOAN_2_BEGIN_DATE
NSLDS_LOAN_2_END_DATE
NSLDS_LOAN_2_GRADE_CODE
NSLDS_LOAN_2_CONTACT_TYPE
NSLDS_LOAN_2_SCHOOL_CODE
NSLDS_LOAN_2_CONTACT_CODE
NSLDS_LOAN_2_GRADE_LEVEL
NSLDS_LOAN_2_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_2_CAP_IN_FLAG"
NSLDS_LOAN_3_SEQUENCE_NUMBER
NSLDS_LOAN_3_TYPE_CODE
NSLDS_LOAN_3_CHANGE_FLAG
NSLDS_LOAN_3_PROGRAM_CODE
NSLDS_LOAN_3_NET_AMOUNT
NSLDS_LOAN_3_CUR_STATUS_CODE
NSLDS_LOAN_3_CUR_STATUS_DATE
NSLDS_LOAN_3_AGG_PRINCI_BAL
NSLDS_LOAN_3_OUT_PR_BAL_DT
NSLDS_LOAN_3_BEGIN_DATE
NSLDS_LOAN_3_END_DATE
NSLDS_LOAN_3_GRADE_CODE
NSLDS_LOAN_3_CONTACT_TYPE
NSLDS_LOAN_3_SCHOOL_CODE
NSLDS_LOAN_3_CONTACT_CODE
NSLDS_LOAN_3_GRADE_LEVEL
NSLDS_LOAN_3_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_3_CAP_IN_FLAG"
NSLDS_LOAN_4_SEQUENCE_NUMBER
NSLDS_LOAN_4_TYPE_CODE
NSLDS_LOAN_4_CHANGE_FLAG
NSLDS_LOAN_4_PROGRAM_CODE
NSLDS_LOAN_4_NET_AMOUNT
NSLDS_LOAN_4_CUR_STATUS_CODE
NSLDS_LOAN_4_CUR_STATUS_DATE
NSLDS_LOAN_4_AGG_PRINCI_BAL
NSLDS_LOAN_4_OUT_PR_BAL_DT
NSLDS_LOAN_4_BEGIN_DATE
NSLDS_LOAN_4_END_DATE
NSLDS_LOAN_4_GRADE_CODE
NSLDS_LOAN_4_CONTACT_TYPE
NSLDS_LOAN_4_SCHOOL_CODE
NSLDS_LOAN_4_CONTACT_CODE
NSLDS_LOAN_4_GRADE_LEVEL
NSLDS_LOAN_4_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_4_CAP_IN_FLAG"
NSLDS_LOAN_5_SEQUENCE_NUMBER
NSLDS_LOAN_5_TYPE_CODE
NSLDS_LOAN_5_CHANGE_FLAG
NSLDS_LOAN_5_PROGRAM_CODE
NSLDS_LOAN_5_NET_AMOUNT
NSLDS_LOAN_5_CUR_STATUS_CODE
NSLDS_LOAN_5_CUR_STATUS_DATE
NSLDS_LOAN_5_AGG_PRINCI_BAL
NSLDS_LOAN_5_OUT_PR_BAL_DT
NSLDS_LOAN_5_BEGIN_DATE
NSLDS_LOAN_5_END_DATE
NSLDS_LOAN_5_GRADE_CODE
NSLDS_LOAN_5_CONTACT_TYPE
NSLDS_LOAN_5_SCHOOL_CODE
NSLDS_LOAN_5_CONTACT_CODE
NSLDS_LOAN_5_GRADE_LEVEL
NSLDS_LOAN_5_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_5_CAP_IN_FLAG"
NSLDS_LOAN_6_SEQUENCE_NUMBER
NSLDS_LOAN_6_TYPE_CODE
NSLDS_LOAN_6_CHANGE_FLAG
NSLDS_LOAN_6_PROGRAM_CODE
NSLDS_LOAN_6_NET_AMOUNT
NSLDS_LOAN_6_CUR_STATUS_CODE
NSLDS_LOAN_6_CUR_STATUS_DATE
NSLDS_LOAN_6_AGG_PRINCI_BAL
NSLDS_LOAN_6_OUT_PR_BAL_DT
NSLDS_LOAN_6_BEGIN_DATE
NSLDS_LOAN_6_END_DATE
NSLDS_LOAN_6_GRADE_CODE
NSLDS_LOAN_6_CONTACT_TYPE
NSLDS_LOAN_6_SCHOOL_CODE
NSLDS_LOAN_6_CONTACT_CODE
NSLDS_LOAN_6_GRADE_LEVEL
NSLDS_LOAN_6_XTR_UNSBZ_LN_FLAG
"_LA:NSLDS_LOAN_6_CAP_IN_FLAG"
NSLDS_LOAN_1_LAST_D_AMOUNT
NSLDS_LOAN_1_LAST_D_DATE
NSLDS_LOAN_2_LAST_D_AMOUNT
NSLDS_LOAN_2_LAST_D_DATE
NSLDS_LOAN_3_LAST_D_AMOUNT
NSLDS_LOAN_3_LAST_D_DATE
NSLDS_LOAN_4_LAST_D_AMOUNT
NSLDS_LOAN_4_LAST_D_DATE
NSLDS_LOAN_5_LAST_D_AMOUNT
NSLDS_LOAN_5_LAST_D_DATE
NSLDS_LOAN_6_LAST_D_AMOUNT
NSLDS_LOAN_6_LAST_D_DATE
DLP_MASTER_PROM_NOTE_FLAG
"_LA:COMBINE_LOAN_LIMIT_TYPE"
"_LA:SUBSDIZ_LOAN_LIMIT_TYPE"
PERSON_NUMBER
PERSON_NAME
AWARD_YEAR
AWARD_YEAR_DESCRIPTION
APPLICATION_RECEIPT_DATE
TRANSACTION_NUMBER
BASE_ID
ISIR_ID
NSLDS_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
PERSON_ID