Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: LOAN_AGGREGATES

Description Contains information received from the National Student Loan Data System (NSLDS) such as NSLDS summary and name information, and the Stafford, Direct, and Perkins loan aggregate and history information.
Key & Frequency One row per aid year, per person, per interface data code, per sequence number.
Recommended Search Columns AID_YEAR, PERSON_UID, CURRENT_RECORD_IND
AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, SEQUENCE_NUMBER

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACG_OVERPAYMENT ACG Overpayment Indicates a National Student Loan Data System ACG overpayment. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_ACG_OVER_PAY_FLG

ACG_OVERPAYMENT_CONTACT ACG Overpayment Contact Indicates the school code or region code where the student's ACG overpayment occurred. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_ACG_OVER_PAY_CONTACT

ACG_OVERPAYMENT_CONTACT_DESC ACG Overpayment Contact Description Describes the school where the student's ACG overpayment occurred. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACG_OVERPAYMENT_DESC ACG Overpayment Description Describes the ACG overpayment. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ACG_PAYMENT_CHANGE ACG Payment Change Indicates a change in the National Student Loan Data System ACG payment data since the previous transaction. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_ACG_PMT_CHG_FLG

ACG_PAYMENT_CHANGE_DESC ACG Payment Change Description Describes the change in the National Student Loan Data System ACG payment data since the previous transaction. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ACTIVE_BANKRPT_CHANGE_IND Active Bankrpt Change Indicator Indicates one or more active loans currently in bankruptcy. VARCHAR2(1)

RCRLDS4

RCRLDS4_ACT_BANKRUPT_FLAG

ACTIVE_BANKRUPTCY_CHANGE Active Bankruptcy Change Indicates if there has been a change to the active bankruptcy flag since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_ACT_BANKRUPT_CHG_FLG

ACTIVE_BANKRUPTCY_CHANGE_DESC Active Bankruptcy Change Description Describes the change made to the active bankruptcy flag since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

RCRLDS4

RCRLDS4_ACTIVITY_DATE

ADDL_LOANS_FLAG Additional Loans Flag This field indicates if the student has additional loans beyond what has been included on the ISIR. VARCHAR2(63)

RCRLDS4

RCRLDS4_ADDL_LOANS_FLG

ADDL_PELL_FLAG Additional Pell Flag This field indicates if the student has additional Pell records beyond what has been included on the ISIR. VARCHAR2(63)

RCRLDS4

RCRLDS4_ADDL_PELL_FLG

ADDL_TEACH_FLAG Additional Teach Flag Indicates additional NSLDS TEACH records were received. VARCHAR2(63)

RCRLDS4

RCRLDS4_ADDL_TEACH_FLG

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_YEAR Financial Aid Year Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RCRLDS4

RCRLDS4_AIDY_CODE

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

COMBINED_AGGREGATE_TOTAL Combined Aggregate Total National Student Loan Data System Aggregate Combined Total. NUMBER

RCRLDS4

RCRLDS4_AGT_COMB_TOTAL

COMBINED_LOAN_LIMIT Combined Loan Limit Indicates combined loan limit status. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_COMB

COMBINED_LOAN_LIMIT_DESC Combined Loan Limit Description Describes the combined loan limit status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

COMBINED_OUTSTANDING_BALANCE Combined Outstanding Balance National Student Loan Data System Aggregate Combined Principle Balance. NUMBER

RCRLDS4

RCRLDS4_AGT_COMB_PRIN_BAL

COMBINED_PENDING_PAYMENT Combined Pending Payment National Student Loan Data System Aggregate Combined Pending Disbursement. NUMBER

RCRLDS4

RCRLDS4_AGT_COMB_PEND_DISB

CREATE_DATE Create Date Date that this National Student Loan Data System record was created in the database. DATE

RCRLDS4

RCRLDS4_CREATE_DATE

CREATOR_ID Creator ID ID of the user who created the record in the database. VARCHAR2(63)

RCRLDS4

RCRLDS4_CREATOR_ID

CURRENT_RECORD_IND Current Record Indicator Indicates if this set of the National Student Loan Data System records has been flagged as the current set for processing. VARCHAR2(1)

RCRLDS4

RCRLDS4_CURR_REC_IND

DEFAULTED_LOAN_IND Defaulted Loan Indicator Indicates if the student has any loans in default. VARCHAR2(1)

RCRLDS4

RCRLDS4_DEFAULTED_LOAN_FLG

DEFAULT_LOAN_CHANGE Default Loan Change Indicates if there has been a change to the defaulted loan flag since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_DEF_LOAN_CHG_FLG

DEFAULT_LOAN_CHANGE_DESC Default Loan Change Description Describes the change to the defaulted loan flag since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DIRECT_LOAN_GRAD_PLUS_MPN Direct Loan Graduate PLUS Master Promissory Note Status of the Master Promissory Note for the graduate student who has borrowed a Direct Loan PLUS loan. VARCHAR2(63)

RCRLDS4

RCRLDS4_DL_GR_PLUS_MPN_FLG

DIRECT_LOAN_GRAD_PLUS_MPN_DESC Direct Loan Graduate PLUS Master Promissory Note Description Describes the status of the Direct Loan PLUS loan Master Promissory Note for the graduate student. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DIRECT_LOAN_MPN Direct Loan Master Promissory Note Status of the Direct Loan Master Promissory Note. VARCHAR2(63)

RCRLDS4

RCRLDS4_DL_MPN_FLAG

DIRECT_LOAN_MPN_DESC Direct Loan Master Promissory Note Description Describes the status of the Direct Loan Master Promissory Note. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DIRECT_LOAN_PAR_PLUS_MPN Direct Loan Par PLUS Master Promissory Note Status of the Direct Loan Parent PLUS Master Promissory Note. VARCHAR2(63)

RCRLDS4

RCRLDS4_DL_PLUS_MPN_FLAG

DIRECT_LOAN_PAR_PLUS_MPN_DESC Direct Loan Par PLUS Master Promissory Note Description Describes the status of the Direct Loan Parent PLUS Master Promissory Note. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DISCHARGE_LOAN Discharge Loan Indicates if the student has any loans that have been discharged. VARCHAR2(63)

RCRLDS4

RCRLDS4_DISCHARG_LOAN_FLG

DISCHARGE_LOAN_CHANGE Discharge Loan Change Indicates if there has been a change to the discharged loan flag since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_DISCHARG_LOAN_CHG_FLG

DISCHARGE_LOAN_CHANGE_DESC Discharge Loan Change Description Describes the change to the discharged loans since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

DISCHARGE_LOAN_DESC Discharge Loan Description Describes the reason why the loans have been discharged. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ENROLLMENT_PATTERN Enrollment Pattern Indicates the student's enrollment pattern for Department of Education. VARCHAR2(63)

RCRLDS4

RCRLDS4_ENROLL_PATTERN_FLAG

ENROLLMENT_PATTERN_DESC Enrollment Pattern Description Enrollment pattern description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

EXCEED_COMBINED_LIMIT Exceed Combined Limit Indicates how close a student is to exceeding the combined loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_COMB

EXCEED_COMBINED_LIMIT_DESC Exceed Combined Limit Description Exceed combined limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

EXCEED_GRAD_COMBINED_LIMIT Exceed Graduate Combined Limit Indicates how close a graduate student is to exceeding the combined loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_GR_AGT_OVER_LIMIT_COMB

EXCEED_GRAD_COMB_LIMIT_DESC Exceed Graduate Combined Limit Description Exceed graduate student's combined loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

EXCEED_GRAD_SUBSIDIZED_LIMIT Exceed Graduate Subsidized Limit Indicates how close a graduate student is to exceeding the subsidized loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_GR_AGT_OVER_LIMIT_SUB

EXCEED_GRAD_SUB_LIMIT_DESC Exceed Graduate Sub Limit Description Exceed graduate student's subsized loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

EXCEED_SUBSIDIZED_LIMIT Exceed Subsidized Limit Indicates how close a student is to exceeding the subsidized loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_SUB

EXCEED_SUBSIDIZED_LIMIT_DESC Exceed Subsidized Limit Description Exceed subsidized loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

FRAUD_CHG_FLAG Fraud change Flag Indicates if there has been a change to the fraud flag since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_FRAUD_CHG_FLG

GRAD_PLUS_AGGREGATE_TOTAL Graduate PLUS Aggregate Total Loan total for Graduate/Professional PLUS loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_GR_PLUS_TOTAL

GRAD_PLUS_OUTSTANDING_BALANCE Graduate PLUS Outstanding Balance Aggregate outstanding principal balance for Graduate/Professional PLUS loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_GR_PLUS_PRIN_BAL

IASG_OVERPAYMENT_CONTACT Iasg Overpayment Contact Contact information for Iraq and Afghanistan Service Grant overpayment. VARCHAR2(63)

RCRLDS4

RCRLDS4_IASG_OVER_PAY_CONTACT

IASG_OVERPAYMENT_FLAG Iasg Overpayment Flag Indicates if the student has an overpayment for an Iraq and Afghanistan Service Grant. VARCHAR2(63)

RCRLDS4

RCRLDS4_IASG_OVER_PAY_FLG

IASG_OVERPAYMENT_FLAG_DESC Iasg Overpayment Flag Description Iasg Overpayment Flag description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTERFACE_TAPE_CODE Interface Tape Code Indicates the source of the data contained in this National Student Loan Data System record. VARCHAR2(63)

RCRLDS4

RCRLDS4_INFC_CODE

INTERFACE_TAPE_CODE_DESC Interface Tape Code Description Describes the source of the data contained in the National Student Loan Data System records. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

LOAN_AGGREGATE_CHANGE Loan Aggregate Change Indicates if there has been a change to the aggregate loan amounts since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_CHG_FLG

LOAN_AGGREGATE_CHANGE_DESC Loan Aggregate Change Description Describes the change to the aggregate loan amounts since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

LOAN_CHANGE Loan Change Indicates that information about one or more loans have changed. VARCHAR2(63)

RCRLDS4

RCRLDS4_LOAN_CHG_FLAG

LOAN_CHANGE_DESC Loan Change Description Describes the loan information that has changed. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

LOAN_FRAUD_IND Loan Fraud Indicator Indicates fraud on one or more loans or overpayments. VARCHAR2(1)

RCRLDS4

RCRLDS4_FRAUD_FLG

LOAN_REPAYMENT_CHANGE Loan Repayment Change Indicates if there has been a change to the satisfactory repayment flag since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_LOAN_SAT_REPAY_CHG_FLG

LOAN_REPAYMENT_CHANGE_DESC Loan Repayment Change Description Describes the change to the satisfactory repayment flag since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

LOAN_REPAYMENT_IND Loan Repayment Indicator Indicates if the student has made satisfactory arrangements to repay the loan. VARCHAR2(1)

RCRLDS4

RCRLDS4_LOAN_SAT_REPAY_FLG

MULTI_SOURCE Multi Source The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NSLDS_CURRENT_BIRTH_DATE Nslds Current Birth Date Current date of birth from National Student Loan Data System for the student. DATE

RCRLDS4

RCRLDS4_CURRENT_BIRTH_DATE

NSLDS_CURRENT_FIRST_NAME Nslds Current First Name Current first name from the National Student Loan Data System for the student. VARCHAR2(63)

RCRLDS4

RCRLDS4_CURRENT_FIRST_NAME

NSLDS_CURRENT_LAST_NAME Nslds Current Last Name Current last name from the National Student Loan Data System for the student. VARCHAR2(63)

RCRLDS4

RCRLDS4_CURRENT_LAST_NAME

NSLDS_CURRENT_TAX_ID Nslds Current Tax ID Current Social Security Number from the National Student Loan Data System for the student. VARCHAR2(63)

RCRLDS4

RCRLDS4_CURRENT_SSN

NSLDS_MATCH Nslds Match Indicates that the National Student Loan Data System has a status of default or refund for the applicant. VARCHAR2(63)

RCRLDS4

RCRLDS4_MATCH_IND

NSLDS_MATCH_DESC Nslds Match Description Describes the National Student Loan Data System match status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NSLDS_PROCESS_DATE Nslds Process Date Date on which the National Student Loan Data System processed this student record. DATE

RCRLDS4

RCRLDS4_PROC_DATE

NSLDS_RESULTS Nslds Results Results from the National Student Loan Data System match for applicants meeting matching criteria. VARCHAR2(63)

RCRLDS4

RCRLDS4_NSLDS_DB_RESULT_FLAG

NSLDS_RESULTS_DESC Nslds Results Description Descriptions of the National Student Loan Data System match for applicants meeting matching criteria. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NSLDS_TRANACTION_NUMBER Nslds Tranaction Number NSLDS transaction number. VARCHAR2(63)

RCRLDS4

RCRLDS4_TRAN_NO

OVERPAYMENTS_CHANGE Overpayments Change Indicates if there has been a change to any of the overpayment flags since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_OVER_PAY_CHG_FLG

OVERPAYMENTS_CHANGE_DESC Overpayments Change Description Describes the change to any of the overpayment flags since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PARENTPLUS_OUTSTANDING_BALANCE Parentplus Outstanding Balance Aggregate outstanding principal balance for Parent PLUS loan types, which is populated if the applicant is a Parent PLUS loan borrower. NUMBER

RCRLDS4

RCRLDS4_AGT_PLUS_OUT_PRIN_BAL

PELL_LIFETIME_ELIGIBILITY_USED Pell Lifetime Eligibility Used Lifetime eligibility used for Pell grants. NUMBER

RCRLDS4

RCRLDS4_PELL_LEU

PELL_LIFETIME_LIMIT Pell Lifetime Limit Indicates how close the student is to or has met or exceeded the allowable Pell lifetime limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_PELL_LEU_LIMIT_FLAG

PELL_LIFETIME_LIMIT_DESC Pell Lifetime Limit Description Pell lifetime limit description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PELL_OVERPAYMENT Pell Overpayment Indicates if a student has a Pell overpayment. VARCHAR2(63)

RCRLDS4

RCRLDS4_PELL_OVER_PAY_FLAG

PELL_OVERPAYMENT_CONTACT Pell Overpayment Contact Indicates the school code or region code where the student's Pell overpayment occurred. VARCHAR2(63)

RCRLDS4

RCRLDS4_PELL_OVER_PAY_CONTACT

PELL_OVERPAYMENT_CONTACT_DESC Pell Overpayment Contact Description Describes the school where the student's Pell overpayment occurred. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PELL_OVERPAYMENT_DESC Pell Overpayment Description Describes the Pell overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PELL_PAYMENT_CHANGE Pell Payment Change Indicates if there has been a change to the Pell Payment data since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_PELL_PMT_CHG_FLG

PELL_PAYMENT_CHANGE_DESC Pell Payment Change Description Describes the change to the Pell payment data since the previous transaction. VARCHAR2(255)

FUNCTION

FUNCTION

GOKODSF.F_GET_DESC

ROKODSF.F_GET_RORMVAL_DESC

PERKINS_CUMULATIVE_AMOUNT Perkins Cumulative Amount Total outstanding principal balance of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CUMULATIVE_AMT

PERKINS_CURRENT_YEAR_AMOUNT Perkins Current Year Amount Current award year disbursement amount of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CURRENT_YR_AMT

PERKINS_LOAN_CHANGE Perkins Loan Change Indicates if there has been a change to the Perkins loan data since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_PERK_CHG_FLG

PERKINS_LOAN_CHANGE_DESC Perkins Loan Change Description Describes the change in the Perkins loan data since the previous transaction. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PERKINS_OVERPAYMENT Perkins Overpayment Indicates whether Perkins loan was overpaid or if satisfactory repayment has occurred. VARCHAR2(63)

RCRLDS4

RCRLDS4_PERK_OVER_PAY_FLG

PERKINS_OVERPAYMENT_DESC Perkins Overpayment Description Describes the Perkins loan overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PERKINS_OVER_PAY_CONTACT Perkins Over Pay Contact Indicates the school code or region code where the student's Perkins loan overpayment occurred. VARCHAR2(63)

RCRLDS4

RCRLDS4_PERK_OVER_PAY_CONTACT

PERKINS_OVER_PAY_CONTACT_DESC Perkins Over Pay Contact Description Describes the school where the student's Perkins loan overpayment occurred. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRLDS4

RCRLDS4_PIDM

PLUS_AGGREGATE_TOTAL PLUS Aggregate Total Loan total for Parent PLUS loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_PLUS_TOTAL

POST_SCREEN_REASON1 Post Screen Reason 1 The first National Student Loan Data System Post-Screening Reason Code, which indicates why the student's eligibility has changed since the initial screening. VARCHAR2(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE

POST_SCREEN_REASON1_DESC Post Screen Reason 1 Description Description of how the student's eligibility has changed since the initial screening as shown in the first reason code. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

POST_SCREEN_REASON2 Post Screen Reason 2 The second National Student Loan Data System Post-Screening Reason Code, which indicates why the student's eligibility has changed since the initial screening. VARCHAR2(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_2

POST_SCREEN_REASON2_DESC Post Screen Reason 2 Description Description of how the student's eligibility has changed since the initial screening as shown in the second reason code. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

POST_SCREEN_REASON3 Post Screen Reason 3 The third National Student Loan Data System Post-Screening Reason Code, which indicates why the student's eligibility has changed since the initial screening. VARCHAR2(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_3

POST_SCREEN_REASON3_DESC Post Screen Reason 3 Description Description of how the student's eligibility has changed since the initial screening as shown in the third reason code. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PROCESS_GROUP Process Group The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

SEOG_OVERPAYMENT Seog Overpayment Indicates if a student has an FSEOG overpayment. VARCHAR2(63)

RCRLDS4

RCRLDS4_SEOG_OVER_PAY_FLAG

SEOG_OVERPAYMENT_CONTACT Seog Overpayment Contact Indicates the school code or region code where the student's FSEOG overpayment occurred. VARCHAR2(63)

RCRLDS4

RCRLDS4_SEOG_OVER_PAY_CONTACT

SEOG_OVERPAYMENT_CONTACT_DESC Seog Overpayment Contact Description Describes the school where the student's FSEOG overpayment occurred. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SEOG_OVERPAYMENT_DESC Seog Overpayment Description Describes the FSEOG overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

SEQUENCE_NUMBER Sequence Number Number which uniquely identifies the set of National Student Loan Data System records if multiple sets have been stored from the same processor or source. NUMBER

RCRLDS4

RCRLDS4_SEQ_NO

SMART_OVERPAYMENT SMART Overpayment Indicates a National Student Loan Data System SMART Grant overpayment. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_SMART_OVER_PAY_FLG

SMART_OVERPAYMENT_CONTACT SMART Overpayment Contact Indicates the school code or region code where the student's SMART overpayment occurred. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_SMART_OVER_PAY_CONTACT

SMART_OVERPAYMENT_CONTACT_DESC SMART Overpayment Contact Description Describes the school where the student's SMART Grant overpayment occurred. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SMART_OVERPAYMENT_DESC SMART Overpayment Description Describes the SMART Grant overpayment. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

SMART_PAYMENT_CHANGE SMART Payment Change Indicates a change in the National Student Loan Data System SMART Grant payment data since the previous transaction. Obsolete as of aid year 1011. VARCHAR2(63)

RCRLDS4

RCRLDS4_SMART_PMT_CHG_FLG

SMART_PAYMENT_CHANGE_DESC SMART Payment Change Description Describes the change in the National Student Loan Data System SMART payment data since the previous transaction. Obsolete as of aid year 1011. VARCHAR2(255)

FUNCTION

FUNCTION

GOKODSF.F_GET_DESC

ROKODSF.F_GET_RORMVAL_DESC

SUBSIDIZED_150_USAGE_LIMIT_IND Subsidized 150 Usage Limit Indicator Indicates whether the student has met the 150 percent subsidized Stafford usage limit. VARCHAR2(1)

RCRLDS4

RCRLDS4_SUB_USE_LIMIT_FLAG

SUBSIDIZED_AGGREGATE_TOTAL Subsidized Aggregate Total Aggregate total subsidized disbursements reported to the National Student Loan Data System. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_TOTAL

SUBSIDIZED_LOAN_LIMIT Subsidized Loan Limit Indicates subsidized loan limit status. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_SUB

SUBSIDIZED_LOAN_LIMIT_DESC Subsidized Loan Limit Description Describes subsidized loan limit status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

SUBSIDIZED_LOAN_YEARS_USE Subsidized Loan Years Use Number of years the student has received Direct Subsidized Loans. NUMBER

RCRLDS4

RCRLDS4_SUB_LOAN_ELIG_USED

SUBSIDIZED_OUTSTANDING_BALANCE Subsidized Outstanding Balance Total outstanding principal balance for subsidized loan types, including the calculated share of a Consolidation Loan that is considered subsidized. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_OUT_PRIN_BAL

SUBSIDIZED_PENDING_PAYMENT Subsidized Pending Payment Aggregate subsidized pending disbursements reported to the National Student Loan Data System. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_PEND_DISB

TEACH_CHG_FLAG Teach Change Flag Indicates a change in the TEACH Grant payment data since the previous transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_TEACH_CHG_FLG

TEACH_GR_DISB_AMT Teaching GR Disbursement Amount Aggregate amount of TEACH Grant received as a graduate student. NUMBER

RCRLDS4

RCRLDS4_AGT_TEACH_GR_DISB_AMT

TEACH_LN_CONV_CHG_FLAG Teach Ln Conversion Change Flag Indicates if there has been a change to the TEACH loan conversion flag. VARCHAR2(63)

RCRLDS4

RCRLDS4_TEACH_LN_CONV_CHG_FLG

TEACH_LN_PRIN_BAL Teaching Loan Principal Balance Aggregate principal balance of the TEACH loans. NUMBER

RCRLDS4

RCRLDS4_AGT_TEACH_LN_PRIN_BAL

TEACH_LOAN_CONV_FLAG Teach Loan Conv Flag Indicates if this student has TEACH Grants that were converted to a loan. VARCHAR2(63)

RCRLDS4

RCRLDS4_TEACH_LOAN_CONV_FLG

TEACH_LOAN_TOTAL Teaching Loan Total The total of all TEACH loans. NUMBER

RCRLDS4

RCRLDS4_TEACH_LOAN_TOTAL

TEACH_OVERPAYMENT_CONTACT Teach Overpayment Contact Contact information for TEACH Grant overpayment. VARCHAR2(63)

RCRLDS4

RCRLDS4_TEACH_OVER_PAY_CONTACT

TEACH_UG_DISB_AMT Teaching UG Disbursement Amount Aggregate amount of TEACH Grant received as an undergraduate student. NUMBER

RCRLDS4

RCRLDS4_AGT_TEACH_UG_DISB_AMT

UNALLOCATED_CONSOLIDATION Unallocated Consolidation National Student Loan Data System Unallocated Consolidated Outstanding Principal Balance. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2

UNALLOCATED_CONSOLIDATION_SUM Unallocated Consolidation Sum National Student Loan Data System Unallocated Consolidated Total. NUMBER

RCRLDS4

RCRLDS4_AGT_CONSOL_TOTAL

UNSUBSIDIZED_AGGREGATE_TOTAL Unsubsidized Aggregate Total Total of the aggregate unsubsidized outstanding principal balance plus the aggregate unsubsidized pending disbursement. NUMBER

RCRLDS4

RCRLDS4_AGT_UNSUB_TOTAL

UNSUBSIDIZED_OUTSTANDING_BAL Unsubsidized Outstanding Balance Total outstanding principal balance for unsubsidized loan types, including the calculated share of a Consolidation Loan that is considered unsubsidized. NUMBER

RCRLDS4

RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL

UNSUBSIDIZED_PENDING_PAYMENT Unsubsidized Pending Payment The pending disbursements for unsubsidized loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_UNSUB_PEND_DISB

USER_ID User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RCRLDS4

RCRLDS4_USER_ID



Ver: 9.2