| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RCRLDS4_ACG_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACG_OVERPAYMENT_CONTACT |
NO |
|
| RCRLDS4_ACG_OVER_PAY_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACG_OVERPAYMENT |
NO |
|
| RCRLDS4_ACG_PMT_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACG_PAYMENT_CHANGE |
NO |
|
| RCRLDS4_ACTIVITY_DATE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACTIVITY_DATE |
NO |
|
| RCRLDS4_ACT_BANKRUPT_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACTIVE_BANKRUPTCY_CHANGE |
NO |
|
| RCRLDS4_ACT_BANKRUPT_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ACTIVE_BANKRPT_CHANGE_IND |
NO |
|
| RCRLDS4_AGT_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
LOAN_AGGREGATE_CHANGE |
NO |
|
| RCRLDS4_AGT_COMB_PEND_DISB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
COMBINED_PENDING_PAYMENT |
NO |
|
| RCRLDS4_AGT_COMB_PRIN_BAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
COMBINED_OUTSTANDING_BALANCE |
NO |
|
| RCRLDS4_AGT_COMB_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
COMBINED_AGGREGATE_TOTAL |
NO |
|
| RCRLDS4_AGT_CONSOL_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
UNALLOCATED_CONSOLIDATION_SUM |
NO |
|
| RCRLDS4_AGT_GR_PLUS_PRIN_BAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
GRAD_PLUS_OUTSTANDING_BALANCE |
NO |
|
| RCRLDS4_AGT_GR_PLUS_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
GRAD_PLUS_AGGREGATE_TOTAL |
NO |
|
| RCRLDS4_AGT_OVER_LIMIT_COMB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES LOAN_AGGREGATES |
COMBINED_LOAN_LIMIT EXCEED_COMBINED_LIMIT |
NO NO |
|
| RCRLDS4_AGT_OVER_LIMIT_SUB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES LOAN_AGGREGATES |
EXCEED_SUBSIDIZED_LIMIT SUBSIDIZED_LOAN_LIMIT |
NO NO |
|
| RCRLDS4_AGT_PLUS_OUT_PRIN_BAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PARENTPLUS_OUTSTANDING_BALANCE |
NO |
|
| RCRLDS4_AGT_PLUS_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PLUS_AGGREGATE_TOTAL |
NO |
|
| RCRLDS4_AGT_SUB_OUT_PRIN_BAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SUBSIDIZED_OUTSTANDING_BALANCE |
NO |
|
| RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2 |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
UNALLOCATED_CONSOLIDATION |
NO |
|
| RCRLDS4_AGT_SUB_PEND_DISB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SUBSIDIZED_PENDING_PAYMENT |
NO |
|
| RCRLDS4_AGT_SUB_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SUBSIDIZED_AGGREGATE_TOTAL |
NO |
|
| RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
UNSUBSIDIZED_OUTSTANDING_BAL |
NO |
|
| RCRLDS4_AGT_UNSUB_PEND_DISB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
UNSUBSIDIZED_PENDING_PAYMENT |
NO |
|
| RCRLDS4_AGT_UNSUB_TOTAL |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
UNSUBSIDIZED_AGGREGATE_TOTAL |
NO |
|
| RCRLDS4_AIDY_CODE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
AID_YEAR |
NO |
|
| RCRLDS4_CREATE_DATE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
CREATE_DATE |
NO |
|
| RCRLDS4_CREATOR_ID |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
CREATOR_ID |
NO |
|
| RCRLDS4_CURRENT_BIRTH_DATE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_CURRENT_BIRTH_DATE |
NO |
|
| RCRLDS4_CURRENT_FIRST_NAME |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_CURRENT_FIRST_NAME |
NO |
|
| RCRLDS4_CURRENT_LAST_NAME |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_CURRENT_LAST_NAME |
NO |
|
| RCRLDS4_CURRENT_SSN |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_CURRENT_TAX_ID |
NO |
|
| RCRLDS4_CURR_REC_IND |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
CURRENT_RECORD_IND |
NO |
|
| RCRLDS4_DEFAULTED_LOAN_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DEFAULTED_LOAN_IND |
NO |
|
| RCRLDS4_DEF_LOAN_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DEFAULT_LOAN_CHANGE |
NO |
|
| RCRLDS4_DISCHARG_LOAN_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DISCHARGE_LOAN_CHANGE |
NO |
|
| RCRLDS4_DISCHARG_LOAN_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DISCHARGE_LOAN |
NO |
|
| RCRLDS4_DL_GR_PLUS_MPN_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DIRECT_LOAN_GRAD_PLUS_MPN |
NO |
|
| RCRLDS4_DL_MPN_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DIRECT_LOAN_MPN |
NO |
|
| RCRLDS4_DL_PLUS_MPN_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
DIRECT_LOAN_PAR_PLUS_MPN |
NO |
|
| RCRLDS4_ENROLL_PATTERN_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
ENROLLMENT_PATTERN |
NO |
|
| RCRLDS4_FRAUD_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
LOAN_FRAUD_IND |
NO |
|
| RCRLDS4_GR_AGT_OVER_LIMIT_COMB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
EXCEED_GRAD_COMBINED_LIMIT |
NO |
|
| RCRLDS4_GR_AGT_OVER_LIMIT_SUB |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
EXCEED_GRAD_SUBSIDIZED_LIMIT |
NO |
|
| RCRLDS4_IASG_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
IASG_OVERPAYMENT_CONTACT |
NO |
|
| RCRLDS4_IASG_OVER_PAY_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
IASG_OVERPAYMENT_FLAG |
NO |
|
| RCRLDS4_INFC_CODE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
INTERFACE_TAPE_CODE |
NO |
|
| RCRLDS4_LOAN_CHG_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
LOAN_CHANGE |
NO |
|
| RCRLDS4_LOAN_SAT_REPAY_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
LOAN_REPAYMENT_CHANGE |
NO |
|
| RCRLDS4_LOAN_SAT_REPAY_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
LOAN_REPAYMENT_IND |
NO |
|
| RCRLDS4_MATCH_IND |
RNASLXX RNINSLD |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_MATCH |
NO |
|
| RCRLDS4_NSLDS_DB_RESULT_FLAG |
RNASLXX RNINSLD |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_RESULTS |
NO |
|
| RCRLDS4_OVER_PAY_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
OVERPAYMENTS_CHANGE |
NO |
|
| RCRLDS4_PELL_LEU |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PELL_LIFETIME_ELIGIBILITY_USED |
NO |
|
| RCRLDS4_PELL_LEU_LIMIT_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PELL_LIFETIME_LIMIT |
NO |
|
| RCRLDS4_PELL_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PELL_OVERPAYMENT_CONTACT |
NO |
|
| RCRLDS4_PELL_OVER_PAY_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PELL_OVERPAYMENT |
NO |
|
| RCRLDS4_PELL_PMT_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PELL_PAYMENT_CHANGE |
NO |
|
| RCRLDS4_PERK_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERKINS_LOAN_CHANGE |
NO |
|
| RCRLDS4_PERK_CUMULATIVE_AMT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERKINS_CUMULATIVE_AMOUNT |
NO |
|
| RCRLDS4_PERK_CURRENT_YR_AMT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERKINS_CURRENT_YEAR_AMOUNT |
NO |
|
| RCRLDS4_PERK_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERKINS_OVER_PAY_CONTACT |
NO |
|
| RCRLDS4_PERK_OVER_PAY_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERKINS_OVERPAYMENT |
NO |
|
| RCRLDS4_PIDM |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
PERSON_UID |
NO |
|
| RCRLDS4_POST_SCREEN_RSN_CDE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
POST_SCREEN_REASON1 |
NO |
|
| RCRLDS4_POST_SCREEN_RSN_CDE_2 |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
POST_SCREEN_REASON2 |
NO |
|
| RCRLDS4_POST_SCREEN_RSN_CDE_3 |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
POST_SCREEN_REASON3 |
NO |
|
| RCRLDS4_PROC_DATE |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_PROCESS_DATE |
NO |
|
| RCRLDS4_SEOG_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SEOG_OVERPAYMENT_CONTACT |
NO |
|
| RCRLDS4_SEOG_OVER_PAY_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SEOG_OVERPAYMENT |
NO |
|
| RCRLDS4_SEQ_NO |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SEQUENCE_NUMBER |
NO |
|
| RCRLDS4_SMART_OVER_PAY_CONTACT |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SMART_OVERPAYMENT_CONTACT |
NO |
|
| RCRLDS4_SMART_OVER_PAY_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SMART_OVERPAYMENT |
NO |
|
| RCRLDS4_SMART_PMT_CHG_FLG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SMART_PAYMENT_CHANGE |
NO |
|
| RCRLDS4_SUB_LOAN_ELIG_USED |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SUBSIDIZED_LOAN_YEARS_USE |
NO |
|
| RCRLDS4_SUB_USE_LIMIT_FLAG |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
SUBSIDIZED_150_USAGE_LIMIT_IND |
NO |
|
| RCRLDS4_TRAN_NO |
RNASLXX RNINSLD |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
NSLDS_TRANACTION_NUMBER |
NO |
|
| RCRLDS4_USER_ID |
RNASLXX |
NO |
REPORTING VIEW |
LOAN_AGGREGATES |
USER_ID |
NO |
|