Reporting View Source: RCRAPP1

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**
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 NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	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_DEMOGRAPHIC NEED_ANALYSIS_FEDERAL_METHOD NEED_ANALYSIS_INST_METHOD NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS_PROFILE_SPECIFIC	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 NEED_ANALYSIS_DEMOGRAPHIC	INTERFACE_TAPE_CODE INTERFACE_TAPE_CODE	NA
RCRAPP1_INST_HOUS_CDE	RNANAXX RNASUXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	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 NEED_ANALYSIS_DEMOGRAPHIC	TRANSACTION_NUMBER TRANSACTION_NUMBER
RCRAPP1_USER_ID	RNANAXX	REPORTING VIEW	NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC	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	FINAID_APPLICANT_STATUS NEED_ANALYSIS	VERIFICATION_REQUIRED_IND SELECTED_FOR_VERIFICATION_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.1