[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_NSLDS_DATA_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_NSLDS_DATA_ALL |
Subobject Name: | |
Status: | VALID |
IGF_AP_NSLDS_DATA_ALL describes the NSLDS data of a financial aid student.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_NSLDS_DATA_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | NSLDS_ID |
IGF_AP_NSLDS_DATA_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ISIR_ID |
IGF_AP_NSLDS_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BASE_ID
TRANSACTION_NUM_TXT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NSLDS_ID | NUMBER | (15) | Yes | Identifier for NSLDS data |
ISIR_ID | NUMBER | (15) | Yes | Identifier for ISIR student record |
BASE_ID | NUMBER | (15) | Unique identifier for student financial aid record | |
NSLDS_TRANSACTION_NUM | NUMBER | (2) | Holds latest transaction number for which NSLDS data was updated | |
NSLDS_DATABASE_RESULTS_F | VARCHAR2 | (1) | Indicates matching record was found in NSLDS database | |
NSLDS_F | VARCHAR2 | (1) | Flag set by NSLDS | |
NSLDS_PELL_OVERPAY_F | VARCHAR2 | (1) | NSLDS Pell overpayment flag. Indicates if there was overpayment of Pell grant. | |
NSLDS_PELL_OVERPAY_CONTACT | VARCHAR2 | (8) | Indicates contact school code for Pell overpayment | |
NSLDS_SEOG_OVERPAY_F | VARCHAR2 | (1) | NSLDS SEOG overpayment flag. Indicates if overpayment was made for Education Opportunity Grant. | |
NSLDS_SEOG_OVERPAY_CONTACT | VARCHAR2 | (8) | Indicates contact school for SEOG overpayment | |
NSLDS_PERKINS_OVERPAY_F | VARCHAR2 | (1) | Indicates if overpayment was made for Perkins grant | |
NSLDS_PERKINS_OVERPAY_CNTCT | VARCHAR2 | (8) | Contact school for Perkins overpayment | |
NSLDS_DEFAULTED_LOAN_F | VARCHAR2 | (1) | Indicates if student has defaulted NSLDS loans | |
NSLDS_DISCHARGED_LOAN_F | VARCHAR2 | (1) | NSLDS discharged loan flag | |
NSLDS_SATIS_REPAY_F | VARCHAR2 | (1) | Indicates loan repaid satisfactorily | |
NSLDS_ACT_BANKRUPTCY_F | VARCHAR2 | (1) | Indicates whether student is bankrupt | |
NSLDS_AGG_SUBSZ_OUT_PRIN_BAL | NUMBER | (6) | NSLDS aggregate subsidized outstanding principal balance amount | |
NSLDS_AGG_UNSBZ_OUT_PRIN_BAL | NUMBER | (6) | NSLDS aggregate unsubsidized outstanding principal balance amount | |
NSLDS_AGG_COMB_OUT_PRIN_BAL | NUMBER | (6) | NSLDS aggregate combined outstanding principal balance amount | |
NSLDS_AGG_CONS_OUT_PRIN_BAL | NUMBER | (6) | NSLDS aggregate consolidated outstanding principal balance amount | |
NSLDS_AGG_SUBSZ_PEND_DISMT | NUMBER | (6) | NSLDS aggregate subsidized pending disbursement amount | |
NSLDS_AGG_UNSBZ_PEND_DISMT | NUMBER | (6) | NSLDS aggregate unsubsidized pending disbursement amount | |
NSLDS_AGG_COMB_PEND_DISMT | NUMBER | (6) | NSLDS aggregate combined pending disbursement amount | |
NSLDS_AGG_SUBSZ_TOTAL | NUMBER | (6) | NSLDS aggregate subsidized total amount | |
NSLDS_AGG_UNSBZ_TOTAL | NUMBER | (6) | NSLDS aggregate unsubsidized total amount | |
NSLDS_AGG_COMB_TOTAL | NUMBER | (6) | NSLDS aggregate combined total amount | |
NSLDS_AGG_CONSD_TOTAL | NUMBER | (6) | NSLDS aggregate consolidated total amount | |
NSLDS_PERKINS_OUT_BAL | NUMBER | (6) | NSLDS Perkins outstanding balance amount | |
NSLDS_PERKINS_CUR_YR_DISMNT | NUMBER | (6) | NSLDS Perkins current year disbursement amount | |
NSLDS_DEFAULT_LOAN_CHNG_F | VARCHAR2 | (1) | NSLDS defaulted loan change flag | |
NSLDS_DISCHGED_LOAN_CHNG_F | VARCHAR2 | (1) | NSLDS discharged loan change flag | |
NSLDS_SATIS_REPAY_CHNG_F | VARCHAR2 | (1) | NSLDS satisfactory repayment change flag | |
NSLDS_ACT_BNKRUPT_CHNG_F | VARCHAR2 | (1) | NSLDS active bankruptcy flag | |
NSLDS_OVERPAY_CHNG_F | VARCHAR2 | (1) | NSLDS overpayments change flag | |
NSLDS_AGG_LOAN_CHNG_F | VARCHAR2 | (1) | NSLDS aggregate loan change flag | |
NSLDS_PERKINS_LOAN_CHNG_F | VARCHAR2 | (1) | NSLDS Perkins loan change flag | |
NSLDS_PELL_PAYMNT_CHNG_F | VARCHAR2 | (1) | NSLDS Pell loan change flag | |
NSLDS_ADDTNL_PELL_F | VARCHAR2 | (1) | NSLDS additional Pell flag | |
NSLDS_ADDTNL_LOAN_F | VARCHAR2 | (1) | NSLDS additional loan flag | |
DIRECT_LOAN_MAS_PROM_NT_F | VARCHAR2 | (1) | Direct loan master promissory flag | |
NSLDS_PELL_SEQ_NUM_1 | NUMBER | (2) | NSLDS Pell sequence number (1) | |
NSLDS_PELL_VERIFY_F_1 | VARCHAR2 | (3) | NSLDS Pell verification flag (1) | |
NSLDS_PELL_EFC_1 | NUMBER | (6) | NSLDS Pell EFC (1) | |
NSLDS_PELL_SCHOOL_CODE_1 | NUMBER | (8) | NSLDS Pell school code (1) | |
NSLDS_PELL_TRANSCN_NUM_1 | NUMBER | (2) | NSLDS Pell transaction number (1) | |
NSLDS_PELL_LAST_UPDT_DT_1 | DATE | Last update date of NSLDS Pell value (1) | ||
NSLDS_PELL_SCHEDULED_AMT_1 | NUMBER | (6) | NSLDS Pell scheduled amount (1) | |
NSLDS_PELL_AMT_PAID_TODT_1 | NUMBER | (6) | NSLDS Pell amount paid to date (1) | |
NSLDS_PELL_REMNG_AMT_1 | NUMBER | (6) | NSLDS Pell remaining amount (1) | |
NSLDS_PELL_PC_SCHD_AWD_US_1 | NUMBER | (5) | NSLDS Pell percent scheduled award used (1) | |
NSLDS_PELL_AWARD_AMT_1 | NUMBER | (6) | NSLDS Pell award amount (1) | |
NSLDS_PELL_SEQ_NUM_2 | NUMBER | (2) | NSLDS Pell sequence number (2) | |
NSLDS_PELL_VERIFY_F_2 | VARCHAR2 | (3) | NSLDS Pell verification flag (2) | |
NSLDS_PELL_EFC_2 | NUMBER | (6) | NSLDS Pell EFC (2) | |
NSLDS_PELL_SCHOOL_CODE_2 | NUMBER | (8) | NSLDS Pell School code (2) | |
NSLDS_PELL_TRANSCN_NUM_2 | NUMBER | (2) | NSLDS Pell transaction number (2) | |
NSLDS_PELL_LAST_UPDT_DT_2 | DATE | Last update date of NSLDS Pell value (2) | ||
NSLDS_PELL_SCHEDULED_AMT_2 | NUMBER | (6) | NSLDS Pell scheduled amount (2) | |
NSLDS_PELL_AMT_PAID_TODT_2 | NUMBER | (6) | NSLDS Pell amount paid to date (2) | |
NSLDS_PELL_REMNG_AMT_2 | NUMBER | (6) | NSLDS Pell remaining amount (2) | |
NSLDS_PELL_PC_SCHD_AWD_US_2 | NUMBER | (5) | NSLDS Pell percent scheduled award used (2) | |
NSLDS_PELL_AWARD_AMT_2 | NUMBER | (6) | NSLDS Pell award amount (2) | |
NSLDS_PELL_SEQ_NUM_3 | NUMBER | (2) | NSDLS Pell sequence number(3) | |
NSLDS_PELL_VERIFY_F_3 | VARCHAR2 | (3) | NSLDS Pell verification flag (3) | |
NSLDS_PELL_EFC_3 | NUMBER | (6) | NSLDS Pell EFC (3) | |
NSLDS_PELL_SCHOOL_CODE_3 | NUMBER | (8) | NSDLS Pell school code (3) | |
NSLDS_PELL_TRANSCN_NUM_3 | NUMBER | (2) | NSDLS Pell transaction number (3) | |
NSLDS_PELL_LAST_UPDT_DT_3 | DATE | Last update date of NSLDS Pell value (3) | ||
NSLDS_PELL_SCHEDULED_AMT_3 | NUMBER | (6) | NSDLS Pell scheduled amount (3) | |
NSLDS_PELL_AMT_PAID_TODT_3 | NUMBER | (6) | NSDLS Pell amount paid to date (3) | |
NSLDS_PELL_REMNG_AMT_3 | NUMBER | (6) | NSDLS Pell remaining amount (3) | |
NSLDS_PELL_PC_SCHD_AWD_US_3 | NUMBER | (5) | NSLDS Pell percent scheduled award used (3) | |
NSLDS_PELL_AWARD_AMT_3 | NUMBER | (6) | NSDLS Pell award amount (3) | |
NSLDS_LOAN_SEQ_NUM_1 | NUMBER | (6) | NSLDS loan (1) sequence number | |
NSLDS_LOAN_TYPE_CODE_1 | VARCHAR2 | (1) | NSLDS loan (1) type code | |
NSLDS_LOAN_CHNG_F_1 | VARCHAR2 | (1) | NSLDS loan (1) change flag | |
NSLDS_LOAN_PROG_CODE_1 | VARCHAR2 | (2) | NSLDS loan (1) program code | |
NSLDS_LOAN_NET_AMNT_1 | NUMBER | (6) | NSLDS loan (1) net amount | |
NSLDS_LOAN_CUR_ST_CODE_1 | VARCHAR2 | (2) | NSLDS loan (1) current status code | |
NSLDS_LOAN_CUR_ST_DATE_1 | DATE | NSLDS loan (1) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_1 | NUMBER | (6) | NSLDS loan (1) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_1 | DATE | NSLDS loan (1) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_1 | DATE | NSLDS loan (1) begin date | ||
NSLDS_LOAN_END_DT_1 | DATE | NSLDS loan (1) end date | ||
NSLDS_LOAN_GA_CODE_1 | VARCHAR2 | (3) | NSLDS loan (1) GA code | |
NSLDS_LOAN_CONT_TYPE_1 | VARCHAR2 | (3) | NSLDS loan (1) contact type | |
NSLDS_LOAN_SCHOL_CODE_1 | VARCHAR2 | (8) | NSLDS loan (1) school code | |
NSLDS_LOAN_CONT_CODE_1 | VARCHAR2 | (8) | NSLDS loan (1) contact code | |
NSLDS_LOAN_GRADE_LVL_1 | VARCHAR2 | (3) | NSLDS loan (1) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_1 | VARCHAR2 | (1) | NSLDS loan (1) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_1 | VARCHAR2 | (1) | NSLDS loan (1) capitalized interest flag | |
NSLDS_LOAN_SEQ_NUM_2 | NUMBER | (6) | NSLDS loan (2) sequence number | |
NSLDS_LOAN_TYPE_CODE_2 | VARCHAR2 | (1) | NSLDS loan(2) type code | |
NSLDS_LOAN_CHNG_F_2 | VARCHAR2 | (1) | NSLDS loan (2) change flag | |
NSLDS_LOAN_PROG_CODE_2 | VARCHAR2 | (2) | NSLDS loan (2) program code | |
NSLDS_LOAN_NET_AMNT_2 | NUMBER | (6) | NSLDS loan (2) net amount | |
NSLDS_LOAN_CUR_ST_CODE_2 | VARCHAR2 | (2) | NSLDS loan (2) current status code | |
NSLDS_LOAN_CUR_ST_DATE_2 | DATE | NSLDS loan (2) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_2 | NUMBER | (6) | NSLDS loan (2) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_2 | DATE | NSLDS loan (2) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_2 | DATE | NSLDS loan (2) begin date | ||
NSLDS_LOAN_END_DT_2 | DATE | NSLDS loan (2) end date | ||
NSLDS_LOAN_GA_CODE_2 | VARCHAR2 | (3) | NSLDS loan (2) GA code | |
NSLDS_LOAN_CONT_TYPE_2 | VARCHAR2 | (3) | NSLDS loan (2) contact type | |
NSLDS_LOAN_SCHOL_CODE_2 | VARCHAR2 | (8) | NSLDS loan (2) school code | |
NSLDS_LOAN_CONT_CODE_2 | VARCHAR2 | (8) | NSLDS loan (2) contact code | |
NSLDS_LOAN_GRADE_LVL_2 | VARCHAR2 | (3) | NSLDS loan (2) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_2 | VARCHAR2 | (1) | NSLDS loan (2) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_2 | VARCHAR2 | (1) | NSLDS loan (2) capitalized interest flag | |
NSLDS_LOAN_SEQ_NUM_3 | NUMBER | (6) | NSLDS loan (3) sequence number | |
NSLDS_LOAN_TYPE_CODE_3 | VARCHAR2 | (1) | NSLDS loan (3) type code | |
NSLDS_LOAN_CHNG_F_3 | VARCHAR2 | (1) | NSLDS loan (3) change flag | |
NSLDS_LOAN_PROG_CODE_3 | VARCHAR2 | (2) | NSLDS loan (3) program code | |
NSLDS_LOAN_NET_AMNT_3 | NUMBER | (6) | NSLDS loan (3) net amount | |
NSLDS_LOAN_CUR_ST_CODE_3 | VARCHAR2 | (2) | NSLDS loan (3) current status code | |
NSLDS_LOAN_CUR_ST_DATE_3 | DATE | NSLDS loan (3) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_3 | NUMBER | (6) | NSLDS loan (3) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_3 | DATE | NSLDS loan (3) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_3 | DATE | NSLDS loan (3) begin date | ||
NSLDS_LOAN_END_DT_3 | DATE | NSLDS loan (3) end date | ||
NSLDS_LOAN_GA_CODE_3 | VARCHAR2 | (3) | NSLDS loan (3) GA code | |
NSLDS_LOAN_CONT_TYPE_3 | VARCHAR2 | (3) | NSLDS loan (3) contact type | |
NSLDS_LOAN_SCHOL_CODE_3 | VARCHAR2 | (8) | NSLDS loan (3) school code | |
NSLDS_LOAN_CONT_CODE_3 | VARCHAR2 | (8) | NSLDS loan (3) contact code | |
NSLDS_LOAN_GRADE_LVL_3 | VARCHAR2 | (3) | NSLDS loan (3) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_3 | VARCHAR2 | (1) | NSLDS loan (3) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_3 | VARCHAR2 | (1) | NSLDS loan (3) capitalized interest flag | |
NSLDS_LOAN_SEQ_NUM_4 | NUMBER | (6) | NSLDS loan (4) sequence number | |
NSLDS_LOAN_TYPE_CODE_4 | VARCHAR2 | (1) | NSLDS loan (4) type code | |
NSLDS_LOAN_CHNG_F_4 | VARCHAR2 | (1) | NSLDS loan (4) change flag | |
NSLDS_LOAN_PROG_CODE_4 | VARCHAR2 | (2) | NSLDS loan (4) program code | |
NSLDS_LOAN_NET_AMNT_4 | NUMBER | (6) | NSLDS loan (4) net amount | |
NSLDS_LOAN_CUR_ST_CODE_4 | VARCHAR2 | (2) | NSLDS loan (4) current status code | |
NSLDS_LOAN_CUR_ST_DATE_4 | DATE | NSLDS loan (4) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_4 | NUMBER | (6) | NSLDS loan (4) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_4 | DATE | NSLDS loan (4) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_4 | DATE | NSLDS loan (4) begin date | ||
NSLDS_LOAN_END_DT_4 | DATE | NSLDS loan (4) end date | ||
NSLDS_LOAN_GA_CODE_4 | VARCHAR2 | (3) | NSLDS loan (4) GA code | |
NSLDS_LOAN_CONT_TYPE_4 | VARCHAR2 | (3) | NSLDS loan (4) contact type | |
NSLDS_LOAN_SCHOL_CODE_4 | VARCHAR2 | (8) | NSLDS loan (4) school code | |
NSLDS_LOAN_CONT_CODE_4 | VARCHAR2 | (8) | NSLDS loan (4) contact code | |
NSLDS_LOAN_GRADE_LVL_4 | VARCHAR2 | (3) | NSLDS loan (4) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_4 | VARCHAR2 | (1) | NSLDS loan (4) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_4 | VARCHAR2 | (1) | NSLDS loan (4) capitalized interest flag | |
NSLDS_LOAN_SEQ_NUM_5 | NUMBER | (6) | NSLDS loan (5) sequence number | |
NSLDS_LOAN_TYPE_CODE_5 | VARCHAR2 | (1) | NSLDS loan (5) type code | |
NSLDS_LOAN_CHNG_F_5 | VARCHAR2 | (1) | NSLDS loan (5) change flag | |
NSLDS_LOAN_PROG_CODE_5 | VARCHAR2 | (2) | NSLDS loan (5) program code | |
NSLDS_LOAN_NET_AMNT_5 | NUMBER | (6) | NSLDS loan (5) net amount | |
NSLDS_LOAN_CUR_ST_CODE_5 | VARCHAR2 | (2) | NSLDS loan (5) current status code | |
NSLDS_LOAN_CUR_ST_DATE_5 | DATE | NSLDS loan (5) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_5 | NUMBER | (6) | NSLDS loan (5) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_5 | DATE | NSLDS loan (5) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_5 | DATE | NSLDS loan (5) begin date | ||
NSLDS_LOAN_END_DT_5 | DATE | NSLDS loan (5) end date | ||
NSLDS_LOAN_GA_CODE_5 | VARCHAR2 | (3) | NSLDS loan (5) GA code | |
NSLDS_LOAN_CONT_TYPE_5 | VARCHAR2 | (3) | NSLDS loan (5) contact type | |
NSLDS_LOAN_SCHOL_CODE_5 | VARCHAR2 | (8) | NSLDS loan (5) school code | |
NSLDS_LOAN_CONT_CODE_5 | VARCHAR2 | (8) | NSLDS loan (5) contact code | |
NSLDS_LOAN_GRADE_LVL_5 | VARCHAR2 | (3) | NSLDS loan (5) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_5 | VARCHAR2 | (1) | NSLDS loan (5) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_5 | VARCHAR2 | (1) | NSLDS loan (5) capitalized interest flag | |
NSLDS_LOAN_SEQ_NUM_6 | NUMBER | (6) | NSLDS loan (6) sequence number | |
NSLDS_LOAN_TYPE_CODE_6 | VARCHAR2 | (1) | NSLDS loan (6) type code | |
NSLDS_LOAN_CHNG_F_6 | VARCHAR2 | (1) | NSLDS loan (6) change flag | |
NSLDS_LOAN_PROG_CODE_6 | VARCHAR2 | (2) | NSLDS loan (6) program code | |
NSLDS_LOAN_NET_AMNT_6 | NUMBER | (6) | NSLDS loan (6) net amount | |
NSLDS_LOAN_CUR_ST_CODE_6 | VARCHAR2 | (2) | NSLDS loan (6) current status code | |
NSLDS_LOAN_CUR_ST_DATE_6 | DATE | NSLDS loan (6) current status date | ||
NSLDS_LOAN_AGG_PR_BAL_6 | NUMBER | (6) | NSLDS loan (6) aggregate principal balance amount | |
NSLDS_LOAN_OUT_PR_BAL_DT_6 | DATE | NSLDS loan (6) outstanding principal balance date | ||
NSLDS_LOAN_BEGIN_DT_6 | DATE | NSLDS loan (6) begin date | ||
NSLDS_LOAN_END_DT_6 | DATE | NSLDS loan (6) end date | ||
NSLDS_LOAN_GA_CODE_6 | VARCHAR2 | (3) | NSLDS loan (6) GA code | |
NSLDS_LOAN_CONT_TYPE_6 | VARCHAR2 | (3) | NSLDS loan (6) contact type | |
NSLDS_LOAN_SCHOL_CODE_6 | VARCHAR2 | (8) | NSLDS loan (6) school code | |
NSLDS_LOAN_CONT_CODE_6 | VARCHAR2 | (8) | NSLDS loan (6) contact code | |
NSLDS_LOAN_GRADE_LVL_6 | VARCHAR2 | (3) | NSLDS loan (6) grade level | |
NSLDS_LOAN_XTR_UNSBZ_LN_F_6 | VARCHAR2 | (1) | NSLDS loan (6) extra unsubsidized loan flag | |
NSLDS_LOAN_CAPITAL_INT_F_6 | VARCHAR2 | (1) | NSLDS loan (6) capitalized interest flag | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
NSLDS_LOAN_LAST_D_AMT_1 | NUMBER | (15) | NSLDS Loan (1) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_1 | DATE | NSLDS Loan (1) Last Disbursement Date | ||
NSLDS_LOAN_LAST_D_AMT_2 | NUMBER | (15) | NSLDS Loan (2) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_2 | DATE | NSLDS Loan (2) Last Disbursement Date | ||
NSLDS_LOAN_LAST_D_AMT_3 | NUMBER | (15) | NSLDS Loan (3) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_3 | DATE | NSLDS Loan (3) Last Disbursement Date | ||
NSLDS_LOAN_LAST_D_AMT_4 | NUMBER | (15) | NSLDS Loan (4) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_4 | DATE | NSLDS Loan (4) Last Disbursement Date | ||
NSLDS_LOAN_LAST_D_AMT_5 | NUMBER | (15) | NSLDS Loan (5) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_5 | DATE | NSLDS Loan (5) Last Disbursement Date | ||
NSLDS_LOAN_LAST_D_AMT_6 | NUMBER | (15) | NSLDS Loan (6) Last Disbursement Amount | |
NSLDS_LOAN_LAST_D_DATE_6 | DATE | NSLDS Loan (6) Last Disbursement Date | ||
DLP_MASTER_PROM_NOTE_FLAG | VARCHAR2 | (30) | Indicates the Direct Loan Plus Master Promissory Note Flag | |
SUBSIDIZED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Subsidized Loan Limit Flag | |
COMBINED_LOAN_LIMIT_TYPE | VARCHAR2 | (1) | Combined Loan Limit Flag | |
TRANSACTION_NUM_TXT | VARCHAR2 | (2) | For storing the ISIR transaction Number |
Cut, paste (and edit) the following text to query this object:
SELECT NSLDS_ID
, ISIR_ID
, BASE_ID
, 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
, TRANSACTION_NUM_TXT
FROM IGF.IGF_AP_NSLDS_DATA_ALL;
IGF.IGF_AP_NSLDS_DATA_ALL does not reference any database object
IGF.IGF_AP_NSLDS_DATA_ALL is referenced by following:
|
|
|