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

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.0