Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACG_OVERPAYMENT	Acg Overpayment	Indicates a National Student Loan Data System ACG overpayment.	VARCHAR2(1)		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.	VARCHAR2(8)		RCRLDS4	RCRLDS4_ACG_OVER_PAY_CONTACT
ACG_OVERPAYMENT_CONTACT_DESC	Acg Overpayment Contact Description	Describes the school where the student's ACG overpayment occurred.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
ACG_OVERPAYMENT_DESC	Acg Overpayment Description	Describes the ACG overpayment.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
ACG_PAYMENT_CHANGE	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	Acg Payment Change Description	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	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(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RCRLDS4	RCRLDS4_ACTIVITY_DATE
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RCRLDS4	RCRLDS4_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(30)		ROBINST	ROBINST_AIDY_DESC
COMBINED_AGGREGATE_TOTAL	Combined Aggregate Total	National Student Loan Data System Aggregate Combined Total.	NUMBER(6)		RCRLDS4	RCRLDS4_AGT_COMB_TOTAL
COMBINED_LOAN_LIMIT	Combined Loan Limit	Indicates combined loan limit status.	VARCHAR2(1)		RCRLDS4	RCRLDS4_AGT_OVER_LIMIT_COMB
COMBINED_LOAN_LIMIT_DESC	Combined Loan Limit Description	Describes the combined loan limit status.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
COMBINED_OUTSTANDING_BALANCE	Combined Outstanding Balance	National Student Loan Data System Aggregate Combined Principle Balance.	NUMBER(6)		RCRLDS4	RCRLDS4_AGT_COMB_PRIN_BAL
COMBINED_PENDING_PAYMENT	Combined Pending Payment	National Student Loan Data System Aggregate Combined Pending Disbursement.	NUMBER(6)		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(30)		RCRLDS4	RCRLDS4_CREATOR_ID
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
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(1)		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(60)		FUNCTION	GOKODSF.F_GET_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(1)		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 Promimsory Note for the graduate student.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
DIRECT_LOAN_MPN	Direct Loan Master Promissory Note	Status of the Direct Loan Master Promissory Note.	VARCHAR2(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
DIRECT_LOAN_PAR_PLUS_MPN	Direct Loan Par PLUS Master Promissory Note	Status of the Direct Loan Parent PLUS Master Promissory Note.	VARCHAR2(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
DISCHARGE_LOAN	Discharge Loan	Indicates if the student has any loans that have been discharged.	VARCHAR2(1)		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(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
DISCHARGE_LOAN_DESC	Discharge Loan Description	Describes the reason why the loans have been discharged.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
GRAD_PLUS_AGGREGATE_TOTAL	Graduate PLUS Aggregate Total	Loan total for Graduate/Professional PLUS loan types.	NUMBER(6)		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(6)		RCRLDS4	RCRLDS4_AGT_GR_PLUS_PRIN_BAL
INTERFACE_TAPE_CODE	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	Interface Tape Code Description	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	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	Loan Aggregate Change Description	Describes the change to the aggregate loan amounts since the previous transaction.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
LOAN_CHANGE	Loan Change	Indicates that information about one or more loans have changed.	VARCHAR2(1)		RCRLDS4	RCRLDS4_LOAN_CHG_FLAG
LOAN_CHANGE_DESC	Loan Change Description	Describes the loan information that has changed.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_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(1)		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(60)		FUNCTION	GOKODSF.F_GET_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
MIF_DESC	MIF Description	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	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	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(12)		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(35)		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(9)		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(1)		RCRLDS4	RCRLDS4_MATCH_IND
NSLDS_MATCH_DESC	Nslds Match Description	Describes the National Student Loan Data System match status.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_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(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
NSLDS_TRANACTION_NUMBER	Nslds Tranaction Number	NSLDS transaction number.	VARCHAR2(2)		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(1)		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(60)		FUNCTION	GOKODSF.F_GET_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(6)		RCRLDS4	RCRLDS4_AGT_PLUS_OUT_PRIN_BAL
PELL_OVERPAYMENT	Pell Overpayment	Indicates if a student has a Pell overpayment.	VARCHAR2(1)		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(8)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
PELL_OVERPAYMENT_DESC	Pell Overpayment Description	Describes the Pell overpayment.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
PELL_PAYMENT_CHANGE	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	Pell Payment Change Description	Describes the change to the Pell payment data since the previous transaction.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
PERKINS_CUMULATIVE_AMOUNT	Perkins Cumulative Amount	Total outstanding principal balance of Perkins loans.	NUMBER(6)		RCRLDS4	RCRLDS4_PERK_CUMULATIVE_AMT
PERKINS_CURRENT_YEAR_AMOUNT	Perkins Current Year Amount	Current award year disbursement amount of Perkins loans.	NUMBER(6)		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(1)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
PERKINS_OVERPAYMENT	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	Perkins Overpayment Description	Describes the Perkins loan overpayment.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_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(8)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RCRLDS4	RCRLDS4_PIDM
PLUS_AGGREGATE_TOTAL	PLUS Aggregate Total	Loan total for Parent PLUS loan types.	NUMBER(6)		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(2)		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(60)		FUNCTION	GOKODSF.F_GET_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(2)		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(60)		FUNCTION	GOKODSF.F_GET_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(2)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
SEOG_OVERPAYMENT	Seog Overpayment	Indicates if a student has an FSEOG overpayment.	VARCHAR2(1)		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(8)		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(60)		FUNCTION	GOKODSF.F_GET_DESC
SEOG_OVERPAYMENT_DESC	Seog Overpayment Description	Describes the FSEOG overpayment.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_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(3)		RCRLDS4	RCRLDS4_SEQ_NO
SMART_OVERPAYMENT	Smart Overpayment	Indicates a National Student Loan Data System SMART Grant overpayment.	VARCHAR2(1)		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.	VARCHAR2(8)		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.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
SMART_OVERPAYMENT_DESC	Smart Overpayment Description	Describes the SMART Grant overpayment	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_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.	VARCHAR2(1)		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.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
SUBSIDIZED_AGGREGATE_TOTAL	Subsidized Aggregate Total	Aggregate total subsidized disbursements reported to the National Student Loan Data System.	NUMBER(6)		RCRLDS4	RCRLDS4_AGT_SUB_TOTAL
SUBSIDIZED_LOAN_LIMIT	Subsidized Loan Limit	Indicates Subsidized loan limit status.	VARCHAR2(1)		RCRLDS4	RCRLDS4_AGT_OVER_LIMIT_SUB
SUBSIDIZED_LOAN_LIMIT_DESC	Subsidized Loan Limit Description	Describes subsidized loan limit status.	VARCHAR2(60)		FUNCTION	GOKODSF.F_GET_DESC
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(6)		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(6)		RCRLDS4	RCRLDS4_AGT_SUB_PEND_DISB
UNALLOCATED_CONSOLIDATION	Unallocated Consolidation	National Student Loan Data System Unallocated Consolidated Outstanding Principal Balance.	NUMBER(6)		RCRLDS4	RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2
UNALLOCATED_CONSOLIDATION_SUM	Unallocated Consolidation Sum	National Student Loan Data System Unallocated Consolidated Total.	NUMBER(6)		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(6)		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(6)		RCRLDS4	RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL
UNSUBSIDIZED_PENDING_PAYMENT	Unsubsidized Pending Payment	The pending disbursements for unsubsidized loan types.	NUMBER(6)		RCRLDS4	RCRLDS4_AGT_UNSUB_PEND_DISB
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RCRLDS4	RCRLDS4_USER_ID
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: