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
|