Composite View Source: RCRAPP1

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RCRAPP1 Financial Aid

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
RCRAPP1_ACTIVITY_DATE	NA	AR_FINAID_APPLICATION1	ACTIVITY_DATE
RCRAPP1_ACYR_CODE	RNASUXX	AR_FINAID_APPLICATION1	ACADEMIC_YEAR
RCRAPP1_ADDR	RNASUXX	AR_FINAID_APPLICATION1	STREET
RCRAPP1_AFDC	RNAPRXX	AR_FINAID_APPLICATION1	GOVERNMENT_FAMILY_AID
RCRAPP1_AIDY_CODE	RNANAxx	AR_FINAID_APPLICATION1	AID_YEAR
RCRAPP1_ALIEN_REG_NO	RNANAXX	AR_FINAID_APPLICATION1	ALIEN_REGISTRATION_NUMBER
RCRAPP1_BIRTH_DATE	RNASUXX	AR_FINAID_APPLICATION1	BIRTH_DATE
RCRAPP1_BUS_FARM_DBT	RNAPRXX	AR_FINAID_APPLICATION1	BUSINESS_DEBT
RCRAPP1_BUS_FARM_VAL	RNAPRXX	AR_FINAID_APPLICATION1	BUSINESS_VALUE
RCRAPP1_CASH_AMT	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	CASH_SAVINGS
RCRAPP1_CHILD_SUPP	RNAPRXX	AR_FINAID_APPLICATION1	CHILD_SUPPORT_INCOME
RCRAPP1_CITY	RNASUXX	AR_FINAID_APPLICATION1	CITY
RCRAPP1_CITZ_IND	RNASUXX	AR_FINAID_APPLICATION1	CITIZENSHIP_ELIGIBILITY_TYPE
RCRAPP1_COLL_CDE	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE
RCRAPP1_COLL_CDE_1	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE1
RCRAPP1_COLL_CDE_2	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE2
RCRAPP1_COLL_CDE_3	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE3
RCRAPP1_COLL_CDE_4	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE4
RCRAPP1_COLL_CDE_5	NA	AR_FINAID_APPLICATION1	COLLEGE5
RCRAPP1_COLL_CDE_6	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE6
RCRAPP1_COLL_CDE_7	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE7
RCRAPP1_COLL_CDE_8	RNASUXX	AR_FINAID_APPLICATION1	COLLEGE8
RCRAPP1_COMPLETION_DATE	RNANAXX	AR_FINAID_APPLICATION1	DATE_APPLICATION_COMPLETED
RCRAPP1_CREATE_DATE	NA	AR_FINAID_APPLICATION1	APPLICATION_CREATE_DATE
RCRAPP1_CURR_REC_IND	RNANAxx	AR_FINAID_APPLICATION1	CURRENT_RECORD_IND
RCRAPP1_DRIVER_LIC_NO	RNANAXX	AR_FINAID_APPLICATION1	DRIVER_LICENSE_NUMBER
RCRAPP1_EXP_ACYR_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_ACADEMIC_YEAR_INCOME
RCRAPP1_EXP_ACYR_OTH_TAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_ACAD_YR_OTHER_INC
RCRAPP1_EXP_ACYR_UNTAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_ACAD_YR_UNTAX_INC
RCRAPP1_EXP_ENROLL_STATUS	RNASUXX	AR_FINAID_APPLICATION1	EXPECTED_ENROLL_STATUS
RCRAPP1_EXP_FATH_INC_FR_WRK	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_FATHER_INCOME
RCRAPP1_EXP_MOTH_INC_FR_WRK	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_MOTHER_INCOME
RCRAPP1_EXP_PAR_OTH_TAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_PARENT_OTHER_INCOME
RCRAPP1_EXP_PAR_UNTAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_PARENT_UNTAXED_INCOME
RCRAPP1_EXP_SMR_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_SUMMER_INCOME
RCRAPP1_EXP_SMR_OTH_TAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_SUMMER_OTHER_INCOME
RCRAPP1_EXP_SMR_UNTAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_SUMMER_UNTAXED_INC
RCRAPP1_EXP_SPS_ACYR_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXP_SPOUSE_ACAD_YEAR_INCOME
RCRAPP1_EXP_SPS_SMR_INC	RNAPRXX	AR_FINAID_APPLICATION1	EXPECTED_SPOUSE_SUMMER_INCOME
RCRAPP1_FAM_MEMB	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	FAMILY_SIZE
RCRAPP1_FATH_INC_FR_WRK	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	FATHER_WORK_INCOME
RCRAPP1_FED_COLL_CHOICE_1	RNANAXX	AR_FINAID_APPLICATION1	COLLEGE_CHOICE1
RCRAPP1_FED_COLL_CHOICE_2	RNANAXX	AR_FINAID_APPLICATION1	COLLEGE_CHOICE2
RCRAPP1_FED_COLL_CHOICE_3	RNANAXX	AR_FINAID_APPLICATION1	COLLEGE_CHOICE3
RCRAPP1_FIRST_NAME	RNASUXX	AR_FINAID_APPLICATION1	FIRST_NAME
RCRAPP1_HME_DBT	RNAPRXX	AR_FINAID_APPLICATION1	HOME_DEBT
RCRAPP1_HME_VAL	RNAPRXX	AR_FINAID_APPLICATION1	HOME_VALUE
RCRAPP1_HOUS_CDE_1	RNASUXX	AR_FINAID_APPLICATION1	HOUSING1
RCRAPP1_HOUS_CDE_2	RNASUXX	AR_FINAID_APPLICATION1	HOUSING2
RCRAPP1_HOUS_CDE_3	RNASUXX	AR_FINAID_APPLICATION1	HOUSING3
RCRAPP1_HOUS_CDE_4	RNASUXX	AR_FINAID_APPLICATION1	HOUSING4
RCRAPP1_HOUS_CDE_5	RNASUXX	AR_FINAID_APPLICATION1	HOUSING5
RCRAPP1_HOUS_CDE_6	RNASUXX	AR_FINAID_APPLICATION1	HOUSING6
RCRAPP1_HOUS_CDE_7	RNASUXX	AR_FINAID_APPLICATION1	HOUSING7
RCRAPP1_HOUS_CDE_8	RNASUXX	AR_FINAID_APPLICATION1	HOUSING8
RCRAPP1_INC_FR_WRK	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	INCOME_WORK
RCRAPP1_INFC_CODE	RNANAxx	AR_FINAID_APPLICATION1	INTERFACE_TAPE_CODE
RCRAPP1_INST_HOUS_CDE	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	HOUSING
RCRAPP1_LAST_NAME	RNASUXX	AR_FINAID_APPLICATION1	LAST_NAME
RCRAPP1_LINE2_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE2_ATTEND_COLLEGE
RCRAPP1_LINE2_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE2_RELATIONSHIP
RCRAPP1_LINE3_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE3_ATTEND_COLLEGE
RCRAPP1_LINE3_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE3_RELATIONSHIP
RCRAPP1_LINE4_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE4_ATTEND_COLLEGE
RCRAPP1_LINE4_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE4_RELATIONSHIP
RCRAPP1_LINE5_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE5_ATTEND_COLLEGE
RCRAPP1_LINE5_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE5_RELATIONSHIP
RCRAPP1_LINE6_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE6_ATTEND_COLLEGE
RCRAPP1_LINE6_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE6_RELATIONSHIP
RCRAPP1_LINE7_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE7_ATTEND_COLLEGE
RCRAPP1_LINE7_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE7_RELATIONSHIP
RCRAPP1_LINE8_ATTEND_COLL	RNASUXX	AR_FINAID_APPLICATION1	LINE8_ATTEND_COLLEGE
RCRAPP1_LINE8_RELSHIP	RNASUXX	AR_FINAID_APPLICATION1	LINE8_RELATIONSHIP
RCRAPP1_MED_DEN_EXP	RNAPRXX	AR_FINAID_APPLICATION1	MEDICAL_DENTAL_EXPENSE
RCRAPP1_MI	RNASUXX	AR_FINAID_APPLICATION1	MIDDLE_INITIAL
RCRAPP1_MOTH_INC_FR_WRK	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	MOTHER_WORK_INCOME
RCRAPP1_MRTL_STATUS	RNASUXX	AR_FINAID_APPLICATION1	MARITAL_STATUS
RCRAPP1_NO_EXEMPT	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	NUMBER_OF_EXEMPTIONS
RCRAPP1_NO_IN_COLL	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	FAMILY_IN_COLLEGE
RCRAPP1_ORIG_COMP_DATE	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	ORIGINAL_COMPUTE_DATE
RCRAPP1_OTH_UNTAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	OTHER_UNTAXED_INCOME
RCRAPP1_OTH_VA_AMT	RNAPRXX	AR_FINAID_APPLICATION1	VETERAN_OTHER_BENEFITS
RCRAPP1_OTH_VA_MTH	RNAPRXX	AR_FINAID_APPLICATION1	VETERAN_OTH_BEN_NO_MONTHS
RCRAPP1_PAR_ADJ_TO_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_INCOME_ADJUSTMENTS
RCRAPP1_PAR_AFDC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_GOVERNMENT_FAMILY_AID
RCRAPP1_PAR_BUS_FARM_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_BUSINESS_INCOME
RCRAPP1_PAR_CASH_AMT	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_CASH_ASSET
RCRAPP1_PAR_CHILD_SUPP	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_CHILD_SUPPORT
RCRAPP1_PAR_DIV_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_DIVIDEND_INCOME
RCRAPP1_PAR_FAM_MEMB	RNANAXX	AR_FINAID_APPLICATION1	PARENT_FAMILY_SIZE
RCRAPP1_PAR_HME_DBT	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_HOME_DEBT
RCRAPP1_PAR_HME_PURCH_AMT	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_HOME_AMOUNT_PAID
RCRAPP1_PAR_HME_VAL	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_HOME_VALUE
RCRAPP1_PAR_HME_YR_PURCH	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_HOME_YEAR_PURCHASED
RCRAPP1_PAR_HOUS_STAT	RNASUXX	AR_FINAID_APPLICATION1	PARENT_HOUSING_STATUS
RCRAPP1_PAR_INT_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_INTEREST_INCOME
RCRAPP1_PAR_MED_DEN_EXP	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_MEDICAL_DENTAL_EXPENSE
RCRAPP1_PAR_MRTL_STATUS	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	PARENT_MARITAL_STATUS
RCRAPP1_PAR_NO_CHILD_TUIT	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_NO_CHILD_SEC_TUITION_PD
RCRAPP1_PAR_NO_EXEMPT	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_NUMBER_OF_EXEMPTIONS
RCRAPP1_PAR_NO_IN_COLL	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_FAMILY_IN_COLLEGE
RCRAPP1_PAR_OLDER_AGE	RNAPRXX	AR_FINAID_APPLICATION1	AGE_OLDER_PARENT
RCRAPP1_PAR_OTH_TAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_OTHER_INCOME
RCRAPP1_PAR_OTH_UNTAX_INC	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_OTHER_UNTAXED_INCOME
RCRAPP1_PAR_REMARRIAGE_DATE	RNASUXX	AR_FINAID_APPLICATION1	PARENT_REMARRIAGE_DATE
RCRAPP1_PAR_SS_BENE	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_GOVERNMENT_BENEFITS
RCRAPP1_PAR_SS_BENE_STU_ONLY	RNAPRXX	AR_FINAID_APPLICATION1	GOVERNMENT_BENEFIT_FOR_STUDENT
RCRAPP1_PAR_STAT_CODE_RES	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_STATE_OF_RESIDENCE
RCRAPP1_PAR_TAX_FORM_IND	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_TAX_RETURN_TYPE
RCRAPP1_PAR_TUIT_PD	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_TUITION_PAID
RCRAPP1_PAR_US_INC	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_ADJUSTED_GROSS_INCOME
RCRAPP1_PAR_US_INC_TAX_PD	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	PARENT_INCOME_TAX_PAID
RCRAPP1_PAR_WAGES	RNAPRXX	AR_FINAID_APPLICATION1	PARENT_WAGES
RCRAPP1_PERMIT_DRAFT_REG	RNANAXX	AR_FINAID_APPLICATION1	PERMIT_DRAFT_REGISTRATION_IND
RCRAPP1_PHONE_AREA	RNASUXX	AR_FINAID_APPLICATION1	PHONE_AREA
RCRAPP1_PHONE_NO	RNASUXX	AR_FINAID_APPLICATION1	PHONE_NUMBER
RCRAPP1_PIDM	NA	AR_FINAID_APPLICATION1	PERSON_UID
RCRAPP1_RCPT_DATE	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	APPLICATION_RECEIPT_DATE
RCRAPP1_REV_COMP_DATE	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	REVISION_COMPUTE_DATE
RCRAPP1_REV_RCPT_DATE	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	APPLICATION_REVISION_RCPT_DATE
RCRAPP1_RE_INV_DBT	RCRAPP1
RCRAPP1_RE_INV_VAL	RCRAPP1
RCRAPP1_RQST_FA_FALL_THIS_YR	RNAPRXX	AR_FINAID_APPLICATION1	REQUESTED_AID_FALL
RCRAPP1_RQST_FA_SPRING_NEXT_YR	RNAPRXX	AR_FINAID_APPLICATION1	REQUESTED_AID_SPRING
RCRAPP1_RQST_FA_SUMMER_NEXT_YR	RNAPRXX	AR_FINAID_APPLICATION1	REQUESTED_AID_NEXT_SUMMER
RCRAPP1_RQST_FA_SUMMER_THIS_YR	RNAPRXX	AR_FINAID_APPLICATION1	REQUESTED_AID_PRECEDING_SUMMER
RCRAPP1_RQST_FA_WINTER_NEXT_YR	RNAPRXX	AR_FINAID_APPLICATION1	REQUESTED_AID_WINTER
RCRAPP1_SEQ_NO	RNANAxx	AR_FINAID_APPLICATION1	APPLICATION_NUMBER
RCRAPP1_SIGNED	RNANAXX	AR_FINAID_APPLICATION1	APPLICATION_SIGNED_BY
RCRAPP1_SPS_INC_FR_WRK	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	SPOUSE_INCOME_WORK
RCRAPP1_SSN	RNAPRXX RNASUXX	AR_FINAID_APPLICATION1	TAX_ID
RCRAPP1_SS_BENE	RNAPRXX	AR_FINAID_APPLICATION1	GOVERNMENT_BENEFITS
RCRAPP1_START_RES_MTH_YR	NA	AR_FINAID_APPLICATION1	START_RESIDENCE_DATE
RCRAPP1_STAT_CODE	RNASUXX	AR_FINAID_APPLICATION1	STATE_PROVINCE
RCRAPP1_STAT_CODE_LIC	RNANAXX	AR_FINAID_APPLICATION1	DRIVER_LICENSE_STATE_PROVINCE
RCRAPP1_STAT_CODE_RES	RNANAXX RNINAIQ	AR_FINAID_APPLICATION1	STATE_OF_RESIDENCE
RCRAPP1_TAX_FORM_IND	RNANAXX	AR_FINAID_APPLICATION1	TAX_RETURN_TYPE
RCRAPP1_USED_TRANS_NO	NA	AR_FINAID_APPLICATION1	TRANSACTION_NUMBER
RCRAPP1_USER_ID	RNANAXX	AR_FINAID_APPLICATION1	USER_ID
RCRAPP1_US_INC	RNAPRXX RNANAXX	AR_FINAID_APPLICATION1	ADJUSTED_GROSS_INCOME
RCRAPP1_US_INC_TAX_PD	RNANAXX RNAPRXX	AR_FINAID_APPLICATION1	INCOME_TAX_PAID
RCRAPP1_VERIFICATION_MSG	RNARSXX RNINAIQ	AR_FINAID_APPLICANT_STATUS	VERIFICATION_REQUIRED_IND
RCRAPP1_VERIFICATION_PRTY	RNINAIQ	AR_FINAID_APPLICATION1	VERIFICATION_PRIORITY
RCRAPP1_YR_IN_COLL	RNANAXX RNASUXX	AR_FINAID_APPLICATION1	YEAR_IN_COLLEGE
RCRAPP1_ZIP	RNASUXX	AR_FINAID_APPLICATION1	POSTAL_CODE

Ver: 8.3