Composite View Source: RCRLDS4

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RCRLDS4 Financial Aid

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
RCRLDS4_ACG_OVER_PAY_CONTACT	RNASLXX	AR_LOAN_AGGREGATES	ACG_OVERPAYMENT_CONTACT
RCRLDS4_ACG_OVER_PAY_FLG	RNASLXX	AR_LOAN_AGGREGATES	ACG_OVERPAYMENT
RCRLDS4_ACG_PMT_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	ACG_PAYMENT_CHANGE
RCRLDS4_ACTIVITY_DATE	RNASLXX	AR_LOAN_AGGREGATES	ACTIVITY_DATE
RCRLDS4_ACT_BANKRUPT_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	ACTIVE_BANKRUPTCY_CHANGE
RCRLDS4_ACT_BANKRUPT_FLAG	RNASLXX	AR_LOAN_AGGREGATES	ACTIVE_BANKRPT_CHANGE_IND
RCRLDS4_AGT_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	LOAN_AGGREGATE_CHANGE
RCRLDS4_AGT_COMB_PEND_DISB	RNASLXX	AR_LOAN_AGGREGATES	COMBINED_PENDING_PAYMENT
RCRLDS4_AGT_COMB_PRIN_BAL	RNASLXX	AR_LOAN_AGGREGATES	COMBINED_OUTSTANDING_BALANCE
RCRLDS4_AGT_COMB_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	COMBINED_AGGREGATE_TOTAL
RCRLDS4_AGT_CONSOL_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	UNALLOCATED_CONSOLIDATION_SUM
RCRLDS4_AGT_GR_PLUS_PRIN_BAL	RNASLXX	AR_LOAN_AGGREGATES	GRAD_PLUS_OUTSTANDING_BALANCE
RCRLDS4_AGT_GR_PLUS_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	GRAD_PLUS_AGGREGATE_TOTAL
RCRLDS4_AGT_OVER_LIMIT_COMB	RNASLXX	AR_LOAN_AGGREGATES	COMBINED_LOAN_LIMIT
RCRLDS4_AGT_OVER_LIMIT_SUB	RNASLXX	AR_LOAN_AGGREGATES	SUBSIDIZED_LOAN_LIMIT
RCRLDS4_AGT_PLUS_OUT_PRIN_BAL	RNASLXX	AR_LOAN_AGGREGATES	PARENTPLUS_OUTSTANDING_BALANCE
RCRLDS4_AGT_PLUS_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	PLUS_AGGREGATE_TOTAL
RCRLDS4_AGT_SUB_OUT_PRIN_BAL	RNASLXX	AR_LOAN_AGGREGATES	SUBSIDIZED_OUTSTANDING_BALANCE
RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2	RNASLXX	AR_LOAN_AGGREGATES	UNALLOCATED_CONSOLIDATION
RCRLDS4_AGT_SUB_PEND_DISB	RNASLXX	AR_LOAN_AGGREGATES	SUBSIDIZED_PENDING_PAYMENT
RCRLDS4_AGT_SUB_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	SUBSIDIZED_AGGREGATE_TOTAL
RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL	RNASLXX	AR_LOAN_AGGREGATES	UNSUBSIDIZED_OUTSTANDING_BAL
RCRLDS4_AGT_UNSUB_PEND_DISB	RNASLXX	AR_LOAN_AGGREGATES	UNSUBSIDIZED_PENDING_PAYMENT
RCRLDS4_AGT_UNSUB_TOTAL	RNASLXX	AR_LOAN_AGGREGATES	UNSUBSIDIZED_AGGREGATE_TOTAL
RCRLDS4_AIDY_CODE	RNASLXX	AR_LOAN_AGGREGATES	AID_YEAR
RCRLDS4_CREATE_DATE	RNASLXX	AR_LOAN_AGGREGATES	CREATE_DATE
RCRLDS4_CREATOR_ID	RNASLXX	AR_LOAN_AGGREGATES	CREATOR_ID
RCRLDS4_CURRENT_BIRTH_DATE	RNASLXX	AR_LOAN_AGGREGATES	NSLDS_CURRENT_BIRTH_DATE
RCRLDS4_CURRENT_FIRST_NAME	RNASLXX	AR_LOAN_AGGREGATES	NSLDS_CURRENT_FIRST_NAME
RCRLDS4_CURRENT_LAST_NAME	RNASLXX	AR_LOAN_AGGREGATES	NSLDS_CURRENT_LAST_NAME
RCRLDS4_CURRENT_SSN	RNASLXX	AR_LOAN_AGGREGATES	NSLDS_CURRENT_TAX_ID
RCRLDS4_CURR_REC_IND	RNASLXX	AR_LOAN_AGGREGATES	CURRENT_RECORD_IND
RCRLDS4_DEFAULTED_LOAN_FLG	RNASLXX	AR_LOAN_AGGREGATES	DEFAULTED_LOAN_IND
RCRLDS4_DEF_LOAN_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	DEFAULT_LOAN_CHANGE
RCRLDS4_DISCHARG_LOAN_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	DISCHARGE_LOAN_CHANGE
RCRLDS4_DISCHARG_LOAN_FLG	RNASLXX	AR_LOAN_AGGREGATES	DISCHARGE_LOAN
RCRLDS4_DL_GR_PLUS_MPN_FLG	RNASLXX	AR_LOAN_AGGREGATES	DIRECT_LOAN_GRAD_PLUS_MPN
RCRLDS4_DL_MPN_FLAG	RNASLXX	AR_LOAN_AGGREGATES	DIRECT_LOAN_MPN
RCRLDS4_DL_PLUS_MPN_FLAG	RNASLXX	AR_LOAN_AGGREGATES	DIRECT_LOAN_PAR_PLUS_MPN
RCRLDS4_FRAUD_FLG	RNASLXX	AR_LOAN_AGGREGATES	LOAN_FRAUD_IND
RCRLDS4_INFC_CODE	RNASLXX	AR_LOAN_AGGREGATES	INTERFACE_TAPE_CODE
RCRLDS4_LOAN_CHG_FLAG	RNASLXX	AR_LOAN_AGGREGATES	LOAN_CHANGE
RCRLDS4_LOAN_SAT_REPAY_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	LOAN_REPAYMENT_CHANGE
RCRLDS4_LOAN_SAT_REPAY_FLG	RNASLXX	AR_LOAN_AGGREGATES	LOAN_REPAYMENT_IND
RCRLDS4_MATCH_IND	RNASLXX RNINSLD	AR_LOAN_AGGREGATES	NSLDS_MATCH
RCRLDS4_NSLDS_DB_RESULT_FLAG	RNASLXX RNINSLD	AR_LOAN_AGGREGATES	NSLDS_RESULTS
RCRLDS4_OVER_PAY_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	OVERPAYMENTS_CHANGE
RCRLDS4_PELL_OVER_PAY_CONTACT	RNASLXX	AR_LOAN_AGGREGATES	PELL_OVERPAYMENT_CONTACT
RCRLDS4_PELL_OVER_PAY_FLAG	RNASLXX	AR_LOAN_AGGREGATES	PELL_OVERPAYMENT
RCRLDS4_PELL_PMT_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	PELL_PAYMENT_CHANGE
RCRLDS4_PERK_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	PERKINS_LOAN_CHANGE
RCRLDS4_PERK_CUMULATIVE_AMT	RNASLXX	AR_LOAN_AGGREGATES	PERKINS_CUMULATIVE_AMOUNT
RCRLDS4_PERK_CURRENT_YR_AMT	RNASLXX	AR_LOAN_AGGREGATES	PERKINS_CURRENT_YEAR_AMOUNT
RCRLDS4_PERK_OVER_PAY_CONTACT	RNASLXX	AR_LOAN_AGGREGATES	PERKINS_OVER_PAY_CONTACT
RCRLDS4_PERK_OVER_PAY_FLG	RNASLXX	AR_LOAN_AGGREGATES	PERKINS_OVERPAYMENT
RCRLDS4_PIDM	RNASLXX	AR_LOAN_AGGREGATES	PERSON_UID
RCRLDS4_POST_SCREEN_RSN_CDE	RNASLXX	AR_LOAN_AGGREGATES	POST_SCREEN_REASON1
RCRLDS4_POST_SCREEN_RSN_CDE_2	RNASLXX	AR_LOAN_AGGREGATES	POST_SCREEN_REASON2
RCRLDS4_POST_SCREEN_RSN_CDE_3	RNASLXX	AR_LOAN_AGGREGATES	POST_SCREEN_REASON3
RCRLDS4_PROC_DATE	RNASLXX	AR_LOAN_AGGREGATES	NSLDS_PROCESS_DATE
RCRLDS4_SEOG_OVER_PAY_CONTACT	RNASLXX	AR_LOAN_AGGREGATES	SEOG_OVERPAYMENT_CONTACT
RCRLDS4_SEOG_OVER_PAY_FLAG	RNASLXX	AR_LOAN_AGGREGATES	SEOG_OVERPAYMENT
RCRLDS4_SEQ_NO	RNASLXX	AR_LOAN_AGGREGATES	SEQUENCE_NUMBER
RCRLDS4_SMART_OVER_PAY_CONTACT	RNASLXX	AR_LOAN_AGGREGATES	SMART_OVERPAYMENT_CONTACT
RCRLDS4_SMART_OVER_PAY_FLG	RNASLXX	AR_LOAN_AGGREGATES	SMART_OVERPAYMENT
RCRLDS4_SMART_PMT_CHG_FLG	RNASLXX	AR_LOAN_AGGREGATES	SMART_PAYMENT_CHANGE
RCRLDS4_TRAN_NO	RNASLXX RNINSLD	AR_LOAN_AGGREGATES	NSLDS_TRANACTION_NUMBER
RCRLDS4_USER_ID	RNASLXX	AR_LOAN_AGGREGATES	USER_ID

Ver: 8.3