[Home] [Help] [Dependency Information]
Object Name: | IGFFV_NSLDS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_NSLDS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the NSLDS data of a financial aid student
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NSLDS_TRANSACTION_NUMBER | NUMBER | (2) | Holds latest transaction number for which NSLDS data was updated | |
NSLDS_DATABASE_RESULTS_FLAG | VARCHAR2 | (1) | NSLDS Database results flag | |
_LA:NSLDS_FLAG | CHAR | (56) | NSLDS flag for NSLDS use only | |
NSLDS_PELL_OVERPAYMENT_FLAG | VARCHAR2 | (1) | NSLDS Pell overpayment flag | |
NSLDS_PELL_OVERPAY_CONTACT | VARCHAR2 | (8) | NSLDS Pell overpayment contact | |
NSLDS_SEOG_OVERPAYMENT_FLAG | VARCHAR2 | (1) | NSLDS SEOG overpayment type | |
NSLDS_SEOG_OVERPAY_CONTACT | VARCHAR2 | (8) | NSLDS SEOG overpayment contact | |
NSLDS_PERKINS_OVERPAY_FLAG | VARCHAR2 | (1) | NSLDS Perkins overpayment type | |
NSLDS_PERKINS_OVERPAY_CNTCT | VARCHAR2 | (8) | NSLDS Perkins overpayment contact | |
_LA:NSLDS_DEFAULTE_LOAN_FLAG | CHAR | (71) | NSLDS Defaulted loan flag | |
NSLDS_DISCHARGED_LOAN_FLAG | VARCHAR2 | (1) | NSLDS Discharged loan type | |
_LA:NSLDS_SATISFACT_REP_FLAG | CHAR | (68) | NSLDS loan satisfactory repayment flag | |
_LA:NSLDS_ACT_BANKRUPT_FLAG | CHAR | (71) | Active bankruptcy flag | |
NSLDS_AGG_SUBSZ_OUT_PRIN_BAL | NUMBER | (6) | NSLDS Aggregate subsidized outstanding principle balance | |
NSLDS_AGG_UNSBZ_OUT_PRIN_BAL | NUMBER | (6) | NSLDS Aggregate unsubsidized outstanding principle balance | |
NSLDS_AGG_COMB_OUT_PRIN_BAL | NUMBER | (6) | NSLDS Aggregate combined outstanding principle balance | |
NSLDS_AGG_CONS_OUT_PRIN_BAL | NUMBER | (6) | NSLDS Aggregate consolidated outstanding principle balance | |
NSLDS_AGG_SUBSZ_PEND_DISMT | NUMBER | (6) | NSLDS Aggregate subsidized pending disbursement | |
NSLDS_AGG_UNSBZ_PEND_DISMT | NUMBER | (6) | NSLDS Aggregate unsubsidized pending disbursement | |
NSLDS_AGG_COMB_PEND_DISMT | NUMBER | (6) | NSLDS Aggregate combined pending disbursement | |
NSLDS_AGG_SUBSIDIZED_TOTAL | NUMBER | (6) | NSLDS Aggregate subsidized total | |
NSLDS_AGG_UNSUBSIDIZED_TOTAL | NUMBER | (6) | NSLDS Aggregate unsubsidized total | |
NSLDS_AGG_COMBINED_TOTAL | NUMBER | (6) | NSLDS Aggregate combined total | |
NSLDS_AGG_CONSOLIDATED_TOTAL | NUMBER | (6) | NSLDS Aggregate consolidated total | |
NSLDS_PERKINS_PRINICIPAL_BAL | NUMBER | (6) | NSLDS Perkins outstanding balance amount | |
NSLDS_PERKINS_CUR_YR_AMOUNT | NUMBER | (6) | NSLDS Perkins current year disbursement amount | |
NSLDS_DEFAULT_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS Defaulted loan change flag | |
NSLDS_DISCHGED_LOAN_CHNG_FLAG | VARCHAR2 | (1) | NSLDS Discharged loan change flag | |
NSLDS_SATIS_REPAY_CHNG_FLAG | VARCHAR2 | (1) | NSLDS satisfactory repayment change flag | |
NSLDS_ACT_BNKRUPT_CHNG_FLAG | VARCHAR2 | (1) | NSLDS active bankruptcy flag | |
NSLDS_OVERPAYMENTS_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS overpayments change flag | |
NSLDS_AGG_LOAN_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS aggregate loan change flag | |
NSLDS_PERKINS_LOAN_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Perkins loan change flag | |
NSLDS_PELL_PAYMNT_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Pell payment loan change flag | |
_LA:NSLDS_ADTIONAL_PELL_FLAG | CHAR | (68) | NSLDS Additional Pell flag | |
_LA:NSLDS_ADTIONAL_LOAN_FLAG | CHAR | (68) | NSLDS Additional Loans flag | |
DIRECT_LOAN_MAS_PROM_NOTE_FLAG | VARCHAR2 | (1) | Direct loan master-Prom flag | |
NSLDS_PELL_1_SEQUENCE_NUMBER | NUMBER | (2) | NSLDS Pell Sequence Number (1) | |
NSLDS_PELL_1_VERIFICATION | VARCHAR2 | (3) | NSLDS Pell Verification code number (1) | |
NSLDS_PELL_1_EFC | NUMBER | (6) | NSLDS Pell EFC(1) | |
NSLDS_PELL_1_SCHOOL_CODE | NUMBER | (8) | NSLDS Pell School Code (1) | |
NSLDS_PELL_1_TRANSACTON_NUMBER | NUMBER | (2) | NSLDS Pell Transaction number(1) | |
NSLDS_PELL_1_LAST_UPDATE_DATE | DATE | NSLDS Pell Last Update date(1) | ||
NSLDS_PELL_1_SCHEDULED_AMOUNT | NUMBER | (6) | NSLDS Pell Scheduled amount(1) | |
NSLDS_PELL_1_AMT_PAID_TO_DATE | NUMBER | (6) | NSLDS Pell amount paid to date(1) | |
NSLDS_PELL_1_REMAING_AMOUNT | NUMBER | (6) | NSLDS Pell remaining amount (1) | |
NSLDS_PELL_1_PC_SCHD_AWARD_US | NUMBER | (5) | NSLDS Pell Percent Scheduled Award used (1) | |
NSLDS_PELL_1_AWARD_AMOUNT | NUMBER | (6) | NSLDS Pell Award amount (1) | |
NSLDS_PELL_2_SEQUENCE_NUMBER | NUMBER | (2) | NSLDS Pell Sequence Number (2) | |
NSLDS_PELL_2_VERIFICATION | VARCHAR2 | (3) | NSLDS Pell Verification flag (2) | |
NSLDS_PELL_2_EFC | NUMBER | (6) | NSLDS Pell EFC(2) | |
NSLDS_PELL_2_SCHOOL_CODE | NUMBER | (8) | NSLDS Pell School code(2) | |
NSLDS_PELL_2_TRANSACTON_NUMBER | NUMBER | (2) | NSLDS Pell Transaction NUMBER | |
NSLDS_PELL_2_LAST_UPDATE_DATE | DATE | NSLDS Pell Last Update date(2) | ||
NSLDS_PELL_2_SCHEDULED_AMOUNT | NUMBER | (6) | NSLDS Pell Scheduled amount(2) | |
NSLDS_PELL_2_AMT_PAID_TO_DATE | NUMBER | (6) | NSLDS Pell amount paid to date(2) | |
NSLDS_PELL_2_REMAING_AMOUNT | NUMBER | (6) | NSLDS Pell remaining amount (2) | |
NSLDS_PELL_2_PC_SCHD_AWARD_US | NUMBER | (5) | NSLDS Pell Percent Scheduled Award used (2) | |
NSLDS_PELL_2_AWARD_AMOUNT | NUMBER | (6) | NSLDS Pell Award amount (2) | |
NSLDS_PELL_3_SEQUENCE_NUMBER | NUMBER | (2) | NSLDS Pell Sequence Number (3) | |
NSLDS_PELL_3_VERIFICATION | VARCHAR2 | (3) | NSLDS Pell Verification flag (3) | |
NSLDS_PELL_3_EFC | NUMBER | (6) | NSLDS Pell EFC(3) | |
NSLDS_PELL_3_SCHOOL_CODE | NUMBER | (8) | NSLDS Pell School code(3) | |
NSLDS_PELL_3_TRANSACTON_NUMBER | NUMBER | (2) | NSLDS Pell Transaction number(3) | |
NSLDS_PELL_3_LAST_UPDATE_DATE | DATE | NSLDS Pell Last Update date(3) | ||
NSLDS_PELL_3_SCHEDULED_AMOUNT | NUMBER | (6) | NSLDS Pell Scheduled amount(3) | |
NSLDS_PELL_3_AMT_PAID_TO_DATE | NUMBER | (6) | NSLDS Pell amount paid to date(3) | |
NSLDS_PELL_3_REMAING_AMOUNT | NUMBER | (6) | NSLDS Pell remaining amount (3) | |
NSLDS_PELL_3_PC_SCHD_AWARD_US | NUMBER | (5) | NSLDS Pell Percent Scheduled Award used (3) | |
NSLDS_PELL_3_AWARD_AMOUNT | NUMBER | (6) | NSLDS Pell Award amount (3) | |
NSLDS_LOAN_1_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (1)sequence number | |
NSLDS_LOAN_1_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (1) type code | |
NSLDS_LOAN_1_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (1) change flag | |
NSLDS_LOAN_1_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (1)Program code | |
NSLDS_LOAN_1_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (1) Net Amount | |
NSLDS_LOAN_1_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (1) current status code | |
NSLDS_LOAN_1_CUR_STATUS_DATE | DATE | NSLDS Loan (1) current status date | ||
NSLDS_LOAN_1_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (1) Aggregate Principle balance | |
NSLDS_LOAN_1_OUT_PR_BAL_DT | DATE | NSLDS Loan (1) Outstanding Principle balance date | ||
NSLDS_LOAN_1_BEGIN_DATE | DATE | NSLDS Loan (1) Begin date | ||
NSLDS_LOAN_1_END_DATE | DATE | NSLDS Loan (1) End date | ||
NSLDS_LOAN_1_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (1) GA code | |
NSLDS_LOAN_1_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (1) Contact Type Code | |
NSLDS_LOAN_1_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (1) School Code | |
NSLDS_LOAN_1_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (1) Contact Code | |
NSLDS_LOAN_1_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (1) grade level | |
NSLDS_LOAN_1_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (1) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_1_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (1) Capitalized Interest Flag | |
NSLDS_LOAN_2_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (2) Sequence Number | |
NSLDS_LOAN_2_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (2) Type Code | |
NSLDS_LOAN_2_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (2) Change Flag NSLDS Loan (2) Change Flag | |
NSLDS_LOAN_2_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (2)Program Code | |
NSLDS_LOAN_2_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (2)Net Amount | |
NSLDS_LOAN_2_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (2) Current Status Code | |
NSLDS_LOAN_2_CUR_STATUS_DATE | DATE | NSLDS Loan (2) Current Status Date | ||
NSLDS_LOAN_2_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (2) Aggregate Principle balance | |
NSLDS_LOAN_2_OUT_PR_BAL_DT | DATE | NSLDS Loan (2) Outstanding Principle balance date | ||
NSLDS_LOAN_2_BEGIN_DATE | DATE | NSLDS Loan (2) Begin date | ||
NSLDS_LOAN_2_END_DATE | DATE | NSLDS Loan (2) End date | ||
NSLDS_LOAN_2_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (2) GA code | |
NSLDS_LOAN_2_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (2) Contact Type | |
NSLDS_LOAN_2_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (2) School Code | |
NSLDS_LOAN_2_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (2) Contact Code | |
NSLDS_LOAN_2_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (2) Grade Level | |
NSLDS_LOAN_2_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (2) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_2_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (2) Capitalized Interest Flag | |
NSLDS_LOAN_3_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (3) Sequence Number | |
NSLDS_LOAN_3_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (3) Type Code | |
NSLDS_LOAN_3_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (3)Change Flag | |
NSLDS_LOAN_3_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (3)Program Code | |
NSLDS_LOAN_3_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (3) Net Amount | |
NSLDS_LOAN_3_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (3) Current Status Code | |
NSLDS_LOAN_3_CUR_STATUS_DATE | DATE | NSLDS Loan (3) Current Status Date | ||
NSLDS_LOAN_3_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (3) Aggregate Principle balance | |
NSLDS_LOAN_3_OUT_PR_BAL_DT | DATE | NSLDS Loan (3) Outstanding Principle balance date | ||
NSLDS_LOAN_3_BEGIN_DATE | DATE | NSLDS Loan (3) Begin date | ||
NSLDS_LOAN_3_END_DATE | DATE | NSLDS Loan (3) End date | ||
NSLDS_LOAN_3_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (3) GA code | |
NSLDS_LOAN_3_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (3) Contact Type | |
NSLDS_LOAN_3_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (3) School Code | |
NSLDS_LOAN_3_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (3) Contact Code | |
NSLDS_LOAN_3_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (3) Grade Level | |
NSLDS_LOAN_3_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (3) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_3_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (3) Capitalized Interest Flag | |
NSLDS_LOAN_4_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (4) Sequence Number | |
NSLDS_LOAN_4_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (4) Type Code | |
NSLDS_LOAN_4_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (4) Change Flag | |
NSLDS_LOAN_4_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (4) Program Code | |
NSLDS_LOAN_4_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (4) Net Amount | |
NSLDS_LOAN_4_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (4) Current Status Code | |
NSLDS_LOAN_4_CUR_STATUS_DATE | DATE | NSLDS Loan (4) Current Status Date | ||
NSLDS_LOAN_4_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (4) Aggregate Principle balance | |
NSLDS_LOAN_4_OUT_PR_BAL_DT | DATE | NSLDS Loan (4) Outstanding Principle balance Date | ||
NSLDS_LOAN_4_BEGIN_DATE | DATE | NSLDS Loan (4) Begin date | ||
NSLDS_LOAN_4_END_DATE | DATE | NSLDS Loan (4) End date | ||
NSLDS_LOAN_4_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (4) GA code | |
NSLDS_LOAN_4_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (4) Contact Type | |
NSLDS_LOAN_4_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (4) School Code | |
NSLDS_LOAN_4_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (4) Contact Code | |
NSLDS_LOAN_4_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (4) Grade Level | |
NSLDS_LOAN_4_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (4) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_4_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (4) Capitalized Interest Flag | |
NSLDS_LOAN_5_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (5) Sequence Number | |
NSLDS_LOAN_5_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (5) Type Code | |
NSLDS_LOAN_5_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (5) Change Flag | |
NSLDS_LOAN_5_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (5) Program Code | |
NSLDS_LOAN_5_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (5) Net Amount | |
NSLDS_LOAN_5_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (5) Current Status Code | |
NSLDS_LOAN_5_CUR_STATUS_DATE | DATE | NSLDS Loan (5) Current Status Date | ||
NSLDS_LOAN_5_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (5) Aggregate Principle balance | |
NSLDS_LOAN_5_OUT_PR_BAL_DT | DATE | NSLDS Loan (5) Outstanding Principle balance date | ||
NSLDS_LOAN_5_BEGIN_DATE | DATE | NSLDS Loan (5) Begin date | ||
NSLDS_LOAN_5_END_DATE | DATE | NSLDS Loan (5) End date | ||
NSLDS_LOAN_5_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (5) GA code | |
NSLDS_LOAN_5_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (5) Contact Type | |
NSLDS_LOAN_5_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (5) School Code | |
NSLDS_LOAN_5_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (5) Contact Code | |
NSLDS_LOAN_5_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (5) Grade Level | |
NSLDS_LOAN_5_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (5) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_5_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (5) Capitalized Interest Flag | |
NSLDS_LOAN_6_SEQUENCE_NUMBER | NUMBER | (6) | NSLDS Loan (6) Sequence Number | |
NSLDS_LOAN_6_TYPE_CODE | VARCHAR2 | (1) | NSLDS Loan (6) Type Code | |
NSLDS_LOAN_6_CHANGE_FLAG | VARCHAR2 | (1) | NSLDS Loan (6) Change Flag | |
NSLDS_LOAN_6_PROGRAM_CODE | VARCHAR2 | (2) | NSLDS Loan (6) Program Code | |
NSLDS_LOAN_6_NET_AMOUNT | NUMBER | (6) | NSLDS Loan (6) Net Amount | |
NSLDS_LOAN_6_CUR_STATUS_CODE | VARCHAR2 | (2) | NSLDS Loan (6) Current Status Code | |
NSLDS_LOAN_6_CUR_STATUS_DATE | DATE | NSLDS Loan (6) Current Status Date | ||
NSLDS_LOAN_6_AGG_PRINCI_BAL | NUMBER | (6) | NSLDS Loan (6) Aggregate Principle balance | |
NSLDS_LOAN_6_OUT_PR_BAL_DT | DATE | NSLDS Loan (6) Outstanding Principle balance date | ||
NSLDS_LOAN_6_BEGIN_DATE | DATE | NSLDS Loan (6) Begin date | ||
NSLDS_LOAN_6_END_DATE | DATE | NSLDS Loan (6) End date | ||
NSLDS_LOAN_6_GRADE_CODE | VARCHAR2 | (3) | NSLDS Loan (6) GA code | |
NSLDS_LOAN_6_CONTACT_TYPE | VARCHAR2 | (3) | NSLDS Loan (6) Contact Type | |
NSLDS_LOAN_6_SCHOOL_CODE | VARCHAR2 | (8) | NSLDS Loan (6) School Code | |
NSLDS_LOAN_6_CONTACT_CODE | VARCHAR2 | (8) | NSLDS Loan (6) Contact Code | |
NSLDS_LOAN_6_GRADE_LEVEL | VARCHAR2 | (3) | NSLDS Loan (6) Grade Level | |
NSLDS_LOAN_6_XTR_UNSBZ_LN_FLAG | VARCHAR2 | (1) | NSLDS Loan (6) Extra Unsubsidized Loan Flag | |
_LA:NSLDS_LOAN_6_CAP_IN_FLAG | CHAR | (75) | NSLDS Loan (6) Capitalized Interest Flag | |
NSLDS_LOAN_1_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (1) Last Disbursement Amount | |
NSLDS_LOAN_1_LAST_D_DATE | DATE | NSLDS Loan (1) Last Disbursement Date | ||
NSLDS_LOAN_2_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (2) Last Disbursement Amount | |
NSLDS_LOAN_2_LAST_D_DATE | DATE | NSLDS Loan (2) Last Disbursement Date | ||
NSLDS_LOAN_3_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (3) Last Disbursement Amount | |
NSLDS_LOAN_3_LAST_D_DATE | DATE | NSLDS Loan (3) Last Disbursement Date | ||
NSLDS_LOAN_4_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (4) Last Disbursement Amount | |
NSLDS_LOAN_4_LAST_D_DATE | DATE | NSLDS Loan (4) Last Disbursement Date | ||
NSLDS_LOAN_5_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (5) Last Disbursement Amount | |
NSLDS_LOAN_5_LAST_D_DATE | DATE | NSLDS Loan (5) Last Disbursement Date | ||
NSLDS_LOAN_6_LAST_D_AMOUNT | NUMBER | (15) | NSLDS Loan (6) Last Disbursement Amount | |
NSLDS_LOAN_6_LAST_D_DATE | DATE | NSLDS Loan (6) Last Disbursement Date | ||
DLP_MASTER_PROM_NOTE_FLAG | VARCHAR2 | (30) | Indicates the Direct Loan Plus Master Promissory Note Flag | |
_LA:COMBINE_LOAN_LIMIT_TYPE | CHAR | (82) | Indicates the Combined Loan Limit | |
_LA:SUBSDIZ_LOAN_LIMIT_TYPE | CHAR | (84) | Indicated the Subsidized Loan Limit | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Unique identification number |
PERSON_NAME | VARCHAR2 | (360) | Yes | Person Name |
AWARD_YEAR | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. | |
AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
APPLICATION_RECEIPT_DATE | DATE | Application Receipt Date | ||
TRANSACTION_NUMBER | VARCHAR2 | (2) | For storing the ISIR transaction Number | |
BASE_ID | NUMBER | (15) | Unique identifier for student financial aid record | |
ISIR_ID | NUMBER | (15) | Yes | Identifier for ISIR student record |
NSLDS_ID | NUMBER | (15) | Yes | Identifier for NSLDS data |
CREATED_BY | NUMBER | (15) | Yes | WHO column |
CREATION_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.IGFFV_NSLDS;
APPS.IGFFV_NSLDS is not referenced by any database object
|
|
|