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 Reporting View Source: RCRAPP4 - NULL

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