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(60)	FUNCTION	GOKODSF.F_GET_DESC
ACG_OVERPAYMENT_DESC	Describes the ACG overpayment.	VARCHAR2(60)	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(60)	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(60)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRLDS4	RCRLDS4_ACTIVITY_DATE
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RCRLDS4	RCRLDS4_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	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(60)	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_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
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(60)	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 Promimsory Note for the graduate student.	VARCHAR2(60)	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(60)	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(60)	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(60)	FUNCTION	GOKODSF.F_GET_DESC
DISCHARGE_LOAN_DESC	Describes the reason why the loans have been discharged.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
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
INTERFACE_TAPE_CODE	Indicates the source of the data contained in this National Student Loan Data System record.	VARCHAR2(7)	RCRLDS4	RCRLDS4_INFC_CODE
INTERFACE_TAPE_CODE_DESC	Describes the source of the data contained in the National Student Loan Data System records.	VARCHAR2(30)	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(60)	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(60)	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(60)	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
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA
MIF_VALUE	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
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(60)	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(60)	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(60)	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(60)	FUNCTION	GOKODSF.F_GET_DESC
PELL_OVERPAYMENT_DESC	Describes the Pell overpayment.	VARCHAR2(60)	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(60)	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(60)	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(60)	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(60)	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(60)	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(60)	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(60)	FUNCTION	GOKODSF.F_GET_DESC
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(60)	FUNCTION	GOKODSF.F_GET_DESC
SEOG_OVERPAYMENT_DESC	Describes the FSEOG overpayment.	VARCHAR2(60)	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(60)	FUNCTION	GOKODSF.F_GET_DESC
SMART_OVERPAYMENT_DESC	Describes the SMART Grant overpayment.	VARCHAR2(60)	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(60)	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(60)	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
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: