DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGFBV_NSLDS

Object Details
Object Name: IGFBV_NSLDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGFBV_NSLDS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
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)
Indicates matching record was found in NSLDS database
_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_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) Net Amount
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
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
Query Text

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
,      TRANSACTION_NUMBER
,      BASE_ID
,      ISIR_ID
,      NSLDS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PERSON_ID
FROM APPS.IGFBV_NSLDS;

Dependencies

[top of page]

APPS.IGFBV_NSLDS references the following:

SchemaAPPS
SynonymIGF_AP_FA_BASE_REC_ALL
SynonymIGF_AP_NSLDS_DATA_ALL

APPS.IGFBV_NSLDS is not referenced by any database object