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

Source Column Source Form Target Type Target Target Column Calculation Formula
RCRAPP3_ACTIVITY_DATE NA COMPOSITE VIEW

AR_FINAID_APPLICATION3

ACTIVITY_DATE

 
RCRAPP3_ADJ_EFC_CALC_REQ RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ADJUSTED_EFC_CALC_REQUEST

 
RCRAPP3_AIDY_CODE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

AID_YEAR

 
RCRAPP3_ASSUMPT_OVRD_1 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE1_IND

 
RCRAPP3_ASSUMPT_OVRD_2 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE2_IND

 
RCRAPP3_ASSUMPT_OVRD_3 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE3_IND

 
RCRAPP3_ASSUMPT_OVRD_4 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE4_IND

 
RCRAPP3_ASSUMPT_OVRD_5 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE5_IND

 
RCRAPP3_ASSUMPT_OVRD_6 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE6_IND

 
RCRAPP3_ASSUMPT_OVRD_7 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE7_IND

 
RCRAPP3_ASSUMPT_OVRD_8 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE8_IND

 
RCRAPP3_ASSUMPT_OVRD_9 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

ASSUMPTION_OVERRIDE9_IND

 
RCRAPP3_CHILD_CARE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

CHILD_CARE_NUMBER

 
RCRAPP3_CHILD_SUPP_PAID RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

CHILD_SUPPORT_PAID

 
RCRAPP3_CO_OP_EARNINGS RNANAXX        
RCRAPP3_C_SIGNED_MTH_DAY RNASUXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

APPLICATION_COMPLETE_MONTH_DAY

 
RCRAPP3_C_SIGNED_YR RNASUXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

APPLICATION_COMPLETE_YEAR

 
RCRAPP3_DEGREE_TYPE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

DEGREE_TYPE

 
RCRAPP3_EDUC_CREDITS RNAPRXX RNANAXX        
RCRAPP3_EFC_RECALC_CORR_REQ RNANAXX        
RCRAPP3_FAA_DEP_OVERRIDE RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

DEPENDENCY_OVERRIDE

 
RCRAPP3_FAA_TITLE_IV_CODE RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

FEDERAL_SCHOOL_CODE

 
RCRAPP3_FARM_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

BUSINESS_DEBT

 
RCRAPP3_FARM_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

BUSINESS_VALUE

 
RCRAPP3_FATHER_AGE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

FATHER_AGE

 
RCRAPP3_FATHER_HI_GRADE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

FATHER_HIGHEST_GRADE

 
RCRAPP3_FATH_SSN_MATCH RNANAXX RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

FATHER_TAX_ID_MATCH

 
RCRAPP3_FED_COLL_CHOICE_10 RNASUXX        
RCRAPP3_FED_COLL_CHOICE_4 RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

COLLEGE_CHOICE4

 
RCRAPP3_FED_COLL_CHOICE_5 RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

COLLEGE_CHOICE5

 
RCRAPP3_FED_COLL_CHOICE_6 RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

COLLEGE_CHOICE6

 
RCRAPP3_FED_COLL_CHOICE_7 RNASUXX        
RCRAPP3_FED_COLL_CHOICE_8 RNASUXX        
RCRAPP3_FED_COLL_CHOICE_9 RNASUXX        
RCRAPP3_GRANT_SCHOLAR_AID RNAPRXX RNANAXX        
RCRAPP3_HOUSE_FOOD_OTH RNAPRXX        
RCRAPP3_INFC_CODE RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

INTERFACE_TAPE_CODE

 
RCRAPP3_INVEST_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

INVESTMENT_DEBT

 
RCRAPP3_INVEST_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

INVESTMENT_VALUE

 
RCRAPP3_IRS_REQUEST_FLAG RNANAXX        
RCRAPP3_MOTHER_AGE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

MOTHER_AGE

 
RCRAPP3_MOTHER_HI_GRADE RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

MOTHER_HIGHEST_GRADE

 
RCRAPP3_MOTH_SSN_MATCH RNANAXX RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

MOTHER_TAX_ID_MATCH

 
RCRAPP3_NEED_BASED_EMPLOY RNAPRXX RNANAXX        
RCRAPP3_PAR_BUS_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_BUSINESS_DEBT

 
RCRAPP3_PAR_BUS_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_BUSINESS_VALUE

 
RCRAPP3_PAR_CHILD_SUPP_PAID RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_CHILD_SUPPORT_PAID

 
RCRAPP3_PAR_CO_OP_EARNINGS RNANAXX        
RCRAPP3_PAR_EDUC_CREDITS RNAPRXX RNANAXX        
RCRAPP3_PAR_EIC RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_EARNED_INCOME_CREDIT

 
RCRAPP3_PAR_FARM_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_FARM_DEBT

 
RCRAPP3_PAR_FARM_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_FARM_VALUE

 
RCRAPP3_PAR_FOR_INC_EXCL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_FOREIGN_INC_EXCLUSION

 
RCRAPP3_PAR_GRANT_SCHOLAR_AID RNAPRXX RNANAXX        
RCRAPP3_PAR_HOUSE_FOOD_OTH RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_HOUSING_FOOD_ALLOWANCE

 
RCRAPP3_PAR_INC_BENEFITS RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_TOTAL_UNTAXED_INCOME

 
RCRAPP3_PAR_INVEST_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_INVESTMENT_DEBT

 
RCRAPP3_PAR_INVEST_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_INVESTMENT_VALUE

 
RCRAPP3_PAR_IRA_KEOUGH RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_RETIREMENT_PLAN_PAYMENT

 
RCRAPP3_PAR_IRS_REQUEST_FLAG RNANAXX        
RCRAPP3_PAR_MAR_MTH_YR RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_MARITAL_STATUS_DATE

 
RCRAPP3_PAR_MTH_MORT_RENT_PAY RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_MORTGAGE_RENT_PAYMENT

 
RCRAPP3_PAR_NEED_BASED_EMPLOY RNAPRXX RNANAXX        
RCRAPP3_PAR_RE_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_REAL_ESTATE_DEBT

 
RCRAPP3_PAR_RE_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_REAL_ESTATE_VALUE

 
RCRAPP3_PAR_TAX_DEF_PENSION RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_TAX_DEFERRED_PENSION

 
RCRAPP3_PAR_TE_INT_INC RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PARENT_TAX_EXEMPT_INTEREST_INC

 
RCRAPP3_PAR_TUI_FEE_DED RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

IM_PARENT_TUITION_FEE_DEDUCT

 
RCRAPP3_PIDM RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PERSON_UID

 
RCRAPP3_PREPARER_EIN RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PREPARER_EIN

 
RCRAPP3_PREPARER_SSN RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

PREPARER_TAX_ID

 
RCRAPP3_REJECT_OVRD_1 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE_B_IND

 
RCRAPP3_REJECT_OVRD_2 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE2_IND

 
RCRAPP3_REJECT_OVRD_20 RNIMSXX        
RCRAPP3_REJECT_OVRD_21 RNIMSXX        
RCRAPP3_REJECT_OVRD_3 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE3_IND

 
RCRAPP3_REJECT_OVRD_4 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE_N_IND

 
RCRAPP3_REJECT_OVRD_5 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE5_IND

 
RCRAPP3_REJECT_OVRD_6 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE_W_IND

 
RCRAPP3_REJECT_OVRD_7 RNIMSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REJECTION_OVERRIDE7_IND

 
RCRAPP3_REJECT_OVRD_B RNIMSXX        
RCRAPP3_REJECT_OVRD_N RNIMSXX        
RCRAPP3_REJECT_OVRD_W RNIMSXX        
RCRAPP3_RE_DBT RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REAL_ESTATE_DEBT

 
RCRAPP3_RE_VAL RNAPRXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

REAL_ESTATE_VALUE

 
RCRAPP3_SEQ_NO RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

APPLICATION_NUMBER

 
RCRAPP3_SOC_SEC RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

TAX_ID_MATCH_STATUS

 
RCRAPP3_SPEC_CIRCUM_FLAG RNANAXX        
RCRAPP3_S_MAR_MTH_YR RNANAXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

MARITAL_STATUS_DATE

 
RCRAPP3_TAX_DEF_PENSION RNAPRXX        
RCRAPP3_TE_INT_INC RNAPRXX        
RCRAPP3_USER_ID RNARSXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

USER_ID

 
RCRAPP3_YR_IN_COLL_2 RNASUXX COMPOSITE VIEW

AR_FINAID_APPLICATION3

YEAR_IN_COLLEGE2

 


Ver: