Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
RCRAPP3_ACTIVITY_DATE |
NA |
NO |
|
|
|
|
|
RCRAPP3_ADJ_EFC_CALC_REQ |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
ADJUSTED_EFC_CALC_REQUEST ADJUSTED_EFC_CALC_REQUEST |
NO NO |
|
RCRAPP3_AIDY_CODE |
RNARSXX |
NO |
|
|
|
|
|
RCRAPP3_ASSUMPT_OVRD_1 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE1_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_2 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE2_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_3 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE3_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_4 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE4_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_5 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE5_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_6 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE6_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_7 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE7_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_8 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE8_IND |
NO |
|
RCRAPP3_ASSUMPT_OVRD_9 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ASSUMPTION_OVERRIDE9_IND |
NO |
|
RCRAPP3_CHILD_CARE |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
CHILD_CARE_NUMBER |
NO |
|
RCRAPP3_CHILD_SUPP_PAID |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
CHILD_SUPPORT_PAID |
NO |
|
RCRAPP3_CO_OP_EARNINGS |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
COOPERATIVE_EARNINGS |
NO |
|
RCRAPP3_C_SIGNED_MTH_DAY |
RNASUXX |
NO |
|
|
|
|
|
RCRAPP3_C_SIGNED_YR |
RNASUXX |
NO |
|
|
|
|
|
RCRAPP3_DEGREE_TYPE |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
DEGREE_TYPE DEGREE_TYPE |
NO NO |
|
RCRAPP3_EDUC_CREDITS |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
EDUCATION_TAX_CREDIT |
NO |
|
RCRAPP3_EFC_RECALC_CORR_REQ |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
EFC_RECALC_SPECIAL_CIRCUM EFC_RECALC_SPECIAL_CIRCUM |
NO NO |
|
RCRAPP3_FAA_DEP_OVERRIDE |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
DEPENDENCY_OVERRIDE DEPENDENCY_OVERRIDE |
NO NO |
|
RCRAPP3_FAA_TITLE_IV_CODE |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
FEDERAL_SCHOOL_CODE FEDERAL_SCHOOL_CODE |
NO NO |
|
RCRAPP3_FARM_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_FARM_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_FATHER_AGE |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_FATHER_HI_GRADE |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
FATHER_HIGHEST_GRADE |
NO |
|
RCRAPP3_FATH_SSN_MATCH |
RNANAXX RNARSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FATHER_TAX_ID_MATCH |
NO |
|
RCRAPP3_FED_COLL_CHOICE_10 |
RNASUXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS_DEMOGRAPHIC |
COLLEGE_CHOICE10 COLLEGE_CHOICE10 COLLEGE_CHOICE10 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_4 |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS NEED_ANALYSIS_ISIR_SPECIFIC |
COLLEGE_CHOICE4 COLLEGE_CHOICE4 COLLEGE_CHOICE4 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_5 |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS |
COLLEGE_CHOICE5 COLLEGE_CHOICE5 COLLEGE_CHOICE5 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_6 |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
COLLEGE_CHOICE6 COLLEGE_CHOICE6 COLLEGE_CHOICE6 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_7 |
RNASUXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_ISIR_SPECIFIC |
COLLEGE_CHOICE7 COLLEGE_CHOICE7 COLLEGE_CHOICE7 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_8 |
RNASUXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS_DEMOGRAPHIC |
COLLEGE_CHOICE8 COLLEGE_CHOICE8 COLLEGE_CHOICE8 |
NO NO NO |
|
RCRAPP3_FED_COLL_CHOICE_9 |
RNASUXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS NEED_ANALYSIS_ISIR_SPECIFIC |
COLLEGE_CHOICE9 COLLEGE_CHOICE9 COLLEGE_CHOICE9 |
NO NO NO |
|
RCRAPP3_GRANT_SCHOLAR_AID |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
GRANT_SCHOLARSHIP_AID |
NO |
|
RCRAPP3_HOUSE_FOOD_OTH |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
HOUSING_FOOD_ALLOWANCE |
NO |
|
RCRAPP3_INFC_CODE |
RNARSXX |
NO |
|
|
|
|
|
RCRAPP3_INVEST_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_INVEST_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_IRS_AGI_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
IRS_AGI_FLAG IRS_AGI_FLAG |
NO NO |
|
RCRAPP3_IRS_DISPLAY_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
IRS_DISPLAY_FLAG |
NO |
|
RCRAPP3_IRS_FIT_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
IRS_FIT_FLAG IRS_FIT_FLAG |
NO NO |
|
RCRAPP3_IRS_REQUEST_FLAG |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
IRS_REQUEST_STATUS IRS_REQUEST_STATUS |
NO NO |
|
RCRAPP3_MOTHER_AGE |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_MOTHER_HI_GRADE |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
MOTHER_HIGHEST_GRADE |
NO |
|
RCRAPP3_MOTH_SSN_MATCH |
RNANAXX RNARSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MOTHER_TAX_ID_MATCH |
NO |
|
RCRAPP3_NEED_BASED_EMPLOY |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
NEED_BASED_EMPLOYMENT |
NO |
|
RCRAPP3_PAR_BUS_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_BUS_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_CHILD_SUPP_PAID |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_CHILD_SUPPORT_PAID |
NO |
|
RCRAPP3_PAR_CO_OP_EARNINGS |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_COOPERATIVE_EARNINGS |
NO |
|
RCRAPP3_PAR_EDUC_CREDITS |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_EDUCATION_TAX_CREDIT |
NO |
|
RCRAPP3_PAR_EIC |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_FARM_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_FARM_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_FOR_INC_EXCL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_GRANT_SCHOLAR_AID |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_GRANT_SCHOLARSHIP_AID |
NO |
|
RCRAPP3_PAR_HOUSE_FOOD_OTH |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_HOUSING_FOOD_ALLOWANCE |
NO |
|
RCRAPP3_PAR_INC_BENEFITS |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_INVEST_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_INVEST_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_IRA_KEOUGH |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_RETIREMENT_PLAN_PAYMENT |
NO |
|
RCRAPP3_PAR_IRS_AGI_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_IRS_AGI_FLAG PARENT_IRS_AGI_FLAG |
NO NO |
|
RCRAPP3_PAR_IRS_DISPLAY_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_IRS_DISPLAY_FLAG |
NO |
|
RCRAPP3_PAR_IRS_FIT_FLAG |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_IRS_FIT_FLAG PARENT_IRS_FIT_FLAG |
NO NO |
|
RCRAPP3_PAR_IRS_REQUEST_FLAG |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_IRS_REQUEST_STATUS PARENT_IRS_REQUEST_STATUS |
NO NO |
|
RCRAPP3_PAR_MAR_MTH_YR |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_MARITAL_STATUS_DATE |
NO |
|
RCRAPP3_PAR_MTH_MORT_RENT_PAY |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_NEED_BASED_EMPLOY |
RNAPRXX RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_NEED_BASED_EMPLOYMENT |
NO |
|
RCRAPP3_PAR_RE_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_RE_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PAR_TAX_DEF_PENSION |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_TAX_DEFERRED_PENSION |
NO |
|
RCRAPP3_PAR_TE_INT_INC |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_TAX_EXEMPT_INTEREST_INC |
NO |
|
RCRAPP3_PAR_TUI_FEE_DED |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_PIDM |
RNARSXX |
NO |
|
|
|
|
|
RCRAPP3_PREPARER_EIN |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PREPARER_EIN |
NO |
|
RCRAPP3_PREPARER_SSN |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PREPARER_TAX_ID |
NO |
|
RCRAPP3_REJECT_OVRD_1 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE_B_IND REJECTION_OVERRIDE_B_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_2 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE2_IND REJECTION_OVERRIDE2_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_20 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE20_IND REJECTION_OVERRIDE20_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_21 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
REJECTION_OVERRIDE21_IND REJECTION_OVERRIDE21_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_3 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE3_IND REJECTION_OVERRIDE3_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_4 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE4_IND REJECTION_OVERRIDE4_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_5 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE5_IND REJECTION_OVERRIDE5_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_6 |
RNIMSXX |
NO |
|
|
|
|
|
RCRAPP3_REJECT_OVRD_7 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
REJECTION_OVERRIDE7_IND REJECTION_OVERRIDE7_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_B |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC |
REJECTION_OVERRIDE_B_IND REJECTION_OVERRIDE_B_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_N |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
REJECTION_OVERRIDE_N_IND REJECTION_OVERRIDE_N_IND |
NO NO |
|
RCRAPP3_REJECT_OVRD_W |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
REJECTION_OVERRIDE_W_IND REJECTION_OVERRIDE_W_IND |
NO NO |
|
RCRAPP3_REJ_REASON_PRTY_1 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_1 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_10 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_10 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_11 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_11 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_12 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_12 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_13 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_13 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_14 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_14 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_2 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_2 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_3 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_3 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_4 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_4 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_5 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_5 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_6 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_6 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_7 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_7 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_8 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_8 |
NO |
|
RCRAPP3_REJ_REASON_PRTY_9 |
RNIMSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
REJECT_REASON_PRIORITY_9 |
NO |
|
RCRAPP3_RE_DBT |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_RE_VAL |
RNAPRXX |
NO |
|
|
|
|
|
RCRAPP3_SEQ_NO |
RNARSXX |
NO |
|
|
|
|
|
RCRAPP3_SOC_SEC |
RNARSXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
TAX_ID_MATCH_STATUS TAX_ID_MATCH_STATUS |
NO NO |
|
RCRAPP3_SPEC_CIRCUM_FLAG |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SPECIAL_CIRCUMSTANCE |
NO |
|
RCRAPP3_S_MAR_MTH_YR |
RNANAXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MARITAL_STATUS_DATE |
NO |
|
RCRAPP3_TAX_DEF_PENSION |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
TAX_DEFERRED_PENSION |
NO |
|
RCRAPP3_TE_INT_INC |
RNAPRXX |
NO |
REPORTING VIEW |
NEED_ANALYSIS |
TAX_EXEMPT_INTEREST_INC |
NO |
|
RCRAPP3_USER_ID |
RNARSXX |
NO |
|
|
|
|
|
RCRAPP3_YR_IN_COLL_2 |
RNASUXX |
NO |
|
|
|
|
|