Composite View Source: RCRAPP4

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RCRAPP4 Financial Aid

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
RCRAPP4_ACTIVITY_DATE	NA	COMPOSITE VIEW	AR_FINAID_APPLICATION4	ACTIVITY_DATE
RCRAPP4_ADDRESS_CHG_FLAG	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	ADDRESS_CHANGE
RCRAPP4_AIDY_CODE	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	AID_YEAR
RCRAPP4_BUS_NET_WORTH	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	BUSINESS_NET_WORTH
RCRAPP4_CUSTODIAL_PARENT	RNASUXX RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_CUSTODIAL_PARENT
RCRAPP4_C_1_OTH_ASSET	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_EST_OTHER_ASSET
RCRAPP4_C_2_OTH_ASSET	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_OTHER_ASSET_OVR
RCRAPP4_C_2_OTH_ASSET_ALLOW	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_OTHER_ASSET_ALLOW_OVR
RCRAPP4_C_2_TRUST_VAL	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_TRUST_AMOUNT
RCRAPP4_C_INST_1_TOT_FAM_CTRB	RCRAPP4	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_TOTAL_FAMILY_CONTRIBUTION	NA
RCRAPP4_C_NA_1_CTRB_FOR_STDT	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_CONTRIBUTION_OFFICIAL_AMT
RCRAPP4_C_NA_1_IM_CTRB_STDT	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_CONTRIBUTION_AMOUNT
RCRAPP4_C_NA_1_PELL_OFFL_EST	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PELL_EFC_OFFICIAL_ESTIMATE
RCRAPP4_C_NA_1_PELL_PGI	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PELL_EFFECTIVE_FAMILY_CONT
RCRAPP4_C_NA_1_P_CTRB_FOR_STDT	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_CONTRIB_OFFICIAL_AMT
RCRAPP4_C_NA_1_P_CTRB_OFFL_EST	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_CONTRIB_OFFICIAL_EST
RCRAPP4_C_NA_1_P_IM_CTRB_STDT	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_PARENT_CONTRIBUTION_AMOUNT
RCRAPP4_C_PAR_1_INC_ADJ	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_EST_INCOME_ADJUST
RCRAPP4_C_PAR_1_OTH_ALLOW	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_EST_OTH_INCOME_ALLOW
RCRAPP4_C_PAR_1_OTH_ASSET	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_EST_OTHER_ASSET
RCRAPP4_C_PAR_2_OTH_ASSET_ALLW	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_PARENT_OTH_ASSET_ALLOW_OVR
RCRAPP4_DEATH_DATE	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	DEATH_DATE
RCRAPP4_DRUG_OFFENSE_CONVIC	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	AID_ELIGIBILITY_RESPONSE
RCRAPP4_EFC_CHANGE_IND	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	EFC_CHANGE_FLAG
RCRAPP4_EMAIL_ADDRESS	RNANAXX RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	EMAIL_ADDRESS
RCRAPP4_EXP_PAR_NO_CHILD_TUIT	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_EXP_NO_CHILD_TUITION_PD
RCRAPP4_EXP_PAR_TUIT_PD	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_EXPECTED_TUITION_PAID
RCRAPP4_FATH_BIRTH_DATE	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FATHER_BIRTH_DATE
RCRAPP4_FATH_FIRST_NAME_INI	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FATHER_FIRST_INITIAL
RCRAPP4_FATH_LAST_NAME	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FATHER_LAST_NAME
RCRAPP4_FATH_SSN	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FATHER_TAX_ID
RCRAPP4_FEE_WAIVER_IND	RNASUXX
RCRAPP4_FISAP_INC	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FISAP_TOTAL_INCOME
RCRAPP4_FM_PAR_DATA_AVAIL	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_DATA_AVAILABLE_IND
RCRAPP4_FORMULA_FOR_CALC	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_FORMULA
RCRAPP4_HME_PURCH_AMT	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	HOME_AMOUNT_PAID
RCRAPP4_HME_YR_PURCH	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	HOME_YEAR_PURCHASED
RCRAPP4_IM_BUDG_DUR_FOR_CALC	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_BUDGET_DURATION
RCRAPP4_IM_PAR_DATA_AVAIL	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	IM_PARENT_DATA_AVAILABLE_IND
RCRAPP4_INFC_CODE	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	INTERFACE_TAPE_CODE
RCRAPP4_INV_NET_WORTH	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	INVESTMENT_NET_WORTH
RCRAPP4_MOTH_BIRTH_DATE	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MOTHER_BIRTH_DATE
RCRAPP4_MOTH_FIRST_NAME_INI	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MOTHER_FIRST_INITIAL
RCRAPP4_MOTH_LAST_NAME	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MOTHER_LAST_NAME
RCRAPP4_MOTH_SSN	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MOTHER_TAX_ID
RCRAPP4_NSLDS_MATCH	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	NATIONAL_STUDENT_LOAN_SYSTEM
RCRAPP4_PAR_BUS_NET_WORTH	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_BUSINESS_NET_WORTH
RCRAPP4_PAR_DEP_CARE_AND_MED	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_DEPEND_CARE_MED_ACCOUNT
RCRAPP4_PAR_INV_NET_WORTH	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_INVESTMENT_NET_WORTH
RCRAPP4_PAR_TX_RET_FILED_IND	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_TAX_RETURN_FILED
RCRAPP4_PAR_WORKSHEET_A	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_PARENT_WORKSHEET_A_TOTAL
RCRAPP4_PAR_WORKSHEET_B	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_WORKSHEET_B_TOTAL
RCRAPP4_PAR_WORKSHEET_C	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_WORKSHEET_C_TOTAL
RCRAPP4_PIDM	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PERSON_UID
RCRAPP4_P_EMAIL_ADDRESS	RNANAXX RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PARENT_EMAIL_ADDRESS
RCRAPP4_SAR_EFC	RCRAPP4	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SAR_EFC	NA
RCRAPP4_SEC_INS_MATCH_IND	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	PERM_RESIDENCY_VER_STATUS
RCRAPP4_SEQ_NO	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	APPLICATION_NUMBER
RCRAPP4_SOURCE_CORRECTION	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	CORRECTION_SOURCE
RCRAPP4_SSA_CITIZEN_IND	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	CITIZENSHIP_TYPE
RCRAPP4_SS_MATCH	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MILITARY_REGISTRATION_STATUS
RCRAPP4_SS_REG_FLAG	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	MILITARY_REG_REQ_STATUS
RCRAPP4_SUB_VERIF_SELECTED	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	SUBSEQUENT_RECORD_SELECTED_VER
RCRAPP4_S_DIV_INT_INC	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	DIVIDEND_INCOME
RCRAPP4_TX_RET_FILED_IND	RNAPRXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	TAX_RETURN_FILED
RCRAPP4_TYPE_DATA_AVAIL	RNINAIQ	COMPOSITE VIEW	AR_FINAID_APPLICATION4	DATA_TYPE_AVAILABLE
RCRAPP4_USER_ID	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	USER_ID
RCRAPP4_VA_MATCH_FLAG	RNARSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	VETERAN_MATCH_STATUS
RCRAPP4_VERIF_NUM	RNIMSXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	VERIFICATION_NUMBER
RCRAPP4_VISA_CLASS	RNASUXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	VISA_CLASSIFICATION
RCRAPP4_WORKSHEET_A	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	FM_WORKSHEET_A_TOTAL
RCRAPP4_WORKSHEET_B	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	WORKSHEET_B_TOTAL
RCRAPP4_WORKSHEET_C	RNAPRXX RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICATION4	WORKSHEET_C_TOTAL

Ver: 8.1