| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| RCRAPP3_ACTIVITY_DATE |
NA |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ACTIVITY_DATE |
NO |
|
| RCRAPP3_ADJ_EFC_CALC_REQ |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ADJUSTED_EFC_CALC_REQUEST |
NO |
|
| RCRAPP3_AIDY_CODE |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
AID_YEAR |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_1 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE1_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_2 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE2_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_3 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE3_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_4 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE4_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_5 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE5_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_6 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE6_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_7 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE7_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_8 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE8_IND |
NO |
|
| RCRAPP3_ASSUMPT_OVRD_9 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
ASSUMPTION_OVERRIDE9_IND |
NO |
|
| RCRAPP3_CHILD_CARE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
CHILD_CARE_NUMBER |
NO |
|
| RCRAPP3_CHILD_SUPP_PAID |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
CHILD_SUPPORT_PAID |
NO |
|
| RCRAPP3_CO_OP_EARNINGS |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_C_SIGNED_MTH_DAY |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
APPLICATION_COMPLETE_MONTH_DAY |
NO |
|
| RCRAPP3_C_SIGNED_YR |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
APPLICATION_COMPLETE_YEAR |
NO |
|
| RCRAPP3_DEGREE_TYPE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
DEGREE_TYPE |
NO |
|
| RCRAPP3_EDUC_CREDITS |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_EFC_RECALC_CORR_REQ |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_FAA_DEP_OVERRIDE |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
DEPENDENCY_OVERRIDE |
NO |
|
| RCRAPP3_FAA_TITLE_IV_CODE |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FEDERAL_SCHOOL_CODE |
NO |
|
| RCRAPP3_FARM_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
BUSINESS_DEBT |
NO |
|
| RCRAPP3_FARM_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
BUSINESS_VALUE |
NO |
|
| RCRAPP3_FATHER_AGE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FATHER_AGE |
NO |
|
| RCRAPP3_FATHER_HI_GRADE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FATHER_HIGHEST_GRADE |
NO |
|
| RCRAPP3_FATH_SSN_MATCH |
RNANAXX RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
FATHER_TAX_ID_MATCH |
NO |
|
| RCRAPP3_FED_COLL_CHOICE_10 |
RNASUXX |
NO |
|
|
|
|
|
| RCRAPP3_FED_COLL_CHOICE_4 |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
COLLEGE_CHOICE4 |
NO |
|
| RCRAPP3_FED_COLL_CHOICE_5 |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
COLLEGE_CHOICE5 |
NO |
|
| RCRAPP3_FED_COLL_CHOICE_6 |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
COLLEGE_CHOICE6 |
NO |
|
| RCRAPP3_FED_COLL_CHOICE_7 |
RNASUXX |
NO |
|
|
|
|
|
| RCRAPP3_FED_COLL_CHOICE_8 |
RNASUXX |
NO |
|
|
|
|
|
| RCRAPP3_FED_COLL_CHOICE_9 |
RNASUXX |
NO |
|
|
|
|
|
| RCRAPP3_GRANT_SCHOLAR_AID |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_HOUSE_FOOD_OTH |
RNAPRXX |
NO |
|
|
|
|
|
| RCRAPP3_INFC_CODE |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
INTERFACE_TAPE_CODE |
NO |
|
| RCRAPP3_INVEST_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
INVESTMENT_DEBT |
NO |
|
| RCRAPP3_INVEST_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
INVESTMENT_VALUE |
NO |
|
| RCRAPP3_IRS_AGI_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
IRS_AGI_FLAG |
NO |
|
| RCRAPP3_IRS_DISPLAY_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
IRS_DISPLAY_FLAG |
NO |
|
| RCRAPP3_IRS_FIT_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
IRS_FIT_FLAG |
NO |
|
| RCRAPP3_IRS_REQUEST_FLAG |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_MOTHER_AGE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MOTHER_AGE |
NO |
|
| RCRAPP3_MOTHER_HI_GRADE |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MOTHER_HIGHEST_GRADE |
NO |
|
| RCRAPP3_MOTH_SSN_MATCH |
RNANAXX RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MOTHER_TAX_ID_MATCH |
NO |
|
| RCRAPP3_NEED_BASED_EMPLOY |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_BUS_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_BUSINESS_DEBT |
NO |
|
| RCRAPP3_PAR_BUS_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_BUSINESS_VALUE |
NO |
|
| RCRAPP3_PAR_CHILD_SUPP_PAID |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_CHILD_SUPPORT_PAID |
NO |
|
| RCRAPP3_PAR_CO_OP_EARNINGS |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_EDUC_CREDITS |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_EIC |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_EARNED_INCOME_CREDIT |
NO |
|
| RCRAPP3_PAR_FARM_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_FARM_DEBT |
NO |
|
| RCRAPP3_PAR_FARM_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_FARM_VALUE |
NO |
|
| RCRAPP3_PAR_FOR_INC_EXCL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_FOREIGN_INC_EXCLUSION |
NO |
|
| RCRAPP3_PAR_GRANT_SCHOLAR_AID |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_HOUSE_FOOD_OTH |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_HOUSING_FOOD_ALLOWANCE |
NO |
|
| RCRAPP3_PAR_INC_BENEFITS |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_TOTAL_UNTAXED_INCOME |
NO |
|
| RCRAPP3_PAR_INVEST_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_INVESTMENT_DEBT |
NO |
|
| RCRAPP3_PAR_INVEST_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_INVESTMENT_VALUE |
NO |
|
| RCRAPP3_PAR_IRA_KEOUGH |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_RETIREMENT_PLAN_PAYMENT |
NO |
|
| RCRAPP3_PAR_IRS_AGI_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_IRS_AGI_FLAG |
NO |
|
| RCRAPP3_PAR_IRS_DISPLAY_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_IRS_DISPLAY_FLAG |
NO |
|
| RCRAPP3_PAR_IRS_FIT_FLAG |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_IRS_FIT_FLAG |
NO |
|
| RCRAPP3_PAR_IRS_REQUEST_FLAG |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_MAR_MTH_YR |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_MARITAL_STATUS_DATE |
NO |
|
| RCRAPP3_PAR_MTH_MORT_RENT_PAY |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_MORTGAGE_RENT_PAYMENT |
NO |
|
| RCRAPP3_PAR_NEED_BASED_EMPLOY |
RNAPRXX RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_PAR_RE_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_REAL_ESTATE_DEBT |
NO |
|
| RCRAPP3_PAR_RE_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_REAL_ESTATE_VALUE |
NO |
|
| RCRAPP3_PAR_TAX_DEF_PENSION |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_TAX_DEFERRED_PENSION |
NO |
|
| RCRAPP3_PAR_TE_INT_INC |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PARENT_TAX_EXEMPT_INTEREST_INC |
NO |
|
| RCRAPP3_PAR_TUI_FEE_DED |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
IM_PARENT_TUITION_FEE_DEDUCT |
NO |
|
| RCRAPP3_PIDM |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PERSON_UID |
NO |
|
| RCRAPP3_PREPARER_EIN |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PREPARER_EIN |
NO |
|
| RCRAPP3_PREPARER_SSN |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
PREPARER_TAX_ID |
NO |
|
| RCRAPP3_REJECT_OVRD_1 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE_B_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_2 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE2_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_20 |
RNIMSXX |
NO |
|
|
|
|
|
| RCRAPP3_REJECT_OVRD_21 |
RNIMSXX |
NO |
|
|
|
|
|
| RCRAPP3_REJECT_OVRD_3 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE3_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_4 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE_N_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_5 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE5_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_6 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE_W_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_7 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECTION_OVERRIDE7_IND |
NO |
|
| RCRAPP3_REJECT_OVRD_B |
RNIMSXX |
NO |
|
|
|
|
|
| RCRAPP3_REJECT_OVRD_N |
RNIMSXX |
NO |
|
|
|
|
|
| RCRAPP3_REJECT_OVRD_W |
RNIMSXX |
NO |
|
|
|
|
|
| RCRAPP3_REJ_REASON_PRTY_1 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_1 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_10 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_10 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_11 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_11 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_12 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_12 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_13 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_13 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_14 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_14 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_2 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_2 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_3 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_3 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_4 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_4 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_5 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_5 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_6 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_6 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_7 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_7 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_8 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_8 |
NO |
|
| RCRAPP3_REJ_REASON_PRTY_9 |
RNIMSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REJECT_REASON_PRIORITY_9 |
NO |
|
| RCRAPP3_RE_DBT |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REAL_ESTATE_DEBT |
NO |
|
| RCRAPP3_RE_VAL |
RNAPRXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
REAL_ESTATE_VALUE |
NO |
|
| RCRAPP3_SEQ_NO |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
APPLICATION_NUMBER |
NO |
|
| RCRAPP3_SOC_SEC |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
TAX_ID_MATCH_STATUS |
NO |
|
| RCRAPP3_SPEC_CIRCUM_FLAG |
RNANAXX |
NO |
|
|
|
|
|
| RCRAPP3_S_MAR_MTH_YR |
RNANAXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
MARITAL_STATUS_DATE |
NO |
|
| RCRAPP3_TAX_DEF_PENSION |
RNAPRXX |
NO |
|
|
|
|
|
| RCRAPP3_TE_INT_INC |
RNAPRXX |
NO |
|
|
|
|
|
| RCRAPP3_USER_ID |
RNARSXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
USER_ID |
NO |
|
| RCRAPP3_YR_IN_COLL_2 |
RNASUXX |
NO |
COMPOSITE VIEW |
AR_FINAID_APPLICATION3 |
YEAR_IN_COLLEGE2 |
NO |
|