Reporting View Source: RCRAPP4

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: RCRAPP4 Financial Aid Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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_AIDY_CODE	RNARSXX
RCRAPP4_BUS_NET_WORTH	RNAPRXX RNANAXX
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 NEED_ANALYSIS_FEDERAL_METHOD	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_DRUG_OFFENSE_CONVIC	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	AID_ELIGIBILITY_RESPONSE
RCRAPP4_EFC_CHANGE_IND	RNIMSXX
RCRAPP4_EMAIL_ADDRESS	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	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
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_FEE_WAIVER_IND	RNASUXX
RCRAPP4_FISAP_INC	RNINAIQ
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_HME_PURCH_AMT	RNAPRXX
RCRAPP4_HME_YR_PURCH	RNAPRXX
RCRAPP4_IM_BUDG_DUR_FOR_CALC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_BUDGET_DURATION
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
RCRAPP4_MOTH_BIRTH_DATE	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	MOTHER_BIRTH_DATE
RCRAPP4_MOTH_FIRST_NAME_INI	RNANAXX
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_NSLDS_MATCH	RNANAXX
RCRAPP4_PAR_BUS_NET_WORTH	RNAPRXX RNANAXX
RCRAPP4_PAR_DEP_CARE_AND_MED	RNAPRXX
RCRAPP4_PAR_INV_NET_WORTH	RNAPRXX RNANAXX
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_PIDM	RNARSXX
RCRAPP4_P_EMAIL_ADDRESS	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_EMAIL_ADDRESS
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
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_SUB_VERIF_SELECTED	RNARSXX
RCRAPP4_S_DIV_INT_INC	RNAPRXX
RCRAPP4_TX_RET_FILED_IND	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	TAX_RETURN_FILED
RCRAPP4_TYPE_DATA_AVAIL	RNINAIQ
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_VISA_CLASS	RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	VISA_CLASSIFICATION
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

Ver: 8.1