[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_NSLDS_DATA |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_AP_NSLDS_DATA
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Obsolete
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| NSLDS_ID | NUMBER | (15) | Yes | |
| ISIR_ID | NUMBER | (15) | Yes | |
| BASE_ID | NUMBER | (15) | ||
| TRANSACTION_NUM_TXT | VARCHAR2 | (2) | For storing the ISIR transaction Number | |
| NSLDS_TRANSACTION_NUM | NUMBER | (2) | ||
| NSLDS_DATABASE_RESULTS_F | VARCHAR2 | (1) | ||
| NSLDS_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_OVERPAY_CONTACT | VARCHAR2 | (8) | ||
| NSLDS_SEOG_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_SEOG_OVERPAY_CONTACT | VARCHAR2 | (8) | ||
| NSLDS_PERKINS_OVERPAY_F | VARCHAR2 | (1) | ||
| NSLDS_PERKINS_OVERPAY_CNTCT | VARCHAR2 | (8) | ||
| NSLDS_DEFAULTED_LOAN_F | VARCHAR2 | (1) | ||
| NSLDS_DISCHARGED_LOAN_F | VARCHAR2 | (1) | ||
| NSLDS_SATIS_REPAY_F | VARCHAR2 | (1) | ||
| NSLDS_ACT_BANKRUPTCY_F | VARCHAR2 | (1) | ||
| NSLDS_AGG_SUBSZ_OUT_PRIN_BAL | NUMBER | (6) | ||
| NSLDS_AGG_UNSBZ_OUT_PRIN_BAL | NUMBER | (6) | ||
| NSLDS_AGG_COMB_OUT_PRIN_BAL | NUMBER | (6) | ||
| NSLDS_AGG_CONS_OUT_PRIN_BAL | NUMBER | (6) | ||
| NSLDS_AGG_SUBSZ_PEND_DISMT | NUMBER | (6) | ||
| NSLDS_AGG_UNSBZ_PEND_DISMT | NUMBER | (6) | ||
| NSLDS_AGG_COMB_PEND_DISMT | NUMBER | (6) | ||
| NSLDS_AGG_SUBSZ_TOTAL | NUMBER | (6) | ||
| NSLDS_AGG_UNSBZ_TOTAL | NUMBER | (6) | ||
| NSLDS_AGG_COMB_TOTAL | NUMBER | (6) | ||
| NSLDS_AGG_CONSD_TOTAL | NUMBER | (6) | ||
| NSLDS_PERKINS_OUT_BAL | NUMBER | (6) | ||
| NSLDS_PERKINS_CUR_YR_DISMNT | NUMBER | (6) | ||
| NSLDS_DEFAULT_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_DISCHGED_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_SATIS_REPAY_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_ACT_BNKRUPT_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_OVERPAY_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_AGG_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_PERKINS_LOAN_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_PAYMNT_CHNG_F | VARCHAR2 | (1) | ||
| NSLDS_ADDTNL_PELL_F | VARCHAR2 | (1) | ||
| NSLDS_ADDTNL_LOAN_F | VARCHAR2 | (1) | ||
| DIRECT_LOAN_MAS_PROM_NT_F | VARCHAR2 | (1) | ||
| NSLDS_PELL_SEQ_NUM_1 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_1 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_1 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_1 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_1 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_1 | DATE | |||
| NSLDS_PELL_SCHEDULED_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_1 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_1 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_1 | NUMBER | (6) | ||
| NSLDS_PELL_SEQ_NUM_2 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_2 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_2 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_2 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_2 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_2 | DATE | |||
| NSLDS_PELL_SCHEDULED_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_2 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_2 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_2 | NUMBER | (6) | ||
| NSLDS_PELL_SEQ_NUM_3 | NUMBER | (2) | ||
| NSLDS_PELL_VERIFY_F_3 | VARCHAR2 | (3) | ||
| NSLDS_PELL_EFC_3 | NUMBER | (6) | ||
| NSLDS_PELL_SCHOOL_CODE_3 | NUMBER | (8) | ||
| NSLDS_PELL_TRANSCN_NUM_3 | NUMBER | (2) | ||
| NSLDS_PELL_LAST_UPDT_DT_3 | DATE | |||
| NSLDS_PELL_SCHEDULED_AMT_3 | NUMBER | (6) | ||
| NSLDS_PELL_AMT_PAID_TODT_3 | NUMBER | (6) | ||
| NSLDS_PELL_REMNG_AMT_3 | NUMBER | (6) | ||
| NSLDS_PELL_PC_SCHD_AWD_US_3 | NUMBER | (5) | ||
| NSLDS_PELL_AWARD_AMT_3 | NUMBER | (6) | ||
| NSLDS_LOAN_SEQ_NUM_1 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_1 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_1 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_1 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_1 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_1 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_1 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_1 | DATE | |||
| NSLDS_LOAN_END_DT_1 | DATE | |||
| NSLDS_LOAN_GA_CODE_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_1 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_1 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_1 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_2 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_2 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_2 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_2 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_2 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_2 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_2 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_2 | DATE | |||
| NSLDS_LOAN_END_DT_2 | DATE | |||
| NSLDS_LOAN_GA_CODE_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_2 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_2 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_2 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_3 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_3 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_3 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_3 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_3 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_3 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_3 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_3 | DATE | |||
| NSLDS_LOAN_END_DT_3 | DATE | |||
| NSLDS_LOAN_GA_CODE_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_3 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_3 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_3 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_4 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_4 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_4 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_4 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_4 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_4 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_4 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_4 | DATE | |||
| NSLDS_LOAN_END_DT_4 | DATE | |||
| NSLDS_LOAN_GA_CODE_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_4 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_4 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_4 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_5 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_5 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_5 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_5 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_5 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_5 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_5 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_5 | DATE | |||
| NSLDS_LOAN_END_DT_5 | DATE | |||
| NSLDS_LOAN_GA_CODE_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_5 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_5 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_5 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_SEQ_NUM_6 | NUMBER | (6) | ||
| NSLDS_LOAN_TYPE_CODE_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CHNG_F_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_PROG_CODE_6 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_NET_AMNT_6 | NUMBER | (6) | ||
| NSLDS_LOAN_CUR_ST_CODE_6 | VARCHAR2 | (2) | ||
| NSLDS_LOAN_CUR_ST_DATE_6 | DATE | |||
| NSLDS_LOAN_AGG_PR_BAL_6 | NUMBER | (6) | ||
| NSLDS_LOAN_OUT_PR_BAL_DT_6 | DATE | |||
| NSLDS_LOAN_BEGIN_DT_6 | DATE | |||
| NSLDS_LOAN_END_DT_6 | DATE | |||
| NSLDS_LOAN_GA_CODE_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_CONT_TYPE_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_SCHOL_CODE_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_CONT_CODE_6 | VARCHAR2 | (8) | ||
| NSLDS_LOAN_GRADE_LVL_6 | VARCHAR2 | (3) | ||
| NSLDS_LOAN_XTR_UNSBZ_LN_F_6 | VARCHAR2 | (1) | ||
| NSLDS_LOAN_CAPITAL_INT_F_6 | VARCHAR2 | (1) | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | (15) | ||
| ORG_ID | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_AMT_1 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_1 | DATE | |||
| NSLDS_LOAN_LAST_D_AMT_2 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_2 | DATE | |||
| NSLDS_LOAN_LAST_D_AMT_3 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_3 | DATE | |||
| NSLDS_LOAN_LAST_D_AMT_4 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_4 | DATE | |||
| NSLDS_LOAN_LAST_D_AMT_5 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_5 | DATE | |||
| NSLDS_LOAN_LAST_D_AMT_6 | NUMBER | (15) | ||
| NSLDS_LOAN_LAST_D_DATE_6 | DATE | |||
| DLP_MASTER_PROM_NOTE_FLAG | VARCHAR2 | (30) | Indicates the Direct Loan Plus Master Promissory Note Status | |
| SUBSIDIZED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Subsidized Loan Limit Flag | |
| COMBINED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Combined Loan Limit Flag |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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_DISCHARGED_LOAN_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_DISCHGED_LOAN_CHNG_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
, 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 APPS.IGF_AP_NSLDS_DATA;
APPS
IGF_AP_NSLDS_DATA_ALL
APPS
IGF_AP_LI_ISIR_IMP_PROC
- show dependent code
IGF_AP_MATCHING_PROCESS_PKG
- show dependent code
IGF_AP_NSLDS_DATA_V
IGF_AW_GEN_003
- show dependent code
IGF_AW_PACKAGING
- show dependent code
IGF_AW_PACKNG_SUBFNS
- show dependent code
|
|
|
|