Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICATION3

Description Contains information specific to the federal methodology for computing applicant need.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRAPP3

RCRAPP3_ACTIVITY_DATE

ADJUSTED_EFC_CALC_REQUEST Contains a request to calculate the adjusted Effective Family Contribution. VARCHAR2(1)

RCRAPP3

RCRAPP3_ADJ_EFC_CALC_REQ

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RCRAPP3

RCRAPP3_AIDY_CODE

APPLICATION_COMPLETE_MONTH_DAY Contains the month and day the application was completed. VARCHAR2(4)

RCRAPP3

RCRAPP3_C_SIGNED_MTH_DAY

APPLICATION_COMPLETE_YEAR Contains the year the application was completed. VARCHAR2(1)

RCRAPP3

RCRAPP3_C_SIGNED_YR

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRAPP3

RCRAPP3_SEQ_NO

ASSUMPTION_OVERRIDE1_IND Set by electronic application user to override assumption 1: Parent's Number of Family Members assumed to be 3. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_1

ASSUMPTION_OVERRIDE2_IND Set by electronic application user to override assumption 2: Parent's Number of College assumed to be 1. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_2

ASSUMPTION_OVERRIDE3_IND Set by electronic application user to override assumption 3: Parent's AGI assumed equal to sum of parent's earned income portions. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_3

ASSUMPTION_OVERRIDE4_IND Set by electronic application user to override assumption 4: Student's Number of College assumed to be 1. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_4

ASSUMPTION_OVERRIDE5_IND Set by electronic application user to override assumption 5: Student's AGI assumed equal to sum of student's and spouse's earned income portions. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_5

ASSUMPTION_OVERRIDE6_IND Set by electronic application user to override assumption 6: Student's social security benefits assumed to be zero. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_6

ASSUMPTION_OVERRIDE7_IND Set by electronic application user to override assumption 7: Student's other real estate/investment value and debt assumed to be zero. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_7

ASSUMPTION_OVERRIDE8_IND Set by electronic application user to override assumption 8: Student's business value and debt assumed to be zero. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_8

ASSUMPTION_OVERRIDE9_IND Set by electronic application user to override assumption 9: Student's farm value and debt assumed to be zero. VARCHAR2(1)

RCRAPP3

RCRAPP3_ASSUMPT_OVRD_9

BUSINESS_DEBT Student's farm debt. NUMBER

RCRAPP3

RCRAPP3_FARM_DBT

BUSINESS_VALUE Student's farm value. NUMBER

RCRAPP3

RCRAPP3_FARM_VAL

CHILD_CARE_NUMBER Number of dependent children for whom the student will pay child care expenses. NUMBER

RCRAPP3

RCRAPP3_CHILD_CARE

CHILD_SUPPORT_PAID Contains the amount paid for child support by a student. NUMBER

RCRAPP3

RCRAPP3_CHILD_SUPP_PAID

COLLEGE_CHOICE10   VARCHAR2(6)    
COLLEGE_CHOICE4 Fourth college choice a student plans to attend. VARCHAR2(6)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_4

COLLEGE_CHOICE5 Fifth college choice a student plans to attend. VARCHAR2(6)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_5

COLLEGE_CHOICE6 Sixth college choice a student plans to attend. VARCHAR2(6)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_6

COLLEGE_CHOICE7   VARCHAR2(6)    
COLLEGE_CHOICE8   VARCHAR2(6)    
COLLEGE_CHOICE9   VARCHAR2(6)    
COOPERATIVE_EARNINGS   NUMBER    
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DEGREE_TYPE Contains the abbreviation of the degree or certificate a student is pursuing. VARCHAR2(3)

RCRAPP3

RCRAPP3_DEGREE_TYPE

DEGREE_TYPE_DESC Degree type description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP3_DEGREE_TYPE)

DEPENDENCY_OVERRIDE Used by the financial aid administrator to override dependency. VARCHAR2(1)

RCRAPP3

RCRAPP3_FAA_DEP_OVERRIDE

DEPENDENCY_OVERRIDE_DESC Dependency override description. VARCHAR2(70)

CALCULATION

DECODE(RCRAPP3_FAA_DEP_OVERRIDE)

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

EDUCATION_TAX_CREDIT   NUMBER    
EFC_RECALC_SPECIAL_CIRCUM   VARCHAR2(1)    
EFC_RECALC_SPECIAL_CIRCUM_DESC   VARCHAR2(4000)    
FATHER_AGE Father's age. VARCHAR2(2)

RCRAPP3

RCRAPP3_FATHER_AGE

FATHER_HIGHEST_GRADE Highest grade level completed by the father. VARCHAR2(1)

RCRAPP3

RCRAPP3_FATHER_HI_GRADE

FATHER_SIGNATURE_IND Indicates whether or not a father's signature is on the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_FATH)

FATHER_TAX_ID_MATCH Father's/Stepfather's Tax ID Match Flag. VARCHAR2(1)

RCRAPP3

RCRAPP3_FATH_SSN_MATCH

FATHER_TAX_ID_MATCH_DESC Father Tax ID match description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP3_FATH_SSN_MATCH)

FEDERAL_SCHOOL_CODE School Code that requested a dependency override or adjusted calculation request. VARCHAR2(6)

RCRAPP3

RCRAPP3_FAA_TITLE_IV_CODE

GRADUATE_PROFESSIONAL_IND Indicates whether or not a student is a graduate or professional student. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_GRAD_OR_PROF)

GRANT_SCHOLARSHIP_AID   NUMBER    
HOUSING_FOOD_ALLOWANCE   NUMBER    
IM_PARENT_TUITION_FEE_DEDUCT Tuition and fees deduction from federal tax forms. NUMBER

RCRAPP3

RCRAPP3_PAR_TUI_FEE_DED

INTERFACE_TAPE_CODE Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). VARCHAR2(7)

RCRAPP3

RCRAPP3_INFC_CODE

INVESTMENT_DEBT Student's investment debt. NUMBER

RCRAPP3

RCRAPP3_INVEST_DBT

INVESTMENT_VALUE Student's investment value. NUMBER

RCRAPP3

RCRAPP3_INVEST_VAL

IRS_AGI_FLAG Indicates whether IRS Adjusted Gross Income data for the student was transferred to the FAFSA. VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_IRS_AGI_FLAG,RCRIRSF_IRS_AGI_FLAG)

IRS_AGI_FLAG_DESC IRS Adjusted Gross Income data for the student was transferred to the FAFSA indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

IRS_DISPLAY_FLAG Indicates whether IRS Data Retrieval Transfer option was displayed for the student. VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_IRS_DISPLAY_FLAG,RCRIRSF_IRS_DISPLAY_FLAG)

IRS_DISPLAY_FLAG_DESC IRS Data Retrieval Transfer option was displayed for the student indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

IRS_FIT_FLAG Indicates whether IRS Federal Income Tax data for the student was transferred to the FAFSA VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_IRS_FIT_FLAG,RCRIRSF_IRS_FIT_FLAG)

IRS_FIT_FLAG_DESC IRS Federal Income Tax data for the student was transferred to the FAFSA indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

IRS_REQUEST_STATUS   VARCHAR2(2)

CALCULATION

NVL(RCRAPP3_IRS_REQUEST_FLAG,RCRIRSF_IRS_REQUEST_FLAG)

IRS_REQUEST_STATUS_DESC   VARCHAR2(4000)    
MARITAL_STATUS_DATE Month and year the student is married, widowed, separated, or divorced. VARCHAR2(6)

RCRAPP3

RCRAPP3_S_MAR_MTH_YR

MARITAL_STATUS_IND Indicates whether or not a student is married. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_MARRIED)

MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

MOTHER_AGE Mother's age. VARCHAR2(2)

RCRAPP3

RCRAPP3_MOTHER_AGE

MOTHER_HIGHEST_GRADE Highest grade level completed by the mother. VARCHAR2(1)

RCRAPP3

RCRAPP3_MOTHER_HI_GRADE

MOTHER_SIGNATURE_IND Indicates whether or not a mother's signature is on the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_MOTH)

MOTHER_TAX_ID_MATCH Mother's/Stepmother's Tax ID Match Flag. VARCHAR2(1)

RCRAPP3

RCRAPP3_MOTH_SSN_MATCH

MOTHER_TAX_ID_MATCH_DESC Mother Tax ID match description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP3_MOTH_SSN_MATCH)

NEED_BASED_EMPLOYMENT   NUMBER    
OFFICIAL_SOURCE_IND Official or unofficial indicator. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_OFFL_UNOFFL_IND)

PARENT_BUSINESS_DEBT Parents' business debt. NUMBER

RCRAPP3

RCRAPP3_PAR_BUS_DBT

PARENT_BUSINESS_VALUE Parents' business value. NUMBER

RCRAPP3

RCRAPP3_PAR_BUS_VAL

PARENT_CHILD_SUPPORT_PAID Amount paid for child support by the parents. NUMBER

RCRAPP3

RCRAPP3_PAR_CHILD_SUPP_PAID

PARENT_COOPERATIVE_EARNINGS   NUMBER    
PARENT_EARNED_INCOME_CREDIT Parents' earned income credit. NUMBER

RCRAPP3

RCRAPP3_PAR_EIC

PARENT_EDUCATION_TAX_CREDIT   NUMBER    
PARENT_FARM_DEBT Parents' farm debt. NUMBER

RCRAPP3

RCRAPP3_PAR_FARM_DBT

PARENT_FARM_VALUE Parents' farm value. NUMBER

RCRAPP3

RCRAPP3_PAR_FARM_VAL

PARENT_FOREIGN_INC_EXCLUSION Parents' foreign income exclusion. NUMBER

RCRAPP3

RCRAPP3_PAR_FOR_INC_EXCL

PARENT_GRANT_SCHOLARSHIP_AID   NUMBER    
PARENT_HOUSING_FOOD_ALLOWANCE Housing, food,and other living allowances paid by the parents to the members of the military, clergy, and others. NUMBER

RCRAPP3

RCRAPP3_PAR_HOUSE_FOOD_OTH

PARENT_INVESTMENT_DEBT Parents' investment debt. NUMBER

RCRAPP3

RCRAPP3_PAR_INVEST_DBT

PARENT_INVESTMENT_VALUE Parents' investment value. NUMBER

RCRAPP3

RCRAPP3_PAR_INVEST_VAL

PARENT_IRS_AGI_FLAG Indicates whether IRS Adjusted Gross Income data for the parent was transferred to the FAFSA. VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_PAR_IRS_AGI_FLAG,RCRIRSF_PAR_IRS_AGI_FLAG)

PARENT_IRS_AGI_FLAG_DESC IRS Adjusted Gross Income data for the parent was transferred to the FAFSA indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

PARENT_IRS_DISPLAY_FLAG Indicates whether IRS Data Retrieval Transfer option was displayed for the parent. VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_PAR_IRS_DISPLAY_FLAG,RCRIRSF_PAR_IRS_DISPLAY_FLAG)

PARENT_IRS_DISPLAY_FLAG_DESC IRS Data Retrieval Transfer option was displayed for the parent indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

PARENT_IRS_FIT_FLAG Indicates whether IRS Federal Income Tax data for the parent was transferred to the FAFSA. VARCHAR2(1)

CALCULATION

NVL(RCRAPP3_PAR_IRS_FIT_FLAG,RCRIRSF_PAR_IRS_FIT_FLAG)

PARENT_IRS_FIT_FLAG_DESC IRS Federal Income Tax data for the parent was transferred to the FAFSA indicator description. VARCHAR2(4000)

RORMVAL

RORMVAL_DESC

PARENT_IRS_REQUEST_STATUS   VARCHAR2(2)

CALCULATION

NVL(RCRAPP3_PAR_IRS_REQUEST_FLAG,RCRIRSF_PAR_IRS_REQUEST_FLAG)

PARENT_IRS_REQUEST_STATUS_DESC   VARCHAR2(4000)    
PARENT_MARITAL_STATUS_DATE Month and year the parents were married, widowed, separated, or divorced. VARCHAR2(6)

RCRAPP3

RCRAPP3_PAR_MAR_MTH_YR

PARENT_MORTGAGE_RENT_PAYMENT Parents' monthly home mortgage or rental payment. NUMBER

RCRAPP3

RCRAPP3_PAR_MTH_MORT_RENT_PAY

PARENT_NEED_BASED_EMPLOYMENT   NUMBER    
PARENT_REAL_ESTATE_DEBT Parents' real estate debt. NUMBER

RCRAPP3

RCRAPP3_PAR_RE_DBT

PARENT_REAL_ESTATE_VALUE Parents' real estate value. NUMBER

RCRAPP3

RCRAPP3_PAR_RE_VAL

PARENT_RESIDE_FARM_IND Indicates whether or not the parents are living on a farm. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_PAR_LIVE_ON_FARM)

PARENT_RETIREMENT_PLAN_PAYMENT Parents' deductible IRA and/or keough payments. NUMBER

RCRAPP3

RCRAPP3_PAR_IRA_KEOUGH

PARENT_TAX_DEFERRED_PENSION Parents' payments to tax-deferred pension and saving plans that are paid directly or withheld from earnings. Also contains the untaxed portion of 401(k) and 403(b) plans. NUMBER

RCRAPP3

RCRAPP3_PAR_TAX_DEF_PENSION

PARENT_TAX_EXEMPT_INTEREST_INC Parents' tax exempt interest income. NUMBER

RCRAPP3

RCRAPP3_PAR_TE_INT_INC

PARENT_TOTAL_UNTAXED_INCOME Parents' untaxed income and benefits. NUMBER

RCRAPP3

RCRAPP3_PAR_INC_BENEFITS

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRAPP3

RCRAPP3_PIDM

PREPARER_EIN Preparer's employee identification number. VARCHAR2(9)

RCRAPP3

RCRAPP3_PREPARER_EIN

PREPARER_SIGNATURE_IND Indicates whether or not the preparer's signature is on the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_PREPARER_SIGN)

PREPARER_TAX_ID Preparer' social security number. VARCHAR2(15)

RCRAPP3

RCRAPP3_PREPARER_SSN

REAL_ESTATE_DEBT Student's real estate debt. NUMBER

RCRAPP3

RCRAPP3_RE_DBT

REAL_ESTATE_VALUE Student's real estate value. NUMBER

RCRAPP3

RCRAPP3_RE_VAL

REJECTION_OVERRIDE20_IND   VARCHAR2(1)    
REJECTION_OVERRIDE21_IND   VARCHAR2(1)    
REJECTION_OVERRIDE2_IND Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age. No longer used. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_2

REJECTION_OVERRIDE3_IND Set to 'Y' by the electronic application user to override rejection 3: Student's taxes paid are greater than zero and equal to or greater than AGI. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_3

REJECTION_OVERRIDE4_IND   VARCHAR2(1)    
REJECTION_OVERRIDE5_IND Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. No longer used. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_5

REJECTION_OVERRIDE7_IND Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members. No longer used. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_7

REJECTION_OVERRIDE_B_IND Indicates if Reject B override accepted - Independent status in question because of student's age. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_1

REJECTION_OVERRIDE_N_IND Set by electronic application user to override reject N: Missing first or last name. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_4

REJECTION_OVERRIDE_W_IND Set by electronic application user to override reject W: Questionable number of family members, greater than 15. VARCHAR2(1)

RCRAPP3

RCRAPP3_REJECT_OVRD_6

REJECT_REASON_PRIORITY_1 Reject Reason Priority 1 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_1

REJECT_REASON_PRIORITY_10 Reject Reason Priority 10 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_10

REJECT_REASON_PRIORITY_11 Reject Reason Priority 11 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_11

REJECT_REASON_PRIORITY_12 Reject Reason Priority 12 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_12

REJECT_REASON_PRIORITY_13 Reject Reason Priority 13 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_13

REJECT_REASON_PRIORITY_14 Reject Reason Priority 14 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_14

REJECT_REASON_PRIORITY_2 Reject Reason Priority 2 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_2

REJECT_REASON_PRIORITY_3 Reject Reason Priority 3 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_3

REJECT_REASON_PRIORITY_4 Reject Reason Priority 4 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_4

REJECT_REASON_PRIORITY_5 Reject Reason Priority 5 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_5

REJECT_REASON_PRIORITY_6 Reject Reason Priority 6 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_6

REJECT_REASON_PRIORITY_7 Reject Reason Priority 7 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_7

REJECT_REASON_PRIORITY_8 Reject Reason Priority 8 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_8

REJECT_REASON_PRIORITY_9 Reject Reason Priority 9 VARCHAR2(2)

RCRAPP3

RCRAPP3_REJ_REASON_PRTY_9

RESIDE_FARM_IND Indicates whether or not a student is living on a farm. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_LIVE_ON_FARM)

SIGNATURE_IND Indicates whether or not a student's signature ison the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_C_SIGNED)

SPECIAL_CIRCUMSTANCE   VARCHAR2(1)    
SPECIAL_CIRCUMSTANCE_DESC   VARCHAR2(4000)    
SPOUSE_SIGNATURE_IND Indicates whether or not a spouse's signature is on the application. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP3_C_SIGNED_SPS)

TAX_DEFERRED_PENSION   NUMBER    
TAX_EXEMPT_INTEREST_INC   NUMBER    
TAX_ID_MATCH_STATUS Tax ID match status. VARCHAR2(1)

RCRAPP3

RCRAPP3_SOC_SEC

TAX_ID_MATCH_STATUS_DESC Tax ID match status description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP3_SOC_SEC)

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

RCRAPP3

RCRAPP3_USER_ID

YEAR_IN_COLLEGE2 Year of study (first, second, etc.) that the student enrolls in this year. VARCHAR2(1)

RCRAPP3

RCRAPP3_YR_IN_COLL_2

YEAR_IN_COLLEGE2_DESC Description of the year of study. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP3_YR_IN_COLL_2)

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: