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