| Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
|---|
| RCRESAR_ACTIVITY_DATE |
NA |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ACTIVITY_DATE |
|
| RCRESAR_AGENCY_IND |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
APPLICATION_SOURCE_SITE |
|
| RCRESAR_AIDY_CODE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
AID_YEAR |
|
| RCRESAR_ALT_1_FC_01_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH1_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_02_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH2_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_03_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH3_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_04_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH4_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_05_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH5_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_06_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH6_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_07_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH7_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_08_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH8_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_10_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH10_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_11_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH11_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_1_FC_12_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH12_FAMILY_CONTRIB_PRIMARY |
|
| RCRESAR_ALT_2_FC_01_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH1_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_02_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH2_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_03_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH3_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_04_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH4_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_05_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH5_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_06_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH6_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_07_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH7_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_08_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH8_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_10_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH10_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_11_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH11_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_ALT_2_FC_12_MTH_CALC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MONTH12_FAMILY_CONTRIB_SECOND |
|
| RCRESAR_AUTO_ZERO_EFC_FLAG |
RNIMSXX |
|
|
|
|
| RCRESAR_A_CITZ_IND |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_CITIZENSHIP |
|
| RCRESAR_A_FAM_MEMB |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FAMILY_SIZE |
|
| RCRESAR_A_FATH_INC_FR_WRK |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FATHER_ASSUMED_INCOME_WORK |
|
| RCRESAR_A_FATH_SSN |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FATHER_ASSUMED_TAX_ID |
|
| RCRESAR_A_HAVE_CHILDREN |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_SUPPORT_CHILD |
|
| RCRESAR_A_INC_FR_WRK |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_INCOME_WORK |
|
| RCRESAR_A_MOTH_INC_FR_WRK |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MOTHER_ASSUMED_INCOME_WORK |
|
| RCRESAR_A_MOTH_SSN |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MOTHER_ASSUMED_TAX_ID |
|
| RCRESAR_A_NO_IN_COLL |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FAMILY_IN_COLLEGE |
|
| RCRESAR_A_PAR_FAM_MEMB |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PARENT_FAMILY_SIZE |
|
| RCRESAR_A_PAR_INC_TAX_PD_IND |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PARENT_ASSUMED_INCOME_TAX_PAID |
|
| RCRESAR_A_PAR_NO_IN_COLL |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PARENT_FAMILY_IN_COLLEGE |
|
| RCRESAR_A_PAR_US_INC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PARENT_ASSUMED_AGI |
|
| RCRESAR_A_P_WORKSHEET_C |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PARENT_ASSUMED_WORKSHEET_C_TOT |
|
| RCRESAR_A_SPS_INC_FR_WRK |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
SPOUSE_ASSUMED_INCOME_WORK |
|
| RCRESAR_A_S_FIT |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_INCOME_TAX_PAID |
|
| RCRESAR_A_S_WORKSHEET_C |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_WORKSHEET_C_TOT |
|
| RCRESAR_A_US_INC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ASSUMED_AGI |
|
| RCRESAR_A_VA_STATUS |
RNIMSXX |
|
|
|
|
| RCRESAR_BATCH_ID |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
BATCH_ID |
|
| RCRESAR_COMM_CODE_01 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT1 |
|
| RCRESAR_COMM_CODE_02 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT2 |
|
| RCRESAR_COMM_CODE_03 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT3 |
|
| RCRESAR_COMM_CODE_04 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT4 |
|
| RCRESAR_COMM_CODE_05 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT5 |
|
| RCRESAR_COMM_CODE_06 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT6 |
|
| RCRESAR_COMM_CODE_07 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT7 |
|
| RCRESAR_COMM_CODE_08 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT8 |
|
| RCRESAR_COMM_CODE_09 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT9 |
|
| RCRESAR_COMM_CODE_10 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT10 |
|
| RCRESAR_COMM_CODE_11 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT11 |
|
| RCRESAR_COMM_CODE_12 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT12 |
|
| RCRESAR_COMM_CODE_13 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT13 |
|
| RCRESAR_COMM_CODE_14 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT14 |
|
| RCRESAR_COMM_CODE_15 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT15 |
|
| RCRESAR_COMM_CODE_16 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT16 |
|
| RCRESAR_COMM_CODE_17 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT17 |
|
| RCRESAR_COMM_CODE_18 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT18 |
|
| RCRESAR_COMM_CODE_19 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT19 |
|
| RCRESAR_COMM_CODE_20 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMMENT20 |
|
| RCRESAR_COMPUTE_BATCH_NO |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
COMPUTED_BATCH_NUMBER |
|
| RCRESAR_CORR_APPL |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
CORRECTION_APPLIED_TRANS_NO |
|
| RCRESAR_EDE_ETI_IND |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
ISIR_ELECT_TRANSACTION |
|
| RCRESAR_ETI_DEST_CODE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
DESTINATION_NUMBER |
|
| RCRESAR_FED_HOUS_CDE_1 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING1 |
|
| RCRESAR_FED_HOUS_CDE_2 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING2 |
|
| RCRESAR_FED_HOUS_CDE_3 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING3 |
|
| RCRESAR_FED_HOUS_CDE_4 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING4 |
|
| RCRESAR_FED_HOUS_CDE_5 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING5 |
|
| RCRESAR_FED_HOUS_CDE_6 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
FEDERAL_HOUSING6 |
|
| RCRESAR_INFC_CODE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
INTERFACE_TAPE_CODE |
|
| RCRESAR_INPUT_REC_TYPE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
INPUT_RECORD_TYPE |
|
| RCRESAR_MDE_SITE_CD |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
TRANSACTION_SITE_SOURCE |
|
| RCRESAR_M_SCHOOL_FLAG_1 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG1 |
|
| RCRESAR_M_SCHOOL_FLAG_2 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG2 |
|
| RCRESAR_M_SCHOOL_FLAG_3 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG3 |
|
| RCRESAR_M_SCHOOL_FLAG_4 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG4 |
|
| RCRESAR_M_SCHOOL_FLAG_5 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG5 |
|
| RCRESAR_M_SCHOOL_FLAG_6 |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
MULTI_SCHOOL_FLAG6 |
|
| RCRESAR_PAID_EFC |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PELL_PAID_EFC |
|
| RCRESAR_PELL_ELGBL |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PELL_ELIGIBLE_IND |
|
| RCRESAR_PIDM |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PERSON_UID |
|
| RCRESAR_REC_TYPE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
PROCESSED_RECORD_TYPE |
|
| RCRESAR_RE_PROC_REA_CD |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
REPROCESSED_REASON |
|
| RCRESAR_SEC_EFC_TYPE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
SECONDARY_EFC_TYPE |
|
| RCRESAR_SEQ_NO |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
APPLICATION_NUMBER |
|
| RCRESAR_TRAN_RECEIPT_DATE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
TRANSACTION_RECEIPT_DATE |
|
| RCRESAR_TRAN_TYPE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
TRANSACTION_TYPE |
|
| RCRESAR_USER_ID |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
USER_ID |
|
| RCRESAR_VERIF_TYPE |
RNIMSXX |
REPORTING VIEW |
NEED_ANALYSIS_ISIR_SPECIFIC |
VERIFICATION_TYPE |
|