| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
|---|
| RCRAPP4_ACTIVITY_DATE |
NA |
|
|
|
|
| RCRAPP4_ADDRESS_CHG_FLAG |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
ADDRESS_CHANGE |
|
| RCRAPP4_ADOPTED_AFTER_13 |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
ADOPTED_AFTER_13 |
|
| RCRAPP4_AIDY_CODE |
RNARSXX |
|
|
|
|
| RCRAPP4_BUS_NET_WORTH |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
BUSINESS_NET_WORTH |
|
| RCRAPP4_COMBAT_PAY |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
COMBAT_PAY |
|
| RCRAPP4_CUSTODIAL_PARENT |
RNASUXX RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_CUSTODIAL_PARENT |
|
| RCRAPP4_C_1_OTH_ASSET |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_EST_OTHER_ASSET |
|
| RCRAPP4_C_2_OTH_ASSET |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_OTHER_ASSET_OVR |
|
| RCRAPP4_C_2_OTH_ASSET_ALLOW |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_OTHER_ASSET_ALLOW_OVR |
|
| RCRAPP4_C_2_TRUST_VAL |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_TRUST_AMOUNT |
|
| RCRAPP4_C_INST_1_TOT_FAM_CTRB |
RCRAPP4 |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD NEED_ANALYSIS |
FM_TOTAL_FAMILY_CONTRIBUTION FM_TOTAL_FAMILY_CONTRIBUTION |
NA |
| RCRAPP4_C_NA_1_CTRB_FOR_STDT |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_CONTRIBUTION_OFFICIAL_AMT |
|
| RCRAPP4_C_NA_1_IM_CTRB_STDT |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_CONTRIBUTION_AMOUNT |
|
| RCRAPP4_C_NA_1_PELL_OFFL_EST |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
PELL_EFC_OFFICIAL_ESTIMATE |
|
| RCRAPP4_C_NA_1_PELL_PGI |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
PELL_EFFECTIVE_FAMILY_CONT |
|
| RCRAPP4_C_NA_1_P_CTRB_FOR_STDT |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_CONTRIB_OFFICIAL_AMT |
|
| RCRAPP4_C_NA_1_P_CTRB_OFFL_EST |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_CONTRIB_OFFICIAL_EST |
|
| RCRAPP4_C_NA_1_P_IM_CTRB_STDT |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_PARENT_CONTRIBUTION_AMOUNT |
|
| RCRAPP4_C_PAR_1_INC_ADJ |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_EST_INCOME_ADJUST |
|
| RCRAPP4_C_PAR_1_OTH_ALLOW |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_EST_OTH_INCOME_ALLOW |
|
| RCRAPP4_C_PAR_1_OTH_ASSET |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_EST_OTHER_ASSET |
|
| RCRAPP4_C_PAR_2_OTH_ASSET_ALLW |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_PARENT_OTH_ASSET_ALLOW_OVR |
|
| RCRAPP4_DEATH_DATE |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
DEATH_DATE |
|
| RCRAPP4_DOD_MATCH_FLAG |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
DOD_MATCH |
|
| RCRAPP4_DOD_PAR_DEATH_DATE |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
DOD_PARENT_DEATH_DATE |
|
| RCRAPP4_DRUG_OFFENSE_CONVIC |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
AID_ELIGIBILITY_RESPONSE |
|
| RCRAPP4_EFC_CHANGE_IND |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
EFC_CHANGE_FLAG |
|
| RCRAPP4_EFM_FORMULA_FOR_CALC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
EFM_DEPENDENCY_STATUS |
|
| RCRAPP4_EMAIL_ADDRESS |
RNANAXX RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS |
EMAIL_ADDRESS EMAIL_ADDRESS |
|
| RCRAPP4_EXP_PAR_NO_CHILD_TUIT |
RNAPRXX |
|
|
|
|
| RCRAPP4_EXP_PAR_TUIT_PD |
RNAPRXX |
|
|
|
|
| RCRAPP4_FATH_BIRTH_DATE |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FATHER_BIRTH_DATE |
|
| RCRAPP4_FATH_FIRST_NAME_INI |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FATHER_FIRST_INITIAL |
|
| RCRAPP4_FATH_LAST_NAME |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FATHER_LAST_NAME |
|
| RCRAPP4_FATH_SSN |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
FATHER_TAX_ID |
|
| RCRAPP4_FISAP_INC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD NEED_ANALYSIS |
FM_FISAP_TOTAL_INCOME FISAP_TOTAL_INCOME |
|
| RCRAPP4_FM_FORMULA_FOR_CALC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_DEPENDENCY_STATUS |
|
| RCRAPP4_FM_PAR_DATA_AVAIL |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_DATA_AVAILABLE_IND |
|
| RCRAPP4_FORMULA_FOR_CALC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_FEDERAL_METHOD |
FM_FORMULA |
|
| RCRAPP4_HIGH_SCHOOL_CITY |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SECONDARY_SCHOOL_CITY |
|
| RCRAPP4_HIGH_SCHOOL_FLG |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SECONDARY_SCHOOL_INVALID |
|
| RCRAPP4_HIGH_SCHOOL_NAME |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SECONDARY_SCHOOL_NAME |
|
| RCRAPP4_HIGH_SCH_CDE |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SECONDARY_SCHOOL |
|
| RCRAPP4_HME_PURCH_AMT |
RNAPRXX |
|
|
|
|
| RCRAPP4_HME_YR_PURCH |
RNAPRXX |
|
|
|
|
| RCRAPP4_HOMELESS |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
HOMELESS |
|
| RCRAPP4_IM_BUDG_DUR_FOR_CALC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_BUDGET_DURATION |
|
| RCRAPP4_IM_FORMULA_FOR_CALC |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_DEPENDENCY_STATUS |
|
| RCRAPP4_IM_PAR_DATA_AVAIL |
RNINAIQ |
REPORTING VIEW |
NEED_ANALYSIS_INST_METHOD |
IM_PARENT_DATA_AVAILABLE_IND |
|
| RCRAPP4_INFC_CODE |
RNARSXX |
|
|
|
|
| RCRAPP4_INV_NET_WORTH |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
INVESTMENT_NET_WORTH |
|
| RCRAPP4_IRA_KEOUGH_AMT |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
RETIREMENT_PLAN_PAYMENT |
|
| RCRAPP4_MOTH_BIRTH_DATE |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MOTHER_BIRTH_DATE |
|
| RCRAPP4_MOTH_FIRST_NAME_INI |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MOTHER_FIRST_INITIAL |
|
| RCRAPP4_MOTH_LAST_NAME |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MOTHER_LAST_NAME |
|
| RCRAPP4_MOTH_SSN |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MOTHER_TAX_ID |
|
| RCRAPP4_MSG_31 |
RNARSXX |
|
|
|
|
| RCRAPP4_MSG_72 |
RNARSXX |
|
|
|
|
| RCRAPP4_NSLDS_MATCH |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
NATIONAL_STUDENT_LOAN_SYSTEM |
|
| RCRAPP4_NSLDS_TRAN_NO |
RNARSXX |
|
|
|
|
| RCRAPP4_OLDEST_LOAN_DATE |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR1_EMPLOYER |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR1_OCCUPATION |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR2_EMPLOYER |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR2_OCCUPATION |
RNARSXX |
|
|
|
|
| RCRAPP4_PARENT_TYPE_1 |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_TYPE1 |
|
| RCRAPP4_PARENT_TYPE_2 |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_TYPE2 |
|
| RCRAPP4_PAR_BUS_NET_WORTH |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_BUSINESS_NET_WORTH |
|
| RCRAPP4_PAR_COMBAT_PAY |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_COMBAT_PAY |
|
| RCRAPP4_PAR_DEPENDENT_CARE |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_DPDNT_CARE_CONTRIBUTION |
|
| RCRAPP4_PAR_DEP_CARE_AND_MED |
RNAPRXX |
|
|
|
|
| RCRAPP4_PAR_FARM_NET_WORTH |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR_FSA_HEALTH_CARE |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_HEALTHCARE_CONTRIBUTION |
|
| RCRAPP4_PAR_HEALTH_SAV_ACCOUNT |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_HSA_CONTRIBUTION |
|
| RCRAPP4_PAR_HSA_PRE_TAX |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_HSA_PRETAX_CONTRIBUTION |
|
| RCRAPP4_PAR_INV_NET_WORTH |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_INVESTMENT_NET_WORTH |
|
| RCRAPP4_PAR_NUM_BUSINESSES |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_NUMBER_OF_BUSINESSES |
|
| RCRAPP4_PAR_NUM_FARMS |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_NUMBER_OF_FARMS |
|
| RCRAPP4_PAR_STATE_FOR_TAXES |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR_TAX_FILER |
RNARSXX |
|
|
|
|
| RCRAPP4_PAR_TX_RET_FILED_IND |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_TAX_RETURN_FILED |
|
| RCRAPP4_PAR_WORKSHEET_A |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_FEDERAL_METHOD |
FM_PARENT_WORKSHEET_A_TOTAL FM_PARENT_WORKSHEET_A_TOTAL |
|
| RCRAPP4_PAR_WORKSHEET_B |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_WORKSHEET_B_TOTAL |
|
| RCRAPP4_PAR_WORKSHEET_C |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_WORKSHEET_C_TOTAL |
|
| RCRAPP4_PELL_1_EFC |
RNARSXX |
|
|
|
|
| RCRAPP4_PELL_2_EFC |
RNARSXX |
|
|
|
|
| RCRAPP4_PIDM |
RNARSXX |
|
|
|
|
| RCRAPP4_PLUS_INT |
RNARSXX |
|
|
|
|
| RCRAPP4_PRISONER_MATCH_FLAG |
RNARSXX |
|
|
|
|
| RCRAPP4_P_ASSET_THRESH_EXCD |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
PARENT_ASSET_THRESHOLD_EXCEED |
|
| RCRAPP4_P_EMAIL_ADDRESS |
RNANAXX RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PARENT_EMAIL_ADDRESS |
|
| RCRAPP4_P_FARM_DBT_FAF |
RNARSXX |
|
|
|
|
| RCRAPP4_P_FARM_VAL_FAF |
RNARSXX |
|
|
|
|
| RCRAPP4_P_IV_INC |
RNARSXX |
|
|
|
|
| RCRAPP4_P_RES_DATE_MO_YR |
RNARSXX |
|
|
|
|
| RCRAPP4_RECORD_MARK |
RNARSXX |
|
|
|
|
| RCRAPP4_REC_TYPE |
RNARSXX |
|
|
|
|
| RCRAPP4_SAR_EFC |
RCRAPP4 |
REPORTING VIEW |
NEED_ANALYSIS |
SAR_EFC |
NA |
| RCRAPP4_SEC_INS_MATCH_IND |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
PERM_RESIDENCY_VER_STATUS |
|
| RCRAPP4_SEQ_NO |
RNARSXX |
|
|
|
|
| RCRAPP4_SOURCE_CORRECTION |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
CORRECTION_SOURCE |
|
| RCRAPP4_SSA_CITIZEN_IND |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
CITIZENSHIP_TYPE |
|
| RCRAPP4_SS_MATCH |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MILITARY_REGISTRATION_STATUS |
|
| RCRAPP4_SS_REG_FLAG |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
MILITARY_REG_REQ_STATUS |
|
| RCRAPP4_STATE_FOR_TAXES |
RNARSXX |
|
|
|
|
| RCRAPP4_STAT_CODE_HIGH_SCH |
RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SECONDARY_SCHOOL_STATE_PROV |
|
| RCRAPP4_SUB_VERIF_SELECTED |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
SUBSEQUENT_RECORD_SELECTED_VER |
|
| RCRAPP4_SURROGATE_ID |
RNARSXX |
|
|
|
|
| RCRAPP4_S_ASSET_THRESH_EXCD |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
ASSET_THRESHOLD_EXCEED |
|
| RCRAPP4_S_DIV_INT_INC |
RNAPRXX |
|
|
|
|
| RCRAPP4_S_EIC |
RNARSXX |
|
|
|
|
| RCRAPP4_S_FARM_DBT_FAF |
RNARSXX |
|
|
|
|
| RCRAPP4_S_FARM_VAL_FAF |
RNARSXX |
|
|
|
|
| RCRAPP4_S_IV_INC |
RNARSXX |
|
|
|
|
| RCRAPP4_S_RES_DATE_MO_YR |
RNARSXX |
|
|
|
|
| RCRAPP4_TAPE_RPT_EXTRCT_DATE |
RNARSXX |
|
|
|
|
| RCRAPP4_TAX_FILER |
RNARSXX |
|
|
|
|
| RCRAPP4_TX_RET_FILED_IND |
RNAPRXX |
REPORTING VIEW |
NEED_ANALYSIS |
TAX_RETURN_FILED |
|
| RCRAPP4_TYPE_DATA_AVAIL |
RNINAIQ |
|
|
|
|
| RCRAPP4_TYPE_FM_CALC |
RNARSXX |
|
|
|
|
| RCRAPP4_USER_ID |
RNIMSXX |
|
|
|
|
| RCRAPP4_VA_MATCH_FLAG |
RNARSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
VETERAN_MATCH_STATUS |
|
| RCRAPP4_VERIF_NUM |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
VERIFICATION_NUMBER |
|
| RCRAPP4_VERSION |
RNARSXX |
|
|
|
|
| RCRAPP4_VISA_CLASS |
RNASUXX |
REPORTING VIEW |
NEED_ANALYSIS_DEMOGRAPHIC |
VISA_CLASSIFICATION |
|
| RCRAPP4_VPDI_CODE |
RNARSXX |
|
|
|
|
| RCRAPP4_WORKSHEET_A |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS NEED_ANALYSIS_FEDERAL_METHOD |
FM_WORKSHEET_A_TOTAL FM_WORKSHEET_A_TOTAL |
|
| RCRAPP4_WORKSHEET_B |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
WORKSHEET_B_TOTAL |
|
| RCRAPP4_WORKSHEET_C |
RNAPRXX RNANAXX |
REPORTING VIEW |
NEED_ANALYSIS |
WORKSHEET_C_TOTAL |
|
| RCRAPP4_WRK_STDY_LOANS_INT |
RNARSXX |
|
|
|
|