Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: RCRAPP1 Financial Aid Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: RCRAPP1 - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
RCRAPP1_ACTIVITY_DATE NA

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

ACTIVITY_DATE

ACTIVITY_DATE

 
RCRAPP1_ACYR_CODE RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

ACADEMIC_YEAR

 
RCRAPP1_ADDR RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

STREET

 
RCRAPP1_AFDC RNAPRXX        
RCRAPP1_AIDY_CODE RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

AID_YEAR

AID_YEAR

NA
RCRAPP1_ALIEN_REG_NO RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

ALIEN_REGISTRATION_NUMBER

 
RCRAPP1_BIRTH_DATE RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

BIRTH_DATE

 
RCRAPP1_BUS_FARM_DBT RNAPRXX

REPORTING VIEW

NEED_ANALYSIS

BUSINESS_DEBT

NA
RCRAPP1_BUS_FARM_VAL RNAPRXX

REPORTING VIEW

NEED_ANALYSIS

BUSINESS_VALUE

NA
RCRAPP1_CASH_AMT RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

CASH_SAVINGS

NA
RCRAPP1_CHILD_SUPP RNAPRXX        
RCRAPP1_CITY RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

CITY

 
RCRAPP1_CITZ_IND RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

CITIZENSHIP_ELIGIBILITY_TYPE

 
RCRAPP1_COLL_CDE RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

COLLEGE

COLLEGE

NA
RCRAPP1_COLL_CDE_1 RNASUXX        
RCRAPP1_COLL_CDE_2 RNASUXX        
RCRAPP1_COLL_CDE_3 RNASUXX        
RCRAPP1_COLL_CDE_4 RNASUXX        
RCRAPP1_COLL_CDE_5 NA        
RCRAPP1_COLL_CDE_6 RNASUXX        
RCRAPP1_COLL_CDE_7 RNASUXX        
RCRAPP1_COLL_CDE_8 RNASUXX        
RCRAPP1_COMPLETION_DATE RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

DATE_APPLICATION_COMPLETED

 
RCRAPP1_CREATE_DATE NA        
RCRAPP1_CURR_REC_IND RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_PROFILE_SPECIFIC

NEED_ANALYSIS_FEDERAL_METHOD

NEED_ANALYSIS_ISIR_SPECIFIC

NEED_ANALYSIS_INST_METHOD

NEED_ANALYSIS_DEMOGRAPHIC

CURRENT_RECORD_IND

CURRENT_RECORD_IND

CURRENT_RECORD_IND

CURRENT_RECORD_IND

CURRENT_RECORD_IND

CURRENT_RECORD_IND

NA
RCRAPP1_DRIVER_LIC_NO RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

DRIVER_LICENSE_NUMBER

DRIVER_LICENSE_NUMBER

 
RCRAPP1_EXP_ACYR_INC RNAPRXX        
RCRAPP1_EXP_ACYR_OTH_TAX_INC RNAPRXX        
RCRAPP1_EXP_ACYR_UNTAX_INC RNAPRXX        
RCRAPP1_EXP_ENROLL_STATUS RNASUXX

REPORTING VIEW

NEED_ANALYSIS

EXPECTED_ENROLL_STATUS

NA
RCRAPP1_EXP_FATH_INC_FR_WRK RNAPRXX        
RCRAPP1_EXP_MOTH_INC_FR_WRK RNAPRXX        
RCRAPP1_EXP_PAR_OTH_TAX_INC RNAPRXX        
RCRAPP1_EXP_PAR_UNTAX_INC RNAPRXX        
RCRAPP1_EXP_SMR_INC RNAPRXX        
RCRAPP1_EXP_SMR_OTH_TAX_INC RNAPRXX        
RCRAPP1_EXP_SMR_UNTAX_INC RNAPRXX        
RCRAPP1_EXP_SPS_ACYR_INC RNAPRXX        
RCRAPP1_EXP_SPS_SMR_INC RNAPRXX        
RCRAPP1_FAM_MEMB RNAPRXX RNANAXX       NA
RCRAPP1_FATH_INC_FR_WRK RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

FATHER_WORK_INCOME

 
RCRAPP1_FED_COLL_CHOICE_1 RNANAXX        
RCRAPP1_FED_COLL_CHOICE_2 RNANAXX        
RCRAPP1_FED_COLL_CHOICE_3 RNANAXX        
RCRAPP1_FIRST_NAME RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

FIRST_NAME

 
RCRAPP1_HME_DBT RNAPRXX

REPORTING VIEW

NEED_ANALYSIS

HOME_DEBT

NA
RCRAPP1_HME_VAL RNAPRXX

REPORTING VIEW

NEED_ANALYSIS

HOME_VALUE

NA
RCRAPP1_HOUS_CDE_1 RNASUXX        
RCRAPP1_HOUS_CDE_2 RNASUXX        
RCRAPP1_HOUS_CDE_3 RNASUXX        
RCRAPP1_HOUS_CDE_4 RNASUXX        
RCRAPP1_HOUS_CDE_5 RNASUXX        
RCRAPP1_HOUS_CDE_6 RNASUXX        
RCRAPP1_HOUS_CDE_7 RNASUXX        
RCRAPP1_HOUS_CDE_8 RNASUXX        
RCRAPP1_INC_FR_WRK RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

INCOME_WORK

 
RCRAPP1_INFC_CODE RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

INTERFACE_TAPE_CODE

INTERFACE_TAPE_CODE

NA
RCRAPP1_INST_HOUS_CDE RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

HOUSING

HOUSING

NA
RCRAPP1_LAST_NAME RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

LAST_NAME

 
RCRAPP1_LINE2_ATTEND_COLL RNASUXX        
RCRAPP1_LINE2_RELSHIP RNASUXX        
RCRAPP1_LINE3_ATTEND_COLL RNASUXX        
RCRAPP1_LINE3_RELSHIP RNASUXX        
RCRAPP1_LINE4_ATTEND_COLL RNASUXX        
RCRAPP1_LINE4_RELSHIP RNASUXX        
RCRAPP1_LINE5_ATTEND_COLL RNASUXX        
RCRAPP1_LINE5_RELSHIP RNASUXX        
RCRAPP1_LINE6_ATTEND_COLL RNASUXX        
RCRAPP1_LINE6_RELSHIP RNASUXX        
RCRAPP1_LINE7_ATTEND_COLL RNASUXX        
RCRAPP1_LINE7_RELSHIP RNASUXX        
RCRAPP1_LINE8_ATTEND_COLL RNASUXX        
RCRAPP1_LINE8_RELSHIP RNASUXX        
RCRAPP1_MED_DEN_EXP RNAPRXX        
RCRAPP1_MI RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

MIDDLE_INITIAL

 
RCRAPP1_MOTH_INC_FR_WRK RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

MOTHER_WORK_INCOME

 
RCRAPP1_MRTL_STATUS RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

MARITAL_STATUS

 
RCRAPP1_NO_EXEMPT RNAPRXX RNANAXX        
RCRAPP1_NO_IN_COLL RNAPRXX RNANAXX       NA
RCRAPP1_ORIG_COMP_DATE RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

ORIGINAL_COMPUTE_DATE

 
RCRAPP1_OTH_UNTAX_INC RNAPRXX        
RCRAPP1_OTH_VA_AMT RNAPRXX        
RCRAPP1_OTH_VA_MTH RNAPRXX        
RCRAPP1_PAR_ADJ_TO_INC RNAPRXX        
RCRAPP1_PAR_AFDC RNAPRXX        
RCRAPP1_PAR_BUS_FARM_INC RNAPRXX        
RCRAPP1_PAR_CASH_AMT RNAPRXX RNANAXX        
RCRAPP1_PAR_CHILD_SUPP RNAPRXX        
RCRAPP1_PAR_DIV_INC RNAPRXX        
RCRAPP1_PAR_FAM_MEMB RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

PARENT_FAMILY_SIZE

PARENT_FAMILY_SIZE

 
RCRAPP1_PAR_HME_DBT RNAPRXX        
RCRAPP1_PAR_HME_PURCH_AMT RNAPRXX        
RCRAPP1_PAR_HME_VAL RNAPRXX        
RCRAPP1_PAR_HME_YR_PURCH RNAPRXX        
RCRAPP1_PAR_HOUS_STAT RNASUXX        
RCRAPP1_PAR_INT_INC RNAPRXX        
RCRAPP1_PAR_MED_DEN_EXP RNAPRXX        
RCRAPP1_PAR_MRTL_STATUS RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PARENT_MARITAL_STATUS

 
RCRAPP1_PAR_NO_CHILD_TUIT RNAPRXX        
RCRAPP1_PAR_NO_EXEMPT RNAPRXX RNANAXX        
RCRAPP1_PAR_NO_IN_COLL RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

PARENT_FAMILY_IN_COLLEGE

PARENT_FAMILY_IN_COLLEGE

 
RCRAPP1_PAR_OLDER_AGE RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

AGE_OLDER_PARENT

 
RCRAPP1_PAR_OTH_TAX_INC RNAPRXX        
RCRAPP1_PAR_OTH_UNTAX_INC RNAPRXX        
RCRAPP1_PAR_REMARRIAGE_DATE RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PARENT_REMARRIAGE_DATE

 
RCRAPP1_PAR_SS_BENE RNAPRXX        
RCRAPP1_PAR_SS_BENE_STU_ONLY RNAPRXX        
RCRAPP1_PAR_STAT_CODE_RES RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

PARENT_STATE_OF_RESIDENCE

PARENT_STATE_OF_RESIDENCE

 
RCRAPP1_PAR_TAX_FORM_IND RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

PARENT_TAX_RETURN_TYPE

 
RCRAPP1_PAR_TUIT_PD RNAPRXX        
RCRAPP1_PAR_US_INC RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

PARENT_ADJUSTED_GROSS_INCOME

NA
RCRAPP1_PAR_US_INC_TAX_PD RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

PARENT_INCOME_TAX_PAID

 
RCRAPP1_PAR_WAGES RNAPRXX        
RCRAPP1_PERMIT_DRAFT_REG RNANAXX        
RCRAPP1_PHONE_AREA RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PHONE_AREA

 
RCRAPP1_PHONE_NO RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

PHONE_NUMBER

 
RCRAPP1_PIDM NA

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

PERSON_UID

PERSON_UID

NA
RCRAPP1_RCPT_DATE RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

APPLICATION_RECEIPT_DATE

 
RCRAPP1_REV_COMP_DATE RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REVISION_COMPUTE_DATE

 
RCRAPP1_REV_RCPT_DATE RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

APPLICATION_REVISION_RCPT_DATE

 
RCRAPP1_RE_INV_DBT RCRAPP1       NA
RCRAPP1_RE_INV_VAL RCRAPP1       NA
RCRAPP1_RQST_FA_FALL_THIS_YR RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REQUESTED_AID_FALL

 
RCRAPP1_RQST_FA_SPRING_NEXT_YR RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REQUESTED_AID_SPRING

 
RCRAPP1_RQST_FA_SUMMER_NEXT_YR RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REQUESTED_AID_NEXT_SUMMER

 
RCRAPP1_RQST_FA_SUMMER_THIS_YR RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REQUESTED_AID_PRECEDING_SUMMER

 
RCRAPP1_RQST_FA_WINTER_NEXT_YR RNAPRXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

REQUESTED_AID_WINTER

 
RCRAPP1_SEQ_NO RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

APPLICATION_NUMBER

APPLICATION_NUMBER

NA
RCRAPP1_SIGNED RNANAXX        
RCRAPP1_SPS_INC_FR_WRK RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

SPOUSE_INCOME_WORK

 
RCRAPP1_SSN RNAPRXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

TAX_ID

TAX_ID

NA
RCRAPP1_SS_BENE RNAPRXX        
RCRAPP1_START_RES_MTH_YR NA

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

START_RESIDENCE_DATE

 
RCRAPP1_STAT_CODE RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

STATE_PROVINCE

 
RCRAPP1_STAT_CODE_LIC RNANAXX

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

DRIVER_LICENSE_STATE_PROVINCE

DRIVER_LICENSE_STATE_PROVINCE

 
RCRAPP1_STAT_CODE_RES RNANAXX RNINAIQ

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

STATE_OF_RESIDENCE

STATE_OF_RESIDENCE

NA
RCRAPP1_TAX_FORM_IND RNANAXX

REPORTING VIEW

NEED_ANALYSIS

TAX_RETURN_TYPE

 
RCRAPP1_USED_TRANS_NO NA

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

TRANSACTION_NUMBER

TRANSACTION_NUMBER

 
RCRAPP1_USER_ID RNANAXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

NEED_ANALYSIS

USER_ID

USER_ID

 
RCRAPP1_US_INC RNAPRXX RNANAXX

REPORTING VIEW

NEED_ANALYSIS

ADJUSTED_GROSS_INCOME

NA
RCRAPP1_US_INC_TAX_PD RNANAXX RNAPRXX

REPORTING VIEW

NEED_ANALYSIS

INCOME_TAX_PAID

 
RCRAPP1_VERIFICATION_MSG RNARSXX RNINAIQ

REPORTING VIEW

NEED_ANALYSIS

FINAID_APPLICANT_STATUS

SELECTED_FOR_VERIFICATION_IND

VERIFICATION_REQUIRED_IND

NA
RCRAPP1_VERIFICATION_PRTY RNINAIQ

REPORTING VIEW

NEED_ANALYSIS

NEED_ANALYSIS_DEMOGRAPHIC

VERIFICATION_PRIORITY

VERIFICATION_PRIORITY

NA
RCRAPP1_YR_IN_COLL RNANAXX RNASUXX

REPORTING VIEW

NEED_ANALYSIS

YEAR_IN_COLLEGE

NA
RCRAPP1_ZIP RNASUXX

REPORTING VIEW

NEED_ANALYSIS_DEMOGRAPHIC

POSTAL_CODE

 


Ver: 8.0