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 Definition Database Data Type Source Name Source Column Local Source Local Target
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

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

NO
ACG_PAYMENT_CHANGE_DESC 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

NO

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

RCRLDS4

RCRLDS4_ACT_BANKRUPT_FLAG

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRLDS4

RCRLDS4_ACTIVITY_DATE

NO

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

NA

NA

NO

NO
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

NO

NO
AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

NO

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

RCRLDS4

RCRLDS4_AGT_COMB_TOTAL

NO

NO
COMBINED_LOAN_LIMIT Indicates combined loan limit status. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_COMB

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_AGT_COMB_PRIN_BAL

NO

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

RCRLDS4

RCRLDS4_AGT_COMB_PEND_DISB

NO

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

RCRLDS4

RCRLDS4_CREATE_DATE

NO

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

RCRLDS4

RCRLDS4_CREATOR_ID

NO

NO
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

NO

NO
DEFAULTED_LOAN_IND Indicates if the student has any loans in default. VARCHAR2(1)

RCRLDS4

RCRLDS4_DEFAULTED_LOAN_FLG

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
DIRECT_LOAN_GRAD_PLUS_MPN 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

NO

NO
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

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_DL_MPN_FLAG

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_DL_PLUS_MPN_FLAG

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_DISCHARG_LOAN_FLG

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_ENROLL_PATTERN_FLAG

NO

NO
ENROLLMENT_PATTERN_DESC Enrollment pattern description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_COMB

NO

NO
EXCEED_COMBINED_LIMIT_DESC Exceed combined limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
EXCEED_GRAD_COMBINED_LIMIT Indicates how close a graduate student is to exceeding the combined loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_GR_AGT_OVER_LIMIT_COMB

NO

NO
EXCEED_GRAD_COMB_LIMIT_DESC Exceed graduate student's combined loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
EXCEED_GRAD_SUBSIDIZED_LIMIT Indicates how close a graduate student is to exceeding the subsidized loan limit. VARCHAR2(63)

RCRLDS4

RCRLDS4_GR_AGT_OVER_LIMIT_SUB

NO

NO
EXCEED_GRAD_SUB_LIMIT_DESC Exceed graduate student's subsized loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_SUB

NO

NO
EXCEED_SUBSIDIZED_LIMIT_DESC Exceed subsidized loan limit description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_AGT_GR_PLUS_TOTAL

NO

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

RCRLDS4

RCRLDS4_AGT_GR_PLUS_PRIN_BAL

NO

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

RCRLDS4

RCRLDS4_IASG_OVER_PAY_CONTACT

NO

NO
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

NO

NO
IASG_OVERPAYMENT_FLAG_DESC Iasg Overpayment Flag description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

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

RCRLDS4

RCRLDS4_INFC_CODE

NO

NO
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

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_LOAN_CHG_FLAG

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_FRAUD_FLG

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_LOAN_SAT_REPAY_FLG

NO

NO
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

NO

NO
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

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

RCRLDS4

RCRLDS4_CURRENT_BIRTH_DATE

NO

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

RCRLDS4

RCRLDS4_CURRENT_FIRST_NAME

NO

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

RCRLDS4

RCRLDS4_CURRENT_LAST_NAME

NO

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

RCRLDS4

RCRLDS4_CURRENT_SSN

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_PROC_DATE

NO

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

RCRLDS4

RCRLDS4_NSLDS_DB_RESULT_FLAG

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
NSLDS_TRANACTION_NUMBER NSLDS transaction number. VARCHAR2(63)

RCRLDS4

RCRLDS4_TRAN_NO

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

NO
PELL_LIFETIME_ELIGIBILITY_USED Lifetime eligibility used for Pell grants. NUMBER

RCRLDS4

RCRLDS4_PELL_LEU

NO

NO
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

NO

NO
PELL_LIFETIME_LIMIT_DESC Pell lifetime limit description VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_PELL_OVER_PAY_FLAG

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PELL_OVERPAYMENT_DESC Describes the Pell overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

NO
PELL_PAYMENT_CHANGE_DESC 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

NO

NO

NO
PERKINS_CUMULATIVE_AMOUNT Total outstanding principal balance of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CUMULATIVE_AMT

NO

NO
PERKINS_CURRENT_YEAR_AMOUNT Current award year disbursement amount of Perkins loans. NUMBER

RCRLDS4

RCRLDS4_PERK_CURRENT_YR_AMT

NO

NO
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

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

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

RCRLDS4

RCRLDS4_PERK_OVER_PAY_FLG

NO

NO
PERKINS_OVERPAYMENT_DESC Describes the Perkins loan overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

RCRLDS4

RCRLDS4_PIDM

NO

NO
PLUS_AGGREGATE_TOTAL Loan total for Parent PLUS loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_PLUS_TOTAL

NO

NO
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(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE

NO

NO
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

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_2

NO

NO
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

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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(63)

RCRLDS4

RCRLDS4_POST_SCREEN_RSN_CDE_3

NO

NO
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

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

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

RCRLDS4

RCRLDS4_SEOG_OVER_PAY_FLAG

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SEOG_OVERPAYMENT_DESC Describes the FSEOG overpayment. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

NO
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

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
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

NO

NO
SMART_PAYMENT_CHANGE_DESC 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

NO

NO

NO
SUBSIDIZED_150_USAGE_LIMIT_IND Indicates whether the student has met the 150 percent subsidized Stafford usage limit. VARCHAR2(1)

RCRLDS4

RCRLDS4_SUB_USE_LIMIT_FLAG

NO

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

RCRLDS4

RCRLDS4_AGT_SUB_TOTAL

NO

NO
SUBSIDIZED_LOAN_LIMIT Indicates subsidized loan limit status. VARCHAR2(63)

RCRLDS4

RCRLDS4_AGT_OVER_LIMIT_SUB

NO

NO
SUBSIDIZED_LOAN_LIMIT_DESC Describes subsidized loan limit status. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

NO

NO
SUBSIDIZED_LOAN_YEARS_USE Number of years the student has received Direct Subsidized Loans. NUMBER

RCRLDS4

RCRLDS4_SUB_LOAN_ELIG_USED

NO

NO
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

NO

NO
SUBSIDIZED_PENDING_PAYMENT Aggregate subsidized pending disbursements reported to the National Student Loan Data System. NUMBER

RCRLDS4

RCRLDS4_AGT_SUB_PEND_DISB

NO

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

RCRLDS4

RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2

NO

NO
UNALLOCATED_CONSOLIDATION_SUM National Student Loan Data System Unallocated Consolidated Total. NUMBER

RCRLDS4

RCRLDS4_AGT_CONSOL_TOTAL

NO

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

RCRLDS4

RCRLDS4_AGT_UNSUB_TOTAL

NO

NO
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

NO

NO
UNSUBSIDIZED_PENDING_PAYMENT The pending disbursements for unsubsidized loan types. NUMBER

RCRLDS4

RCRLDS4_AGT_UNSUB_PEND_DISB

NO

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

RCRLDS4

RCRLDS4_USER_ID

NO

NO


Ver: 9.2