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_ADOPTED_AFTER_13	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	ADOPTED_AFTER_13
RCRAPP4_AIDY_CODE	RNARSXX
RCRAPP4_BUS_NET_WORTH	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	BUSINESS_NET_WORTH
RCRAPP4_COMBAT_PAY	RNANAXX	REPORTING VIEW	NEED_ANALYSIS	COMBAT_PAY
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_DOD_MATCH_FLAG	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DOD_MATCH
RCRAPP4_DOD_PAR_DEATH_DATE	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	DOD_PARENT_DEATH_DATE
RCRAPP4_DRUG_OFFENSE_CONVIC	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	AID_ELIGIBILITY_RESPONSE
RCRAPP4_EFC_CHANGE_IND	RNIMSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	EFC_CHANGE_FLAG
RCRAPP4_EFM_FORMULA_FOR_CALC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	EFM_DEPENDENCY_STATUS
RCRAPP4_EMAIL_ADDRESS	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS	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_FISAP_INC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_FISAP_TOTAL_INCOME
RCRAPP4_FM_FORMULA_FOR_CALC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_FEDERAL_METHOD	FM_DEPENDENCY_STATUS
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_HIGH_SCHOOL_CITY	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_CITY
RCRAPP4_HIGH_SCHOOL_FLG	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_INVALID
RCRAPP4_HIGH_SCHOOL_NAME	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_NAME
RCRAPP4_HIGH_SCH_CDE	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL
RCRAPP4_HME_PURCH_AMT	RNAPRXX
RCRAPP4_HME_YR_PURCH	RNAPRXX
RCRAPP4_HOMELESS	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	HOMELESS
RCRAPP4_IM_BUDG_DUR_FOR_CALC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_BUDGET_DURATION
RCRAPP4_IM_FORMULA_FOR_CALC	RNINAIQ	REPORTING VIEW	NEED_ANALYSIS_INST_METHOD	IM_DEPENDENCY_STATUS
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	REPORTING VIEW	NEED_ANALYSIS	INVESTMENT_NET_WORTH
RCRAPP4_IRA_KEOUGH_AMT	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	RETIREMENT_PLAN_PAYMENT
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	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	NATIONAL_STUDENT_LOAN_SYSTEM
RCRAPP4_PARENT_TYPE_1	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_TYPE1
RCRAPP4_PARENT_TYPE_2	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	PARENT_TYPE2
RCRAPP4_PAR_BUS_NET_WORTH	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_BUSINESS_NET_WORTH
RCRAPP4_PAR_COMBAT_PAY	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_COMBAT_PAY
RCRAPP4_PAR_DEP_CARE_AND_MED	RNAPRXX
RCRAPP4_PAR_INV_NET_WORTH	RNAPRXX RNANAXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_INVESTMENT_NET_WORTH
RCRAPP4_PAR_NUM_BUSINESSES	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_NUMBER_OF_BUSINESSES
RCRAPP4_PAR_NUM_FARMS	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_NUMBER_OF_FARMS
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_ASSET_THRESH_EXCD	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	PARENT_ASSET_THRESHOLD_EXCEED
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	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	CORRECTION_SOURCE
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_STAT_CODE_HIGH_SCH	RNANAXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SECONDARY_SCHOOL_STATE_PROV
RCRAPP4_SUB_VERIF_SELECTED	RNARSXX	REPORTING VIEW	NEED_ANALYSIS_DEMOGRAPHIC	SUBSEQUENT_RECORD_SELECTED_VER
RCRAPP4_S_ASSET_THRESH_EXCD	RNAPRXX	REPORTING VIEW	NEED_ANALYSIS	ASSET_THRESHOLD_EXCEED
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.5