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
|