Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RCRESAR Financial Aid
SGHE Banner Operational Data Store Composite View Source: RCRESAR - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
RCRESAR_ACTIVITY_DATE NA COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ACTIVITY_DATE

 
RCRESAR_AGENCY_IND RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

APPLICATION_SOURCE_SITE

 
RCRESAR_AIDY_CODE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

AID_YEAR

 
RCRESAR_ALT_1_FC_01_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH1_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_02_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH2_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_03_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH3_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_04_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH4_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_05_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH5_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_06_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH6_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_07_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH7_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_08_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH8_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_10_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH10_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_11_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH11_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_1_FC_12_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH12_FAMILY_CONTRIB_PRIMARY

 
RCRESAR_ALT_2_FC_01_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH1_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_02_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH2_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_03_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH3_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_04_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH4_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_05_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH5_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_06_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH6_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_07_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH7_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_08_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH8_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_10_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH10_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_11_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH11_FAMILY_CONTRIB_SECOND

 
RCRESAR_ALT_2_FC_12_MTH_CALC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MONTH12_FAMILY_CONTRIB_SECOND

 
RCRESAR_AUTO_ZERO_EFC_FLAG RNIMSXX        
RCRESAR_A_CITZ_IND RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_CITIZENSHIP

 
RCRESAR_A_FAM_MEMB RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FAMILY_SIZE

 
RCRESAR_A_FATH_INC_FR_WRK RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FATHER_ASSUMED_INCOME_WORK

 
RCRESAR_A_FATH_SSN RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FATHER_ASSUMED_TAX_ID

 
RCRESAR_A_HAVE_CHILDREN RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_SUPPORT_CHILD

 
RCRESAR_A_INC_FR_WRK RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_INCOME_WORK

 
RCRESAR_A_MOTH_INC_FR_WRK RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MOTHER_ASSUMED_INCOME_WORK

 
RCRESAR_A_MOTH_SSN RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MOTHER_ASSUMED_TAX_ID

 
RCRESAR_A_NO_IN_COLL RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FAMILY_IN_COLLEGE

 
RCRESAR_A_PAR_FAM_MEMB RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_FAMILY_SIZE

 
RCRESAR_A_PAR_INC_TAX_PD_IND RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_ASSUMED_INCOME_TAX_PAID

 
RCRESAR_A_PAR_NO_IN_COLL RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_FAMILY_IN_COLLEGE

 
RCRESAR_A_PAR_US_INC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_ASSUMED_AGI

 
RCRESAR_A_P_WORKSHEET_C RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PARENT_ASSUMED_WORKSHEET_C_TOT

 
RCRESAR_A_SPS_INC_FR_WRK RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

SPOUSE_ASSUMED_INCOME_WORK

 
RCRESAR_A_S_FIT RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_INCOME_TAX_PAID

 
RCRESAR_A_S_WORKSHEET_C RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_WORKSHEET_C_TOT

 
RCRESAR_A_US_INC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ASSUMED_AGI

 
RCRESAR_A_VA_STATUS RNIMSXX        
RCRESAR_BATCH_ID RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

BATCH_ID

 
RCRESAR_COMM_CODE_01 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT1

 
RCRESAR_COMM_CODE_02 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT2

 
RCRESAR_COMM_CODE_03 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT3

 
RCRESAR_COMM_CODE_04 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT4

 
RCRESAR_COMM_CODE_05 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT5

 
RCRESAR_COMM_CODE_06 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT6

 
RCRESAR_COMM_CODE_07 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT7

 
RCRESAR_COMM_CODE_08 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT8

 
RCRESAR_COMM_CODE_09 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT9

 
RCRESAR_COMM_CODE_10 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT10

 
RCRESAR_COMM_CODE_11 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT11

 
RCRESAR_COMM_CODE_12 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT12

 
RCRESAR_COMM_CODE_13 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT13

 
RCRESAR_COMM_CODE_14 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT14

 
RCRESAR_COMM_CODE_15 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT15

 
RCRESAR_COMM_CODE_16 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT16

 
RCRESAR_COMM_CODE_17 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT17

 
RCRESAR_COMM_CODE_18 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT18

 
RCRESAR_COMM_CODE_19 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT19

 
RCRESAR_COMM_CODE_20 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMMENT20

 
RCRESAR_COMPUTE_BATCH_NO RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

COMPUTED_BATCH_NUMBER

 
RCRESAR_CORR_APPL RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

CORRECTION_APPLIED_TRANS_NO

 
RCRESAR_EDE_ETI_IND RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

ISIR_ELECT_TRANSACTION

 
RCRESAR_ETI_DEST_CODE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

DESTINATION_NUMBER

 
RCRESAR_FED_HOUS_CDE_1 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING1

 
RCRESAR_FED_HOUS_CDE_2 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING2

 
RCRESAR_FED_HOUS_CDE_3 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING3

 
RCRESAR_FED_HOUS_CDE_4 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING4

 
RCRESAR_FED_HOUS_CDE_5 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING5

 
RCRESAR_FED_HOUS_CDE_6 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

FEDERAL_HOUSING6

 
RCRESAR_INFC_CODE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

INTERFACE_TAPE_CODE

 
RCRESAR_INPUT_REC_TYPE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

INPUT_RECORD_TYPE

 
RCRESAR_MDE_SITE_CD RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

TRANSACTION_SITE_SOURCE

 
RCRESAR_M_SCHOOL_FLAG_1 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG1

 
RCRESAR_M_SCHOOL_FLAG_2 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG2

 
RCRESAR_M_SCHOOL_FLAG_3 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG3

 
RCRESAR_M_SCHOOL_FLAG_4 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG4

 
RCRESAR_M_SCHOOL_FLAG_5 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG5

 
RCRESAR_M_SCHOOL_FLAG_6 RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

MULTI_SCHOOL_FLAG6

 
RCRESAR_PAID_EFC RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PELL_PAID_EFC

 
RCRESAR_PELL_ELGBL RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PELL_ELIGIBLE_IND

 
RCRESAR_PIDM RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PERSON_UID

 
RCRESAR_REC_TYPE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

PROCESSED_RECORD_TYPE

 
RCRESAR_RE_PROC_REA_CD RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

REPROCESSED_REASON

 
RCRESAR_SEC_EFC_TYPE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

SECONDARY_EFC_TYPE

 
RCRESAR_SEQ_NO RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

APPLICATION_NUMBER

 
RCRESAR_TRAN_RECEIPT_DATE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

TRANSACTION_RECEIPT_DATE

 
RCRESAR_TRAN_TYPE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

TRANSACTION_TYPE

 
RCRESAR_USER_ID RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

USER_ID

 
RCRESAR_VERIF_TYPE RNIMSXX COMPOSITE VIEW

AR_NEED_ANALYSIS_ISIR_SPEC

VERIFICATION_TYPE

 


Ver: 8.1