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.	VARCHAR2(1)	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.	VARCHAR2(8)	RCRLDS4	RCRLDS4_ACG_OVER_PAY_CONTACT	NO	NO
ACG_OVERPAYMENT_CONTACT_DESC	Describes the school where the student's ACG overpayment occurred.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACG_OVERPAYMENT_DESC	Describes the ACG overpayment.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
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	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(1)	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(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRLDS4	RCRLDS4_ACTIVITY_DATE	NO	NO
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	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	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(1)	RCRLDS4	RCRLDS4_AGT_OVER_LIMIT_COMB	NO	NO
COMBINED_LOAN_LIMIT_DESC	Describes the combined loan limit status.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_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(30)	RCRLDS4	RCRLDS4_CREATOR_ID	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	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(1)	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(60)	FUNCTION	GOKODSF.F_GET_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(1)	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 Promimsory Note for the graduate student.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DIRECT_LOAN_MPN	Status of the Direct Loan Master Promissory Note.	VARCHAR2(1)	RCRLDS4	RCRLDS4_DL_MPN_FLAG	NO	NO
DIRECT_LOAN_MPN_DESC	Describes the status of the Direct Loan Master Promissory Note.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DIRECT_LOAN_PAR_PLUS_MPN	Status of the Direct Loan Parent PLUS Master Promissory Note.	VARCHAR2(1)	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(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DISCHARGE_LOAN	Indicates if the student has any loans that have been discharged.	VARCHAR2(1)	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(1)	RCRLDS4	RCRLDS4_DISCHARG_LOAN_CHG_FLG	NO	NO
DISCHARGE_LOAN_CHANGE_DESC	Describes the change to the discharged loans since the previous transaction.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DISCHARGE_LOAN_DESC	Describes the reason why the loans have been discharged.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
ENROLLMENT_PATTERN	Indicates the student's enrollment pattern for Department of Education.	VARCHAR2(1)	RCRLDS4	RCRLDS4_ENROLL_PATTERN_FLAG	NO	NO
ENROLLMENT_PATTERN_DESC	Enrollment pattern 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(8)	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(1)	RCRLDS4	RCRLDS4_IASG_OVER_PAY_FLG	NO	NO
IASG_OVERPAYMENT_FLAG_DESC	Iasg Overpayment Flag description	VARCHAR2(60)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
INTERFACE_TAPE_CODE	Indicates the source of the data contained in this National Student Loan Data System record.	VARCHAR2(7)	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(30)	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(1)	RCRLDS4	RCRLDS4_AGT_CHG_FLG	NO	NO
LOAN_AGGREGATE_CHANGE_DESC	Describes the change to the aggregate loan amounts since the previous transaction.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LOAN_CHANGE	Indicates that information about one or more loans have changed.	VARCHAR2(1)	RCRLDS4	RCRLDS4_LOAN_CHG_FLAG	NO	NO
LOAN_CHANGE_DESC	Describes the loan information that has changed.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_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(1)	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(60)	FUNCTION	GOKODSF.F_GET_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
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	NO	NO
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	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(12)	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(35)	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(9)	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(1)	RCRLDS4	RCRLDS4_MATCH_IND	NO	NO
NSLDS_MATCH_DESC	Describes the National Student Loan Data System match status.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_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(1)	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(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NSLDS_TRANACTION_NUMBER	NSLDS transaction number.	VARCHAR2(2)	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(1)	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(60)	FUNCTION	GOKODSF.F_GET_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_LIMIT	Indicates how close the student is to or has met or exceeded the allowable Pell lifetime limit.	VARCHAR2(1)	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(1)	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(8)	RCRLDS4	RCRLDS4_PELL_OVER_PAY_CONTACT	NO	NO
PELL_OVERPAYMENT_CONTACT_DESC	Describes the school where the student's Pell overpayment occurred.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PELL_OVERPAYMENT_DESC	Describes the Pell overpayment.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
PELL_PAYMENT_CHANGE_DESC	Describes the change to the Pell payment data since the previous transaction.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	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(1)	RCRLDS4	RCRLDS4_PERK_CHG_FLG	NO	NO
PERKINS_LOAN_CHANGE_DESC	Describes the change in the Perkins loan data since the previous transaction.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PERKINS_OVERPAYMENT	Indicates whether Perkins loan was overpaid or if satisfactory repayment has occurred.	VARCHAR2(1)	RCRLDS4	RCRLDS4_PERK_OVER_PAY_FLG	NO	NO
PERKINS_OVERPAYMENT_DESC	Describes the Perkins loan overpayment.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
PERKINS_OVER_PAY_CONTACT_DESC	Describes the school where the student's Perkins loan overpayment occurred.	VARCHAR2(60)	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(2)	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(60)	FUNCTION	GOKODSF.F_GET_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(2)	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(60)	FUNCTION	GOKODSF.F_GET_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(2)	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(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SEOG_OVERPAYMENT	Indicates if a student has an FSEOG overpayment.	VARCHAR2(1)	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(8)	RCRLDS4	RCRLDS4_SEOG_OVER_PAY_CONTACT	NO	NO
SEOG_OVERPAYMENT_CONTACT_DESC	Describes the school where the student's FSEOG overpayment occurred.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SEOG_OVERPAYMENT_DESC	Describes the FSEOG overpayment.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_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.	VARCHAR2(1)	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.	VARCHAR2(8)	RCRLDS4	RCRLDS4_SMART_OVER_PAY_CONTACT	NO	NO
SMART_OVERPAYMENT_CONTACT_DESC	Describes the school where the student's SMART Grant overpayment occurred.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SMART_OVERPAYMENT_DESC	Describes the SMART Grant overpayment.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
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	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(1)	RCRLDS4	RCRLDS4_AGT_OVER_LIMIT_SUB	NO	NO
SUBSIDIZED_LOAN_LIMIT_DESC	Describes subsidized loan limit status.	VARCHAR2(60)	FUNCTION	GOKODSF.F_GET_DESC	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(30)	RCRLDS4	RCRLDS4_USER_ID	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: