Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE 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.

Target Column Business Definition Database Data Type Source Name Source Column
ACG_OVERPAYMENT Indicates a National Student Loan Data System ACG overpayment. VARCHAR2(1)

RCRLDS4

RCRLDS4_ACG_OVER_PAY_FLG

ACG_OVERPAYMENT_CONTACT Indicates the school code or region code where the student's ACG overpayment occurred. VARCHAR2(8)

RCRLDS4

RCRLDS4_ACG_OVER_PAY_CONTACT

ACG_OVERPAYMENT_CONTACT_DESC Describes the school where the student's ACG overpayment occurred. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACG_OVERPAYMENT_DESC Describes the ACG overpayment. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACG_PAYMENT_CHANGE Indicates a change in the National Student Loan Data System ACG payment data since the previous transaction. VARCHAR2(1)

RCRLDS4

RCRLDS4_ACG_PMT_CHG_FLG

ACG_PAYMENT_CHANGE_DESC Describes the change in the National Student Loan Data System ACG payment data since the previous transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVE_BANKRPT_CHANGE_IND Indicates one or more active loans currently in bankruptcy. VARCHAR2(1)

RCRLDS4

RCRLDS4_ACT_BANKRUPT_FLAG

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

RCRLDS4

RCRLDS4_ACT_BANKRUPT_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DATE Date record was inserted or updated. DATE

RCRLDS4

RCRLDS4_ACTIVITY_DATE

ADMINISTRATIVE_GROUP The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

RCRLDS4

RCRLDS4_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

COMBINED_AGGREGATE_TOTAL National Student Loan Data System Aggregate Combined Total. NUMBER

RCRLDS4

RCRLDS4_AGT_COMB_TOTAL

COMBINED_LOAN_LIMIT Indicates combined loan limit status. VARCHAR2(1)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_COMB

COMBINED_LOAN_LIMIT_DESC Describes the combined loan limit status. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_AGT_COMB_PRIN_BAL

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

RCRLDS4

RCRLDS4_AGT_COMB_PEND_DISB

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

RCRLDS4

RCRLDS4_CREATE_DATE

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

RCRLDS4

RCRLDS4_CREATOR_ID

CURRENT_RECORD_IND 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 Indicates if the student has any loans in default. VARCHAR2(1)

RCRLDS4

RCRLDS4_DEFAULTED_LOAN_FLG

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

RCRLDS4

RCRLDS4_DEF_LOAN_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_DL_GR_PLUS_MPN_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_DL_MPN_FLAG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_DL_PLUS_MPN_FLAG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_DISCHARG_LOAN_FLG

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

RCRLDS4

RCRLDS4_DISCHARG_LOAN_CHG_FLG

DISCHARGE_LOAN_CHANGE_DESC Describes the change to the discharged loans since the previous transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_AGT_GR_PLUS_TOTAL

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

RCRLDS4

RCRLDS4_AGT_GR_PLUS_PRIN_BAL

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 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 Indicates if there has been a change to the aggregate loan amounts since the previous transaction. VARCHAR2(1)

RCRLDS4

RCRLDS4_AGT_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

LOAN_CHANGE Indicates that information about one or more loans have changed. VARCHAR2(1)

RCRLDS4

RCRLDS4_LOAN_CHG_FLAG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_FRAUD_FLG

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

RCRLDS4

RCRLDS4_LOAN_SAT_REPAY_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_LOAN_SAT_REPAY_FLG

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(6)

NA

NA

MULTI_SOURCE_DESC 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 of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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 Current first name from the National Student Loan Data System for the student. VARCHAR2(12)

RCRLDS4

RCRLDS4_CURRENT_FIRST_NAME

NSLDS_CURRENT_LAST_NAME Current last name from the National Student Loan Data System for the student. VARCHAR2(35)

RCRLDS4

RCRLDS4_CURRENT_LAST_NAME

NSLDS_CURRENT_TAX_ID Current Social Security Number from the National Student Loan Data System for the student. VARCHAR2(9)

RCRLDS4

RCRLDS4_CURRENT_SSN

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

RCRLDS4

RCRLDS4_MATCH_IND

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_PROC_DATE

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

RCRLDS4

RCRLDS4_NSLDS_DB_RESULT_FLAG

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

FUNCTION

GOKODSF.F_GET_DESC

NSLDS_TRANACTION_NUMBER NSLDS transaction number. VARCHAR2(2)

RCRLDS4

RCRLDS4_TRAN_NO

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

RCRLDS4

RCRLDS4_OVER_PAY_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

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_OVERPAYMENT Indicates if a student has a Pell overpayment. VARCHAR2(1)

RCRLDS4

RCRLDS4_PELL_OVER_PAY_FLAG

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

RCRLDS4

RCRLDS4_PELL_OVER_PAY_CONTACT

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

FUNCTION

GOKODSF.F_GET_DESC

PELL_OVERPAYMENT_DESC Describes the Pell overpayment. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_PELL_PMT_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

PERKINS_CUMULATIVE_AMOUNT Total outstanding principal balance of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CUMULATIVE_AMT

PERKINS_CURRENT_YEAR_AMOUNT Current award year disbursement amount of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CURRENT_YR_AMT

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

RCRLDS4

RCRLDS4_PERK_CHG_FLG

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_PERK_OVER_PAY_FLG

PERKINS_OVERPAYMENT_DESC Describes the Perkins loan overpayment. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PERKINS_OVER_PAY_CONTACT Indicates the school code or region code where the student's Perkins loan overpayment occurred. VARCHAR2(8)

RCRLDS4

RCRLDS4_PERK_OVER_PAY_CONTACT

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

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_PIDM

PLUS_AGGREGATE_TOTAL Loan total for Parent PLUS loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_PLUS_TOTAL

POST_SCREEN_REASON1 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(2)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE

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

FUNCTION

GOKODSF.F_GET_DESC

POST_SCREEN_REASON2 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(2)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_2

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

FUNCTION

GOKODSF.F_GET_DESC

POST_SCREEN_REASON3 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(2)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_3

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

FUNCTION

GOKODSF.F_GET_DESC

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 Indicates if a student has an FSEOG overpayment. VARCHAR2(1)

RCRLDS4

RCRLDS4_SEOG_OVER_PAY_FLAG

SEOG_OVERPAYMENT_CONTACT Indicates the school code or region code where the student's FSEOG overpayment occurred. VARCHAR2(8)

RCRLDS4

RCRLDS4_SEOG_OVER_PAY_CONTACT

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

FUNCTION

GOKODSF.F_GET_DESC

SEOG_OVERPAYMENT_DESC Describes the FSEOG overpayment. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Indicates a National Student Loan Data System SMART Grant overpayment. VARCHAR2(1)

RCRLDS4

RCRLDS4_SMART_OVER_PAY_FLG

SMART_OVERPAYMENT_CONTACT Indicates the school code or region code where the student's SMART overpayment occurred. VARCHAR2(8)

RCRLDS4

RCRLDS4_SMART_OVER_PAY_CONTACT

SMART_OVERPAYMENT_CONTACT_DESC Describes the school where the student's SMART Grant overpayment occurred. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SMART_OVERPAYMENT_DESC Describes the SMART Grant overpayment VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SMART_PAYMENT_CHANGE Indicates a change in the National Student Loan Data System SMART Grant payment data since the previous transaction. VARCHAR2(1)

RCRLDS4

RCRLDS4_SMART_PMT_CHG_FLG

SMART_PAYMENT_CHANGE_DESC Describes the change in the National Student Loan Data System SMART payment data since the previous transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RCRLDS4

RCRLDS4_AGT_SUB_TOTAL

SUBSIDIZED_LOAN_LIMIT Indicates subsidized loan limit status. VARCHAR2(1)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_SUB

SUBSIDIZED_LOAN_LIMIT_DESC Describes subsidized loan limit status. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Aggregate subsidized pending disbursements reported to the National Student Loan Data System. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_PEND_DISB

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

RCRLDS4

RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2

UNALLOCATED_CONSOLIDATION_SUM National Student Loan Data System Unallocated Consolidated Total. NUMBER

RCRLDS4

RCRLDS4_AGT_CONSOL_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 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 The pending disbursements for unsubsidized loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_UNSUB_PEND_DISB

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

RCRLDS4

RCRLDS4_USER_ID



Ver: 8.0