Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RCRAPP4 Financial Aid
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_ADOPTED_AFTER_13 RNAPRXX        
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_COMBAT_PAY RNANAXX        
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_DOD_MATCH_FLAG RNAPRXX        
RCRAPP4_DOD_PAR_DEATH_DATE RNAPRXX        
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_EFM_FORMULA_FOR_CALC RNINAIQ        
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_FISAP_INC RNINAIQ COMPOSITE VIEW

AR_FINAID_APPLICATION4

FISAP_TOTAL_INCOME

 
RCRAPP4_FM_FORMULA_FOR_CALC RNINAIQ        
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_HIGH_SCHOOL_CITY RNANAXX        
RCRAPP4_HIGH_SCHOOL_FLG RNANAXX        
RCRAPP4_HIGH_SCHOOL_NAME RNANAXX        
RCRAPP4_HIGH_SCH_CDE RNANAXX        
RCRAPP4_HME_PURCH_AMT RNAPRXX        
RCRAPP4_HME_YR_PURCH RNAPRXX        
RCRAPP4_HOMELESS RNAPRXX        
RCRAPP4_IM_BUDG_DUR_FOR_CALC RNINAIQ COMPOSITE VIEW

AR_FINAID_APPLICATION4

IM_BUDGET_DURATION

 
RCRAPP4_IM_FORMULA_FOR_CALC RNINAIQ        
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_IRA_KEOUGH_AMT RNAPRXX        
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_MSG_31 RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

MESSAGE_31

 
RCRAPP4_MSG_72 RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

MESSAGE_72

 
RCRAPP4_NSLDS_MATCH RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

NATIONAL_STUDENT_LOAN_SYSTEM

 
RCRAPP4_NSLDS_TRAN_NO RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

NATIONAL_STUDENT_LOAN_TRAN_NUM

 
RCRAPP4_OLDEST_LOAN_DATE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

OLDEST_LOAN_DATE

 
RCRAPP4_PAR1_EMPLOYER RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_1_EMPLOYER

 
RCRAPP4_PAR1_OCCUPATION RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_1_OCCUPATION

 
RCRAPP4_PAR2_EMPLOYER RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_2_EMPLOYER

 
RCRAPP4_PAR2_OCCUPATION RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_2_OCCUPATION

 
RCRAPP4_PARENT_TYPE_1 RNANAXX        
RCRAPP4_PARENT_TYPE_2 RNANAXX        
RCRAPP4_PAR_BUS_NET_WORTH RNAPRXX RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_BUSINESS_NET_WORTH

 
RCRAPP4_PAR_COMBAT_PAY RNAPRXX        
RCRAPP4_PAR_DEPENDENT_CARE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_DPDNT_CARE_CONTRIBUTION

 
RCRAPP4_PAR_DEP_CARE_AND_MED RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_DEPEND_CARE_MED_ACCOUNT

 
RCRAPP4_PAR_FARM_NET_WORTH RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_FARM_NET_WORTH

 
RCRAPP4_PAR_FSA_HEALTH_CARE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_HEALTHCARE_CONTRIBUTION

 
RCRAPP4_PAR_HEALTH_SAV_ACCOUNT RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_HSA_CONTRIBUTION

 
RCRAPP4_PAR_HSA_PRE_TAX RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_HSA_PRETAX_CONTRIBUTION

 
RCRAPP4_PAR_INV_NET_WORTH RNAPRXX RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_INVESTMENT_NET_WORTH

 
RCRAPP4_PAR_NUM_BUSINESSES RNAPRXX        
RCRAPP4_PAR_NUM_FARMS RNAPRXX        
RCRAPP4_PAR_STATE_FOR_TAXES RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_STATE_FOR_TAXES

 
RCRAPP4_PAR_TAX_FILER RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_TAX_FILER

 
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_PELL_1_EFC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PRI_EFF_FAMILY_CONTRIBUTION

 
RCRAPP4_PELL_2_EFC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

SEC_EFF_FAMILY_CONTRIBUTION

 
RCRAPP4_PIDM RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PERSON_UID

 
RCRAPP4_PLUS_INT RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

INTERESTED_IN_PLUS_LOAN

 
RCRAPP4_PRISONER_MATCH_FLAG RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PRISONER_MATCH

 
RCRAPP4_P_ASSET_THRESH_EXCD RNAPRXX        
RCRAPP4_P_EMAIL_ADDRESS RNANAXX RNASUXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_EMAIL_ADDRESS

 
RCRAPP4_P_FARM_DBT_FAF RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENTS_FARM_DEBT

 
RCRAPP4_P_FARM_VAL_FAF RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENTS_FARM_VALUE

 
RCRAPP4_P_IV_INC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_TITLE_IV_INC_EXCLUSION

 
RCRAPP4_P_RES_DATE_MO_YR RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

PARENT_RESIDENT_SINCE_DATE

 
RCRAPP4_RECORD_MARK RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

RECORD_MARK

 
RCRAPP4_REC_TYPE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

RECORD_TYPE

 
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_STATE_FOR_TAXES RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENT_STATE_FOR_TAXES

 
RCRAPP4_STAT_CODE_HIGH_SCH RNANAXX        
RCRAPP4_SUB_VERIF_SELECTED RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

SUBSEQUENT_RECORD_SELECTED_VER

 
RCRAPP4_SURROGATE_ID RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

SURROGATE_ID

 
RCRAPP4_S_ASSET_THRESH_EXCD RNAPRXX        
RCRAPP4_S_DIV_INT_INC RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

DIVIDEND_INCOME

 
RCRAPP4_S_EIC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENT_EIC

 
RCRAPP4_S_FARM_DBT_FAF RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENTS_FARM_DEBT

 
RCRAPP4_S_FARM_VAL_FAF RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENTS_FARM_VALUE

 
RCRAPP4_S_IV_INC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

TITLE_IV_INCOME_EXCLUSION

 
RCRAPP4_S_RES_DATE_MO_YR RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENT_RESIDENT_SINCE_DATE

 
RCRAPP4_TAPE_RPT_EXTRCT_DATE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

TAPE_REPORT_EXTRACT_DATE

 
RCRAPP4_TAX_FILER RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

STUDENT_TAX_FILER

 
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_TYPE_FM_CALC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

TYPE_OF_FM_CALCULATION

 
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_VERSION RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

VERSION

 
RCRAPP4_VISA_CLASS RNASUXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

VISA_CLASSIFICATION

 
RCRAPP4_VPDI_CODE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

VPDI_CODE

 
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

 
RCRAPP4_WRK_STDY_LOANS_INT RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION4

INTEREST_IN_WORK_STUDY_OR_LOAN

 


Ver: